Information Schema QUERY_CACHE_INFO Table
Description
The table is not a standard Information Schema table, and is a MariaDB extension.
The QUERY_CACHE_INFO
table is created by the QUERY_CACHE_INFO plugin, and allows you to see the contents of the query cache. It creates a table in the information_schema database that shows all queries that are in the cache. You must have the PROCESS
privilege (see GRANT) to use this table.
It contains the following columns:
Column
Description
STATEMENT_SCHEMA
Database used when query was included
STATEMENT_TEXT
Query text
RESULT_BLOCKS_COUNT
Number of result blocks
RESULT_BLOCKS_SIZE
Size in bytes of result blocks
RESULT_BLOCKS_SIZE_USED
Size in bytes of used blocks
LIMIT
Added MariaDB 10.1.8.
MAX_SORT_LENGTH
Added MariaDB 10.1.8.
GROUP_CONCAT_MAX_LENGTH
Added MariaDB 10.1.8.
CHARACTER_SET_CLIENT
Added MariaDB 10.1.8.
CHARACTER_SET_RESULT
Added MariaDB 10.1.8.
COLLATION
Added MariaDB 10.1.8.
TIMEZONE
Added MariaDB 10.1.8.
DEFAULT_WEEK_FORMAT
Added MariaDB 10.1.8.
DIV_PRECISION_INCREMENT
Added MariaDB 10.1.8.
SQL_MODE
Added MariaDB 10.1.8.
LC_TIME_NAMES
Added MariaDB 10.1.8.
CLIENT_LONG_FLAG
Added MariaDB 10.1.8.
CLIENT_PROTOCOL_41
Added MariaDB 10.1.8.
PROTOCOL_TYPE
Added MariaDB 10.1.8.
MORE_RESULTS_EXISTS
Added MariaDB 10.1.8.
IN_TRANS
Added MariaDB 10.1.8.
AUTOCOMMIT
Added MariaDB 10.1.8.
PACKET_NUMBER
Added MariaDB 10.1.8.
HITS
Incremented each time the query cache is hit. Added MariaDB 10.3.2.
For example:
SELECT * FROM information_schema.QUERY_CACHE_INFO;
+------------------+-----------------+---------------------+--------------------+-------------------------+
| STATEMENT_SCHEMA | STATEMENT_TEXT | RESULT_BLOCKS_COUNT | RESULT_BLOCKS_SIZE | RESULT_BLOCKS_SIZE_USED |
+------------------+-----------------+---------------------+--------------------+-------------------------+
...
| test | SELECT * FROM a | 1 | 512 | 143 |
| test | select * FROM a | 1 | 512 | 143 |
...
+------------------+-----------------+---------------------+--------------------+-------------------------
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?