Re: Does myisampack affect the query cache?

[Rick James]

Some wild guesses...

* What is the name of the table?

* How big is the resultset that it decides not to cache? Does it refuse to cache even a tiny resultset, such as SELECT COUNT(*) WHERE ..., with the where clause forces a table scan.

* Are there comments in the SELECT?
http://bugs.mysql.com/bug.php?id=55016

* Don't know what I might find here:
SHOW VARIABLES LIKE 'query_%';
SHOW GLOBAL STATUS LIKE 'Qc_%';