on Stack Overflow
See other posts from Stack Overflow
or by alistair.mp
Published on 2010-04-15T09:57:10Z Indexed on 2010/04/15 10:23 UTC
Read the original article Hit count: 239
We're running a large site at the moment which has a dedicated VPS for it's database server which is running MySQL and nothing else. At the moment all four CPU cores are running at close to 100% all of the time but the memory usage sticks at around 268MB out of an available 4096MB. I'm wondering what we can do to better utilise the memory and reduce the CPU load by tweaking MySQL's settings?
Here is what we currently have in my.cnf: http://pastie.org/private/hxeji9o8n3u9up9mvtinbq
© Stack Overflow or respective owner