cancel
Showing results for 
Search instead for 
Did you mean: 

Too many Database connections

Jump to solution

Current connection : 146

A value outside the normal range can indicate a heavy load on the DB, which can affect DB and overall Manager Performance  - Normal range: <90 

What I have done so far:

1. Update Max_Connection to 250 in the NSM_INSTALL_PATH/MySQL/my.ini

2. Verified Config of NSM Manager and MySQL is installed

Intel Xeon CPU E5-2697 v2 @ 2.7 GHz 

RAM - 32 GB

OS - Windows Server 2008 R2 Standard with SP1 - 64 bit

 

NSM Manager version - 9.1.7.75

Sensor model : M-4050

Sensor Software: 9.1.3.13

 

Any help will be greatly appreciated 

 

Thanks,

Gagandeep

1 Solution

Accepted Solutions
Reliable Contributor petermason
Reliable Contributor
Report Inappropriate Content
Message 7 of 8

Re: Too many Database connections

Jump to solution

Hi Gagandeep,

I looked back through my old SR's and see that I reported this to them previously.

There was no solution to the SR at the time.

I normally just run thee health checks one group at a time, Summary, Database and Connectivity.

Regards

Peter

View solution in original post

7 Replies
Reliable Contributor petermason
Reliable Contributor
Report Inappropriate Content
Message 2 of 8

Re: Too many Database connections

Jump to solution

Hey Gagandeep,

Is this for the same environment with 1 manager and 2 sensors?

Where are you seeing this error? Is it appearing in the Health Checks?

Are you seeing the error continuously or is it intermittent?

What volume of alerts are you generating per sensor and what is the size of your DB?

Have you run tuning on the DB recently?

Regards

Peter

 

Re: Too many Database connections

Jump to solution

Hello Peter,

 

Yes, this is for the same environment.

Correct, it is appearing on the Health Check.

I would say, I see it continuously.

DB size is 1 GB with largest Table: 394 MB

Alert Count - 234,421 - Oldest Alert: Mar 01 03:00:05 2019
Newest Alert: May 30 14:50:07 2019

DB is set to autotune Every Saturday for All Tables.

Last Tuning Time:  2019-Jun-01 03:01:59 GMT-04:00

 

Thanks,

Gagandeep

 

 

 

Reliable Contributor petermason
Reliable Contributor
Report Inappropriate Content
Message 4 of 8

Re: Too many Database connections

Jump to solution

Hey Gagandeep,

I think I had this problem back when the Heath Checks were introduced to NSP, it seemed to be because I was running all of the health checks at the same time. 

If you just select the Database Connections check on it's own does it still give a high volume of connections?

Regards

Peter

Re: Too many Database connections

Jump to solution

That's interesting.

DB Connections.PNG

Indeed DB connection count came low when selecting only DB Connections. 

Thanks for the tip. 

Cheers

Gagandeep

Re: Too many Database connections

Jump to solution

Hi Peter,

I'm not sure if McAfee Developer/Engineering is aware about this issue.

Cheers

Gagandeep

Reliable Contributor petermason
Reliable Contributor
Report Inappropriate Content
Message 7 of 8

Re: Too many Database connections

Jump to solution

Hi Gagandeep,

I looked back through my old SR's and see that I reported this to them previously.

There was no solution to the SR at the time.

I normally just run thee health checks one group at a time, Summary, Database and Connectivity.

Regards

Peter

View solution in original post

Highlighted

Re: Too many Database connections

Jump to solution

Thank you so much for that information.

 

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