Jue (Jacky) Shu wrote:
> qcache_free_blocks is 1 when mysql starts.
> it grows to 2000 after a week.
> is there ant way to decrease it?
Not really. But, go ahead and post the output of
SHOW STATUS LIKE 'Q%';
> does mysql do anything to re-organize query
> cache?
Yes, it's an LRU-based cache that invalidates cache blocks when tables accessed in the queries contained in the cache block are used in an INSERT/UPDATE/DELETE statement. Therefore, if you have heavy writes to a specific table, make sure that you use the SQL_NO_CACHE keyword in queries against that table so that cache block thrashing doesn't occur.
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com