[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/ubunt

[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 memb

[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 t

[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://

[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:/

[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@li

[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 k

[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:/

[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

[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@list

[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 ubunt

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 : > I woke up this morning and found I was experiencing this issue on 9.04 > (final, standard desktop version).  I also

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

[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@

[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 mem

[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 Re

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

[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

[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

[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

[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@list

[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

[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, wh

[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 Ubunt

[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 Ubun

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

[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 :)

[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 http

[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-1ubun

[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, whi

[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 notifi

[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/105

[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 an

[Bug 105457] Re: mysqd_safe high cpu usage

FYI, someone has filed a bug report on Debian, too, see . (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

[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

[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

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

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

[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

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

[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 subscr

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

[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-b

[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 noti

[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/ubu

[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://list

[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/1054

[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 http

[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 ar

[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 ther

[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

[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: Ne

[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 r

[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

[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

[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 i

[Bug 105457] Re: mysqd_safe high cpu usage

I have the same problem. Yesterday I stopped mysqld through the init.d script, which worked, because there was no listener active, no socketfile, and init.d/mysql status said: Stopped. But I looked on my server today, and there was still a mysqld_safe process taking up 100% cpu. strace -p [my

[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 becaus

[Bug 105457] Re: mysqd_safe high cpu usage

We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on t

[Bug 105457] Re: mysqd_safe high cpu usage

Thank you for taking the time to report this bug and helping to make Ubuntu better. Can you have a look at the log messages in /var/log/mysql.err and /var/log/mysql.log ? ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: New => Incomplete -- mysqd_safe high cpu usage https://bugs.launchpad.

[Bug 105457] Re: mysqd_safe high cpu usage

** Changed in: mysql-dfsg-5.0 (Ubuntu) Sourcepackagename: None => mysql-dfsg-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 ubunt