How Can the Query Cache be Used and Tested in MySQL Server? (Doc ID 1023634.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

MySQL Server - Version 4.0 and later
All Platforms

Goal

Learn how to enable and test the query cache in MySQL and how to use the Qcache_hits and Qcache_inserts status variables to see whether a query was using the query cache.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms