Boolean Education Yan Shiba MySQL Optimization Video Tutorial

• Chapter1 mysql performance optimization tutorial
• 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