RE: deadlock - further information

2006-03-26 Thread Rithish Saralaya
> As 11 > 4, 4.1.11 is newer than 4.1.4, so this variable is available to you. Gawwddd... I really made an ass of myself that time... :o) Thanks for pointing it out though. > 4.1.11 is almost a year old. Have you read the list of bugs fixed since then? >

Re: deadlock - further information

2006-03-26 Thread Michael Stassen
Rithish Saralaya wrote: in 4.1.xx, you can use the my.cnf option innodb_locks_unsafe_for_binlog to make InnoDB to use a consistent read in the SELECT tables in CREATE ... SELECT. Read the caveats about the my.cnf option, though. Thanks. However, whatever is written in http://dev.mysql.com/do

Re: deadlock - further information

2006-03-20 Thread Heikki Tuuri
Rithish, - Original Message - From: ""Rithish Saralaya"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, March 20, 2006 10:02 AM Subject: deadlock - further information --=_NextPart_000_0059_01C64C23.16088020 Content-Type: text/plain; charset="iso-8859-1" Co