Mysql statements with slow execution speed

To monitor slow execution of Mysql statements, you must first enable the log_slow_queries authority for slow query output. You can set it in the MySQL configuration file (my. ini/my. cnf) or through the MySQL client. The advantage of the second method is that the setting takes effect without restarting the MySQL service. Then try this: First connect to the Mysql server through the client, and then enter the following statement: SQL code SET GLOBAL log_slow_queries = ON; SET GLOBAL long_query_time = 3; in this way, MySQL records SQL statements that take more than 3 seconds and outputs them to a slow query log file. The question is, where is the slow query log file? Run the following statement in the MYSQL client: SQL code show variables like 'slow _ query_log_file '; the location of the MySQL slow query log file is displayed. My is:/usr/local/mysql/data/host-slow.log