NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.
All the Perl that's Practical to Extract and Report
every Perl script that says:
"Don't be stupid."
--Larry Wall
Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.
no index... (Score:2)
In brief:
See
http://dev.mysql.com/doc/refman/5.0/en/innodb-locks-set.html [mysql.com]
InnoDB sets a lock on the index range that was scanned. No index = all rows.
If you add an index to the row you were using to update it should work.
This is also helpful:
http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-isolation.html [mysql.com]
Setting the transaction isolation level to read-committed is one of my "must do after installing and before st
-- ask bjoern hansen [askbjoernhansen.com], !try; do();