Returns the isolation level for the current session and the maximum permitted size of the binary log file : Global Variables « Command MySQL « SQL / MySQL






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

Returns the isolation level for the current session and the maximum permitted size of the binary log file

       


SELECT @@tx_isolation, @@global.max_binlog_size;








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.SET @@session.character_set_client
3.SET @@session.character_set_results
4.SET @@character_set_connection
5.SELECT @@COLLATION_DATABASE
6.Change the @@STORAGE_ENGINE
7.Determine the isolation level of a connection
8.Determining the Communication Forms Supported by the MySQL Server
9.Change the value of the SQL_MODE parameter to PIPES_AS_CONCAT.