Mysql query cache: Revision history

From wikinotes

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

8 September 2022

  • curprev 04:2704:27, 8 September 2022Will talk contribs 1,473 bytes +382 No edit summary
  • curprev 04:2104:21, 8 September 2022Will talk contribs 1,091 bytes +1,091 Created page with "{{ NOTE | It is disabled by default starting in MySQL-5.6<br> https://dev.mysql.com/blog-archive/mysql-8-0-retiring-support-for-the-query-cache/ }} The query cache is a key-value store of cacheable-queries, and their result.<br> This interferes with benchmarking, since repeat queries may be much faster to lookup. To avoid the query cache: <syntaxhighlight lang="mysql"> # 1. Add a calculated-function to your selected rows - since they are not cacheable # TODO: valida..."