Answer the question
In order to leave comments, you need to log in
MySQL how to configure caching after installation?
Hello!
There is MySQL 5.7.19, as far as I understand, it was not configured after installation. All parameters are default, including query_cache_type = 0. For me, this was a surprise.
I rarely do customization. The last time I did this was at least 5 years ago, on older versions in general. Then I remember setting up different cache parameters depending on the load profile. But I do not remember such that the cache was ever disabled. Without it, everything always (at least before) slowed down.
At the same time, mysqltuner says that everything is OK:
[OK] Query cache is disabled by default due to mutex contention on multiprocessor machines.
https://dev.mysql.com/doc/refman/5.7/en/server-sys...
The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. Deprecation includes query_cache_type.
What does this even mean? Is caching no longer used? For the second hour I have been looking for information on the subject, I can not find anything sensible.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question