Manage the Isolation level in MySQL or MariaDB

InnoDB offers all four transaction isolation levels:

Serializable:
Most conservative reading level, all transaction is treated complete separated.
Always get accurate data, but performance is slow because it makes every transaction in serialized form.

REPEATABLE READ:
The default for INNODB.

READ COMMITTED:
Uses a locking strategy that is ideal for performance.

READ UNCOMMITTED:
Least amount of protection between transactions.

Note: The default INNODB isolation level is Repeatable Read. For transaction database, you need to convert into Read Committed.

File used to change transactional level in MySQL:

C:\MYSQL\my sql server 5.6\my.ini
Entry:
transaction-isolation = REPEATABLE-READ

Note: Need to reboot the MySQL before my.ini file parameter change affects

Check the Current Isolation level in MySQL or MariaDB

SELECT @@global.tx_isolation as Global_isolation_level,@@tx_isolation as session_isolation_level;

Global_isolation_level|session_isolation_level|
----------------------+-----------------------+
REPEATABLE-READ       |REPEATABLE-READ        |

Change the isolation level at the session level:

set session transaction isolation level read committed;

Change the global transaction isolation level:

set global transaction isolation level read committed;
set global transaction isolation level serializable;

You can change it with the following commands also:

SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
SET GLOBAL tx_isolation='REPEATABLE-READ';
SET SESSION tx_isolation='SERIALIZABLE';