8.0 set the query cache to quote the following wrong
Unknown system variable 'query_cache_type'
CodePudding user response:
Given the current limitations in MySQL 5.7 survival period will continue to support the query cache, MySQL 8.0 will not support the query cache, and encourage users to upgrade to use the server serves as a middleman for the query rewrite or ProxySQL cache,We hope this change will only affect a few users, but if you worry about it, please contact and get in touch!
Thank you for using MySQL!
The MySQL development team's reply,
You can take a look at this article, [MySQL 8.0: no longer support query cache] (https://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-cache/)
CodePudding user response:
Actually, not cancelled, this function also is not very big,With other cache server, for example: redis,
CodePudding user response:
????? Still use 5.6, prepared a 8.0.19 to change, always find new query particularly slow, there are such things?