MariaDB starting with 10.1.x

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


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:

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