Think again!. There are many corruptions, crashes, and hangs caused by insert delayed statements. Be especially cautious of using an old version of mysql to do delayed inserts in combination with triggers, stored routines, and merge tables.
Bug #28280 - insert delayed on a table containing trigger leads to server crash
Bug #27998 - mysqld crashed when executing INSERT DELAYED on a BLACKHOLE table
Bug #26464 - insert delayed + update + merge = corruption
Bug #26445 - MySQL crash: drop trigger and insert delayed
Bug #26238 - inserted delayed always inserts 0 for BIT columns
Bug #25712 - insert delayed and check table run together report crashed tables
Bug #25507 - multi-row insert delayed + auto increment causes duplicate key entries on slave
Bug #23312 - server hangs 'closing tables' with insert delayed,flush tables,alter table
Bug #21483 - Server abort or deadlock on INSERT DELAYED with another implicit insert
Bug #16218 - Crash on insert delayed
Monday, May 21, 2007
Using 'insert delayed into ... '?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment