Sysconsole archiving (deletion) is very slow [message #1001075] |
Wed, 16 January 2013 01:08 |
|
Hi,
it is observed that the sysconsole process is running fine but not able to delete the full unrequired records. After 2-3 days of continuous monitoring it is observed that it run continuously and I have to manually stop it otherwise there might be chances it will eat up DB connections and lead to failure of important daily job import process.
Before starting the archiving I usually run the following query to get an idea of the records about to deleted.
Query: SELECT count(*) FROM process_instance pi WHERE (pi.state IN (1, 2) AND pi.oid = pi.rootProcessInstance)
Result: 7295553
Sysconsole setup:
Quote:sysconsole -verbose -force archive -deadProcesses -noBackup -b 20 -partition mypartition
After 8 hours the above query returns a result of 7163153.
Please suggest what corrective measure can be applied.
Thank you
|
|
|
Re: Sysconsole archiving (deletion) is very slow [message #1001077 is a reply to message #1001075] |
Wed, 16 January 2013 01:11 |
|
You should archive / delete long entries before each archive run of dead processes.
sysconsole -force archive -logEntries -b 20 -partition mypartition
This should speed up the archive process significantly as no expensive reference check on log_entry table needs to be done.
Secondly, you should remove verbose attribute and make sure that the log level is on ERROR again.
You may increase the batch size again, since it was not the root cause of the issue.
All three actions should improve the speed of archiving tremendously.
|
|
|
Powered by
FUDForum. Page generated in 0.02701 seconds