MySQL Optimization (outline)

Reference: http://www.cnblogs.com/villion/archive/2009/07/23/1893765.html#3031899

MySQL optimization can mainly consider the following four aspects:

1. Database design:

This is from the big aspect, the architecture aspect to design the database, designs the sick database, the later optimization also was not saved

The main design of the database design of the 3 major paradigms, and according to the actual, moderate anti-paradigm (efficiency-space)

2.sql Statement Optimization:

SQL statement optimization, in fact, is usually the Select query optimization, then the index must not be avoided

So the focus of this section is how to use indexes correctly and efficiently, and how to view and analyze the efficiency of SQL statements

3. Database parameter configuration:

The default MySQL consideration is general machine versatility, so there may not really play the maximum performance of MySQL,

This can be set according to the configuration of the computer, so that MySQL will play its maximum power.

4. Proper hardware resources and operating system:

This is the actual use of the relevant

MySQL Optimization (outline)