The method of constructing slow query by mysql

This article will explain in detail the method of constructing slow query on mysql. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Mysql constructs slow query methods: 1, modify the configuration file, add relevant code in [my.ini], define slow query time and slow query log log records; 2, open slow query through MySQL database.

The method of constructing slow query by mysql:

Method 1:

Modify the configuration file to add several lines to my.ini: mainly the definition time of slow query (slow query for more than 2 seconds), and slow query log log record (slow_query_log)

Method 2: open slow query through MySQL database:

This is the end of the method of constructing slow query on mysql. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.