I have a new Dataminer build and the operation works as expected but shortly after it stops writing data to MySQL.
When checked the 'Max Connections' is reached in MySQL
If the MySQL service is restarted data is again written to the MySQL database until the 'Max Connections' is again reached. Max Connections is set to 100.
I was going to reload the Dataminer software and MySQL from scratch but thought it may be some repairable issue.
Does anyone have any comments ?
Hi Neil greeting!
If you have access to MySQL workbench you can change the Max connections and apply the new setting. We usually use "max_connections=1000" on MySQL deployments.
Please refer to the attached images for guidance.
Hope it helps.
Kind regards
We have seen it before that the max connections reached over 100 on some other setups, what we did in that case is just increase the max connections to 500. You can simply do that in the workbench UI or with a query:
database - How to increase MySQL connections(max_connections)? - Stack Overflow
Restarting then both DataMiner & MySQL should solve the issue permanently. We've never seen it reach over 500 and did not encounter any downsides by doing so.
Hi Neil,
Checking previous DataMiner installers (9.6), the maximum amount of concurrent connections is set to 1000 (Release notes). Please could you confirm which installer has been used in this new DataMiner build?
To be specific I used the 9.5 installer and downgraded to 9.0. In the upgrade process I will check to confirm the Max connections are updated.
HI, its actually an old build still at 9.0 just building new servers to update to 10.2 and this came up.
I will change to 500 max connections and monitor.
Thanks for the comment