MySQL optimization self-Summary, mysql Optimization

MySQL optimization self-Summary, mysql Optimization

Through work and time learning, I have summarized the major aspects of MySQL optimization:

① Optimization on the storage layer (including storage engines, column types, and paradigm specifications );

② Optimize the design layer (including cache: memcache and redis, index the column fields, and partition and table sharding );

③ Optimize the architecture layer (read/write replication, Master/Slave separation, that is, build a Cluster Server );

④ Optimize the SQL statement layer (select a more appropriate SQL statement for addition, deletion, modification, and query. You can use the explain execution plan to check whether the selected SQL statement is appropriate. Generally, the minimum level is range, const is the highest level, system is the top level, and some SQL statements can only reach the index, so other methods are required for optimization );