It's not a bug. I guess this is a myisam table? http://dev.mysql.com/doc/refman/5.1/en/table-locking.html Any time the table is changed with myisam, the whole table is locked. That's the way it works. Innodb doesn't do it this way but it might cause other issues for you. Try changing the table type on a test system and see if it helps/hinders your problem(s).
why did they change this? I reverted everything to 5.0.19 and I'm using load data infiles again, with zero locking issues
load data infile seems to use different logic from replace delayed, it does not lock at all
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]