How do I turn on mysql's built in query cache for infinidb? I tried turning on the query result cache by setting query_cache_size & other options provided here: http://dev.mysql.com/doc/refman/5.1/en/query-cache-configuration.html
However, it seems like it does not work with infinidb storage engine. Is that true?
If so, what sort of solution is suggested for caching the results of a query?