Mysql low_priority for innodb: select which query should be stalled

Question

I have a set of two queries that I sometimes see in a dead end.

One is a standalone request that needs to be done only occasionally. I would like some way to make innodb prefer to flip this request back in case of a deadlock, and not another, like the low_priority keyword works for myisam.

Is there any way to tell innodb that it is relatively normal to roll back a given request in case of a dead end?

Answer 1

To answer your question: no, there is no way.

, , ? (SELECT... FOR UPDATE).

- , .

Answer 2

MySQL, , () .

InnoDB , , , .