Hi.
After some time in production, I can see occasionally error "Too many connections" during health check.
What is default value and how can I change this ?
This is last NSM 8.3 Standalone install.
Solved! Go to Solution.
Because there is MySQL under the NSM, DB connection can be changed in my.cnf file
# Edit NSM_INSTALL_PATH/MySQL/my.ini and locate section
[mysqld] and
modify/add
max_connections = 250
MySQL’s default configuration sets the maximum simultaneous connections to 100.
Note from MySQL doc: The maximum concurrent connection can be maximum range: 4,294,967,295.but please, be carefull setting huge value.
Also see the thread_concurrency
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=8
Hi Lubomir
Could you provide more details?
What's the health check test you are running?
What's the sensor model?
Regards
David
It is not specific check test.
I run standard check tests and sometimes several tests run OK but then the rest of tests returns "SQL Error: Data source rejected establishment of connection, message from server: "Too many connections""
I can see this on E-Mail Server Connectivity, Slow Queries, Unused Custom IPS Policies and some other tests.
When I re-run the same test subset, all is OK and tests return expected values.
NSM is on VMware with 10GB NIC. Local DB on NSM is used.
Hi Lubomir
That message is telling you the MySQL database has more connection requests that is can support.
I'm not 100% on how the Mysql connections are set during the install, but here you have a couple of points you can check:
If as you say, the health check works sometimes, you could also try running the checks when the manager is less busy: i.e. you don't have any scheduled reports/maintenance tasks running.
What is the reason why you are running this health checks? Do you observe any other problems?
Regards
David
Because there is MySQL under the NSM, DB connection can be changed in my.cnf file
# Edit NSM_INSTALL_PATH/MySQL/my.ini and locate section
[mysqld] and
modify/add
max_connections = 250
MySQL’s default configuration sets the maximum simultaneous connections to 100.
Note from MySQL doc: The maximum concurrent connection can be maximum range: 4,294,967,295.but please, be carefull setting huge value.
Also see the thread_concurrency
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=8
This one has been bugging me for a while - glad to see a solution to it!
Download the new ePolicy Orchestrator (ePO) Support Center Extension which simplifies ePO management and provides support resources directly in the console. Learn more about ePO Support Center
Corporate Headquarters
2821 Mission College Blvd.
Santa Clara, CA 95054 USA