Connection pool anomaly detection mechanism
Techniques and structures to prevent exhaustion of a database connection pool, including retrieving data from the database connection pool, monitoring the data to determine whether the connection pool is at risk of an exhaustion condition, analyzing the data to determine whether one or more clients accessing the database connection pool are offenders upon determining that the connection pool is at risk and throttling access to the one or more clients accessing the database connection pool upon determining the one or more clients to be offenders.
1. A method to prevent exhaustion of a database connection pool, comprising:
retrieving data from the database connection pool;
monitoring the data to determine whether the connection pool is at risk of an exhaustion condition;
analyzing the data to determine whether one or more clients accessing the database connection pool are offenders upon determining that the connection pool is at risk, wherein the database connection pool is determined to be at risk upon a determination that utilization of the database connection pool is greater than a threshold utilization value and determined to be at sustained risk upon a determination that the database connection pool has been at risk for more than a first threshold percentage of intervals;
determining that the client is a sustained offender upon a determination that the client is an offender having a utilization greater than a second threshold percentage of intervals; and
throttling access to the one or more clients accessing the database connection pool upon determining the one or more clients to be offenders.
2. The method of claim 1 , wherein the database connection pool is determined to be at intermittent risk upon a determination that the database connection pool has been at risk for more than a third threshold percentage of intervals, wherein the second threshold percentage is less than the first threshold percentage of intervals.
3. The method of claim 2 , further comprising determining that a client is an intermittent offender upon a determination that the client is an offender having a client weight greater than a predetermined threshold weight.
4. The method of claim 1 , wherein access is throttled to the one or more clients based on one or more throttling rules providing a throttle access rate limit.
5. The method of claim 4 , further comprising removing the throttle upon a determination that the connection pool is no longer at risk of the exhaustion condition.
6. A computing device comprising:
at least one physical memory device to store a connection pool manager; and
one or more processors coupled with the at least one physical memory device, the one or more processors configurable to execute the connection pool manager to retrieve data from the database connection pool, monitor the data to determine whether the connection pool is at risk of an exhaustion condition, analyze the data to determine whether one or more clients accessing the database connection pool are offenders upon determining that the connection pool is at risk and throttle access to the one or more clients accessing the database connection pool upon determining the one or more clients to be offenders and determine that the client is a sustained offender upon a determination that the client is an offender having a utilization greater than a second threshold percentage of intervals, wherein the database connection pool is determined to be at risk upon a determination that utilization of the database connection pool is greater than a threshold utilization value and determined to be at sustained risk that upon a determination that the database connection pool has been at risk for more than a first threshold percentage of intervals.
7. The computing device of claim 6 , wherein the database connection pool is determined to be at intermittent risk upon a determination that the database connection pool has been at risk for more than a third threshold percentage of intervals, wherein the third threshold percentage is less than the first threshold percentage of intervals.
8. The computing device of claim 7 , further comprising the connection pool manager determining that a client is an intermittent offender upon a determination that the client is an offender having a client weight greater than a predetermined threshold weight.
9. The computing device of claim 6 , wherein access is throttled to the one or more clients based on one or more throttling rules providing a throttle access rate limit.
10. The computing device of claim 9 , wherein the connection pool manager removes the throttle upon a determination that the connection pool is no longer at risk of the exhaustion condition.
11. A non-transitory computer-readable medium having stored thereon instructions that, when executed by one or more processors, are configurable to cause the one or more processors to:
retrieve data from the database connection pool;
monitor the data to determine whether the connection pool is at risk of an exhaustion condition;
analyze the data to determine whether one or more clients accessing the database connection pool are offenders upon determining that the connection pool is at risk, wherein the database connection pool is determined to be at risk upon a determination that utilization of the database connection pool is greater than a threshold utilization value and determined to be at sustained risk upon a determination that the database connection pool has been at risk for more than a first threshold percentage of intervals;
determine that the client is a sustained offender upon a determination that the client is an offender having a utilization greater than a second threshold percentage of intervals; and
throttle access to the one or more clients accessing the database connection pool upon determining the one or more clients to be offenders.
12. The computer-readable medium of claim 11 , wherein the access is throttled to the one or more clients based on one or more throttling rules providing a throttle access rate limit.
13. The computer-readable medium of claim 12 , having stored thereon instructions that, when executed by one or more processors, are configurable to further cause the one or more processors to remove the throttle upon a determination that the connection pool is no longer at risk of the exhaustion condition.
14. The computer-readable medium of claim 11 , wherein the database connection pool is determined to be at intermittent risk upon a determination that the database connection pool has been at risk for more than a third threshold percentage of intervals, wherein the third threshold percentage is less than the first threshold percentage of intervals.