Optimization: Only InnobDB, no MyISAM

As I’ve chosen to use only InnoDB for my tables, I wish to know which configuration values I may cut to save on memory.

Also, I understand that MyISAM is used anyway for temporary tables. It also seems like the default “MySQL” and “Information_Schema” databases use MyISAM. Can this be changed or am I stuck with MyISAM anyway?


You are stuck with myisam. You should leave about 32M or so in your key_buffer for temporary tables, and that’s about the only thing you need to change.