What determines the success or failure of the e-commerce Double 11 promotion?
Database server in Double 11 promotion
What affects database performance during big sales
Problems caused by large watches
Problems caused by big events
Several aspects that affect performance
CPU resources and available memory size
Disk configuration and selection
Using RAID to increase the performance of traditional machine hard drives
Use solid state storage SSD or PCIe card
Using network storage SAN and NAS
Summary: The Impact of Server Hardware on Performance
The impact of operating system on performance-The operating system suitable for MySQL
CentOS system parameter optimization
File system impact on performance
MySQL architecture
MySQL commonly used storage engine MyISAM
Innodb, a commonly used storage engine for MySQL
Features of Innodb storage engine (1)
Features of Innodb storage engine (2)
MySQL commonly used storage engine CSV
Archive, a commonly used storage engine for MySQL
MySQL commonly used storage engine Memory
Federated, a commonly used storage engine for MySQL
How to choose a storage engine
Introduction to MySQL server parameters
Memory configuration related parameters
IO related configuration parameters
Security related configuration parameters
Other common configuration parameters
Impact of database design on performance
Summarize
What is benchmark testing
How to benchmark
Benchmark demo example
Mysql benchmark tool mysqlslap
Mysql benchmarking tool sysbench
sysbench benchmark test demonstration example
Introduction to database structure optimization
Database structure design
Requirements analysis and logical design
Requirements analysis and logical design-anti-paradigm design
Advantages and disadvantages of normalized design and denormalized design
Introduction to physical design
Physical design-selection of data types
Physical design - how to store date type
Physical Design - Summary
Introduction to mysql replication function
mysql binary log
The impact of mysql binary log format on replication
How mysql replication works
Logpoint-based replication
GTID based replication
MySQL replication topology
MySQL replication performance optimization
MySQL replication FAQs
What is high availability architecture
Introduction to MMM architecture
MMM architecture example demonstration (Part 1)
MMM architecture example demonstration (Part 2)
Advantages and disadvantages of MMM architecture
Introduction to MHA architecture
MHA architecture example demonstration (1)
MHA architecture example demonstration (2)
MHA architecture advantages and disadvantages
Introduction to read-write separation and load balancing
MaxScale example demonstration
Btree index and Hash index
Install the demo database
Index optimization strategy (Part 1)
Index optimization strategy (medium)
Index optimization strategy (Part 2)
Three ways to obtain SQL with performance issues
Introduction to slow query log
Slow query log example
Get performance problem SQL in real time
SQL parsing preprocessing and execution plan generation
How to determine the time spent in various stages of query processing
Query optimization for specific SQL
Several ways to divide databases into tables
Preparation before database sharding
Database sharding demonstration (Part 1)
Database sharding demonstration (Part 2)
Introduction to database monitoring
Database availability monitoring
Database performance monitoring
MySQL master-slave replication monitoring