We have a Java based SaaS application running on MySQL database on a 2 GB Linux VPS.
Recently we added RAM to the server and since couple of days, MySQL is taking up 99% of CPU usage. We are quite clueless as to why this is happening.
We have made some changes in the my.cnf file as we have read in certain forums. We have enhanced the resources for MySQL.
Where can we go next?