My apologies - you're right. In the general case readers don't block writes, but InnoDB does use share locks on some foreign key interactions and when using th

My apologies - you're right. In the general case readers don't block writes, but InnoDB does use share locks on some foreign key interactions and when using the SERIALIZABLE isolation level.