[Bug 105457] Re: mysqd_safe high cpu usage

[john W]

I am running Ubuntu 8.04 Hardy 64 bit. 
This exact problem started when I added MythTV from the standard repository. 
MythTV adds a MySQL server. 
I had already had  MySQL server from an Apache install. 
Now I seem to have two SQL servers. 

I have some clues to add, although I am a Linux newbie and a recent Vista convert. 
I had the mysqld_safe process running at 100 percent on one processor. 
I ran this command: "sudo /etc/init.d/mysql restart" 
and now I have two mysqld_safe processes running, 100 percent on both of two processors. 

A view of /var/log/syslog shows a gazillion lines like this:


Oct  1 07:37:48 Athlon-Ubuntu kernel: [112619.174876] VFS: busy inodes on changed media.
Oct  1 07:37:48 Athlon-Ubuntu kernel: [112619.189661] VFS: busy inodes on changed media.
Oct  1 07:38:04 Athlon-Ubuntu kernel: [112635.159970] VFS: busy inodes on changed media.
Oct  1 07:38:04 Athlon-Ubuntu kernel: [112635.173478] VFS: busy inodes on changed media.

And then there was this interesting set of lines:

Oct  1 10:15:20 Athlon-Ubuntu mysqld_safe[24687]: Fatal error: Can't remove the pid file: /var/run/mysqld/mysqld.pid
Oct  1 10:15:20 Athlon-Ubuntu mysqld_safe[24689]: Please remove it manually and start /usr/bin/mysqld_safe again
Oct  1 10:15:20 Athlon-Ubuntu mysqld_safe[24691]: mysqld daemon not started

And then more of the gazillion lines

And then this, which happened at the time I issued the restart:

Oct  1 10:15:43 Athlon-Ubuntu mysqld_safe[24932]: started
Oct  1 10:15:43 Athlon-Ubuntu mysqld[24935]: 081001 10:15:43  InnoDB: Started; log sequence number 0 43655
Oct  1 10:15:43 Athlon-Ubuntu mysqld[24935]: 081001 10:15:43 [Note] /usr/sbin/mysqld: ready for connections.
Oct  1 10:15:43 Athlon-Ubuntu mysqld[24935]: Version: '5.0.51a-3ubuntu5.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
Oct  1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24974]: Upgrading MySQL tables if necessary.
Oct  1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24983]: Looking for 'mysql' in: /usr/bin/mysql
Oct  1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24983]: Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck
Oct  1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24983]: This installation of MySQL is already upgraded to 5.0.51a, use --force if you still need to run mysql_upgrade
Oct  1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24989]: Checking for insecure root accounts.
Oct  1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24993]: WARNING: mysql.user contains 3 root accounts without password!
Oct  1 10:15:44 Athlon-Ubuntu /etc/mysql/debian-start[24994]: Checking for crashed MySQL tables.
Oct  1 10:15:45 Athlon-Ubuntu kernel: [122085.868833] VFS: busy inodes on changed media.

And then, more of the gazillion lines.

I am going to try the manual remove of the Pid file and post the
results.

John.

-- 
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.