Bug #3333 Manual incorrectly describes how FLUSH TABLES operates with query cache
Submitted: 30 Mar 2004 4:48 Modified: 30 Mar 2004 8:46
Reporter: Victoria Reznichenko Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:
Assigned to: Bugs System CPU Architecture:Any

[30 Mar 2004 4:48] Victoria Reznichenko
In the manual mentioned:

You can defragment the query cache to better utilize its memory with the FLUSH QUERY CACHE statement. The statement does not remove any queries from the cache. The FLUSH TABLES statement also flushes the query cache. 


Looking in the mysqladmin extended-status output I can see that
FLUSH TABLES works as RESET QUERY CACHE statement, it removes all queries from the cache.

How to repeat:
Run mysqladmin extended-status before and after FLUSH TABLES command.
[30 Mar 2004 8:46] Paul DuBois
Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant