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.