Hi Rick,
Thanks for the advise. I have now set my query-cache to zero.
(I take your point about query cache too large. I understand that a
smaller cache size, and the use of the SQL_NO_CACHE and SQL_CACHE
directives can be used to control which queries are cached. Therefore
trying to get
As for the crash, I don't know. Instead, I recommend either shrinking the size
(if you use a big QC) or turning it off. This would make the issue go away.
ANY modification to a particular table leads to ALL entries in the Query cache
being purged. For that reason, we (Yahoo) almost never use