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 Utilisateurs l'ont trouvée utile
Cette réponse était-elle pertinente?

Related Articles

redirect using .htaccess

1) Temporary Redirect : Redirect temp / http://www.test.com This will redirect...

Install Microsoft SQL Server

The installation of Microsoft SQL Server, like that of various modern products is fairly easy,...

Create PostgreSQL user account

It is advisable to run PostgreSQL under a separate user account. This user account should only...

ColdFusion DSN parameters are not updated

SYMPTOMS New CF DSN records are created.  Even the set of parameters is tried to be updated...

How does memory overcommit affect PostgreSQL?

In Linux 2.4 and later, the default virtual memory behavior is not optimal for PostgreSQL....