Tuning MySQL to take advantage of a 4GB VPS

Posted by alistair.mp 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: 367

Filed under:
|

Hello,

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

Thanks

© Stack Overflow or respective owner

Related posts about mysql

Related posts about performance-tuning