MySQL baby <[EMAIL PROTECTED]> wrote: > Anyone using TONS of Query Cache for a high-traffic site? > > Our search server is really sweating. > I was about to jump through a LOT of software loops to program > query caching at the app level, when I realized that MySQL had > it built-in already. (We're using newest: 4.0.18) > > Seems we've got plenty of Qcache_free_memory (see below) - so > I'm wondering... > > Has anyone set their query_cache_size= setting really high > like 1GB of RAM - to see how it helps?
You can set query_cache_size to 1Gb, but this can causes slight performance drop because MySQL will need to manage more memory. You better let MySQL manage memory by using Qcache_lowmem_prunes variable. > > Any more articles or info on this besides the docs at > http://www.mysql.com/doc/en/Query_Cache.html ? > > > > > | Key_blocks_used | 29625 | > | Key_read_requests | 31993562 | > | Key_reads | 28450 | > | Key_write_requests | 204631 | > | Key_writes | 131756 | > | Max_used_connections | 140 | > | Not_flushed_key_blocks | 0 | > | Not_flushed_delayed_rows | 0 | > | Open_tables | 100 | > | Open_files | 146 | > | Open_streams | 0 | > | Opened_tables | 106 | > | Questions | 1337108 | > | Qcache_queries_in_cache | 11363 | > | Qcache_inserts | 530809 | > | Qcache_hits | 520845 | > | Qcache_lowmem_prunes | 0 | > | Qcache_not_cached | 1984 | > | Qcache_free_memory | 255088000 | > | Qcache_free_blocks | 4773 | > | Qcache_total_blocks | 27515 | -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
