[Bug 105457] Re: mysqd_safe high cpu usage

Thu Apr 2 02:59:05 BST 2009

Hello all,

I've experienced this problem today.
I'm feeling lazy, so I'll let you observe:

thor:/var/log$ uname -a
Linux thor 2.6.24-23-generic #1 SMP Mon Jan 26 00:13:11 UTC 2009 i686 GNU/Linux

thor:~$ cat /etc/issue
Ubuntu 8.04.2 \n \l

thor:~$ sudo apt-get install mysql-server mysql-client
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following extra packages will be installed:
  libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl
  mysql-client-5.0 mysql-server-5.0
Suggested packages:
  dbishell mysql-doc-5.0 tinyca
Recommended packages:
  libhtml-template-perl mailx
The following NEW packages will be installed:
  libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl mysql-client
  mysql-client-5.0 mysql-server mysql-server-5.0
0 upgraded, 8 newly installed, 0 to remove and 0 not upgraded.
Need to get 36.3MB of archives.
After this operation, 108MB of additional disk space will be used.
Do you want to continue [Y/n]? 
Get:1 http://us.archive.ubuntu.com hardy/main libnet-daemon-perl 0.38-1.1 [45.9kB]
Get:2 http://us.archive.ubuntu.com hardy/main libplrpc-perl 0.2017-1.1 [35.0kB]
Get:3 http://us.archive.ubuntu.com hardy/main libdbi-perl 1.601-1 [771kB]
Get:4 http://us.archive.ubuntu.com hardy/main libdbd-mysql-perl 4.005-1 [134kB]
Get:5 http://us.archive.ubuntu.com hardy-updates/main mysql-client-5.0 5.0.51a-3ubuntu5.4 [7826kB]
Get:6 http://us.archive.ubuntu.com hardy-updates/main mysql-server-5.0 5.0.51a-3ubuntu5.4 [27.4MB]
Get:7 http://us.archive.ubuntu.com hardy-updates/main mysql-client 5.0.51a-3ubuntu5.4 [52.1kB]
Get:8 http://us.archive.ubuntu.com hardy-updates/main mysql-server 5.0.51a-3ubuntu5.4 [54.2kB]
Fetched 36.3MB in 1min2s (586kB/s)                                             
Preconfiguring packages ...
Selecting previously deselected package libnet-daemon-perl.
(Reading database ... 147205 files and directories currently installed.)
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.38-1.1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2017-1.1_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.601-1_i386.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.005-1_i386.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.51a-3ubuntu5.4_i386.deb) ...
Selecting previously deselected package mysql-server-5.0.
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-3ubuntu5.4_i386.deb) ...
Selecting previously deselected package mysql-client.
Unpacking mysql-client (from .../mysql-client_5.0.51a-3ubuntu5.4_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.0.51a-3ubuntu5.4_all.deb) ...
Setting up libnet-daemon-perl (0.38-1.1) ...
Setting up libplrpc-perl (0.2017-1.1) ...
Setting up libdbi-perl (1.601-1) ...
Setting up libdbd-mysql-perl (4.005-1) ...
Setting up mysql-client-5.0 (5.0.51a-3ubuntu5.4) ...
Setting up mysql-server-5.0 (5.0.51a-3ubuntu5.4) ...
 * Stopping MySQL database server mysqld
   ...done.
Reloading AppArmor profiles : done.
 * Starting MySQL database server mysqld
   ...done.
 * Checking for corrupt, not cleanly closed and upgrade needing tables.

Setting up mysql-client (5.0.51a-3ubuntu5.4) ...
Setting up mysql-server (5.0.51a-3ubuntu5.4) ...

thor:~$ mysql -p -u root
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.0.51a-3ubuntu5.4 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database amarok;
Query OK, 1 row affected (0.00 sec)

mysql> use amarok;
Database changed
mysql> grant all on amarok.* to amarok at localhost identified by 'xxxxxxxx';
Query OK, 0 rows affected (0.00 sec)

mysql> exit;
Bye

thor:~$ top

top - 18:36:57 up 54 min,  1 user,  load average: 1.07, 0.88, 0.51
Tasks: 136 total,   3 running, 133 sleeping,   0 stopped,   0 zombie
Cpu0  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu1  : 26.0%us, 74.0%sy,  0.0%ni,  0.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Mem:   3622324k total,  1330412k used,  2291912k free,    34860k buffers
Swap:  9004392k total,        0k used,  9004392k free,   830804k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND            
 9661 root      20   0  1772  528  440 S   99  0.0   7:12.71 mysqld_safe                   

thor:~$ iostat -x 1
Linux 2.6.24-23-generic (thor) 	04/01/2009

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
          14.50    0.00   36.00    0.00    0.00   49.50

Device:         rrqm/s   wrqm/s     r/s     w/s   rsec/s   wsec/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sdb               0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00

thor:/var/log$ ls -l /var/log/mysql*
-rw-r----- 1 mysql adm    0 2009-04-01 18:25 /var/log/mysql.err
-rw-r----- 1 mysql adm    0 2009-04-01 18:25 /var/log/mysql.log

/var/log/mysql:
total 0

                Thanks,
                Brett

-- 
mysqd_safe high cpu usage
https://bugs.launchpad.net/bugs/105457
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.