Slow MYSQL problem record database statements

Log_slow_queries must be enabled for a 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. Let's try this:
First, connect to the Mysql server through the client, and then enter the following statement:
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 on the MYSQL client:
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