Shulou(Shulou.com)06/01 Report--

Four isolation levels

READ-UNCOMMITTED read uncommitted READ-COMMITTED read submitted REPEATABLE-READ repeatable readable SERIALIZABLE serial

The new connection is executed on the client side without restarting the mysql service for the transaction isolation level to take effect:

Example: set global.tx_isolation='READ-COMMITTED'

Tips: this isolation level will be used for new connections after setting up, but the default isolation level Repeatable Read will be restored after mysql restart.

Verification: select @ @ tx_isolation

For restart to take effect, add the following under the [mysqld] paragraph of the mysql configuration file my.cnf:

Transaction-isolation=Read-Committed

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.