Slow MYSQL speed, record database statements

MYSQL is slow, and Web programs that record database statements are slow. The first object to be detected is the database, which has been known for a few years. What should I do if I want to track SQL statements that drag down the server performance in MySQL? 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: www.2cto.com first connects to the Mysql server through the client, and then enters 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 in 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
Author Li Qiu