Collections:
Read Consistency Support in MySQL in MySQL
How Does MySQL Handle Read Consistency in MySQL?
✍: FYIcenter.com
Read consistency is a concept that describes how consistent the output will be on two subsequent read operations. A read operation is usually a stand alone SELECT statement or a SELECT subquery in a parent statement.
A database server can support up to 3 levels of read consistency:
By default, MySQL server offers the highest level, Transaction-Level Read Consistency, on tables with transaction-safe storage engines, like InnoDB.
⇒ Transaction Isolation Levels in MySQL
⇐ Transaction Roll Back when Session Killed in MySQL
2017-08-03, 1585🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......