Best practice for using MySQL query cache

Best practice for using MySQL query cache

by Masashi Narumoto -
Number of replies: 2

I'm experiencing slow queries because of the lock at MySQL (5.7) query cache. Enabling query cache is recommended in the doc below, but in my case, it looks like disabling query cache gives me performance gain. Do we have any latest recommendation about it? Do you recommend to selectively enable/disable each different queries? Which ones should be enabled? Any suggestions would be appreciated.

 https://docs.moodle.org/310/en/Performance_recommendations#MySQL_performance, 

Average of ratings: -
In reply to Masashi Narumoto

Re: Best practice for using MySQL query cache

by Darko Miletić -

You should not use query cache. That recommendation is obsolete. Query cache has been removed from MySQL as of  8.0.

https://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-cache/

Average of ratings: Useful (1)