MySQL Query History

設定 MySQL General Log、Slow Query Log


MySQL 5.1 /etc/mysql/my.cnf 設定檔有些小更改 (see below)
Slow Query Log in MySQL 5.1 Cheat Sheet | Palomino DB 


MySQL 5.1 以上支援動態啟用 Log

mysql> set global log_output=file;
mysql> set global general_log_file='/var/log/mysql/general.log';
mysql> set global slow_query_log_file='/car/log/mysql/slow.log';
mysql> set global general_log=on;
mysql> set global slow_query_log=on;

mysql> SHOW VARIABLES LIKE 'slow_query_log_file';

View Log

# cat /var/log/mysql/general.log | grep -E '[[:space:]]+[[:digit:]]+[[:space:]]Query' | grep -iE 'Query([[:space:]])+(/\*.*\*/)?(insert|update|delete)'

Reference :
Enable slow query logging in MySQL
MySQL :: MySQL 5.1 Reference Manual :: 5.2.5 The Slow Query Log
MySQL 日志文件 说明 - David Dai -- Focus on Oracle - 博客频道 - CSDN.NET 

舊
SQL - MySQL Server 日常維護: Log 分析(mysqlsla) - 史萊姆論壇