MySQL 8 and Query Cache problem

Mysql 8 - Query Cache Problem

Since Sun Microsystems bought MySQL (and then Oracle Corporation bought Sun), MySQL has begun to change significantly. It has grown and has had power to handle many projects with small or middle size amounts of data. MySQL is a great tool which has lived for many years on the database market. But in my opinion something went wrong along the way…

MySQL 5.7 was the last version which supported Query Cache functionality.

The query cache is deprecated as of MySQL 5.7.20, and was removed in MySQL 8.0.

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_query_cache_size

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

Limitations of the Query Cache

I welcome changes, when changes lead to something better – but in this case we got nothing. No alternative functionality was provided in return.

Downgrading is not supported.

https://dev.mysql.com/doc/refman/8.0/en/downgrading.html

If you are “lucky” you will encounter problem with new collation for example:

When restoring 8.0 db in mysql 5.7 – Unknown collation: ‘utf8mb4_0900_ai_ci’

What else?

Leave a Reply

Your email address will not be published. Required fields are marked *