Manage Query Cache

You can check whether the query cache is present in your MySQL server using the following statement:

mysql> SHOW VARIABLES LIKE 'have_query_cache';

You can defragment the query cache to better utilize its memory with
FLUSH QUERY CACHE

RESET QUERY CACHE
statement removes all query results from the query cache.

To monitor query cache performance, use
SHOW STATUS
to view the cache status variables:

mysql> SHOW STATUS LIKE 'Qcache%';

  • Email, SSL
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Finding what packages are installed on a Linux system

For distributions that use RPM format packages, use the command: $ rpm -qa You may want to...

Manage Tablespaces

Tablespaces in PostgreSQL allow database administrators to define locations in the file system...

Change the DNS servers for the network interfaces on Windows server

In Network Connections, right-click the local area connection, and then click Properties. In...

Backing up and restoring a MySQL database from the command line

. Shell into your box as root, then: mysqldump -a -u USERNAME -p DATABASE > FILENAME.mysql...

Export the data from different tables in our shared SQL environment?

Using Enterprise Manager Expand SQL Server group Expand the server name Expand Databases...