I want to convert some (not all) the MyISAM tables to InnoDB. Here is my current my.cnf: pastebin.com/FW8YXtLQ
What would be the best configuration? (need to add InnoDB settings, byecause there are no InnoDB settings in my my.cnf)
|show 6 more comments|
You mentioned before you are running
Here are some good settings to start with
Don't do the conversion yet !!!
Put there settings in my.cnf, then do the following
Now, you can do the conversion.
Give it a Try !!!
UPDATE 2013-05-10 10:44 EDT
Here are my past posts on tuning InnoDB for better CPU usage
Here are my past posts on tuning InnoDB