MySQL & InnoDB

InnoDB is our preferred database engine.  Use show engines to see if InnoDB is enabled.

show engines \G

show table status \G

When changing the InnoDB log file size make sure you remove the ib_logfile* files.  If you don't the server doesn't start cleanly and you get an error in /var/log/mysql.err such as the following:

InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 67108864 bytes!

I found the DB install scripts in RightScale does not do this, causing me hours of pain for a simple task.