Four notes from the InnoDB section of MySQL

Four notes from the InnoDB section of MySQL

The first is the transaction implementation mechanism of InnoDB. On csdn, click "Download". Here we will briefly introduce that it is controlled through redo and undo, in addition, the log buffer is refreshed to the redo log file every second, so it is very fast for large transaction commit. For undo logs, it is used for transaction rollback, and it has its own undo segment in the shared tablespace. The isolation level of transactions is implemented through locks. Therefore, we need to understand the InnoDB Lock Mechanism. This section also describes distributed transactions, that is, xa.

The second is the InnoDB Lock Mechanism. On csdn, click "Download". It mainly introduces the InnoDB Lock Mechanism and InnoDB implements row-level locks, there are also shared locks and exclusive locks, like MyISAM locks and write locks, and InnoDB also has the intention to lock. In addition, the InnoDB Engine implements consistent non-locked read through MVCC. Of course, you can also use SQL statements to manually lock the read. There is an auto-increment problem, which is mentioned in many places, that is, the upper bound of auto-increment operations will become a hot topic.

The third is InnoDB Index. On csdn: Click to download. It mainly introduces InnoDB Index mechanism. InnoDB uses B + Tree index and hash index, however, we do not need to manage the hash index. InnoDB will automatically create it. Because InnoDB is an index organization table, there will be clustered indexes and non-clustered indexes, and some data will refer to non-clustered indexes as secondary indexes or secondary indexes. The pre-read mechanism is also introduced here. For pre-read, it needs to be used properly. Improper use will lead to performance degradation.

The fourth is InnoDB Performance Tuning. On csdn, click here for download. It mainly introduces some content about InnoDB optimization, and is more inclined to choose and judge the hardware, I also introduced some knowledge about raid.

The above are the four notes for InnoDB. If you feel useful, download them.