MySQL transaction isolation level and logging Mode Selection

Source: Internet
Author: User

Guidance:

MySQL has four transaction isolation levels: Read-uncommitted, Read-committed, Repeatable-read, and Seriailizable. I believe everyone knows their similarities and differences, if you are not clear, you can refer to another technical article: transaction and lock details of MySQL_InnoDB. However, the performance differences and application scenarios between the second and third isolation levels are prone to some misunderstandings, especially those who are familiar with Oracle, for this reason, I wrote a special technical article to guide you to reasonably choose the two transaction isolation levels.

Test environment and glossary:

Operating System: CentOS release 5.5 (Final)

MySQL version: 5.1.40-community-log

InnoDB version: build-in

Transaction isolation level: Read-committed (RC) and Repeatable-read (RR)

Log registration options (LBO): STATEMENT-based logging (LBS ),

ROW-based format (LBR)

Log replication mode (RBO): STATEMENT, ROW, and MIXED

Analysis and Summary of the combination of transaction isolation level and log mode:

N transaction isolation level: Read-committed (RC)

Transaction Security: the InnoDB Engine table is not supported for DML (DML refers to INSERT, UPDATE, DELETE), but all operations on data in non-transaction engine tables are allowed;

Transaction performance: the InnoDB table of the transaction engine cannot be operated;

U RC and STATEMENT configuration combinations

Log record format: All change operations register binary logs (LBS) based on commands );

Replication security: for SQL statements, if uncertain functions exist, data replication is consistent;

IO volume: no increase;

  • 1
  • 2
  • 3
  • 4
  • Next Page

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.