MySQL database optimization (analysis tools)

Before the system background alarm too many, simple query the following reason, mainly is the data volume is large, the number of queries and database performance is low caused. At that time, a simple analysis of the database configuration and a few tables with slow log queries added a single-column index to a long-running table, and the effect was more obvious.

14 National Day during the background interface of the public number call situation is as follows, of course, this is only one of the public number, we backstage about 10 to 20 public number in the active

Back part of the data

The most recent call reached 160,000, but the failure rate is 40%, relative to the national day period of 80,000 data, the failure rate of 80% to improve the line. But since the problem exists, the optimization work has to continue.

MySQL database optimization (analysis tools)