Score:1

Alternate method for caching mysql query (query_cache) on version above 8.0

fm flag

On mysql version 8+ the query_cache support was removed.

I know why it is not a friendly thing with InnoDB when considering the CPU.

But I've some databases which really need this support where user repeat the same query in most cases.

Is it possible to restore query_cache or to achieve the caching via some other means.

ua flag
Let's discuss some of the queries. And show up `SHOW CREATE TABLE`. It may lead to a workaround.
anx avatar
fr flag
anx
Also [on topic](https://dba.meta.stackexchange.com/questions/922/are-questions-about-implementation-details-of-a-database-on-topic/923) and seen by more specialised experts [at our sister site for database administrators](https://dba.stackexchange.com/questions/tagged/query-cache+mysql)
Wilson Hauck avatar
jp flag
MariaDB still supports Query Cache function.
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.