A comprehensive technology for MySQL optimization, mainly including
- The design of the table is rationalized (in accordance with 3NF), some of which need inverse paradigm; http://www.cnblogs.com/ChaosJu/p/4543210.html
- SQL statement optimization;
- Add appropriate index (index) [Four kinds: normal index, primary key index, unique index unique, full-text index];
- Select the appropriate storage engine (MyISAM, InnoDB, memory);
- Sub-table Technology (horizontal Division, vertical division);
- Read-write [write: Update/delete/add] separation;
- Stored procedures [modular programming, can improve speed];
- Configuration optimization for MySQL [Configure maximum concurrency number My.ini, adjust cache size];
- MySQL server hardware upgrade;
- Periodically remove unwanted data and defragment it regularly (MyISAM).
Subsequent blog essays will be a simple analysis of the above content.
MySQL optimization technology