[rt-users] preferred db for rt ?

[Mat]

Is it always slow? or just slow when alot of users are using it?

Eg, If you do a search at 3am in the morning when there are no other users
on does it seem fast.

Is everything slow or just certain searches?

I found that mysql runs into problem with locking, due to the fact the
mysql's default table type uses table level locking, which causes major
issues
when there are lots of people using RT2. postgres uses row level which
seems to work better. I haven't moved over to postgres yet, however my
initial testing seems to indicate that searchs are in general a little
slower
on postgres when there is only one user, however you don't end up with
everyone waiting for a table to unlock so their query can run, so it runs
better overall when there are lots of users.

mysql certainly seems faster when 99% of the queries are selects, but throw
a
few updates in there and it soon locks up.

Also... how have you configured mysql, at first I got bitten not knowing
that
you actually have to tell mysql how much ram it can use, which resulted in
mysql continuely having to write searches out to disk, drematically slowing
down the queries.

Regards,
Mat.


> -----Original Message-----
> From: rt-users-admin at lists.fsck.com
> [mailto:rt-users-admin at lists.fsck.com]On Behalf Of matthew zeier
> Sent: Friday, 29 March 2002 9:10 AM
> To: rt-users at lists.fsck.com
> Subject: Re: [rt-users] preferred db for rt ?
>
>
> > matthew zeier <mrz at intelenet.net> said:
> > >My NOC guys are complaining about performance with rt (mysql
> backend).  I
> > >migrated everything to faster hardware but I'm still getting
> "complaints"
> on
> > >searches and ticket content draws.
> > >
> > Are you sure mySQL is the bottleneck? I don't like the database, but I
> cannot
> > say it's slow.
>
> No, I guess I don't know for certain it's a db issue.
>
> I moved from a Sun Netra T1 105 360Mhz 512MB to Redhat 7.2 4GB
> RAM, 4x550Mhz
> Xeon.  Both running mysql and Apache+mod_perl+mod_ssl.
>
>
>
> - mz
>
>
>
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users