[debian-mysql] Bug#679723: Bug#679723: Bug#679723: mysqld: started using loads of CPU when leapsecond passed

[Nicholas Bamber]

forwarded 679723 http://bugs.mysql.com/bug.php?id=65778
thanks

Mozilla IT report the same issue and a possible work around.
http://blog.mozilla.org/it/2012/06/30/mysql-and-the-leap-second-high-cpu-and-the-fix/

On 01/07/12 04:28, Nicholas Bamber wrote:
> Actually on my Linux system it the mysqld process has the hghest CPU:
> 
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
> 
>  2560 mysql     20   0  408m 2372  692 S   53  0.1 155:39.60 mysqld
> 
> On kreebsd-i386 its low
> 74852 mysql    128   0  223m  32m    0 S   0.0  1.6   3:30.71 mysqld
> 
> 
> 
> I tried an strace
> 
> root at taylor:/tmp# strace -p 2560
> Process 2560 attached - interrupt to quit
> restart_syscall(<... resuming interrupted call ...>
> 
> I'm thinking what else I can do to investigate.
> 
> On 01/07/12 03:55, Julian Gilbey wrote:
>> Package: mysql-server-core-5.5
>> Version: 5.5.24+dfsg-4
>>
>> My mysqld recently started using loads of CPU, on two different
>> computers.  There was no obvious reason, and restarting the daemon did
>> not appear to help.  Finding a thread about mythtv suggested a
>> possible reason: the leap second which occurred at 23:59:60 GMT on 30
>> June 2012 (about 3 hours ago now).  Rebooting the computer seems to
>> have sorted the problem.
>>
>> Obviously, this is going to be hard to reproduce and test - either it
>> will have happened to lots of people or not, and it probably won't be
>> reproducible until the next leap second occurs :-(
>>
>> I'm running kernel 3.2.0-2-amd64 (linux-image 3.2.20-1) and running
>> ntpd.
>>
>>    Julian
>>
>>
>>
>> _______________________________________________
>> pkg-mysql-maint mailing list
>> pkg-mysql-maint at lists.alioth.debian.org
>> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint
>>
> 
> 
> 
> 
> _______________________________________________
> pkg-mysql-maint mailing list
> pkg-mysql-maint at lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint
>