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

Christian Steger steger at indis.at
Fri Sep 21 12:51:13 EDT 2001


hi dave,
 
thanks for your suggestion, will se whats happen after a while, i have
seen the performance increased now extremly. - putted also as a cron job.
 
i guess the main problem appears is my large attachmenttable:
 
38496704 Sep 21 18:31 Attachments.MYD
 
however, will watch whats going on in the next time.
 
thanks again to you dave  and jesse.
 
christian

*$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";





More information about the rt-users mailing list