mysql hogs cpu

Forum for questions and support relating to the 1.25.x releases only.
Locked
Carrier82
Posts: 96
Joined: Sat Jul 28, 2012 8:30 pm

mysql hogs cpu

Post by Carrier82 »

Hi

I have a four camera Atom D2700 server running ubuntu 12.01 and zm 1.25. I have a couple of hundred events and now the server has turned almost completely unresponsive. I suspect the reason is that the mysqld process hogs all the processing power of one core (according to top). Google hasn't been helpful, any ideas on troubleshooting? I did check all tables, all ok. Did try restarting the mysql server but nothing, cpu use climbs instantly. It used to work ... :(
Flasheart
Posts: 342
Joined: Thu Jul 06, 2006 2:27 pm

Re: mysql hogs cpu

Post by Flasheart »

Running out of memory?

Try running htop, free and iotop to try and find where the bottleneck lies. Any general performance guide will help you.
Locked