yes, we are running at serializable, which also explains the locking problems, especially since we just upgraded from .49. thanks joe
On Fri, 2002-08-09 at 15:27, Jeremy Zawodny wrote: > On Fri, Aug 09, 2002 at 02:38:03PM -0700, Joe Shear wrote: > > [snip] > > > COMMIT > > we are using the highest level of transactional security -- the term for > > it eludes me at the moment. > > You mean the isolation level? Are you running at SERIALIZABLE rather > than READ-COMMITTED? IF so, why? You will have more lock contention at > a higher isolation level. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 3 days, processed 82,315,348 queries (264/sec. avg) > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
