Extermly high MySQL CPU%

ashrafpro

• January 20, 2020 05:23

Hi, Any advice how to solve this problem? this is a new dedicated machine, the MySQL CPU usage strikes to this level. this is my.cnf [mysqld] bind-address=127.0.0.1 performance-schema=0 init-connect='SET NAMES utf8mb4' collation_server=utf8mb4_unicode_ci character_set_server=utf8mb4 skip-character-set-client-handshake datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid innodb_buffer_pool_size=134217728
any advice?

• 

  cPanelLauren

  • January 20, 2020 18:46

  You might try running the mysql tuner as well as reading through the following; And the following:

  0
• 

  amiwaybantai

  • January 29, 2020 19:04

  i could not understand Physical Memory Usage i am hosing my domain on shared server with 1 Gb of Physical Memory Usage and it start to get used 90% with 5-7 active user is there any thing wrong with my website load and what should i do

  0
• 

  cPanelLauren

  • January 29, 2020 22:07

  i could not understand Physical Memory Usage i am hosing my domain on shared server with 1 Gb of Physical Memory Usage and it start to get used 90% with 5-7 active user is there any thing wrong with my website load and what should i do

  
  This is something you need to address with your hosting provider. As a user on a shared hosting environment you would have no way to make any of the changes suggested.

  0

Please sign in to leave a comment.