MySQL Optimization Video Tutorial—Boolean Education

• Chapter1 MySQL optimization tutorial
• 1-1 Be specific in your answer
• 1-2 Table building principles
• 1-3 Column type selection
• 1-4 Index principle
• 1-5 hash index
• 1-6 Common misunderstandings about index building
• 1-7 Index classic topics
• 1-8 Index experiment
• 1-9 Clustered index and non-clustered index
• 1-10 Page split test
• 1-11 Index coverage
• 1-12 A classic topic on a forum
• 1-13 ideal index
• 1-14 Pseudo hash index
• 1-15 Principles of multi-column indexes
• 1-16 Indexing and sorting
• 1-17 Duplicate and redundant indexes
• 1-18 repair table
• 1-19 Query general principles
• 1-20 explain detailed explanation
• 1-21 in type subquery trap
• 1-22 Force the use of indexes
• 1-23 count and union
• 1-24 limit page turning optimization topic