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