In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.