Information Schema QUERY_RESPONSE_TIME Table
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.0.4
The QUERY_RESPONSE_TIME
table was introduced in MariaDB 10.0.4
Description
The Information Schema QUERY_RESPONSE_TIME
table contains information about queries that take a long time to execute . It is only available if the QUERY_RESPONSE_TIME
plugin has been installed.
It contains the following columns:
Column | Description |
---|---|
TIME | Time interval |
COUNT | Count of queries falling into the time interval |
TOTAL | Total execution time of all queries for this interval |
See QUERY_RESPONSE_TIME
plugin for a full description.
The table is not a standard Information Schema table, and is a MariaDB extension.
SHOW QUERY_RESPONSE_TIME
is available from MariaDB 10.1.1 as an alternative for retrieving the data.
Example
SELECT * FROM information_schema.QUERY_RESPONSE_TIME; +----------------+-------+----------------+ | TIME | COUNT | TOTAL | +----------------+-------+----------------+ | 0.000001 | 0 | 0.000000 | | 0.000010 | 17 | 0.000094 | | 0.000100 | 4301 0.236555 | | 0.001000 | 1499 | 0.824450 | | 0.010000 | 14851 | 81.680502 | | 0.100000 | 8066 | 443.635693 | | 1.000000 | 0 | 0.000000 | | 10.000000 | 0 | 0.000000 | | 100.000000 | 1 | 55.937094 | | 1000.000000 | 0 | 0.000000 | | 10000.000000 | 0 | 0.000000 | | 100000.000000 | 0 | 0.000000 | | 1000000.000000 | 0 | 0.000000 | | TOO LONG | 0 | TOO LONG | +----------------+-------+----------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.