As of version 8.0, MySQL will be retiring the query cache. Here is the TLDR overview:
What is the query cache?
The MySQL query cache seeks to improve performance at the database level by checking incoming queries against it’s cache and returning pre-stored results when they’re available. On the face of it, this may seem a sensible approach but over time issues with the implementation have become apparent – hence the planned deprecation. Read more →