[Bug 105457] Re: mysqd_safe high cpu usage
*** This bug is a duplicate of bug 675185 *** https://bugs.launchpad.net/bugs/675185 ** This bug has been marked a duplicate of bug 675185 [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU * You can subscribe to bug 675185 by following this link: https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.0/+bug/675185/+subscribe -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
*** This bug is a duplicate of bug 675185 *** https://bugs.launchpad.net/bugs/675185 ** This bug has been marked a duplicate of bug 675185 [Hardy SRU] dash bug causes mysqld_safe to spin at 100% CPU * You can subscribe to bug 675185 by following this link: https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.0/+bug/675185/+subscribe -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
If it's hard to reproduce for you, I'm having it every now and then on my Ubuntu 9.04 server 64-bit, and I am willing to enable logs and do anything necessary to help you. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
If it's hard to reproduce for you, I'm having it every now and then on my Ubuntu 9.04 server 64-bit, and I am willing to enable logs and do anything necessary to help you. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
It seems to be a dash bug, partly fixed by: http://git.kernel.org/?p=utils/dash/dash.git;a=commit;h=3800d4934391b144fd261a7957aea72ced7d47ea And this bug should be fixed, it's still present in Hardy, and Hardy support should stop April 21, 2011, not in 2010. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
Please also note that the mysql bug may not be present in karmic because mysqld_safe was rewriting, but the dash bug is still here. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
It seems to be a dash bug, partly fixed by: http://git.kernel.org/?p=utils/dash/dash.git;a=commit;h=3800d4934391b144fd261a7957aea72ced7d47ea And this bug should be fixed, it's still present in Hardy, and Hardy support should stop April 21, 2011, not in 2010. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Please also note that the mysql bug may not be present in karmic because mysqld_safe was rewriting, but the dash bug is still here. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
** Also affects: server-papercuts Importance: Undecided Status: New -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
Not a server papercut. The bug has been opened for a long time as it's not reliably reproducible. This bug will probably be marked as won't fix as mysqld_safe should be replaced by an upstart job. ** Changed in: server-papercuts Status: New = Invalid -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
** Also affects: server-papercuts Importance: Undecided Status: New -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Not a server papercut. The bug has been opened for a long time as it's not reliably reproducible. This bug will probably be marked as won't fix as mysqld_safe should be replaced by an upstart job. ** Changed in: server-papercuts Status: New = Invalid -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I have this problem in 64-bit desktop karmic running mysql 5.1.37-1ubuntu5. As part of my daily maintenance chores, I 'sudo /etc/init.d/mysql stop' the server, copy the database directory to my backup drive and 'sudo /etc/init.d/mysql start' the server afterwards. Frequently, and I do not know when or why, the mysqld_safe process is not stopped by the above command. The start command launches its own instance of the mysqld_safe process. And bingo, we've got to competing mysqld_safe processes and the load of one of the cpu's goes to 100%. As a temporary solution, I will issue a 'sudo killall mysqld_safe' immediately after the stop command. However this should not be needed, and I feel that this problem is really a showstopper, far from unimportant! -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
came across this on ubuntu karmic alpha 5 , It was nice enough to share the cpu and luckily after rebooting the cpu usage was fine. Having to reboot was disappointing. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
@Kieran Hogg This should be resolved in 5.1.37-1ubuntu3 -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
came across this on ubuntu karmic alpha 5 , It was nice enough to share the cpu and luckily after rebooting the cpu usage was fine. Having to reboot was disappointing. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
@Kieran Hogg This should be resolved in 5.1.37-1ubuntu3 -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I'm now getting this for the first time after upgrading to 5.1.37-1ubuntu2. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I'm now getting this for the first time after upgrading to 5.1.37-1ubuntu2. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Happens to me, too. Killing the mysqld_safe works, but I guess that is only temporary? -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
Happens to me, too. Killing the mysqld_safe works, but I guess that is only temporary? -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I woke up this morning and found I was experiencing this issue on 9.04 (final, standard desktop version). I also saw two instances of mysql_safe with one eating all the CPU. I installed mytop but didn't see anything happening, and /etc/init.d/mysql restart did not help. Both mysql.log and mysql.err were empty files. The only mysql database on this box is for Amarok 1.4, and amarok was not running at the time. Last night the problem was definitely not occurring, and I hadn't logged into this system for a couple days prior to that (the box was restarted on Sunday). The commands I performed last night were: an apt-get update apt-get upgrade apt-get install prelink prelink -amR I just went through y dpkg.log, and mysql was updated last night, so I'm willing to bet the bug was somehow triggered by that process. -- 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
Re: [Bug 105457] Re: mysqd_safe high cpu usage
We already know that the bug is triggered by something that restart the mysql process (On my server it sometimes even occurs when I run /etc/init.d/mysql restart) 2009/6/3 NickA sdnick...@gmail.com: I woke up this morning and found I was experiencing this issue on 9.04 (final, standard desktop version). I also saw two instances of mysql_safe with one eating all the CPU. I installed mytop but didn't see anything happening, and /etc/init.d/mysql restart did not help. Both mysql.log and mysql.err were empty files. The only mysql database on this box is for Amarok 1.4, and amarok was not running at the time. Last night the problem was definitely not occurring, and I hadn't logged into this system for a couple days prior to that (the box was restarted on Sunday). The commands I performed last night were: an apt-get update apt-get upgrade apt-get install prelink prelink -amR I just went through y dpkg.log, and mysql was updated last night, so I'm willing to bet the bug was somehow triggered by that process. -- mysqd_safe high cpu usage https://bugs.launchpad.net/bugs/105457 You received this bug notification because you are a direct subscriber of the bug. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I woke up this morning and found I was experiencing this issue on 9.04 (final, standard desktop version). I also saw two instances of mysql_safe with one eating all the CPU. I installed mytop but didn't see anything happening, and /etc/init.d/mysql restart did not help. Both mysql.log and mysql.err were empty files. The only mysql database on this box is for Amarok 1.4, and amarok was not running at the time. Last night the problem was definitely not occurring, and I hadn't logged into this system for a couple days prior to that (the box was restarted on Sunday). The commands I performed last night were: an apt-get update apt-get upgrade apt-get install prelink prelink -amR I just went through y dpkg.log, and mysql was updated last night, so I'm willing to bet the bug was somehow triggered by that process. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 105457] Re: mysqd_safe high cpu usage
We already know that the bug is triggered by something that restart the mysql process (On my server it sometimes even occurs when I run /etc/init.d/mysql restart) 2009/6/3 NickA sdnick...@gmail.com: I woke up this morning and found I was experiencing this issue on 9.04 (final, standard desktop version). I also saw two instances of mysql_safe with one eating all the CPU. I installed mytop but didn't see anything happening, and /etc/init.d/mysql restart did not help. Both mysql.log and mysql.err were empty files. The only mysql database on this box is for Amarok 1.4, and amarok was not running at the time. Last night the problem was definitely not occurring, and I hadn't logged into this system for a couple days prior to that (the box was restarted on Sunday). The commands I performed last night were: an apt-get update apt-get upgrade apt-get install prelink prelink -amR I just went through y dpkg.log, and mysql was updated last night, so I'm willing to bet the bug was somehow triggered by that process. -- mysqd_safe high cpu usage https://bugs.launchpad.net/bugs/105457 You received this bug notification because you are a direct subscriber of the bug. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I got this behavior when mysql got uninstalled when I ran apt-get autoremove. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I got this behavior when mysql got uninstalled when I ran apt-get autoremove. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I've got this problem on Ubuntu 9.04 RC (Mythbuntu). Dang strange database behavior. It seems mysql sometimes boots okay but sometimes it boots and I can't connect to it. That behavior sounds like Bug 326768 (https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.0/+bug/326768). It may not be ideal, but have you investigated the work-around presented there? -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I've got this problem on Ubuntu 9.04 RC (Mythbuntu). Dang strange database behavior. It seems mysql sometimes boots okay but sometimes it boots and I can't connect to it. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
( Sorry for not attaching that, guys. ) -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
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 ama...@localhost identified by ''; 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 %MEMTIME+ 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.500.00 36.000.000.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.000.00
[Bug 105457] Re: mysqd_safe high cpu usage
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 ama...@localhost identified by ''; 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 %MEMTIME+ 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.500.00 36.000.000.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.000.00
[Bug 105457] Re: mysqd_safe high cpu usage
( Sorry for not attaching that, guys. ) -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: Confirmed = Triaged -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: Confirmed = Triaged -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I can confirm the same problem. @foucault: I was running an amazon EC2 instance, AMI-ID: ami-7efd1a17 (http://alestic.com/), 32 bit, 8.04. And I also had 2 running mysqld_safe processes, one running wild, the other one as expected. (kinda easy to overlook the other process if you are just hunting down the culprit, as one usually sort by cpu usage :P) And I also think I tried to start the mysql server when it already was running, as described as part of the problem in the mysql bug tracker link you gave. Although I'm not able to reproduce it by trying to start mysql when already started.. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I can confirm the same problem. @foucault: I was running an amazon EC2 instance, AMI-ID: ami-7efd1a17 (http://alestic.com/), 32 bit, 8.04. And I also had 2 running mysqld_safe processes, one running wild, the other one as expected. (kinda easy to overlook the other process if you are just hunting down the culprit, as one usually sort by cpu usage :P) And I also think I tried to start the mysql server when it already was running, as described as part of the problem in the mysql bug tracker link you gave. Although I'm not able to reproduce it by trying to start mysql when already started.. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Same here -- 100% CPU with 32-bit iron (no virtualization). On Hardy that should be long term supported. It's quite serious, can anyone from Canonical comment on this? -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
Same here -- 100% CPU with 32-bit iron (no virtualization). On Hardy that should be long term supported. It's quite serious, can anyone from Canonical comment on this? -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Just squashed this bug on yet another server I think this only affects 32bit xen-kernal virtual instances, slicehost amazon ec2 etc. care to confirm, comment? -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
Just squashed this bug on yet another server I think this only affects 32bit xen-kernal virtual instances, slicehost amazon ec2 etc. care to confirm, comment? -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
@foucault - Nope. Mine (reported earlier) was x86-64 on raw iron; not xen. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I also have this problem, very annoying. I killed the process and changed the /etc/init.d/mysql script. It seems to work but maybe it will come back.. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I also have this problem, very annoying. I killed the process and changed the /etc/init.d/mysql script. It seems to work but maybe it will come back.. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I can confirm this bug. Ubuntu 8.04.1 - 64-bit. ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: Triaged = Confirmed -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
How come this bugs importance is set to low? My virtual host is unusable when this bug happens and sometimes even apache starts failing because of the high load. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
How come this bugs importance is set to low? My virtual host is unusable when this bug happens and sometimes even apache starts failing because of the high load. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Confirm, this is happening to me... 2.6.22-14-generic #1 SMP Tue Dec 18 08:02:57 UTC 2007 i686 GNU/Linux I have these mysql packages installed ii mysql-client-5.0 5.0.45-1ubuntu3.3 MySQL database client binaries ii mysql-common 5.0.45-1ubuntu3.3 MySQL database common files rc mysql-common-4.1 4.1.11a-4sarge4 mysql database common files (e.g. /etc/mysql/my.cnf) ii mysql-server-5.0 5.0.45-1ubuntu3.3 MySQL database server binaries -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
init.d/mysql script: ERR_LOGGER= This did not help me. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
adding SLEEP 3 to mysqld_safe script did not help also I noticed that init.d/mysql stop did not stop the process, i had to kill XX manually and then restart. I have both sleep 3 and ER_LOGGER= in place and its still juping between 80-99% reverting to old setting and begging my thread stalk :) -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
found what I think the msql bug might be:
http://bugs.mysql.com/bug.php?id=35647
I saw two copies of mysql_d running ...
I solved it for now, by both editing the /etc/init.d/mysql and starting
and stopping mysql a bunch.
I commented out sanity check, as per the suggestion here
http://forum.slicehost.com/comments.php?DiscussionID=1000
case ${1:-''} in
'start')
# sanity_checks;
# Start daemon
I hope this is helpfull, (I wish I could edit my posts...) well you get
the train of thought effect this way :P
--
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
[Bug 105457] Re: mysqd_safe high cpu usage
Confirm, this is happening to me... 2.6.22-14-generic #1 SMP Tue Dec 18 08:02:57 UTC 2007 i686 GNU/Linux I have these mysql packages installed ii mysql-client-5.0 5.0.45-1ubuntu3.3 MySQL database client binaries ii mysql-common 5.0.45-1ubuntu3.3 MySQL database common files rc mysql-common-4.1 4.1.11a-4sarge4 mysql database common files (e.g. /etc/mysql/my.cnf) ii mysql-server-5.0 5.0.45-1ubuntu3.3 MySQL database server binaries -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
init.d/mysql script: ERR_LOGGER= This did not help me. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
adding SLEEP 3 to mysqld_safe script did not help also I noticed that init.d/mysql stop did not stop the process, i had to kill XX manually and then restart. I have both sleep 3 and ER_LOGGER= in place and its still juping between 80-99% reverting to old setting and begging my thread stalk :) -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
found what I think the msql bug might be:
http://bugs.mysql.com/bug.php?id=35647
I saw two copies of mysql_d running ...
I solved it for now, by both editing the /etc/init.d/mysql and starting
and stopping mysql a bunch.
I commented out sanity check, as per the suggestion here
http://forum.slicehost.com/comments.php?DiscussionID=1000
case ${1:-''} in
'start')
# sanity_checks;
# Start daemon
I hope this is helpfull, (I wish I could edit my posts...) well you get
the train of thought effect this way :P
--
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 subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
** Also affects: mysql-dfsg-5.0 (Debian) via http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=499192 Importance: Unknown Status: Unknown -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
** Also affects: mysql-dfsg-5.0 (Debian) via http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=499192 Importance: Unknown Status: Unknown -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Deleting the Pid file made no difference. I used sudo top and killed the two Mysql_safe processes and all is ok now. If and when it returns I will post the conditions of return. I hope these clues help to squish the bug. 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
[Bug 105457] Re: mysqd_safe high cpu usage
I just checked, the gazillion VFS lines noted above are continuing inside of /var/log/syslog. The workaround may not be totally effective yet, unless there is some other problem on my system. 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
[Bug 105457] Re: mysqd_safe high cpu usage
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 Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Deleting the Pid file made no difference. I used sudo top and killed the two Mysql_safe processes and all is ok now. If and when it returns I will post the conditions of return. I hope these clues help to squish the bug. John. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I just checked, the gazillion VFS lines noted above are continuing inside of /var/log/syslog. The workaround may not be totally effective yet, unless there is some other problem on my system. John. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
FYI, someone has filed a bug report on Debian, too, see http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=499192. (Maybe there're duplicates, I don't know.) -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
FYI, someone has filed a bug report on Debian, too, see http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=499192. (Maybe there're duplicates, I don't know.) -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Also affects Hardy. What justifies this being a low priority bug? This is pretty serious. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
the mysqld_safe script is where the bug is. it loops at full throttle. just an a sleep # in and it slows the looping. crazy that it eats up so many cpu cycles so fast! but non-attached shell scripts can spin in loop like this. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
the mysqld_safe script is where the bug is. it loops at full throttle. just an a sleep # in and it slows the looping. crazy that it eats up so many cpu cycles so fast! but non-attached shell scripts can spin in loop like this. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I had a fresh install of Ubuntu Hardy with MySQL 5.0.51 and found the mysqld_safe using 100% CPU. The fix I did was edit the init.d/mysql script: ERR_LOGGER= I've got a ton of nodes, so I don't often sift through these logs anyway -- YMMV CaT -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I suspect some sort of race condition between two mysql_safe processes. At least, every time I experienced this bug, there were at last two mysql_safe processes active, and at least one of them was running amok. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I had a fresh install of Ubuntu Hardy with MySQL 5.0.51 and found the mysqld_safe using 100% CPU. The fix I did was edit the init.d/mysql script: ERR_LOGGER= I've got a ton of nodes, so I don't often sift through these logs anyway -- YMMV CaT -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I suspect some sort of race condition between two mysql_safe processes. At least, every time I experienced this bug, there were at last two mysql_safe processes active, and at least one of them was running amok. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
This is hitting me really hard on a cluster I run with several users having ubuntu instances. Many instances are using 100% CPU due to this bug and causing the overall degradation of service I can provide on my cluster. It needs to be fixed, the rating Importance: low is entirely bogus. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I'm in agreement with William. I, too, run VPS's for several users and offer Ubuntu as a choice. When they run MySQL, CPU usage is through the roof, killing any hope in hell for equal CPU rights with other users. The low importance is probably due to the fact that Cancomical realises that no one should ever use Ubuntu for any server installation, ever, and thus aren't going to deal with this any further. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I experienced this bug three times in two weeks. On my system, it implies that my backups take two hours instead of 10 minutes. On other systems, it may silently render the backup plan (or other maintainance) impossible, and this is no fun anymore. In my personal opinion, this is even critical. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I'm in agreement with William. I, too, run VPS's for several users and offer Ubuntu as a choice. When they run MySQL, CPU usage is through the roof, killing any hope in hell for equal CPU rights with other users. The low importance is probably due to the fact that Cancomical realises that no one should ever use Ubuntu for any server installation, ever, and thus aren't going to deal with this any further. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I experienced this bug three times in two weeks. On my system, it implies that my backups take two hours instead of 10 minutes. On other systems, it may silently render the backup plan (or other maintainance) impossible, and this is no fun anymore. In my personal opinion, this is even critical. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
This is hitting me really hard on a cluster I run with several users having ubuntu instances. Many instances are using 100% CPU due to this bug and causing the overall degradation of service I can provide on my cluster. It needs to be fixed, the rating Importance: low is entirely bogus. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Can someone confirm Eskimo's report? Actually, mysqld_safe is part of mysql-server-5.0, so I can't really believe that this disables it. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
Can someone confirm Eskimo's report? Actually, mysqld_safe is part of mysql-server-5.0, so I can't really believe that this disables it. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Actually it worked for me, but I have to remove everything related to MySql. So you can go to Synaptic Package Manager and search for mysql-, then sort it out by installed flag to get the found installed packages on top of list, then mark it for Complete Removal and finally apply the changes. After that install only specific mysql packages as mysql-server-5.0 and mysql-client-5.0 (see attached screen-shot for detail). Fill the difference: 1. No 100% CPU usage 2. mysqld is running instead of mysqld_safe ** Attachment added: That's what I have after solving this problem http://launchpadlibrarian.net/15443658/Screenshot-Synaptic%20Package%20Manager%20.png -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I agree with Paul van Genderen, estaticdeath's solution didn't work for me, either. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I agree with Paul van Genderen, estaticdeath's solution didn't work for me, either. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
estaticdeath: although I did have the mysql-server meta package, your solution didn't work for me. I wouldn't consider this bug triaged yet until there's a real solution. Thanks for your efforts though! -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
estaticdeath: although I did have the mysql-server meta package, your solution didn't work for me. I wouldn't consider this bug triaged yet until there's a real solution. Thanks for your efforts though! -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Thank you estaticdeath. Your solution works well ! -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
nevermind MrTuTu. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
Thank you estaticdeath. Your solution works well ! -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
nevermind MrTuTu. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
hey guys, the solution was to not install both mysql-server (meta package depending on the latest version) and mysql-server-5.0 (MySQL database server binaries), i just remove both and reinstall mysql- server-5.0 and it done well ! -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
hey guys, the solution was to not install both mysql-server (meta package depending on the latest version) and mysql-server-5.0 (MySQL database server binaries), i just remove both and reinstall mysql- server-5.0 and it done well ! -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I previously said that this will trigger it every time: $ apt-get remove --purge mysql-server-5.0 This is not the case. However, if you purge, then install, then immediately purge, you will trigger the bug. See my comments on 2008-03-13 for my thoughts on why. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
I have this problem too, and mysql has just been installed on my system (I installed the LAMP system from Synaptic). I did not touch any config file. It is using factory settings. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
This might be related to checking for crashed tables (ie poor interaction between debian-start and mysqld_safe). I noticed that mysql would not accept connections until the crashed tables operation was completed. mysqld_safe and /etc/init.d/mysql use mysqladmin to connect to the database, so there may be poor interaction here. -- 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 subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 105457] Re: mysqd_safe high cpu usage
Also run into this bug when preforming an upgrade. An interesting entry in /var/log/daemon.log: mysqld_safe[4464]: mysqld process hanging, pid 4356 - killed Not sure if it's related to this process though. ** Changed in: mysql-dfsg-5.0 (Ubuntu) Importance: Undecided = Low Status: New = Triaged -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
This will trigger it every time: $ apt-get remove --purge mysql-server-5.0 -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
the mysql log files are always empty on a debian/ubuntu system. mysql logs to syslog. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
I had the same problem: mysqd_safe using 100% CPU running wait4() syscall. The problem started just after I've restarted MySQL, because I've changed the configuration file (I've changed bind-address from 127.0.0.1 to 0.0.0.0 in /etc/mysql/my.cnf). I've noticed that more than one mysql_safe was running. After killall mysql_safe and started again the server, everything went back to normal. -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
Oops, forgot some version info... MySQL Version = 5.0.45-Debian_1ubuntu3.1-log uname -a = Linux mysql-01 2.6.22-14-server #1 SMP Sun Oct 14 22:09:15 GMT 2007 x86_64 GNU/Linux -- 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
[Bug 105457] Re: mysqd_safe high cpu usage
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
[Bug 105457] Re: mysqd_safe high cpu usage
I've also encountered this bug, though have been unable to reproduce it. My mysql.err and mysql.log files are empty. ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: Invalid = New -- 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
