[MediaWiki-l] Scaling up - MySQL server

Tim Starling tstarling at wikimedia.org
Fri Feb 21 21:58:47 UTC 2014


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




More information about the MediaWiki-l mailing list