Mysql 600% CPU usage

[Patricio Segovia]

This its my my.cnf file:

[mysqld]
max_connections = 200
query_cache_type = 1
query_cache_size = 256M
query_cache_limit = 2M
performance-schema = 0
local-infile = 0
tmpdir=/mysqltmp
wait_timeout = 120
interactive_timeout = 120
sort_buffer_size = 2G
myisam_sort_buffer_size = 2G
default-storage-engine=MyISAM
innodb_file_per_table = 1
max_allowed_packet = 268435456
open_files_limit=12000
key_buffer_size = 2G
read_buffer_size = 16M

My server its a xeon 8 core and 8 gb ram.

What i did wrong?

Regards!

 

[Jcats]

It most likely has nothing to do with your mysql configuration.

You have to check the queries to see what is causing the usage:

# mysqladmin proc

 

[kernow]

Maybe nothing, you should install something to monitor your MySQL processes and find out who/what is causing the load. mytop - a top clone for MySQL

 

[SysSachin]

Hello,

You have to optimize MySQL by using mysqltuner script and update the my.cnf record as per the mysqltuner.

 

[cPanelMichael]

Hello,

You'd need to first verify if any specific databases or tables are leading to the excessive resource usage. You can do this via the use of a command such as "mysqladmin processlist", as mentioned in the earlier posts to this thread.

Thanks!

 

[Jcats]

You have to optimize MySQL by using mysqltuner script and update the my.cnf record as per the mysqltuner.

You can tune it as much as you want, this more than likely has nothing to do with tuning.