Hello, I just upgraded to MySQL 4.0.18. I have a question about the new query-cache. The documentation says:
"The FLUSH TABLES statement also flushes the query cache." What does that mean exactly? Does it mean FLUSH TABLES, in effect, is equal to RESET QUERY CACHE, in that it purges the cache? Or does it mean FLUSH TABLES just defrags the query-cache, and has the effect of FLUSH QUERY CACHE? I would also be interesting to know whether defragging the query-cache takes any disk I/O. Also, I initially set the query_cache_size to 128M. That is a bit excessive, perhaps. Is there a known, say, 'key_buffer to query_cache_size' ratio? Thanks, - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]