Anhaus, Thomas schrieb:
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 ?
No.
In this case the catalog caches will be cleared very often and you will not be
able to reach better hit rates.
Is there a way to see the age of a session? The caching will start for
every new seesion at zero - right?
regards,
Michael
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
