mysqd_safe high cpu usage
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ubuntu Server papercuts |
Invalid
|
Undecided
|
Unassigned | ||
mysql-dfsg-5.0 (Debian) |
Unknown
|
Unknown
|
|||
mysql-dfsg-5.0 (Ubuntu) |
Triaged
|
Low
|
Unassigned |
Bug Description
mysqld_safe bash wrapper is very high on cpu usage some times. Trying to debug the problem i saw that there where 2 instances of the script running on the same time, the the one that used the cpu so high had no child mysqld process. I issues a /etc/init.d/mysql stop but the cpu hungry process didn't died, still eating all cpu cycles. At the end of the report i copy & pasted outputs of some command that i found useful to describe the problem.
I couldn't get any step to reproduce the problem but i saw it more that once, on different edgy installed systems. I also saw a topic on forum talking about this problem : http://
dcerouter_11726:~# top
top - 02:57:28 up 3:34, 7 users, load average: 1.93, 1.90, 1.87
Tasks: 218 total, 1 running, 215 sleeping, 0 stopped, 2 zombie
Cpu(s): 15.4%us, 44.8%sy, 0.0%ni, 39.3%id, 0.2%wa, 0.2%hi, 0.2%si, 0.0%st
Mem: 969576k total, 799984k used, 169592k free, 118608k buffers
Swap: 2835432k total, 17624k used, 2817808k free, 336764k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
4566 root 25 0 1656 528 436 S 97 0.1 206:14.53 mysqld_safe
dcerouter_11726:~# strace -p 4566
------------
wait4(-1, 0xbfdccc50, 0, NULL) = -1 ECHILD (No child processes)
wait4(-1, 0xbfdccc50, 0, NULL) = -1 ECHILD (No child processes)
wait4(-1, 0xbfdccc50, 0, NULL) = -1 ECHILD (No child processes)
wait4(-1, 0xbfdccc50, 0, NULL) = -1 ECHILD (No child processes)
wait4(-1, 0xbfdccc50, 0, NULL) = -1 ECHILD (No child processes)
wait4(-1, 0xbfdccc50, 0, NULL) = -1 ECHILD (No child processes)
wait4(-1, 0xbfdccc50, 0, NULL) = -1 ECHILD (No child processes)
wait4(-1, 0xbfdccc50, 0, NULL) = -1 ECHILD (No child processes)
wait4(-1, 0xbfdccc50, 0, NULL) = -1 ECHILD (No child processes)
wait4(-1, 0xbfdccc50, 0, NULL) = -1 ECHILD (No child processes)
----------
dcerouter_
4566 ? R 213:49 /bin/sh /usr/bin/
4724 ? S 0:00 /bin/sh /usr/bin/
13513 ? Sl 1:20 \_ /usr/sbin/mysqld --basedir=/usr --datadir=
13524 ? S 0:00 \_ logger -p daemon.err -t mysqld_safe -i -t mysqld
29490 pts/34 S+ 0:00 \_ grep mysqld
dcerouter_11726:~# dpkg -l '*mysql*'
Desired=
| Status=
|/ Err?=(none)
||/ Name Version Description
+++-===
un gda2-mysql <none> (no description available)
un libclass-
ii libdbd-mysql-perl 3.0006-1 A Perl5 database interface to the MySQL database
un libmysql-java <none> (no description available)
un libmysqlclient-dev <none> (no description available)
ii libmysqlclient10 3.23.56-3 LGPL-licensed client library for MySQL databases
ii libmysqlclient12 4.0.24-10ubuntu2 mysql database client library
un libmysqlclient1
ii libmysqlclient14 4.1.15-1ubuntu5 mysql database client library
un libmysqlclient15 <none> (no description available)
ii libmysqlclient15off 5.0.24a-9ubuntu2 mysql database client library
un libmysqlclient6-dev <none> (no description available)
un libmysqlclient9 <none> (no description available)
un libmysqlclient9-dev <none> (no description available)
ii libqt3-mt-mysql 3.3.6-3ubuntu3 MySQL database driver for Qt3 (Threaded)
un libqt3-mysql <none> (no description available)
un libqt3c-mt-mysql <none> (no description available)
un libqt3c102-mt-mysql <none> (no description available)
un mysql <none> (no description available)
un mysql-base <none> (no description available)
ii mysql-client 5.0.24a-9ubuntu2 mysql database client (current version)
un mysql-client-4.1 <none> (no description available)
ii mysql-client-5.0 5.0.24a-9ubuntu2 mysql database client binaries
ii mysql-common 5.0.24a-9ubuntu2 mysql database common files (e.g. /etc/mysql/my.cnf)
un mysql-common-4.1 <none> (no description available)
un mysql-dev <none> (no description available)
un mysql-devel <none> (no description available)
un mysql-gpl-client <none> (no description available)
ii mysql-server 5.0.24a-9ubuntu2 mysql database server (current version)
un mysql-server-4.1 <none> (no description available)
ii mysql-server-5.0 5.0.24a-9ubuntu2 mysql database server binaries
ii php4-mysql 4.4.2-1.1 MySQL module for php4
un php5-mysql <none> (no description available)
un virtual-
un virtual-
dcerouter_11726:~#
Changed in mysql-dfsg-5.0: | |
status: | Confirmed → Triaged |
Thank you for taking the time to report this bug and helping to make Ubuntu better.
Can you have a look at the log messages in /var/log/mysql.err and /var/log/mysql.log ?