Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
0 votes
82 views
in Q2A Core by

The link to the MySQL query cache documentation on the Optimization page in the Q2A documentation is broken.

Current: http://dev.mysql.com/doc/refman/5.1/en/query-cache.html

Should be: http://dev.mysql.com/doc/refman/5.7/en/query-cache.html

by
edited by
Anyway that's dead right? No longer supported in 8.0
by
As of yet it's only deprecated. It will be removed (according to the docs) with MySQL 8.0.
by
Sorry, 8.0. Actually we had a big issue due to this. Top users per month plugin became a garbage on 8.0

1 Answer

+2 votes
by
Good catch! The tricky thing is that Q2A supports MySQL 5.0 or later. But well, it makes sense to link to 5.7, given the circumstances. I've just created the PR to fix that: https://github.com/q2a/q2a.github.io/pull/49

BTW, I didn't know about that feature being removed. I can't think of any really slow query that could significantly leverage that feature in Q2A. However, I'm sure several plugins will be hit by this.

Sadly, the fix will either mean to use third party tools that might be a pain for the average user to configure or just write a programmatic cache in each plugin, which is the approach I usually follow (I've never relied in the query cache).
by
Yes. Q2A core faced no issues.
...