title: mysql replication skip statement. is it possible?
body: <p>There is a system with ROW-based replication.
  Yesterday i have executed a heavy statement on my master accidently and found my slaves far behind master. I have interrupted the query on master, but it was still running on slaves.
  So i got my slaves 15 hours behind master.</p>
  
  <p>I have already tried to step over one position by resetting slave and increasing MASTER_LOG_POS, but with no luck: position wasn't found, because relay log wasn't read further than a heavy query event. </p>
  
  <pre><code>Read_Master_Log_Pos == Exec_Master_Log_Pos
  </code></pre>
  
  <ul>
  <li>Is there any way to skip the heavy query? 
  (i don't care about data that has to be changed by query)</li>
  <li>Is there a way to kill a query on a slave taken from relay log?</li>
  <li>Is there a way to roll the slaves back in 1 position, remove the
  event from master bin-log and resume the replication?</li>
  </ul>