High load coming from /usr/sbin/mysqld --daemonize?

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,580
1,041
313
cPanel Access Level
Root Administrator
@Manishpandey - there often isn't a single fix to resolve load issues when dealing with MySQL, and I didn't see one specific thing noted in the earlier posts. I like to watch the "mysqladmin proc status" command on the system to see the queries in real time, as well as see if there are frequent entries in the MySQL error log. Usually those two things will let me know if a certain user is experiencing problems with the system or using too many resources.
 

friv

Registered
Dec 14, 2018
4
0
1
Serbia
cPanel Access Level
Website Owner
@Manishpandey - there often isn't a single fix to resolve load issues when dealing with MySQL, and I didn't see one specific thing noted in the earlier posts. I like to watch the "mysqladmin proc status" command on the system to see the queries in real time, as well as see if there are frequent entries in the MySQL error log. Usually those two things will let me know if a certain user is experiencing problems with the system or using too many resources.
Hello guys

I have the same problem with Mysql high load.

20601 mysql 20 0 1917068 307944 7988 S 22.1 5.2 113:40.44 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysql+

And constantly is holding server CPU near 100%

Please check attachments.
 

Attachments

Abdul Rahim

Registered
Dec 14, 2021
1
0
1
United States
cPanel Access Level
Root Administrator
@friv - my advice to you would be the same - you'll want to run "mysqladmin proc status" to see what MySQL is doing in real-time on the machine and see if you can track down any issues.
Hello! Hope you guys are doing well. I do have a similar issue with my installation. The following process

/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

with the owner being mysql constantly is absorbing around 12-20 % CPU with memory usage. However, when I run "mysqladmin proc status" it shows no query (look at the following screenshot)
1639496130716.png

Please take note that I have enabled automatica back up in the system and to Google Drive, could that be why it's constantly having such usage of CPU utilization. Any help will be much appreciated.

Best,
Abdul,
IslamTheCure.com
 

cPanelAnthony

Administrator
Staff member
Oct 18, 2021
1,051
106
118
Houston, TX
cPanel Access Level
Root Administrator
The setup gives off an impression of being comparative yet I am interested if there isn't some distinction between the treatment of MySQL strings on CentOS 6 rather than CentOS 7 - In this occasion so we can look further into the issue/arrangement would you be able to please open a ticket utilizing the connection in my mark? When open please answer with the Ticket ID here so we can refresh this string with the goal once the ticket is settled.
MySQL settings should only differ between actual versions of the MySQL software.