New user's registration have been closed due to high spamming and low trafic on this forum. Please contact forum admins directly if you need an account. Thanks !

100% MySQL CPU Usage

Got problems with your B2 or B3? Share and get helped!
Post Reply
dan13l
Posts: 50
Joined: 20 Apr 2007, 20:30

100% MySQL CPU Usage

Post by dan13l »

I've just put a new drive in my Bubba 2, and it's been chattering away for the last couple of days. I ran top on it, and mysql is using 96.5% of the CPU, has been doing for over 24 hours. Mediatomb seems to be high too, but not anywhere near as bad as MySQL.

I've copied some music and photos onto Bubba, (150gb's worth) could that be causing the high CPU while it indexes?

Presumably I could just uninstall Mediatomb if I'm not using it?
RandomUsername
Posts: 904
Joined: 09 Oct 2009, 18:49

Re: 100% MySQL CPU Usage

Post by RandomUsername »

I experienced the same thing. It's definitely related to Mediatomb indexing your files. Mine ran for more than 24 hours before I killed it. I disabled Mediatomb as I don't use it anyway.
jallee
Posts: 49
Joined: 12 Jun 2009, 13:15

Re: 100% MySQL CPU Usage

Post by jallee »

I have also changed the disk.;-)
380G, took 8 hours to transfer and it was completed for two hours ago.
So you should not have these CPU % so long, here is mine..

top - 20:17:34 up 9:48, 1 user, load average: 0.06, 0.04, 0.08
Tasks: 85 total, 1 running, 84 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.3%us, 0.7%sy, 0.0%ni, 98.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 255804k total, 227484k used, 28320k free, 9964k buffers
Swap: 1048568k total, 2208k used, 1046360k free, 148004k cached

What says:

Code: Select all

free
sfdisk -luS
When you ssh in to the bubba.
Post Reply