How Can I Log All MySQL Queries to a File for One Hour?

Log Output Configuration in MySQL

This question explores the capability of MySQL to enable query logging. The user seeks to monitor all queries for an hour and output the log to a file.

To achieve this, the following procedures are recommended:

SET global log_output = 'FILE';
SET global general_log_file='/Applications/MAMP/logs/mysql_general.log';
SET global general_log = 1;

This sequence of commands will commence logging of queries to the specified file. Once the desired time frame has elapsed, the logging can be disabled with the following command:

SET global general_log = 0;

By utilizing these methods, it is feasible to effectively monitor all queries within a specified period and store the resulting log for further analysis.

The above is the detailed content of How Can I Log All MySQL Queries to a File for One Hour?. For more information, please follow other related articles on the PHP Chinese website!