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

[Chris Scott]

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
>
>