NagiosXI: 5.8.1 and 5.5.2
DB is Offloaded
DB Version: 5.6.48-88.0
Our database team is wondering why they are seeing connection to the database that are command for Sleep. These average around 50 to 100 connections and when lots of failures happen can shoot up to around 300 to 600.
What is spawning these Sleep connections and why are they needed?
Nagios XI - Database Connection - Sleeps
-
lexisnexis
- Posts: 27
- Joined: Wed Dec 30, 2015 3:19 pm
Nagios XI - Database Connection - Sleeps
You do not have the required permissions to view the files attached to this post.
-
scottwilkerson
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: Nagios XI - Database Connection - Sleeps
These are just active connections waiting for a query to run
-
lexisnexis
- Posts: 27
- Joined: Wed Dec 30, 2015 3:19 pm
Re: Nagios XI - Database Connection - Sleeps
Thank you. Will let the DBA Team know.
-
scottwilkerson
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: Nagios XI - Database Connection - Sleeps
Locking threadlexisnexis wrote:Thank you. Will let the DBA Team know.