MySql very High CPU Load, please help

msalmanzaib

• November 15, 2014 11:59

My server MySQL load is too high 230% mostly Please let me guide how can I optimize it. Server OVH with 48GB RAM. System information Server load 16.71 (8 CPUs) (Alert) Memory Used 4.01% (1,985,444 of 49,514,432) (Ok) Swap Used 0% (0 of 523,260) (OK) my.cnf [mysqld] innodb_file_per_table=1 bind-address=127.0.0.1 open_files_limit=4596 innodb_buffer_pool_size=134217728 max_allowed_packet=268435456 Currently Load Averages: 13.17 13.95 13.68 Thank you.

• 

  cPanelMichael

  • November 18, 2014 19:31

  Hello :) The following thread is a good place to start when attempting to tune your MySQL configuration: mysqlmymonlite.sh server stats gathering tool for cPanel Server Thank you.

  0

Please sign in to leave a comment.