c0i0t3

Well-Known Member
Sep 30, 2005
61
0
156
Hospedagem de Site
hi, I am passing for a problem in mysql that it is causing overload in my machine!

the problem initiated when it brought up to date cpanel for version

WHM 10.8.0 cPanel 10.8.2-S120 and mysql (4.1.18-standard-log)




I ordered to bring up to date mysql more the problem I continued the same

/scripts/mysqlup --force

mysql (4.1.19-standard-log)



the process is always above of 30% of CPU and arrives up to 60%

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
29197 mysql 15 0 301M 78M 3792 S 51.8 5.5 111:36 1 mysqld


eximstat does not appear no process using only, more already I stopped eximstat and the process continues functioning!


Show MySQL Processes

+--------+-----------+-----------+-----------+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-----------+-----------+-----------+---------+-------+-------+------------------+
| 16411 | eximstats | localhost | eximstats | Sleep | 19771 | | |
| 151259 | root | localhost | | Query | 0 | | show processlist |
+--------+-----------+-----------+-----------+---------+-------+-------+------------------+

IN PHPMYADMIN

ID User Host Database Command Time Status SQL query
Kill 16411 eximstats localhost eximstats Sleep 19868 --- ---
Kill 152084 root localhost mysql Query 0 --- SHOW PROCESSLIST

[email protected] [~]# mysqladmin proc
+--------+-----------+-----------+-----------+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+-----------+-----------+-----------+---------+-------+-------+------------------+
| 16411 | eximstats | localhost | eximstats | Sleep | 20500 | | |
| 159261 | root | localhost | | Query | 0 | | show processlist |
+--------+-----------+-----------+-----------+---------+-------+-------+------------------+


Show Current CPU Usage

29197 mysql 0 45.7 3.6 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/plutonio.isbrasil.info.pid --skip-locking --port=3306 --socket=/var/lib/mysql/mysql.sock


when I try to catch information seems that the process does not exist, plus it continues working!

Process Manager

Main >> System Health >> Show Current CPU Usage
The Process no longer exists


load in the schedule of great access on for 60 - 80


Already I tried to kill the process plus it return! Already I left 8 days it to work and it stops mysql and always it comes back toward the beginning!

All the security rules are brought up to date, php 5.1.4, apf, mod_secure, rootkit...


How I can make for I discovered what he happens in this process? What it can be?

With high load the statisticians are with difficulties to work and have 2 days without generating correctly
 

netlook

Well-Known Member
Mar 25, 2004
335
0
166
All our servers running MySQL 4.1.19-standard from /scripts/mysqlup have the same thing - mysql is still using CPU resource without processing any queries.

Is it MySQL 4.1.19 bug?
 

jackie46

BANNED
Jul 25, 2005
537
0
166
netlook said:
All our servers running MySQL 4.1.19-standard from /scripts/mysqlup have the same thing - mysql is still using CPU resource without processing any queries.

Is it MySQL 4.1.19 bug?
We upgraded all our RH boxes to 4.1.19-standard today and we are not seeing any issues with resources.