A common method of MySQL database optimization

1. Optimize indexes, SQL statements, analyze slow queries;

2. Design the database strictly according to the design paradigm of the database;

3. You can save disk IO by using memcache caching, and placing frequently accessed data in the Memcache cache without the need for frequently changing data;

4. Optimize hardware, adopt SSD, use Disk Queue technology (RAID0,RAID1,RDID5), etc.

5. Using MySQL internal table partitioning technology, the data layer different files, can improve the efficiency of disk reading;

6. Vertical sub-table; Put some infrequently read data in a table, save disk I/O;

7. The master-slave separation reads and writes, and the read and write operations of the database are separated by the master-slave replication;

8. Sub-database sub-table sub-machine (data volume is particularly large), the main principle is data routing;

9. Select the appropriate table engine and optimize the parameters;

10. Architecture-level caching, static and distributed;

11. Do not use full-text indexing;

12. Use faster storage, such as NoSQL storage for frequently accessed data

This article is from the "Hello I am Forest" blog, please make sure to keep this source http://chensenlin.blog.51cto.com/10559465/1875193

A common method of MySQL database optimization