SQL optimization and troubleshooting (MySQL version)

• Chapter1 MySQL underlying principles
• 1-1 Course Introduction
• 1-2 Installation, start and stop of RPM version of MySQL under Linux
• 1-3 MySQL startup problems, configuration files, and encoding problems
• 1-4 MySQL layering and storage engine
• Chapter2 SQL optimization
• 2-1 SQL parsing process, index, B-tree
• 2-2 B-tree and index
• 2-3 SQL optimization preparation
• 2-4 id, table in explain
• 2-5 Detailed explanation of type level
• 2-6 Index type and gradual optimization, key_len calculation method
• 2-7 ref、rows、usingFilesort
• 2-8 Extra field
• Chapter3 Optimization case
• 3-1 Optimization example
• 3-2 Single table optimization and summary
• 3-3 Multi-table optimization
• Chapter4 The principle of optimization failure
• 4-1 Avoid index failure principle
• 4-2 Other common optimization methods
• Chapter5 SQL Troubleshooting-Slow Query Log
• 5-1 Slow query threshold and mysqldumpslow tool
• 5-2 Simulate and analyze massive data through profiles
• 5-3 Global query log
• Chapter6 lock mechanism
• 6-1 Detailed explanation of lock mechanism
• 6-2 Write lock example and MyISAM mode features
• 6-3 Table lock situation analysis and row lock analysis
• 6-4 Precautions and usage analysis of row locks
• 6-5 Query row lock