"Mark" <[EMAIL PROTECTED]> wrote: > I recently just upgraded to MySQL 4.0.18. I still have a few questions about > the new query-cache. Since I am new to the query-cache, I really hope > someone has some answers. > > 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.
FLUSH TABLES removes all queries from the cache like RESET QUERY CACHE. > 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? > > A last question. :) I am correct in my assumption that, with the > query_cache and all, I can reduce key_buffer_size? It is now set to 64M > (against a 128M query_cache_size). My guess is that I will need less of > key_buffer_size space. Right? query_cache_size isn't related to the key_buffer_size. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]