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

[Matthew Watson]

Regarding this...

 Anyone tried mysql with InnoDB tables and RT2?  InnoDB supports
transactions and row locking (which is what I want) , so i'm not sure how
rt2 will handle is just slotted in? Anyone?

Mat.


> -----Original Message-----
> From: rt-users-admin at lists.fsck.com
> [mailto:rt-users-admin at lists.fsck.com]On Behalf Of Matthew Watson
> Sent: Tuesday, 22 January 2002 3: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