Section1 Big ideas for MySQL optimization

09 minutes03 seconds

Section2 A simple introduction to awk

13 minutes52 seconds

Section3 Observe periodic server changes

35 minutes31 seconds

Section4 Observe mysql process status

38 minutes25 seconds

Section5 Column selection principles

11 minutes06 seconds

Section6 Effective rules for multi-column indexes

33 minutes34 seconds

Section7 Multi-column index experiment

39 minutes18 seconds

Section8 Mall multi-column index experiment

15 minutes10 seconds

Section9 Clustered index concept

15 minutes41 seconds

Section10 Efficiency of clustered index random primary key values

15 minutes03 seconds

Section11 index coverage

12 minutes33 seconds

Section12 Case study on slow sorting of a certain clustered index

35 minutes09 seconds

Section13 Index length and resolution

19 minutes53 seconds

Section14 Pseudo hash function reduces index length

09 minutes35 seconds

Section15 Large data volume paging optimization

24 minutes24 seconds

Section16 Indexing and sorting

08 minutes14 seconds

Section17 Redundant indexes and duplicate indexes

03 minutes57 seconds

Section18 Index fragmentation repair

04 minutes16 seconds

Section19 explain analysis sql effect

22 minutes11 seconds

Section20 in type subquery trap

16 minutes18 seconds

Section21 Is exists necessarily slower than subquery?

12 minutes06 seconds

Section22 max min unconventional optimization techniques

18 minutes58 seconds

Section23 count optimization tips

05 minutes05 seconds

Section24 Clever use of variables to reduce queries

25 minutes48 seconds

Section25 MySQL master-slave cluster configuration

40 minutes27 seconds

Section26 The difference between binlog-format

05 minutes35 seconds

Section27 master-master replication

17 minutes57 seconds

Section28 Primary key conflict resolution

16 minutes15 seconds

Section29 Passive-master replication

05 minutes07 seconds

Section30 mysql-proxy completes load balancing and separation of reading and writing

40 minutes05 seconds

Section31 partition partition

23 minutes26 seconds

Section32 Business explanation

28 minutes34 seconds