Bug #89172 Wrong information about the Query Cache
Submitted: 10 Jan 2018 15:57 Modified: 12 Jan 2018 0:18
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S1 (Critical)
Version:8.0 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[10 Jan 2018 15:57] Daniël van Eeden
Page: https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html

"""A.1.6. Does MySQL 8.0 have a Query Cache? Does it work on Server, Instance or Database?

Yes. The query cache operates on the server level, caching complete result sets matched with the original query string. If an exactly identical query is made (which often happens, particularly in web applications), no parsing or execution is necessary; the result is sent directly from the cache. Various tuning options are available. See The MySQL Query Cache."""

Page: https://dev.mysql.com/doc/refman/5.7/en/query-cache.html

"""The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0."""

How to repeat:
Read docs

Suggested fix:
Update the FAQ.
[10 Jan 2018 16:08] MySQL Verification Team
Thank you for the bug report.
[12 Jan 2018 0:18] Paul DuBois
Posted by developer:
Changed https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html to indicate that the QC is deprecated in 5.7 and removed in 8.0.

Changed https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html to remove the question, since there is no QC in 8.0.