We are experiencing problems with our Percona Server. After 1 week of uptime the CPU% increases up to 80% with insignificant load. After restarting the server, CPU% drop to less then 3%. This obviously worries us because we expect big growth in the upcoming days. Slowqueries.log does not show us anything significant.
How can we debug this problem?
These are our specs:
Opsys: CentOS release 6.2 (Final)
Kernel: 2.6.32-220.13.1.el6.x86_64 GNU/Linux
Server version: 5.5.27-28.0-log Percona Server (GPL), Release rel28.0, Revision 291