{{ variable.name }}
Introduction: Currently, databases are the fundamental components for data storage in most systems. The efficiency of databases has a crucial impact on the stability and efficiency of the system. To provide a better user experience, the optimization of the database is extremely important. So from which aspects should we optimize our database? Let's explore and study together in this course!
Chapter 1 Introduction to Database Optimization
This chapter introduces the course objectives of this course, providing an overall grasp of the relevant content of database optimization.
1-1 Introduction to MySQL Optimization
Chapter 2 SQL Statement Optimization
This chapter mainly introduces the relevant knowledge of SQL statement optimization
2-1 Data Preparation
2-2 How to enable and Store MySQL Slow Log
2-3 MySQL Slow Log Analysis Tool - mysqldumpslow
2-4 MySQL Slow Log Analysis Tool - pt-query-digest
2-5 How to discover problematic SQL through slow log Checking
2-6 Query and analyze the execution plan of SQL through explain
2-7 Optimization of Count() and Max()
Optimization of subqueries 2-8
2-9 Optimization of group by
2-10 Optimization of Limit queries
Chapter 3 Index Optimization
This chapter mainly introduces how to select appropriate columns to create indexes and the maintenance methods of indexes.
3-1 How to Choose the Appropriate columns to build an index
3-2 Methods for Optimizing SQL Indexes
3-3 Methods for Index Maintenance
Chapter 4 Database Structure Optimization
This chapter mainly explains the significance of database structure for database optimization and how to design a clear and efficient database structure.
4-1 Select the appropriate data type
4-2 Normalization Optimization of Database Tables
4-3 Anti-normalization Optimization of Database Tables
4-4 Vertical Splitting of Database Tables
4-5 Horizontal Splitting of Database Tables
Chapter 5 System Configuration Optimization
This chapter mainly introduces the impact of system configuration on MySQL optimization, with a focus on some of the more important parameters.
5-1 Database System Configuration Optimization
5-2 MySQL Configuration File Optimization
5-3 Use of third-party configuration tools
Chapter 6 Server Hardware Optimization
This chapter briefly introduces the impact of server hardware on MYSQL optimization and how to select CPU and memory to provide better server performance.
6-1 Server Hardware Optimization