innodb_deadlock_detect can be used to disable deadlock detection.
select for share and select for update now has NOWAIT and SKIP LOCKED which causes the statement to return immediately. SKIP LOCKED removes locked rows from the result set. NOWAIT allows you to immediately throw a lock acquisition failure which can be useful in case of looping. Skip locked never waits as well.
ALGORITHM=INSTANT is supported for ALTER TABLE operations. This is done by default. - adding a column - adding/dropping a virtual column - adding/dropping a column default value - modifying the definition of an enum/set column - changing index type - renaming a table