Automatic runtime optimization for a database hosting system

A system for runtime optimization of a database hosting system, comprising:

• a processor set;
• one or more computer-readable storage media;
• and
• program instructions stored on the one or more computer-readable storage media to cause the processor set to perform operations comprising:
• receiving, by the database hosting system, a query having a query type and an expected performance value range for the query, wherein lower performance values indicate better performance;
• selecting, by the database hosting system, a first database having a first configuration parameter value that, when used to execute a previous query of the query type, resulted in an execution performance value within the received expected performance value range;
• executing the query by the selected first database;
• measuring an execution parameter value for the executing the query;
• determining, by the database hosting system, that the measured execution parameter value is below a lower threshold value of the received expected performance value range;
• and
• adjusting a configuration of the database hosting system, wherein the adjusting comprises identifying, by the database hosting system in response to the determining, a second configuration parameter value for the first database such that executing a next query of the query type requires fewer computing resources than the executing the query using the first configuration parameter.

A computer program product for runtime optimization of a database hosting system, comprising:

• one or more computer-readable storage media;
• and
• program instructions stored on the one or more computer-readable storage media to perform operations comprising:
• receiving, by the database hosting system, a query having a query type and an expected performance value range for the query, wherein lower performance values indicate better performance;
• selecting, by the database hosting system, a first database having a first configuration parameter value that, when used to execute a previous query of the query type, resulted in an execution performance value within the received expected performance value range;
• executing the query by the selected first database;
• measuring an execution parameter value for the executing the query;
• determining, by the database hosting system, that the measured execution parameter value is below a lower threshold value of the received expected performance value range;
• and
• adjusting a configuration of the database hosting system, wherein the adjusting comprises identifying, by the database hosting system in response to the determining, a second configuration parameter value for the first database such that executing a next query of the query type requires fewer computing resources than the executing the query using the first configuration parameter.