-
InnoDB in MySQL
I came across some links before on InnoDB when I was wondering about doing transactions and heavy inserts/updates. Is InnoDB simply a type of table? Could I use InnoDB tables for certain functions within a standard MySQL database? Or would I have to make my whole database use InnoDB?
-
yeah, InnoDB is just a table type. you can use it for a single table. MySQL has to be compiled w/ InnoDB support, though, which it don't think it is by default. you would just specify it in your CREATE TABLE statement like this:
CREATE TABLE table (.....) TYPE=InnoDB;
there are some different behaviors with InnoDB compared to the default MyISAM (i don't know exactly what). so watch out for those. :)