Re: Inserts & backups locking tables!?!

[Matt Ryan]

More info on what we found

5.0.19 let us use load data infile replace, or load data infile insert ignore depending on what table we used, with no locking issues


5.0.24 broke this, everything started to lock

we switched to using a temp table, and replace/insert from that, it worked fine, but if a big query was ran, the replace would lock, and any selects issued after the replace would also lock until the very first select was done, I am getting 50 locked selects on a 5 second large query stacked with a replace, needless to say this completely killed our website's speed

we went back to 5.0.19, using load data directly into the table and it fixed our problem.


is this a known problem? Backups also do not work right on 5.0.24, locking all the tables for selects