All pages
Powered by GitBook
1 of 1

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