Hi Filip,
>>DATACACH LRU OVERFLOW:32<< means that the data cache is full. No free
data cache frame is available to read or create a new page. Task 32 is
suspended as long as the data writer tasks have flushed the cache.
I suppose that the data cache is filled with changed pages, because of
your restructuring job. Furthermore a suppose that you have implemented
a continuous(!) flow of DML operations and the i/o system is not able to
write the pages as fast as you create respl. change them. If possible you
could increase the size of the data cache.
Regards,
Torsten
SAP Labs Berlin
-----Original Message-----
From: Filip Sergeys [mailto:filip.sergeys@stripped]
Sent: Freitag, 1. Oktober 2004 13:47
To: maxdb@stripped
Subject: DATACACH LRU OVERFLOW -> something to worry about ?
Hello,
We are doing a heavy database restructuring causing 6h of non stop
inserting and updating. At a certain point in time the database becomes
unresponsive. Connecting with sqlcli works, but it is impossible to run
queries.
Upon looking in knldiag file, I see a lot of DATACACH LRU OVERFLOW:32.
Is this something to worry about?
The partition where the archived logs are written to is not full(I
delete them at regular intervals because they are not needed, a full
database backup will be taken at the end), the datafiles are not full
either.
DB: 7.5.00.14
OS: SuSE linux.
Thanx,
Filip Sergeys
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* System Engineer, Verzekeringen NV *
* www.verzekeringen.be *
* Oostkaai 23 B-2170 Merksem *
* 03/6416673 - 0477/340942 *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=1
