• unknown's avatar
    Fix for BUG#3081 "if an INSERT DELAYED is killed, it is binlogged as killed but it's not needed". · d44d6976
    unknown authored
    INSERT DELAYED works only for one-row inserts (in latest 4.0 versions
    at least). So killing a delayed_insert thread does not spoil replication:
    the rows which actually went into the table are exactly those listed
    in the binlog. So when the delayed_insert thread is killed, don't log
    it as 'killed', because it causes superfluous stops on the slave.
    
    
    sql/log_event.cc:
      INSERT DELAYED works only for one-row inserts (in latest 4.0 versions
      at least). So killing a delayed_insert thread does not spoil replication:
      the rows which actually went into the table are exactly those listed
      in the binlog. So when the delayed_insert thread is killed, don't log
      it as 'killed', because it causes superfluous stops on the slave.
    d44d6976
log_event.cc 68.5 KB