Shulou(Shulou.com)06/01 Report--

This article will explain in detail what mysql slow query refers to. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

MySQL slow query is to record slow SQL statements in the log, which needs to be turned on before it can be used.

Write in the configuration file my.cnf of MySQL:

Long_query_time = 10log-slow-queries = / var/lib/mysql/mysql-slow.log

Long_query_time refers to how long the SQL will be logged, in this case, 10 seconds.

The log-slow-queries setting writes the log there (in the example, the slow log will be written to the file / var/lib/mysql/mysql-slow.log). If it is empty, the system will give the slow log a hostname and add slow.log. If the parameter log-long-format is set, all queries that do not use the index will also be logged.

This is a very useful journal. It has little impact on performance (assuming that all queries are fast) and emphasizes the queries that need the most attention (missing indexes or indexes that are not best applied).

On the mysql slow query refers to what is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.