Re: query_cache TimeToLive

2008-01-09 Thread Brent Baisley
The query_cache TimeToLive is variable. The query will be in the cache as long as the data does not change. Once a table/data changes, the query cache for those tables are cleared. It's not the best implementation, but it's way better than nothing. MySQL 5 does have an "o

query_cache TimeToLive

2008-01-08 Thread Thomas Raso
Hi all, how mysql manage the query_cache TimeToLive (live) and how can I change it ? Thanks