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:
| 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 |
© 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/