cancel
Showing results for 
Search instead for 
Did you mean: 

NSM 8.3 - "Too many connections"

Jump to solution

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.

1 Solution

Accepted Solutions
Highlighted

Re: NSM 8.3 - "Too many connections"

Jump 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

View solution in original post

5 Replies
Reliable Contributor d_aloy
Reliable Contributor
Report Inappropriate Content
Message 2 of 6

Re: NSM 8.3 - "Too many connections"

Jump to solution

Hi Lubomir

Could you provide more details?

What's the health check test you are running?

What's the sensor model?

Regards

David

Re: NSM 8.3 - "Too many connections"

Jump to solution

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.

Reliable Contributor d_aloy
Reliable Contributor
Report Inappropriate Content
Message 4 of 6

Re: NSM 8.3 - "Too many connections"

Jump to solution

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:

  • CPU's of the server where NSM/Mysql is installed will affect the number of threads supported by Mysql (i.e. if you have 4 CPU it will support 4*2=8 threads.
  • Also, when you installed the NSM, did you correctly configure the settings for the right number of sensors you have? The higher the number of sensors, the more connections will be required. Maybe you have installed more sensors lately and this is increasing the connections requests above the initially configured settings.
    • You could try re-running the NSM installer over the current installation and increase the number of sensors to be managed to the maximum and see if that make any difference.

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

Highlighted

Re: NSM 8.3 - "Too many connections"

Jump 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

View solution in original post

Re: NSM 8.3 - "Too many connections"

Jump to solution

This one has been bugging me for a while - glad to see a solution to it!

More McAfee Tools to Help You
  • Subscription Service Notification (SNS)
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • eSupport: Policy Orchestrator
  • Community Help Hub

      New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

    • Find Forum FAQs
    • Learn How to Earn Badges
    • Ask for Help
    Go to Community Help

    Join the Community

      Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

    • Get helpful solutions from McAfee experts.
    • Stay connected to product conversations that matter to you.
    • Participate in product groups led by McAfee employees.
    Join the Community
    Join the Community