Hello.
You don't have enough free blocks in cache, and I guess it has a big fragmentation. Follow recommendations from: http://dev.mysql.com/doc/mysql/en/query-cache-configuration.html Decrease the value of query_cache_min_res_unit and run FLUSH QUERY CACHE from time to time. "Paco Martinez Rodriguez" <[EMAIL PROTECTED]> wrote: > Hi.. > > I'm using "cache queries" with MySQL 4.0.13 during three days and I get > a little better speed. > > Value of Query_cache_size =3D 20 Mb. > > I have two questions.=20 > > 1.- Is there any way to see which queries are being stored ?? > > 2.- How can I delay "qcache_lowmen_pruenes" ?? In three day values of it > is 64421 Is it too ?? > > +-------------------------+----------+ > | Variable_name | Value | > +-------------------------+----------+ > | Qcache_queries_in_cache | 3106 | > | Qcache_inserts | 447577 | > | Qcache_hits | 2697410 | > | Qcache_lowmem_prunes | 64421 | > | Qcache_not_cached | 1421991 | > | Qcache_free_memory | 10226504 | > | Qcache_free_blocks | 418 | > | Qcache_total_blocks | 6997 | > | Threads_cached | 0 | > +-------------------------+----------+ > > Thank you !!! > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
