MySQL Optimization overview

What are the main considerations for MySQL optimization?

1. Before you do MySQL optimization, you can do a whole performance test of MySQL server, look at the server bottleneck problem where, mainly to do benchmark test, to test the server's disk IO capability. To see how big the server is.

2. Run a certain script to observe the running state of MySQL, if MySQL has irregular fluctuations, the possible problem is due to the individual SQL statement is not reasonable to write. Then use the slow query or the Profiles tool to analyze which step of the SQL statement takes a long time. Finally, you can use the Explain tool to analyze the behavior of the modified SQL statement execution. So as to make reasonable improvements. Of course, there may be periodic fluctuations in MySQL, then the problem is that there is a problem with the MySQL cache system. At this point, you need to modify the MySQL cache policy.

This article is from "riding a stupid Bird slowly fly" blog, please be sure to keep this source http://sinsea.blog.51cto.com/4656533/1729766

MySQL Optimization overview