Use MySQL's slow query log to find inefficient SQL statements

Title, to turn on MySQL's slow query log, you can set two items in the MySQL configuration file under [mysqld]:

Log-slow-queries = D:/soft/phpnow/mysql-5.1.50/test.log
Long_query_time = 1

Log-slow-queries represents the log book storage location, Long_query_time indicates the execution time unit is seconds, so set up after restarting the MySQL server, query more than 1 seconds of SQL statements will be recorded in the log, it is important to note that the Log_query_ Time cannot set decimals (some versions can also be set if tested).

Use MySQL's slow query log to find inefficient SQL statements