MySQL-官方文檔摘抄

發(fā)布時間：2020-08-09 16:37:44 來源：ITPUB博客閱讀：161 作者：wangwenan6 欄目：MySQL數(shù)據(jù)庫

點(diǎn)擊(此處)折疊或打開

There are three phases to an index build.
In the first phase, the clustered index is scanned, and index entries are generated and added to the sort buffer. When the sort buffer becomes full, entries are sorted and written out to a temporary intermediate file. This process is also known as a “run”.
In the second phase, with one or more runs written to the temporary intermediate file, a merge sort is performed on all entries in the file.
In the third and final phase, the sorted entries are inserted into the B-tree.

點(diǎn)擊(此處)折疊或打開

When running an online DDL operation, the thread that runs the ALTER TABLE statement applies an “online log” of DML operations that were run concurrently on the same table from other connection threads. When the DML operations are applied, it is possible to encounter a duplicate key entry error (ERROR 1062 (23000): Duplicate entry), even if the duplicate entry is only temporary and would be reverted by a later entry in the “online log”.This is similar to the idea of a foreign key constraint check in InnoDB in which constraints must hold during a transaction.

點(diǎn)擊(此處)折疊或打開

Semisynchronous Replication
The slave acknowledges receipt of a transaction's events only after the events have been written to its relay log and flushed to disk.

半同步只負(fù)責(zé)relaylog的落盤, 并不關(guān)心Slave是否真的有應(yīng)用這些events, 所以Master的雙1+半同步正常可以確認(rèn)binlog到了Slave端, Slave在不出問題的情況下能做到最終一致性;

點(diǎn)擊(此處)折疊或打開

innodb_lock_wait_timeout applies to InnoDB row locks only. A MySQL table lock does not happen inside InnoDB and this timeout does not apply to waits for table locks.
The lock wait timeout value does not apply to deadlocks when innodb_deadlock_detect is enabled (the default) because InnoDB detects deadlocks immediately and rolls back one of the deadlocked transactions. When innodb_deadlock_detect is disabled, InnoDB relies

on innodb_lock_wait_timeout for transaction rollback when a deadlock occurs.

For example, metadata lock

向AI問一下細(xì)節(jié)

猜你喜歡