My website is being very slow or non-responsive. A quick look at the top
command shows me something like this:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1709 mysql 20 0 828m 432m 5584 S 382.6 5.4 7414:24 mysqld
The rest of the processes are way below those values. Obviously MySQL is having some issues. How can I check what is actually going on and why does it take so many resources?
Thanks.