title: Mysql low_priority for innodb: choose which query should be rolled back in a deadlock
body: <p>I have a set of two queries which I've occasionally seen deadlocking.</p>
  
  <p>One is an offline query that only needs to be run occasionally. I'd like some way to have innodb prefer to roll this query back in the event of a deadlock and not the other, sort of like the way the low_priority keyword works for myisam.</p>
  
  <p>Is there any way to tell innodb that it's relatively ok to roll back a given query in the event of a deadlock?</p>