[Spce-user] High cpu load on mysql, but no queries
Jon Bonilla (Manwe)
jbonilla at sipwise.com
Wed Jul 4 08:31:37 EDT 2012
El Wed, 04 Jul 2012 14:21:07 +0200
Mario Contreras <mario.contreras at innovasur.es> escribió:
> Hi all.
> I have seen a lot of cpu load in mysqld process. I have googled it and
> it seems it's a kernel's bug due to a leap second happened in 30 June
> 23:59:59 that affects java, mysql and other applications (in fact I
> could check it with vmware, the cpu load boosted in that moment).
> The solution I did is this:
> /etc/init.d/ntp stop; LANG=C date "$(date)"; /etc/init.d/ntp start
> Is there any problem restarting ntp?
Thanks for the tip. We also detected some affected systems and had to restart
ntpd in several PRO systems.
What we did was this:
/etc/init.d/ntp stop; export LANG="en_EN"; date -s "`date`";
touch /tmp/leap_second ; /etc/init.d/ntp start
The explanation was taken from here (German):
More information about the Spce-user