내용으로 건너뛰기

Error Upgrading MySQL 5.7 to 8.0

0
  1. MySQL 8.0 syntax check for routine-like objects https://dev.mysql.com/doc/refman/8.0/en/keywords.html More Information: https://dev.mysql.com/doc/refman/en/keywords.html mysql.flush_rewrite_rules - at line 5,8: unexpected token 'QUERY'

질문됨 3년 전1.1천회 조회

1개 답변
1

Hi,

Look at this similar issue: https://bugs.mysql.com/bug.php?id=112067

It states: the query cache is removed in MySQL 8.0. The command to reset query cache was also removed from the query rewrite script in 8.0. as follows

It is confirmed by MySQL official documentation: https://dev.mysql.com/blog-archive/mysql-8-0-retiring-support-for-the-query-cache/

With the current limitations noted, the query cache will continue to be supported for the life time of MySQL 5.7. MySQL 8.0 will not support query cache, and users upgrading will be encouraged to use either Server-side Query Rewrite or ProxySQL as a man-in-the-middle cache.

So, follow MySQL guidance to fix your issue.

Best,

Didier

전문가

답변함 3년 전

AWS
전문가

검토됨 3년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.