Determine the isolation level of a connection : Global Variables « Command MySQL « SQL / MySQL






  1. SQL / MySQL
  2. Command MySQL
  3. Global Variables

Determine the isolation level of a connection

      
mysql>
mysql>
mysql> SELECT @@tx_isolation, @@global.tx_isolation;
+-----------------+-----------------------+
| @@tx_isolation  | @@global.tx_isolation |
+-----------------+-----------------------+
| REPEATABLE-READ | REPEATABLE-READ       |
+-----------------+-----------------------+
1 row in set (0.00 sec)

mysql>








Related examples in the same category

1.View the current setting for the global transaction isolation level by using the @@global.tx_isolation system variable
2.Returns the isolation level for the current session and the maximum permitted size of the binary log file
3.SET @@session.character_set_client
4.SET @@session.character_set_results
5.SET @@character_set_connection
6.SELECT @@COLLATION_DATABASE
7.Change the @@STORAGE_ENGINE
8.Determining the Communication Forms Supported by the MySQL Server
9.Change the value of the SQL_MODE parameter to PIPES_AS_CONCAT.