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 ?
Robin Devos [SLC] [DevOps Enabler] Selected answer as best 17th May 2023
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
Robin Devos [SLC] [DevOps Enabler] Selected answer as best 17th May 2023