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, 3311🔥, 0💬
Popular Posts:
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...
How Run SQL*Plus Commands That Are Stored in a Local File in Oracle? If you have a group of commands...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...