Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

Nagios XI - Database Connection - Sleeps

https://support.nagios.com/forum/viewtopic.php?t=61776

Page 1 of 1

Nagios XI - Database Connection - Sleeps

Posted: Tue Feb 23, 2021 9:54 am
by lexisnexis
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?
Capture.PNG

Re: Nagios XI - Database Connection - Sleeps

Posted: Wed Feb 24, 2021 10:14 am
by scottwilkerson
These are just active connections waiting for a query to run

Re: Nagios XI - Database Connection - Sleeps

Posted: Thu Feb 25, 2021 10:39 am
by lexisnexis
Thank you. Will let the DBA Team know.

Re: Nagios XI - Database Connection - Sleeps

Posted: Thu Feb 25, 2021 11:21 am
by scottwilkerson
lexisnexis wrote:Thank you. Will let the DBA Team know.
Locking thread
All times are UTC-05:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited