MySQL knowledge framework [blog Summary – continuous update]

1. Logical architecture and storage engine

• 01 MySQL logical architecture: how is an SQL query executed?
• 02 MySQL storage engine: the difference between MyISAM and InnoDB

2. Log file

• 03 MySQL error log
• 04 MySQL slow query log (slow log)
• 05 MySQL binary (binlog)
• 06 MySQL redo log

3. Index

• 07 MySQL index (I) basic index
• 08 MySQL indexing (II) principles of indexing

4. Lock

• 09 MySQL lock (I) global lock: how to make a logical backup of the whole database?
• 10 MySQL lock (II) table lock: why does adding fields to a small table cause the whole database to hang up?
• 11 MySQL lock (three line lock): what is unreal reading? How to solve unreal reading?
• 12 Locking rules and cases of MySQL lock (four row lock)

5. Services

• 13 MySQL transactions (I) understanding transactions
• 14 MySQL transaction (II) implementation principle of transaction isolation: consistent read

6. High availability

• 15 MySQL high availability (I) active and standby synchronization: how does MySQL ensure the consistency between active and standby
• 16 MySQL high availability (II) how to solve the active / standby delay?
• 17 MySQL high availability (III) build active and standby synchronization practice