Re: why my Qcache_not_cached is very large?
http://dev.mysql.com/doc/mysql/en/Query_Cache_How.html
Above mentioned causes of making queries non-cacheable. Knowing so few information I can't say more. Most frequently queries are not cached because of unsing some function with side effect or random value, or temporary table.
Also to see is query cache efficient of is not, you have to check on query cache hits.
Mr. Oleksandr Byelkin
MySQL AB, Full-Time Developer
Lugansk, Ukraine
Subject
Views
Written By
Posted
14320
December 16, 2004 11:45PM
14713
December 17, 2004 06:42AM
Re: why my Qcache_not_cached is very large?
9450
December 27, 2004 01:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.