Author Topic: mysqld CPU spike issue still around...  (Read 656 times)

JaseP

  • Addicted
  • *
  • Posts: 526
    • View Profile
    • JaseP's LinuxMCE Wiki User page
mysqld CPU spike issue still around...
« on: August 26, 2012, 02:49:49 am »
I am running and apt-get upgrade on my core and MDs (MDs got done relatively quickly)...

I was trying to shut down unnecessary things sucking up bandwidth or traffic on the whole network when I just happened to run a top on the Core, to see if there was anything hogging up system resources that might possibly slow down the upgrade,... That's when I noticed the CPU pegged near 100% on the mysqld... (turns out it had nothing to do with the slowness,... apparently that's just my connection to the LinuxMCE servers)...

I searched the forums and noticed that this appeared back in the 810 version, ... and that several people had noticed that if you kill mysqld it doesn't hog CPU cycles when it respawns... So I did that, and whataya know... same thing on 1004... a well behaved, respawned mysqld after killing it... (of course it had nothing to do with download efficiency) .

Does anyone know what's causing this??
See my User page on the LinuxMCE Wiki for a description of my system configuration (click the little globe under my profile pic).

posde

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 2997
  • Wastes Life On LinuxMCE Since 2007
    • View Profile
    • My Home
Re: mysqld CPU spike issue still around...
« Reply #1 on: August 26, 2012, 10:08:48 am »
You might want to look at CPU utilization of mysqld for a longer period of time, and see if you can find a pattern.

hari

  • Administrator
  • LinuxMCE God
  • *****
  • Posts: 2421
    • View Profile
    • ago control
Re: mysqld CPU spike issue still around...
« Reply #2 on: August 26, 2012, 10:18:01 am »
I'd also try to use the log_slow_queries setting in my.cnf
rock your home - http://www.agocontrol.com home automation

dextaslab

  • Veteran
  • ***
  • Posts: 75
    • View Profile
    • modlog.net
Re: mysqld CPU spike issue still around...
« Reply #3 on: August 26, 2012, 12:28:52 pm »
Possibly try installing mrtg, or collectd to graph cpu usage, that way you'll be able to better determine when it happens and possibly why. What CPU/RAM does the affected system have?

JaseP

  • Addicted
  • *
  • Posts: 526
    • View Profile
    • JaseP's LinuxMCE Wiki User page
Re: mysqld CPU spike issue still around...
« Reply #4 on: August 26, 2012, 02:58:08 pm »
The system is an Intel dual core with 4GB RAM...
See my User page on the LinuxMCE Wiki for a description of my system configuration (click the little globe under my profile pic).