MariaDB starting with 10.1.x

The QUERY_CACHE_QUERIES_TABLES table will be introduced in a future version of MariaDB. See MDEV-4682

Description

The QUERY_CACHE_QUERIES_TABLES table will be introduced as part of a future change to the QUERY_CACHE_INFO plugin, and shows all tables used in a query cache entry.

The table is not a standard Information Schema table, and is a MariaDB extension.

It contains the following columns:

ColumnDescription
QUERY_CACHE_IDcache entry id (only for qc_info plugin, internally server use a hash table), use with QUERY_CACHE_QUERIES table
SCHEMAtable database schema
TABLE_NAMEtable name
TABLE_SUFFIXwith partition engine this will display partition name like P#p0

Comments

Comments loading...