MySQL Performance tuning kick

The effect is, with 2/8 principles, M.F.B. s to solve most things. So kick, limited to the overall adjustment, not involved in specific details.

1, InnoDB

Using the InnoDB engine

2, Innodb_buffer_pool

Adjust and innodb about the parameters, as much as possible in memory and InnoDB instance

3. Index

Index, needless to say.

4. Cache

Query caching, such as Redis

5. Batch Write

such as queue cache data, there is a dedicated thread in the idle batch storage

6, SQL can not write the too stamp

MySQL Performance tuning kick