Preemptive connection pool adjustments
AssigneeeBay Inc.
InventorsTimothy Robison, Sarang Mukund Kulkarni
Life of this patent
Estimating the term…
Abstract
Systems and methods for preemptive adjustments of connections in a database connection pool are provided. In example embodiments, a number of quality of service engines analyze database connection pool metrics data to generate instructions to increase or decrease the number of connections in a connection pool, preemptively, before shortages or surpluses of connections occur. Corrective engines can analyze performance of the quality of service engines and can, when necessary, instruct the quality of service engines to modify their prediction mechanisms.
Claims20
A computer-implemented method, comprising:
- receiving database connection requests from a plurality of applications;
- accessing connection pool metrics data that corresponds to a database connection pool having a number of open connections, the connection pool metrics data comprising connection use time data and request frequency data corresponding to the database connection requests;
- determining an open connection load level using the connection use time data and the request frequency data;
- and
- modifying the number of open connections in the database connection pool based on the open connection load level.
A system, the system comprising::
- one or more processors of a machine;
- and
- a memory storing instructions that, when executed by the the one or more processors, cause the machine to at least:
- receive database connection requests from a plurality of applications;
- access connection pool metrics data that corresponds to a database connection pool having a number of open connections, the connection pool metrics data comprising connection use time data and request frequency data corresponding to the database connection requests;
- determine an open connection load level using the connection use time data and the request frequency data;
- and
- modify the number of open connections in the database connection pool based on the open connection load level.
A non-transitory machine-readable storage medium embodying instructions that, when executed by a machine, cause the machine to perform operations comprising:
- receive database connection requests from a plurality of applications;
- access connection pool metrics data that corresponds to a database connection pool having a number of open connections, the connection pool metrics data comprising connection use time data and request frequency data corresponding to the database connection requests;
- determine an open connection load level using the connection use time data and the request frequency data;
- and
- modify the number of open connections in the database connection pool based on the open connection load level.
Dependencies are inferred from the claim text.