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?

1 answer

This one is the BEST answer!

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.


Submitted by Michele.DuBose on Thu, 03/15/2018 - 15:33

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?

Submitted by antoine.mottier on Thu, 03/15/2018 - 15:46

You should benefit from at least one part of the performance improvement in the Community Edition.
Subscription Edition have extra features that can lead to better performance / availability such as the support for cluster environments.

Submitted by Michele.DuBose on Thu, 03/22/2018 - 19:55

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

Submitted by antoine.mottier on Mon, 03/26/2018 - 10:20

You need first to migrate from 6.3.2 to 7.0.0 and then from 7.0.0 to 7.6.3.
See the documentation page about migration.

Submitted by Michele.DuBose on Thu, 05/17/2018 - 16:36

antoine.mottier how do I go about identifying the SQL code of the queries? What configuration in bonita fires off these queries?