Course Introduction
01 minutes24 secondsInstallation, start and stop of RPM version of MySQL under Linux
09 minutes31 secondsMySQL startup problems, configuration files, and encoding problems
23 minutes34 secondsMySQL layering and storage engine
15 minutes54 secondsSQL parsing process, index, B-tree
18 minutes52 secondsB-tree and index
23 minutes47 secondsSQL optimization preparation
11 minutes30 secondsid, table in explain
38 minutes33 secondsDetailed explanation of type level
29 minutes52 secondsIndex type and gradual optimization, key_len calculation method
27 minutes04 secondsref、rows、usingFilesort
17 minutes48 secondsExtra field
22 minutes39 secondsOptimization example
16 minutes24 secondsSingle table optimization and summary
22 minutes30 secondsMulti-table optimization
35 minutes12 secondsAvoid index failure principle
19 minutes14 secondsOther common optimization methods
36 minutes04 secondsSlow query threshold and mysqldumpslow tool
12 minutes35 secondsSimulate and analyze massive data through profiles
43 minutes25 secondsGlobal query log
11 minutes33 secondsDetailed explanation of lock mechanism
33 minutes01 secondsWrite lock example and MyISAM mode features
05 minutes18 secondsTable lock situation analysis and row lock analysis
24 minutes04 secondsPrecautions and usage analysis of row locks
17 minutes52 secondsQuery row lock
04 minutes21 seconds