mysql-Official Documentation-optimization

Reference Link: https://dev.mysql.com/doc/refman/5.6/en/optimize-overview.html

Article Summary:

Overview:
The basic optimization starts from the software level rule, because the software affects the hardware, the high-level optimization starts from the internal mechanism such as CPU and IO. Ordinary users to retrofit software and hardware configuration to improve performance, advanced users to improve the performance of MySQL software.
Basic design is most important for database performance. such as: reasonable table structure, appropriate index, appropriate storage engine, appropriate row format, appropriate locking policy, using cache.

The hardware level is also important. such as: Disk seek time, disk read and write speed, CPU cycle, memory bandwidth.

Use annotations with MySQL-related keywords to take care of both performance and portability.

mysql-Official Documentation-optimization