Task #13360

Updated by José Raddaoui Marín over 1 year ago

We have been seeing DB deadlocks lately, in web requests (#12709) and CSV import (#13354) for example. We should analyze if using a different transaction isolation level could improve the situation.

Initial research:

- Designing Data-Intensive Applications (Chapter 7)
- https://dev.mysql.com/doc/refman/8.0/en/commit.html
- https://www.oreilly.com/library/view/mysql-reference-manual/0596002653/ch06s07.html
- https://mariadb.com/kb/en/set-transaction
- https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html
- https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html

My initial impression is that to avoid the deadlock we could introduce lost updates and that the we shouldn't change the current isolation level.