High CPU Usage on VPS

[Lock Down]

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

to set your musql total to your memory use these formulas :

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.

 

[salman]

reduce you FCGI spaw process, and optimize your database

if not then hardwares mean ( CPU + Ram) is not enough to work simultaneous connections spawn by FCGI