@vikassaini01 he already did if you had read the topic ..

to set your musql total to your memory use these formulas :
[quote]
server_buffers + total_per_thread_buffers * max_connections
(server_buffers = key_buffer_size + innodb_buffer_pool_size + innodb_additional_mem_pool_size + innodb_log_buffer_size + query_cache_size)
(total_per_thread_buffers = read_buffer_size + read_rnd_buffer_size + sort_buffer_size + thread_stack + join_buffer_size)

you have to check each of these values and figure out which one is responsible for this huge number. And don't trust this script unreservedly - I tested and it calculated that the maximum memory was 140% of the total amount of physical memory. Which normally will work ok.
Lock Down Reviewed by Lock Down on . High CPU Usage on VPS Hey guys, I get a lot of CPU spikes and I'm not quite sure how to fix it. http://i.lulzimg.com/2e85d176e2.jpg http://i.lulzimg.com/5b3174e9bc.jpg It constantly goes from very low 0-2% to 50-99% as you can see from the two screenshots. Its a 3GB 3 CPU Core VPS on Centos 5 64bit, Nginx, APC, and MySQL hosting about 2 wordpress sites with a combined daily traffic of about 6k UV/day. For the VPS specs I know for a fact that is plenty of power for just 6k traffic. And the port Rating: 5