Recent versions of MySQL and MariaDB default to repeatable-read for InnoDB tables, not read-commited : https://dev.mysql.com/doc/refman/8.4/en/set-transaction.

Recent versions of MySQL and MariaDB default to repeatable-read for InnoDB tables, not read-commited : https://dev.mysql.com/doc/refman/8.4/en/set-transaction.html#set-transaction-isolation-level https://dev.mysql.com/doc/refman/8.4/en/set-transaction.html... https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/set-commands/set-transaction#isolation-level https://mariadb.com/docs/server/reference/sql-statements/adm... I don't know about MyISAM though (who uses it anyway ;-) ).