MySQL Database Performance tuning seven: Other (read-write separation, sub-table, etc.)

A, sub-table

Horizontal Division

Vertical Division

Second, read and write separation

Third, choose a reasonable data type, especially the primary key

Iv. files, pictures and other large files using file system storage

Five, database parameter configuration

Note: The maximum number of max_connections connections is usually set at around 1000 to 2000 to the limit.
Query_cache_size Query Cache Size

Six, reasonable hardware resources and operating system

MySQL Database Performance tuning seven: Other (read-write separation, sub-table, etc.)