Mysql 600% CPU usage

Patricio Segovia

• March 07, 2017 11:10

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

  • March 07, 2017 20:24

  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
  

  0
• 

  kernow

  • March 07, 2017 20:31

  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

  0
• 

  SysSachin

  • March 08, 2017 00:59

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

  0
• 

  cPanelMichael

  • March 08, 2017 14:02

  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!

  0
• 

  Jcats

  • March 08, 2017 14:57

  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.

  0

Please sign in to leave a comment.