[rt-users] 6000 tickets system slows down and eats memory

[David C. Troy]

The other thing I've been doing to keep things running smoothly is running
the following statements nightly via cron -- adapt as makes sense for you:

$dbh->do("OPTIMIZE TABLE Tickets");
print "Optimized Tickets.\n";
$dbh->do("OPTIMIZE TABLE Transactions");
print "Optimized Transactions.\n";
$dbh->do("OPTIMIZE TABLE Attachments");
print "Optimized Attachments.\n";
$dbh->do("OPTIMIZE TABLE Watchers");
print "Optimized Watchers.\n";
$dbh->do("OPTIMIZE TABLE ObjectKeywords");
print "Optimized ObjectKeywords.\nDone!\n\n";

This clears out any deleted stuff and defrags the tables too I believe.

I do this at like 3AM and it's kept things relatively clean.

Dave

=====================================================================
David C. Troy   [dave at toad.net]                   410-544-6193 Sales
ToadNet - Want to go fast?                        410-544-1329 FAX
570 Ritchie Highway, Severna Park, MD 21146-2925  www.toad.net

On Fri, 21 Sep 2001, Jesse Vincent wrote:

> A while back, Dave from toad.net posted some indices you could add
> which significantly improve performance.  Did you add them?
> (They are automatically added to new installs these days, too)
>
>
> On Fri, Sep 21, 2001 at 11:47:31AM +0200, Christian Steger wrote:
> >
> > hi there,
> >
> > running my rt 2.0.7 box on a 500mhz box with 512mb ram - redhat 7.1
> > in the meantime i have already 6000 tickets, some of them contains
> > attachments.
> >
> > the problem appears all the time, if i answer an ticket via gui, it needs
> > in the meantime approx 15 seconds after sending out an answer.
> > within that time the box eats my whole memory - he start to swap.
> >
> > other functions within the rt working fine and speedy :)
> >
> > sometimes i have seen that some apacheprocesses hanging as child and eats
> > a part of my cpu as well as mem.
> >
> > any idea what could be happen here ?
> >
> > the apache i use is:
> > Apache/1.3.19 Ben-SSL/1.42 (Unix) mod_perl/1.25
> >
> > everything is static compiled.
> >
> > thanks for any comments
> >
> > christian steger
> >
> >
> >
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> >
>
> --
> http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
>