mysql hogs cpu
Posted: Mon Nov 19, 2012 6:14 pm
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 ...
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 ...