MySQL optimization and mysql Performance Optimization

MySQL optimization and mysql Performance Optimization

 

1. Table Structure 2. Data Type 3. index 4. Constraints

Set the not null non-null constraint for the field, because null not only occupies more space, but also makes the comparison and index complex.

5. SQL statement 6. Cache

Currently, we access data most of the time through the ORM framework. These frameworks often provide the cache function (level-1 cache or level-2 cache). Enabling the cache can reduce the number of accesses to the database, which not only improves the reflection speed, it also reduces the pressure on the database.

 

Refer:
Http://blog.csdn.net/waferleo/article/details/7179009
Http://www.cnblogs.com/nathan-1988/archive/2012/07/17/2596439.html