MySQL server causing application to hang
In troubleshooting MySQL , I check what queries are running and status of a server with SHOW FULL PROCESSLIST in MySQL server and process status. From the results from the query, they're multiple items that are running Select statements, which seem to take a significant amount of time to process. These Select statements seem to be queries that Bonitasoft creates and runs in the background. My first question is, what is the purpose of these queries? Second, is there any ramifications for killing the queries that take a long time to complete?
For additional information, the MySQL server runs on the same server as the application server that host Bonitasoft.
Do you have the details of these requests? Also it seems you're using an old version of the platform, a lot of optimization have been done since the version 6.3.2.