MySQL Forums
Forum List  »  Performance

Re: why my Qcache_not_cached is very large?
Posted by: Oleksandr Byelkin
Date: December 27, 2004 01:54PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
14046
December 16, 2004 11:45PM
13790
December 17, 2004 06:42AM
Re: why my Qcache_not_cached is very large?
9146
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.