1 of 1

Information Schema QUERY_CACHE_INFO Table

The Information Schema QUERY_CACHE_INFO table shows all queries currently stored in the query cache, aiding in cache performance analysis.

Description

This table is not a standard Information Schema table, but 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

For example:

_{This page is licensed: CC BY-SA / Gnu FDL}

Information Schema QUERY_CACHE_INFO Table

The Information Schema QUERY_CACHE_INFO table shows all queries currently stored in the query cache, aiding in cache performance analysis.

Description

This table is not a standard Information Schema table, but a MariaDB extension.

It contains the following columns:

Column

Description

For example:

_{This page is licensed: CC BY-SA / Gnu FDL}

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 |
...
+------------------+-----------------+---------------------+--------------------+-------------------------

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 |
...
+------------------+-----------------+---------------------+--------------------+-------------------------