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, 1614🔥, 0💬
Popular Posts:
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...