Hello,

we got the following warnings in our knldiag ( no errors in knldiag.err )

2005-07-06 11:26:42 29823 WNG 53076 DATACACH LRU OVERFLOW: 95
2005-07-06 11:26:42 29820 WNG 53076 DATACACH LRU OVERFLOW: 92
2005-07-06 11:26:42 29788 WNG 53076 DATACACH LRU OVERFLOW: 60
2005-07-06 11:26:42 29809 WNG 53076 DATACACH LRU OVERFLOW: 81
2005-07-06 11:26:42 29788 WNG 53076 DATACACH LRU OVERFLOW: 60
2005-07-06 11:26:42 29811 WNG 53076 DATACACH LRU OVERFLOW: 83

What is the reason for these errors? 
We've increased the data cache now to 1GB ( from 600MB ). I'm not sure that 
this will fix our problem.

By the way there are also this messages in the knldiag file
2005-07-06 11:41:27  1751     53000 DATACACH Reduce Data Cache (pool): 2913


How can we trace the problem to find out which sql leads to the DATACACH LRU 
OVERFLOW?

regards
Michael

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to