NOTE

Database Optimization

1. What Is Database Optimization 2. Database Optimization Approaches 2.1. Application Layer 2.1.1. Cache How to Design a Cache System.md 2.2. Database Layer 2.2.1. SQL Statements MySQL SQL Tuning.md 2.2.2. Table Structure Redundant fields in the main table 2.2.3. Replication MySQL Primary-Replica Replication.md 2.2.4. Partitioning, Database Sharding, and Table Sharding Database Sharding and Table Sharding.md 2.3. System Layer 2.3.1. Tune Server Parameters MySQL Configuration Linux Configuration 2.4. Hardware Layer More Powerful Machines 3. References

DatabasesCreated 01/17/2020Updated 05/31/20221 min readhistorical

This is a historical learning note and may contain outdated or incomplete understanding.

1. What Is Database Optimization

2. Database Optimization Approaches

2.1. Application Layer

2.1.1. Cache

How to Design a Cache System.md

2.2. Database Layer

2.2.1. SQL Statements

MySQL SQL Tuning.md

2.2.2. Table Structure

Put redundant fields in the main table

2.2.3. Replication

MySQL Primary-Replica Replication.md

2.2.4. Partitioning, Database Sharding, and Table Sharding

Database Sharding and Table Sharding.md

2.3. System Layer

2.3.1. Tune Server Parameters

MySQL configuration
Linux configuration

2.4. Hardware Layer

More powerful machines

3. References

Discussion

JavaScript is required to load comments.Open the discussion on GitHub