US 11,750,692 B2
Connection pool anomaly detection mechanism
Olumayokun Obembe, Concord, CA (US); Da Zhao, San Mateo, CA (US); Fabio Meireles Fernandez Valbuena, Alpharetta, GA (US); Ping-Hsiu Hsieh, San Francisco, CA (US); Xiaodan Wang, Dublin, CA (US); Vijayanth Devadhar, Fremont, CA (US); Jason Woods, Toronto (CA); Ashwini Bijwe, Hayward, CA (US); Yichuan Cai, Bellevue, WA (US); Paul E. Jatkowski, Clinton Township, MI (US); Kin Lun Wong, Hillsborough, CA (US); Sidarth Conjeevaram, San Jose, CA (US); Zeyu Zheng, Hayward, CA (US); and Jae Young Park, San Francisco, CA (US)
Assigned to Salesforce, Inc., San Francisco, CA (US)
Filed by Salesforce, Inc., San Francisco, CA (US)
Filed on Sep. 15, 2021, as Appl. No. 17/475,825.
Application 17/475,825 is a continuation of application No. 16/660,904, filed on Oct. 23, 2019, granted, now 11,165,857.
Prior Publication US 2022/0006858 A1, Jan. 6, 2022
This patent is subject to a terminal disclaimer.
Int. Cl. H04L 67/101 (2022.01); G06F 11/30 (2006.01); G06F 16/25 (2019.01)
CPC H04L 67/101 (2013.01) [G06F 11/3006 (2013.01); G06F 16/252 (2019.01)] 16 Claims
OG exemplary drawing
 
1. A method to prevent exhaustion of a database connection pool, comprising:
retrieving data from the database connection pool;
analyzing the data to determine whether the database 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 has been at risk in a number of intervals in the multiple intervals in which the data connection pool is analyzed for being at risk; and
throttling access to the database connection pool upon determining the database connection pool has been at risk, wherein:
the database connection pool is 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 the intervals,
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 second predetermined threshold percentage of the intervals, wherein the second predetermined threshold percentage is less than the first threshold percentage of the intervals, and
a client is determined as a sustained offender upon a determination that the client is an offender having a utilization greater than a third predetermined threshold percentage of the intervals.