13:41 SmashingX referenced.

Cloward: Brittman: Ok, I’ll revert to a copy before I did the upgrade of FreeBSD.

Soyars: Sorry such a noobie question

Prophit: Izham: InnoDB offers ACID transactions, foreign key constraints, and robust crash recovery. Generally a good default unless something specific requires MyISAM.

Sensenbrenner: Does MySQL handle refering to the table being updated/deleted in update/delete? I mean, I’m sure it used to have problem with refering to the same table again but I’m not sure if it’s consistent across all the engines

Keiter: Izham: look at the CREATE TABLE . ENGINE= statements in your .sql file

Soyars: Its just norm statement i tink

Soyars: ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CH****T=utf8 COLLATE=utf8_unicode_ci;

Hunnicutt: Brittman: No luck with that. :

Keiter: Izham: perfect. Read the link I gave you.

Keiter: Izham: it can make a 4-5 hours import take 15 minutes, if you misconfigured mysqld

Brittman: Dopeelf: hard to say, did you look at something like strace?

Brittman: Dopeelf: or ask the fbsd folks if they have seen something similar?

Brittman: Dopeelf: or made sure that all outstanding updates applied cleanly? or just reinstall mysql?

Brittman: Dopeelf: seems like a crash or linking problem or something from here but could be lots of things

Golberg: Brittman: I did a 10.1-10.2 upgrade and part of that is reinstalling all packages. But I noticed now that I installed lsof it complained about being compiled for the wrong version of FreeBSD so maybe I have something wrong in the repo file. I’ll check.

Blythe: When I try to add a new foreign key it says that mysql got disconnected, why is that happening?

Vitantonio: I got this: ERROR 2013 HY000: Lost connection to MySQL server during query

Losh: I really wish that error was, “Network read error”

Samuelsen: Brittman: Never mind, I botched the upgrade of my jail. Read the do***entation and supplied the target release instead of the source release so my libraries are from the wrong release.

Riekena: Brittman: Thank you for the help though! I wouldn’t have figured this out if you hadn’t said it crashed before it had started. To me it looked like it did start.

Toms: Any help on this please?

Losh: SmashingX: most likely the query was killed, mysql stopped, or the network errored

Oland: Losh: But it’s always when I execute a specific query

Brittman: SmashingX: does uptime status variable of mysqld reset?

Brittman: Dopeelf: np. glad i could help and that my guess was close

Huron: How can I know that Brittman ?

Brittman: SmashingX: show global status like ‘uptime’;

Frohlich: Do you mean execute uptime inside of mysql?

Draggoo: SmashingX: MySQL error code 150: Foreign key constraint is incorrectly formed — To see the error: SHOW ENGINE INNODB STATUSG and look for the Latest Foreign Key Error — More information and FK requirements: http://dev.mysql.com/doc/refman/5.6/en/innodb-foreign-key-constraints.html

Crayne: I have learned ‘uptime’ is ‘select now – interval variable_value second as starttime from information_schema.global_status where variable_name=’uptime’;’, as a factoid

Marquis: I don’t get it I get this error: FOREIGN KEY unit_id REFERENCES units unit_id:

Gahl: Cannot find an index in the referenced table where the

Larouche: Referenced columns appear as the first columns, or column types

Ghan: In the table and the referenced table do not match for constraint.

Mapp: And I have a units table with unit_id as a key

Killins: I don’t understand what’s the error

Brittman: SmashingX: same data type? eg int unsigned not null?

Balas: Brittman: I think that’s the error :/ I have decimal and int

Simser: Brittman: error messages from mysql are hard to understand

Brittman: 13:41 SmashingX referenced columns appear as the first columns, or column types