Mysql Maxing out CPU

Question

Mysql Maxing out CPU

My Xserve has become unresponsive as of late. After looking through processes, I find this:

Mysql is crushing my CPU at over 100% usage for a minute, then going away, only to reappear and further bog it down. So, I kill it. It reappears. I restart the server, it reappears. I then double check that it is not enabled under in the Server Admin preferences and it is not. So, what other services in 10.6.8 Server require Mysql? Any help disabling it would be greatly appreciated as the server is almost unusable.

MacBooks, iMacs, Xserves, etc, Mac OS X (10.6.8)

Posted on Sep 25, 2012 8:38 AM

Reply

Answer 1

Sep 25, 2012 9:34 AM in response to Russell Lindenschmidt

Review the server console logs and see what relevent information (if any) is being logged related to this.

Reply

Answer 2

Sep 25, 2012 10:03 AM in response to MrHoffman

Looked through the logs for the PID and User, the only reference I could find was SystemStarter calling the Mysql runner and then starting MySQL database server. Not sure why SystemStarter would do that as the service is turned off though?

Reply

Answer 3

Sep 25, 2012 11:44 AM in response to Russell Lindenschmidt

If there's something wacky that's auto-relaunching MySQL, the process id will be a moving target.

Launch Console.app and have a look at the MySQL log.

If the system is fairly quiet while you're looking at the logs, then looking at all logged messages with Console.app can be feasible, too.

Reply

Answer 4

Sep 25, 2012 1:03 PM in response to MrHoffman

The only thing in MySQL.log is upgrade info from 2011-11-30:

*snip*

2011-11-30 08:38:53 America/Denver [I] ==== MySQL admin log created ====

2011-11-30 08:38:53 America/Denver [I] Performing Migration/Upgrade for MySQL Service.

2011-11-30 08:38:53 America/Denver [I] Migration options:

2011-11-30 08:38:53 America/Denver [I] purge = YES

2011-11-30 08:38:53 America/Denver [I] sourceRoot = /Previous System

2011-11-30 08:38:53 America/Denver [I] sourceType = System

2011-11-30 08:38:53 America/Denver [I] sourceVersion = 10.5.8

2011-11-30 08:38:53 America/Denver [I] targetRoot = /

*snip*

I've been watching all logged messages with the Console during lunch, and nothing pops up for MySQL.

Reply

Answer 5

Sep 25, 2012 3:55 PM in response to Russell Lindenschmidt

Tried grepping the logs for any mysql chatter?

Reply