Shulou(Shulou.com)06/01 Report--

Optimize indexes, SQL statements, and analyze slow queries

When designing tables, the database is designed strictly according to the design paradigm of the database.

You can save disk IO by using memcache cache to put frequently accessed data and data that do not need to change frequently in memcache cache.

Optimize hardware, adopt SSD, use disk queue technology (RAID0,RAID1,RDID5), etc.

The use of MySQL internal table partitioning technology to layer data into different files can improve the reading efficiency of the disk.

Divide the table vertically; put some infrequently read data in a table to save disk Imax O

Master-slave read and write separation; master-slave replication is used to separate database read and write operations

Sub-library sub-table sub-machine (a large amount of data), the main principle is data routing

Select the appropriate table engine and optimize the parameters

Architecture-level caching, static, and distributed

Do not use full-text index

Adopt faster storage methods, such as NoSQL to store frequently accessed data

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.