Possibly moving to InnoDB
mkanat at bugzilla.org
Wed Aug 9 02:37:02 UTC 2006
On Wed, 2006-08-09 at 09:24 +1000, Bradley Baetz wrote:
> Well... Yes, if you change the isolation mode there aren't the locks.
> But you either need isolation or locks for data integrity, so thats
> not really a solution.
True. Thankfully, though, our longest-running query (buglist.cgi) would
have no problem running READ UNCOMMITTED. I'd have to read up more on
exactly how the deadlock code works, but perhaps that would help.
Everything Solved: Competent, Friendly Bugzilla and Linux Services
More information about the developers