MySQL high CPU usage in Bonitasoft
Hello,
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?
No answers yet.
Comments
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?
It is on the application server.
Also, I noticed a separate issue which may have to be asked in a different forum, that Bonita Portal does not work all the time with Chrome. I found this link here which talks about the software being incompatible with Chrome 60: https://bonita.atlassian.net/browse/BBPMC-509. However, based on the information in this link, does this affect version 6.3.2 also?
I was able to identify that when the CPU usage is high, the results from the FULL processlist query displays multiple items that are in the query command. I'm assuming this is a possible cause for the high usage. If so, what's the purpose of those queries? They're all Select statements that seem to take a long time to execute. I noticed in the dashboard that I can kill a query or connection but I'm not sure what the ramifications of doing so would do to the application.