MySQL Connections

Solved1.36K viewsMySQl Connections
3
0 Comments

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

3 Answers

1
15.88K 2 Comments

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?

Neil Smith Posted new comment 8th March 2022
Neil Smith commented

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
Neil Smith commented

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.
You are viewing 1 out of 3 answers, click here to view all answers.