MySQL Advanced-showprofile

First, what is Show profile?

Is MySQL provides a measure of the resource consumption that can be used to analyze the execution of statements in the current session, which can be used for SQL tuning.

By default, the parameter is turned off and the last 15 run results are saved.

Second, the analysis steps

1, whether support, see whether the current MySQL version is supported

　　　　

2, open function, default is off, need to open before use.

　　　　

　　　　

3. Running sq

L

4, see the results, show profiles;

　　　　

5. Diagnose Sql,show profile Cpu,block io for query previous problem SQL digital number;

　　　　

　　　　

　　　　

6, the daily development needs to pay attention to the conclusion

　　　　

　　　　

　　　　

MySQL Advanced-showprofile