Updating mysql isolation level

There are many ways to do that, one of them is:

mysql> SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
mysql> SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
mysql> SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
verify that it got updated:
mysql> SELECT @@tx_isolation;
mysql> SELECT @@global.tx_isolation;

This will update mysql isolation level to be READ COMMITTED