Shulou(Shulou.com)06/01 Report--

The InnoDB engine follows the ACID principle, and ACID mainly refers to:

? A: atomicity. Atomicity

? C: consistency consistency

? I: isolation. Isolation

? D: durability. Persistence

Atomicity atomicity the atomicity in the ACID principle is mainly related to InnoDB transactions, which is mainly related to the following functions of MySQL:

? Autocommit setting. Auto submit Settin

? COMMIT statement. Commit statement

? ROLLBACK statement. Rollback statement

? Operational data from the INFORMATION_SCHEMAtables. Manipulate data from the INFORMATION_SCHEMA table

Consistency consistency the consistency in the ACID principle mainly includes the protection and processing of data in the case of crash within innodb, which is mainly related to the following functions of MySQL:

? InnoDB doublewrite buffer. Write twice

? InnoDB crash recovery. Instance recovery

Isolation in the principle of Isolation isolation ACID mainly includes InnoDB transactions, especially transaction isolation level, which is related to the following functions of MySQL:

? Autocommit setting. Auto submit Settin

? SET ISOLATION LEVEL statement. Set transaction isolation level (four: RU, RC, RR, SERIALIZABLE)

? The low-level details of InnoDB locking. During performance tuning, you see these details through

INFORMATION_SCHEMA tables. The underlying details of the Innodb lock. Get the performance-related details from the related tables under INFORMATION_SCHEMA.

Persistence in the Durability persistence ACID principle mainly includes the hardware configuration related to the running of MySQL. This is complicated because it depends on your CPU, network, storage, and so on.

The main MySQL functions are related to the following:

? InnoDB doublewrite buffer is turned on or off with the innodb_doublewrite option

? The mechanism of refreshing redo log by innodb_flush_log_at_trx_commit

? Sync_binlog. Refresh the mechanism of binlog

? Innodb_file_per_table. The Innodb table is a single file store

? Write cache for storage devices, such as disk drives, SSD, or RAID arrays

? Buffer supported by battery in storage device

? Operating systems running MySQL, especially support for fsync () system calls

? UPS protection

? Your backup strategy, such as backup frequency, backup type, backup retention time, etc.

? Distributed data applications, hardware between data centers, network connections, etc.

Reference link: http://dev.mysql.com/doc/refman/5.7/en/mysql-acid.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.