How Can I Monitor MySQL Query Execution Across Multiple Servers?

Monitoring Query Execution Across MySQL Servers

To monitor query execution across multiple MySQL servers, one can employ various techniques.

MySQL >=5.1.12

For servers running MySQL 5.1.12 or later, you can enable global logging using SQL commands:

1. SET GLOBAL log_output = 'TABLE';
2. SET GLOBAL general_log = 'ON';

This will log queries in the mysql.general_log table.

File Output

Alternatively, you can configure MySQL to output logs to a file:

1. SET GLOBAL log_output = "FILE";
2. SET GLOBAL general_log_file = "/path/to/logfile.log";
3. SET GLOBAL general_log = 'ON';

Advantages of SQL-Based Logging

Setting up logging via SQL commands offers several advantages:

• No need to modify configuration files.
• Logging can be turned on and off dynamically without restarting the server.
• Logs are not permanently written to disk by default.

Additional Resources

For more detailed information, refer to the MySQL 5.1 Reference Manual:

• [Server System Variables - general_log](https://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#general_log)

The above is the detailed content of How Can I Monitor MySQL Query Execution Across Multiple Servers?. For more information, please follow other related articles on the PHP Chinese website!