search

Next Section: mysql-proxy完成负载均衡与读写分离2732 plays

5 秒后自动播放下一节
  Watch Again

Boolean Education Yan Shiba MySQL Optimization Video Tutorial

Introduction >
ChapterCourseware
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
  • CancelreplySending
  • Cancelpost a noteSending