Boolean Education Yan Shiba MySQL Optimization Video Tutorial-Free online video tutorial-php.cn

At present, the database is the basic component for data storage in most systems. The efficiency of the database has a vital impact on the stability and efficiency of the system. In order to have a better user experience, the optimization of the database is extremely important. So from what aspects should we optimize our database? Let us discuss and learn together in the course "Boolean Education Yan 18 MySQL Optimization Video Tutorial"!

Difficulty：Advanced

Total of32 chapters

77842 plays

Chapter1mysql performance optimization tutorial: Big ideas for MySQL optimization
09 minutes03 seconds; A simple introduction to awk
13 minutes52 seconds; Observe periodic server changes
35 minutes31 seconds; Observe mysql process status
38 minutes25 seconds; Column selection principles
11 minutes06 seconds; Effective rules for multi-column indexes
33 minutes34 seconds; Multi-column index experiment
39 minutes18 seconds; Mall multi-column index experiment
15 minutes10 seconds; Clustered index concept
15 minutes41 seconds; Efficiency of clustered index random primary key values
15 minutes03 seconds; index coverage
12 minutes33 seconds; Case study on slow sorting of a certain clustered index
35 minutes09 seconds; Index length and resolution
19 minutes53 seconds; Pseudo hash function reduces index length
09 minutes35 seconds; Large data volume paging optimization
24 minutes24 seconds; Indexing and sorting
08 minutes14 seconds; Redundant indexes and duplicate indexes
03 minutes57 seconds; Index fragmentation repair
04 minutes16 seconds; explain analysis sql effect
22 minutes11 seconds; in type subquery trap
16 minutes18 seconds; Is exists necessarily slower than subquery?
12 minutes06 seconds; max min unconventional optimization techniques
18 minutes58 seconds; count optimization tips
05 minutes05 seconds; Clever use of variables to reduce queries
25 minutes48 seconds; MySQL master-slave cluster configuration
40 minutes27 seconds; The difference between binlog-format
05 minutes35 seconds; master-master replication
17 minutes57 seconds; Primary key conflict resolution
16 minutes15 seconds; Passive-master replication
05 minutes07 seconds; mysql-proxy completes load balancing and separation of reading and writing
40 minutes05 seconds; partition partition
23 minutes26 seconds; Business explanation
28 minutes34 seconds

About Instructor

阿神: PHP developer

You will learn:: After studying "Boolean Education Yan 18 MySQL Optimization Video Tutorial", you can learn the following content: 1. Understand the methods and techniques of various aspects of database optimization 2. How to optimize SQL statements and indexes 3. How to optimize the database structure and operating environment