MySQL high CPU usage in Bonitasoft
My Bonitasoft application has been erratic lately. It seems the cause is from MySQL. To troubleshoot, I ran the SHOW FULL processlist query. The results were items that are in the Sleep command. Based on my research, the Sleep command does not affect performance. I also enabled slow query log, however, it does not seem to log anything. I checked the space on the Mysql server and it says, 10 GB of 19 GB available. Could the spacing be a potential cause for the high CPU usage? Moreover, I noticed on the Server status dashboard, it says that there are 9 connections. I don't understand what that means or what's connected. Could someone point me in a direction in figuring out what's going on with the MySQL server?
Are you using a dedicated server for the MySQL database or does it run on the same one as the application server that host Bonita?