Broken link to MySQL query cache documentation

Question

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

Comments

Anyway that's dead right? No longer supported in 8.0

---

As of yet it's only deprecated. It will be removed (according to the docs) with MySQL 8.0.

---

Sorry, 8.0. Actually we had a big issue due to this. Top users per month plugin became a garbage on 8.0

Answer 1

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).

Comments

Yes. Q2A core faced no issues.