Name: SQL optimization and troubleshooting (MySQL version)
Uploaded: 2022-11-29T17:09:17+8:00
Duration: 522 min 1 s
Description: MySQL installation and configuration under Linux, database logical layering, parsing process, index, detailed analysis of SQL execution plan, principles to avoid index failure, optimization cases, common optimization strategies, slow SQL troubleshooting, simulation of massive data, lock mechanism, MySQL under windows and linux Master-slave replication.

MySQL installation and configuration under Linux, database logical layering, parsing process, index, detailed analysis of SQL execution plan, principles to avoid index failure, optimization cases, common optimization strategies, slow SQL troubleshooting, simulation of massive data, lock mechanism, MySQL under windows and linux Master-slave replication.

Difficulty：Intermediate

Total of26 chapters

19083 plays

Chapter1MySQL underlying principles: Course Introduction
01 minutes24 seconds; Installation, start and stop of RPM version of MySQL under Linux
09 minutes31 seconds; MySQL startup problems, configuration files, and encoding problems
23 minutes34 seconds; MySQL layering and storage engine
15 minutes54 seconds
Chapter2SQL optimization: SQL parsing process, index, B-tree
18 minutes52 seconds; B-tree and index
23 minutes47 seconds; SQL optimization preparation
11 minutes30 seconds; id, table in explain
38 minutes33 seconds; Detailed explanation of type level
29 minutes52 seconds; Index type and gradual optimization, key_len calculation method
27 minutes04 seconds; ref、rows、usingFilesort
17 minutes48 seconds; Extra field
22 minutes39 seconds
Chapter3Optimization case: Optimization example
16 minutes24 seconds; Single table optimization and summary
22 minutes30 seconds; Multi-table optimization
35 minutes12 seconds
Chapter4The principle of optimization failure: Avoid index failure principle
19 minutes14 seconds; Other common optimization methods
36 minutes04 seconds
Chapter5SQL Troubleshooting-Slow Query Log: Slow query threshold and mysqldumpslow tool
12 minutes35 seconds; Simulate and analyze massive data through profiles
43 minutes25 seconds; Global query log
11 minutes33 seconds
Chapter6lock mechanism: Detailed explanation of lock mechanism
33 minutes01 seconds; Write lock example and MyISAM mode features
05 minutes18 seconds; Table lock situation analysis and row lock analysis
24 minutes04 seconds; Precautions and usage analysis of row locks
17 minutes52 seconds; Query row lock
04 minutes21 seconds

About Instructor

王林: student

You will learn:: MySQL installation and configuration under Linux, database logical layering, parsing process, index, detailed analysis of SQL execution plan, principles to avoid index failure, optimization cases, common optimization strategies, slow SQL troubleshooting, simulation of massive data, lock mechanism, MySQL under windows and linux Master-slave replication.

SQL optimization and troubleshooting (MySQL version)

About Instructor

php.cn