Thanks Paul. But that my query doesn't violate any of
these conditions. Here is more detail:
mysql> show status like "%qcache%";
+-+---+
| Variable_name | Value |
+-+---+
| Qcache_queries_in_cache | 0 |
| Qcache
I have a complex query which took 4 seconds, I set the
query cache size to 512MB. BUt the query is not
cached, it only returns 7 rows, so the cache size is
not a problem here. Anyway I can find out why MySQL
4.1 is not caching my queries?
Thanks a lot
Haitao
_
At 17:02 -0700 5/3/04, Haitao Jiang wrote:
I have a complex query which took 4 seconds, I set the
query cache size to 512MB. BUt the query is not
cached, it only returns 7 rows, so the cache size is
not a problem here. Anyway I can find out why MySQL
4.1 is not caching my queries?
The criteria for