On 19/02/14 09:11, David Gerard wrote:
So, what's a good approach to scaling up MySQL on a VM? Add more memory? Add more cores? (How's MySQL 5.5-ubuntu do for multicore?)
You would add more cores only if the CPU is maxed out at peak times. More memory (with almost all allocated to innodb_buffer_pool) would be advisable if there is a significant amount of disk read activity. The buffer pool size should be sufficient to hold all the indexes in memory. Use SHOW TABLE STATUS to estimate the size of them. Ideally, there should be enough memory to hold all the data as well, except for the text table.
-- Tim Starling