Direkt zum Inhalt

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'

gefragt vor 3 Jahren1120 Aufrufe

1 Antwort
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

EXPERTE

beantwortet vor 3 Jahren

AWS
EXPERTE

überprüft vor 3 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.