[rt-users] Issue with DB with lots (1500+) tickets (3.04)

Aleš Sušnik alesh at sportina.si
Mon Sep 15 13:02:39 EDT 2003


Scott,

send your HW (CPU & RAM) info also it might help alot!
How many users do you have?
How much swap?

Perl version?
mod_perl or fastcgi?
Apache version?

I think mysql 4.x is very highly recommended!

A.

-----Original Message-----
From: rt-users-admin at lists.fsck.com [mailto:rt-users-admin at lists.fsck.com]
On Behalf Of Scott Dexter
Sent: Monday, September 15, 2003 5:17 PM
To: rt-users
Subject: [rt-users] Issue with DB with lots (1500+) tickets (3.04)


I started the system from scratch, and tickets went into an empty rt3 db
fine, but when I put in the old DB of 1500+ tickets it's then that I
have huge perfromacne issues, mostly on inserts. I switched to using
my-large.vnf with MySQL3, is moving to Mysql4 really my only option, is
there some way to optimize the tickets part of the DB?

Scott

-- 
Scott Dexter
Jr Unix Administrator
Ingenta, Inc.
111R Chestnut Street, Providence, RI 02903
T  +1.401.331.2014
F  +1.401.331.2015
E   scott.dexter at ingenta.com
AIM scottder517


_______________________________________________
rt-users mailing list
rt-users at lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm





More information about the rt-users mailing list