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, 2020, Oracle Corporation and/or its affiliates. All rights reserved.