Good/Better config for MySQL on an EC2 Large Instance
- by Tim Reynolds
I have an EC2 Large instance dedicated to MySQL.
It will be serving a Joomla/Magento combo so it has a blend of InnoDB and MyISAM tables. I have only worked with MyISAM in the past and am therefore unfamiliar with the settings InnoDB uses. Experiments so far have been less than fruitful, as I keep causing the InnoDB engine to be disabled.
My instance is running Ubuntu 10.04 64 bit server edition and has ~7.5G of ram. MySQL is currently using ~0.6% of that, with somewhat poor performance. I would like to configure it to use as much of the system RAM as is reasonable.
Testing some settings I learned that the InnoDB logs can't collectively be larger than 4G.
Would anyone be able to provide some base InnoDB and MyISAM settings to get my started.
Thank you
Tim