innodb

mysql simple problem with foreign keys

I have two tables: Table Author: ID (INTEGER), author_name (VARCHAR), first_name (VARCHAR), last_name (VARCHAR), preferred_name (VARCHAR). Table CoAuthored: ID (INTEGER) author1ID (INTEGER), author2ID (INTEGER), paper_ID (INTEGER) (ID of the co-authored paper referenced by this link) I want to add foreign key constraints such that aut...

Engine select with SOURCE in mysql

How do I change the engine to MyISAM when using a SOURCE import in mysql? It currently defaults to InnoDB. would there be any difference between the speed of the import between the engines for say a 5gb .sql file? ...

3 way transaction deadlock in mysql innodb?

If innodb detects a 3 way deadlock, would it report on all the involved transactions in the "LAST DEADLOCK DETECTED" section of "show engine innodb status" ? Also when innodb reports a deadlock, why doesn't it ever report the locks TRANSACTION (1) holds? It reports locks TRANSACTION (1) is waiting for, It reports locks TRANSACTION (2) is...

MySQL InnoDB Text Search Options

Knowing full well that my InnoDB tables don't support FULLTEXT searches, I'm wondering what my alternatives are for searching text in tables ? Is the performance that bad when using LIKE ? I see a lot of suggestions saying to make a copy of the InnoDB table in question in a MYISAM table, and then run queries against THAT table and matc...

MySQL "remembers" deleted InnoDB table

MySQL is giving me grief when I try to recreate a particular table in a particular database; I believe the problem is that somewhere MySQL has some records of the table's foreign keys and keeps trying to check the constraint when I try to recreate the table. The database in question is for the test environment and is periodically refres...