try mysql 4.x, why?
p3 450mhz, 320mb ram, 512mb swap, 5000 tickets, 3 very active users,
everything else (apache, mod_perl, perl) is same as you.
Runs about 10% slower then 2.0, which is not noticable!
Ow, and RT isn’t the only thing running on the machine, we got also
sendmail, 7 other PHP apps, etc…
A.From: Scott Dexter [mailto:firstname.lastname@example.org]
Sent: Monday, September 15, 2003 7:09 PM
Cc: Aleš Sušnik
Subject: RE: [rt-users] Issue with DB with lots (1500+) tickets (3.04)
send your HW (CPU & RAM) info also it might help alot!
Right now it’s a 500 mhz processor with 256mb ram.
How many users do you have?
Only like 4 active (admin)users of the web interface.
How much swap?
5.8.0 (that came with RH 8)
mod_perl or fastcgi?
I think mysql 4.x is very highly recommended!
From: email@example.com [mailto:firstname.lastname@example.org]
On Behalf Of Scott Dexter
Sent: Monday, September 15, 2003 5:17 PM
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?
Jr Unix Administrator
111R Chestnut Street, Providence, RI 02903