[Bug 105457] Re: mysqd_safe high cpu usage

2010-11-14 Thread Jakob Unterwurzacher
*** 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

2010-07-16 Thread Calabacin
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

2010-06-16 Thread Corentin Chary
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

2010-06-16 Thread Corentin Chary
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

2010-01-22 Thread Frank Groeneveld
** 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

2010-01-22 Thread Mathias Gug
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

2009-09-07 Thread blackest_knight
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

2009-09-07 Thread Dave Walker
@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

2009-08-24 Thread Kieran Hogg
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

2009-06-10 Thread sandos
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

2009-06-03 Thread NickA
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

2009-06-03 Thread Frank Groeneveld
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

2009-05-26 Thread Dima Ryazanov
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

2009-05-01 Thread MarcRandolph
 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

2009-04-01 Thread invsblduck
( 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

2009-04-01 Thread invsblduck
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

2009-03-30 Thread Mathias Gug
** 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

2009-02-20 Thread Martin Hansen
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

2009-02-19 Thread Mrts
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

2009-01-21 Thread foucault
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

2008-11-30 Thread E-Jey
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

2008-11-16 Thread Frank Groeneveld
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

2008-11-06 Thread foucault
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

2008-11-06 Thread foucault

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

2008-11-06 Thread foucault
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

2008-11-06 Thread foucault
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

2008-10-28 Thread Mathias Gug
** 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

2008-10-01 Thread john W
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

2008-10-01 Thread john W
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

2008-09-24 Thread Torsten Bronger
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

2008-08-15 Thread syadnom
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

2008-08-09 Thread Chris Twa
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

2008-08-09 Thread Torsten Bronger
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

2008-07-15 Thread William Pitcock
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

2008-07-15 Thread Kashinath Rajendra Pande
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

2008-07-15 Thread Torsten Bronger
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

2008-07-09 Thread Torsten Bronger
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

2008-05-19 Thread dustym
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

2008-05-16 Thread Paul van Genderen
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

2008-04-03 Thread MrTuTu
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

2008-04-03 Thread estaticdeath
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

2008-03-28 Thread estaticdeath
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