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 server connection pool are provided. In example embodiments, a number of quality of service engines analyze server 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.
Claims21
1-20. (canceled)
A computer-implemented method, comprising:
- accessing connection metrics for a database connection pool that includes a plurality of connections, the connection metrics describing past requests for one or more of the plurality of connections and wait time data associated with the past requests;
- receiving a plurality of connection requests for the database connection pool;
- determining a potential wait time for an additional connection request based on the connection metrics;
- and
- modifying a quantity of open connections in the plurality of connections based on the potential wait time, prior to receiving the additional connection request.
A system comprising:
- one or more processors;
- and
- a computer-readable storage medium storing instructions that are executable by the one or more processors to perform operations comprising:
- accessing connection metrics for a database connection pool that includes a plurality of connections, the connection metrics describing past requests for one or more of the plurality of connections and wait time data associated with the past requests;
- receiving a plurality of connection requests for the database connection pool;
- determining a potential wait time for an additional connection request based on the connection metrics;
- and
- modifying a quantity of open connections in the plurality of connections based on the potential wait time, prior to receiving the additional connection request.
A method implemented by at least one computing device, the method comprising:
- accessing connection metrics for a database connection pool that includes a plurality of connections, the connection metrics describing past requests for one or more of the plurality of connections and wait time data associated with the past requests;
- receiving a plurality of connection requests for the database connection pool;
- determining a potential wait time for an additional connection request based on the connection metrics;
- and
- prior to receiving the additional connection request, modifying a quantity of open connections in the plurality of connections by:
- adding a new open connection to the database connection pool responsive to determining that the potential wait time satisfies a threshold value;
- and
- removing at least one open connection from the plurality of connections responsive to determining that the potential wait time fails to satisfy the threshold value.
Dependencies are inferred from the claim text.