RE: Read_only and InnoDB transactions

2011-11-28 Thread David Lerer
Biriukov [mailto:v.v.biriu...@gmail.com] Sent: Monday, November 28, 2011 9:20 AM To: David Lerer Cc: mysql@lists.mysql.com Subject: Re: Read_only and InnoDB transactions MySQL Community Server 5.1.59 on the Centos 5.7 2011/11/28 David Lerer mailto:dle...@us.univision.com>> What version do y

Re: Read_only and InnoDB transactions

2011-11-28 Thread Viacheslav Biriukov
MySQL Community Server 5.1.59 on the Centos 5.7 2011/11/28 David Lerer > What version do you use? David. > > -Original Message- > From: Viacheslav Biriukov [mailto:v.v.biriu...@gmail.com] > Sent: Monday, November 28, 2011 7:09 AM > To: mysql@lists.mysql.com > S

RE: Read_only and InnoDB transactions

2011-11-28 Thread David Lerer
What version do you use? David. -Original Message- From: Viacheslav Biriukov [mailto:v.v.biriu...@gmail.com] Sent: Monday, November 28, 2011 7:09 AM To: mysql@lists.mysql.com Subject: Read_only and InnoDB transactions Hi all. >From the Mysql Documentation: If you attempt to ena

Read_only and InnoDB transactions

2011-11-28 Thread Viacheslav Biriukov
Hi all. >From the Mysql Documentation: If you attempt to enable read_only while other clients hold explicit table > locks or have pending transactions, the attempt blocks until the locks are > released and the transactions end. While the attempt to enable read_only is > pending, requests by other