This section explains how to tune the database performance of MB by configuring various parameters in the master-datasources.xml file.
|Improvement Area||Description||Performance Recommendations|
|The maximum number of active connections||This is specified by entering a value for the ||This should be set in proportion to the number of messages published and consumed. If there are too many active connections in the connection pool, some of them would be idle, incurring an unnecessary system overhead. The default/recommended value is 100.|
|The maximum waiting time.||The ||A lower number of milliseconds can be set if you want the database to be updated faster. If you increase the waiting time, it will reduce the performance of the MB in terms of the publish/consumption rate. The default/recommended value is 30000.|
|Testing objects borrowed from the pool||Select ||This parameter should be set to |
|Validation interval||The ||The purpose of the parameter is to control system overhead that can be caused by excessive validation tests. the default/recommended value is 30000 milliseconds. You can increase this value to minimise the system overhead or reduce it if it is more important to ensure the reliability of the connections.|