1-1 Big ideas for MySQL optimization

1-2 A simple introduction to awk

1-3 Observe periodic server changes

1-4 Observe mysql process status

1-5 Column selection principles

1-6 Effective rules for multi-column indexes

1-7 Multi-column index experiment

1-8 Mall multi-column index experiment

1-9 Clustered index concept

1-10 Efficiency of clustered index random primary key values

1-11 index coverage

1-12 Case study on slow sorting of a certain clustered index

1-13 Index length and resolution

1-14 Pseudo hash function reduces index length

1-15 Large data volume paging optimization

1-16 Indexing and sorting

1-17 Redundant indexes and duplicate indexes

1-18 Index fragmentation repair

1-19 explain analysis sql effect

1-20 in type subquery trap

1-21 Is exists necessarily slower than subquery?

1-22 max min unconventional optimization techniques

1-23 count optimization tips

1-24 Clever use of variables to reduce queries

1-25 MySQL master-slave cluster configuration

1-26 The difference between binlog-format

1-27 master-master replication

1-28 Primary key conflict resolution

1-29 Passive-master replication

1-30 mysql-proxy completes load balancing and separation of reading and writing

1-31 partition partition

1-32 Business explanation