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