U
U
ua302019-03-29 16:19:28
MySQL
ua30, 2019-03-29 16:19:28

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

1 answer(s)
F
Fixid, 2019-03-29
@Fixid

The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. Deprecation includes query_cache_type.

Quite a clear line. Rejected for quite objective reasons

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question