transactional engine relies on transaction logs to ensure acid (atomicity, consistency, isolation, persistence)Therefore, the transaction log, the most important thing is to ensure the transaction reliabilityHow the transaction log works: Each line of the transaction log is a piece of information, typically a transaction ID number, which records the ID information generated by which transaction, and secondly, which table of the library he affects, again his original data, and new data. Generally for delete table operations the drop table transaction is not a recoverable server variable related to the transaction log: Use show GLOBAL VARIABLES like '%log% '; View. Only the InnoDB engine that supports transactions on MySQL. Therefore, the transaction log is related to the Innodbinnodb_flush_log_at_trx_commit: Log events in memory synchronization to the behavior of the log file, the following 1 means that when a transaction commit will be written to disk once, and refresh. 2 represents each transaction commit, but does not perform a disk refresh (the best performance, but data security is difficult to protect). 0 means synchronization is performed every second and disk refresh Innodb_log_buffer_size: Memory buffer size innodb_log_file_size: Transaction log file size Innodb_log_file_in_group: Transaction log Group, The transaction log in the General transaction log group file has two innodb_log_group_home_dir: indicates that the log group holds data./The transaction log that represents the data Catalog transaction log group is generally called IB_LOGFILE0Ib_logfile1 This is the InnoDB transaction log fileInnodb_mirrored_log_groups: Does the log do mirrored transaction logs should not be placed on the same disk as the data? Can be placed on the same disk, can also be stored separately, it is recommended to mirror the transaction logtransaction logs are important components for ensuring data installation, and we cannot manually manipulate transaction logs, which are operated by the MySQL storage engine InnoDB itself.
MySQL Log-transaction log
