Yves Goergen wrote:
> On 13.11.2007 19:19 CE(S)T, Perrin Harkins wrote:
>> "You can use next-key locking to implement a uniqueness check in your
>> application: (...)
>> http://dev.mysql.com/doc/refman/5.0/en/innodb-next-key-locking.html
>
> This doesn't help my problem either. It may lock new INSERTs to the
> table, but it won't lock SELECTs so any other concurrent user can still
It will absolutely lock SELECTs. Are you sure autocommit is set to 0
and you have an open transaction? Are you sure your table is InnoDB?
I'm doing this right now:
-- cxn 1
mysql> set autocommit=0;
mysql> begin;
mysql> select * from t1 for update;
+------+
| a |
+------+
| 1 |
+------+
1 row in set (0.00 sec)
-- cxn 2
mysql> set autocommit=0;
mysql> begin;
mysql> select * from t1 for update;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
