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 ?
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.