You cant use my configuration because have many differences there.

with 512 Ram, I suggest you change :
max_connections = 100;
key_buffer_size = 16M;
table_cache = 512;

Change then restart your mysql server.
Rapid4All Reviewed by Rapid4All on . mysql usage 99.8%|Site Not Loading|Please help to optimize hello guys, mysql usage is more than 99%, and site is not loading due to it. I have tried rebooting the VPS, but it soon start using 99% and site again goes down. http://lulzimg.com/i9/1d3cc486.png Please help me guys... or please link to some tutorial on web, becoz i tried and didn't find anything. thanks in advance Rating: 5