WL#10824: Remove query cache
Affects: Server-8.0
—
Status: Complete
We've decided to remove the query cache for 8.0 (it will be deprecated in 5.7,
which this worklog does not concern itself with).
The proposed design:
* HAVE_QUERY_CACHE will now return NO, so that well-behaved clients can check
for this and behave accordingly.
* The SQL_NO_CACHE keyword will continue to exist, but will be ignored (no
effect in the grammar). This is so that e.g. mysqldump can continue working.
(SQL_CACHE will be removed as a token.)
* The RESET QUERY CACHE and FLUSH QUERY CACHE statements will be removed. Trying
to use them will return errors.
* All query cache command-line options will be removed. Trying to set them will
return errors.
* All query cache system variables will be removed. Trying to set them will
return errors.
* All tests that are for testing query cache will be removed. Some tests use
the query cache as a means to other ends (e.g. reducing I/O); we will need to
look at these on a case-by-case basis.
* All RQG grammars that set SQL_CACHE/SQL_NO_CACHE will have these parts
removed.
Apart from that, the procedure is quite obvious; we just remove all query cache-
related code.
Copyright (c) 2000, 2025, Oracle Corporation and/or its affiliates. All rights reserved.