Skip to content

MySQL query performance logging

MySQL query performance logging is configured using the slow-query-log and general-log settings within the server configuration file (e.g., my.ini).^[600-developer-database-mysql-mysql8-portable.md]

Configuration

To track query performance, specific directives must be defined in the configuration file:

  • Slow Query Log: This is enabled by setting slow-query-log=1.^[600-developer-database-mysql-mysql8-portable.md] You must also specify the output file path using slow_query_log_file.^[600-developer-database-mysql-mysql8-portable.md]
  • General Log: This is controlled by the general-log directive.^[600-developer-database-mysql-mysql8-portable.md] This log records all queries executed by the server and requires a general_log_file path.^[600-developer-database-mysql-mysql8-portable.md]
  • Error Log: While typically for server issues, the log-error path is defined alongside performance logs for comprehensive monitoring.^[600-developer-database-mysql-mysql8-portable.md]

Configuration Example

Below is an example configuration snippet showing the paths for the log files:

general-log=0
general_log_file=D:/JavaTool/database/mysql-8.0.13-winx64/mysql-general.log
slow-query-log=1
slow_query_log_file=D:/JavaTool/database/mysql-8.0.13-winx64/mysql-slow.log
log-error=D:/JavaTool/database/mysql-8.0.13-winx64/mysql-error.log

^[600-developer-database-mysql-mysql8-portable.md]

Sources

^[600-developer-database-mysql-mysql8-portable.md]

  • [[MySQL]]
  • [[Query Optimization]]