[rt-users] mysql vs pgsql (in regards to lock contention)

[Mat]

Hi,

 No really keen to try 4.0a , our rt2 system needs to be up alot, any idea
of the stablility of 4.0a? Do you know if ALL tables support row level? I
read somewhere about dbd tables supporting it.



> -----Original Message-----
> From: Chris Scott [mailto:chris at hostorlando.com]
> Sent: Tuesday, 22 January 2002 11:46 PM
> To: Matthew Watson
> Cc: rt-users at lists.fsck.com
> Subject: RE: [rt-users] mysql vs pgsql (in regards to lock contention)
>
>
> Hi Matthew,
>
> Sorry for a reply that doesn't directly answer your question, but...
>
> If you have the time/resources/desire/etc., you could try installing MySQL
> 4.0 alpha which supports row level locking and import your RT2
> database into
> it to see how it performs.  It seems like you could have 4.0 run on a
> different port and then change your config.pm to the new database,
> stop/start apache, and start some benchmarking.
>
> Chris
>
>
> > -----Original Message-----
> > From: rt-users-admin at lists.fsck.com
> > [mailto:rt-users-admin at lists.fsck.com]On Behalf Of Matthew Watson
> > Sent: Monday, January 21, 2002 11:06 PM
> > To: rt-users at lists.fsck.com
> > Subject: [rt-users] mysql vs pgsql (in regards to lock contention)
> >
> >
> > Hi.
> >
> >  Just wondering if anyone has done any tests regarding how mysql goes vs
> > pgsql with RT2, in particular in regards to locking.
> >
> >  I'm currently using mysql, which only seems to support table
> > level locking,
> > and this causes problems when all our staff and in and hitting RT2 hard.
> > pgsql supports row locking, which in theory, should have less locking
> > contention. Anyone tested this??
> >
> >  Anyone using pgsql on a system with a few staff members (we have 15-20
> > staff using rt2 at a time) getting these locking issues?
> >
> > Regards.
> > ----------------------------------------------
> > Matthew Watson
> > Development, Netspace Online Systems
> > mwatson at netspace.net.au
> >
> >
> > _______________________________________________
> > rt-users mailing list
> > rt-users at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-users
> >
> >
>