Michael Jürgens wrote : >Gesendet: Freitag, 14. Oktober 2005 16:59 >An: [email protected] >Betreff: Help needed with Catalog Cache > > >Hello, > >I don´t understand how to optimize catalog cache. >In my database it is always at round about 50-60%. >I´ve set the catalog cache.(CAT-CACHE_SUPPLY) to 32000 pages, >but there >is no change. >If I add all catalog cache values from the sessions I get only >8000 pages. > >How can I find out what´s wrong - please help. > > >Best regards, > >Michael > > > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/maxdb?>[EMAIL PROTECTED] > >
Maybe your application executes many rollback statements ? In this case the catalog caches will be cleared very often and you will not be able to reach better hit rates. Besides CAT_CACHE_SUPPLY just defines an upper limit for the catalog caches. The cache size will always start with CAT_CACHE_MINSIZE and will increase on demand. If there's no demand, the catalog caches will not increase. Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
