I have also seen this problem today on MySQL. My /var/log/mysql.err and
.log files are also empty, I suspect this is another bug where the
installation file is not configuring syslogd properly. However, below
are some lines from /var/log/syslog. After I noticed that mysqld_safe
was at 100% cpu, I issued a mysqladmin shutdown. (Note, up until that
point the server and database were still running fine)

I suspect the first "mysqld_safe[15155]: ended" message is from the
shutdown command and the second is the one I manually killed of via top.


----
Jan 22 14:27:24 mysql-01 -- MARK --
Jan 22 14:30:45 mysql-01 mysqld[13897]: 080122 14:30:45 [Note] 
/usr/sbin/mysqld: Normal shutdown
Jan 22 14:30:45 mysql-01 mysqld[13897]:
Jan 22 14:30:47 mysql-01 mysqld[13897]: 080122 14:30:47  InnoDB: Starting 
shutdown...
Jan 22 14:30:52 mysql-01 mysqld[13897]: 080122 14:30:52  InnoDB: Shutdown 
completed; log sequence number 0 71517936
Jan 22 14:30:52 mysql-01 mysqld[13897]: 080122 14:30:52 [Note] 
/usr/sbin/mysqld: Shutdown complete
Jan 22 14:30:52 mysql-01 mysqld[13897]:
Jan 22 14:30:52 mysql-01 mysqld_safe[15155]: ended
Jan 22 14:43:42 mysql-01 mysqld_safe[15180]: ended
Jan 22 14:44:04 mysql-01 mysqld_safe[15279]: started
Jan 22 14:44:08 mysql-01 mysqld[15282]: 080122 14:44:08  InnoDB: Started; log 
sequence number 0 71517936
Jan 22 14:44:08 mysql-01 mysqld[15282]: 080122 14:44:08 [Note] 
/usr/sbin/mysqld: ready for connections.
Jan 22 14:44:08 mysql-01 mysqld[15282]: Version: '5.0.45-Debian_1ubuntu3.1-log' 
 socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Debian etch distribution
Jan 22 14:44:08 mysql-01 /etc/mysql/debian-start[15344]: Upgrading MySQL tables 
if necessary.
Jan 22 14:44:09 mysql-01 /etc/mysql/debian-start[15348]: Looking for 'mysql' 
in: /usr/bin/mysql
Jan 22 14:44:09 mysql-01 /etc/mysql/debian-start[15348]: Looking for 
'mysqlcheck' in: /usr/bin/mysqlcheck
Jan 22 14:44:09 mysql-01 /etc/mysql/debian-start[15348]: This installation of 
MySQL is already upgraded to 5.0.45, use --force if you still need to run 
mysql_upgrade
Jan 22 14:44:09 mysql-01 /etc/mysql/debian-start[15357]: Checking for insecure 
root accounts.
Jan 22 14:44:09 mysql-01 /etc/mysql/debian-start[15361]: Checking for crashed 
MySQL tables.
----

-- 
mysqd_safe high cpu usage
https://bugs.launchpad.net/bugs/105457
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to