W3cubDocs

/MariaDB

Information Schema QUERY_CACHE_QUERIES_TABLES Table

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:

Column Description
QUERY_CACHE_ID Cache entry id (only for qc_info plugin, internally server use a hash table), use with QUERY_CACHE_QUERIES table
SCHEMA Table database schema
TABLE_NAME Table name
TABLE_SUFFIX With partition engine this will display partition name like P#p0
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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-query_cache_queries_tables-table/