MariaDB starting with 5.5.31

This plugin was first released in MariaDB 5.5.31

The QUERY_CACHE_INFO plugin allows you to see the contents of the query cache. It creates the QUERY_CACHE_INFO 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. Querying of this table acquires the query cache lock and will result in lock waits for queries using/expiring the query cache.

Versions

VersionStatusIntroduced
1.0StableMariaDB 10.1.13
1.0Gamma

Installation

The plugin is installed in the usual way (see Installing plugins), for example:

INSTALL PLUGIN query_cache_info SONAME 'query_cache_info';

Example

select statement_schema, statement_text, result_blocks_count, 
  result_blocks_size from information_schema.query_cache_info;
+------------------+------------------+---------------------+--------------------+
| statement_schema | statement_text   | result_blocks_count | result_blocks_size |
+------------------+------------------+---------------------+--------------------+
| test             | select * from t1 |                   1 |                512 |
+------------------+------------------+---------------------+--------------------+

Comments

Comments loading...
Loading