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, 2042🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...