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. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
