hi,
we're running otrs 1.3.2p01 on a rather weak "AMD Sempron 2200",
512MB, IDE softraid using the postgres backend.
i'm seeing serious slowdowns (requests can take up to several minutes when
multiple users are working on it) with these figures:
- up to 5 concurrent users
- tbl article 80982 items
- tbl ticket 42625 items
the following performance relevant changes have been made:
- Config.PM has
$Self->{TicketIndexModule} =
'Kernel::System::Ticket::IndexAccelerator::StaticDB';
- i've changed the 'id' column in the article table to bigint (to make
postgres use the index)
- some postgres tweaking, regular vacuum analyze / vacuum full
the effect was little so i'm now seeking to reduce the article count by
purging old tickets from the database. thus i've created an agent job to
delete tickets that are either in state 'removed' or older than 8 weeks.
unfornationally that job runs _really_ slow (as in ~2 tickets per second).
it seems GenericAgent is doing it the hard way (find single ticket, delete,
repeat...). i really want to help out by kicking off a series
of "delete from .." on the database but i don't know how.
can someone please enlighten me:
1. how do i find all tickets that are 'removed' or older than 42 days? (sql)
2. from which of the 91 tables do these tickets (and refs) need to be
deleted in order not to break something?
thanks for any advice!
best regards
moe
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
