Bonita MySQL background queries
I am running Bonita 6.32 and MySQL 5.6.19. There are background select queries running on the MySQL repository. These queries take a long time to complete which causes the Bonita application to hang. The application and MySQL are on the same server. Can anyone tell me the purpose of these select queries? How can I solve the issue of the queries taking a long time to process? Is there a way to prevent the application from hanging when the queries take a long time to complete?
The background queries are most likely related to process timers and messages events management (asynchronous processing).
I recommend to upgrade to the latest version of Bonita as some continuous improvement have been done on SQL queries performance especially in version 7.4, 7.5 and 7.6.0.
If you are able to identify exactly the SQL code of the queries that might help to isolate the issue but for community users I'm afraid that the only suggestion I'll have is to update to the latest version.
Thank you antoine.mottier for your response. Will the improvement for the SQL queries apply if I upgrade to the Community Edition of the latest version or would I need to obtain the Subscription Edition?
Can I go straight from version 6.3.2 to 7.6.0 or should I migrate incrementally? For example, 6.3.2 to 7.0; 7.0 to 7.6.0
antoine.mottier how do I go about identifying the SQL code of the queries? What configuration in bonita fires off these queries?