Section1 SQL parsing process, index, B-tree

18 minutes52 seconds

Section2 B-tree and index

23 minutes47 seconds

Section3 SQL optimization preparation

11 minutes30 seconds

Section4 id, table in explain

38 minutes33 seconds

Section5 Detailed explanation of type level

29 minutes52 seconds

Section6 Index type and gradual optimization, key_len calculation method

27 minutes04 seconds

Section7 ref、rows、usingFilesort

17 minutes48 seconds

Section8 Extra field

22 minutes39 seconds

Section1 Optimization example

16 minutes24 seconds

Section2 Single table optimization and summary

22 minutes30 seconds

Section3 Multi-table optimization

35 minutes12 seconds

Section1 Avoid index failure principle

19 minutes14 seconds

Section2 Other common optimization methods

36 minutes04 seconds

Section1 Slow query threshold and mysqldumpslow tool

12 minutes35 seconds

Section2 Simulate and analyze massive data through profiles

43 minutes25 seconds

Section3 Global query log

11 minutes33 seconds

Section1 Detailed explanation of lock mechanism

33 minutes01 seconds

Section2 Write lock example and MyISAM mode features

05 minutes18 seconds

Section3 Table lock situation analysis and row lock analysis

24 minutes04 seconds

Section4 Precautions and usage analysis of row locks

17 minutes52 seconds

Section5 Query row lock

04 minutes21 seconds