MySQLで一時的にクエリログを出力

ON

code:text

$ sudo mkdir -p /var/log/mysql

$ sudo chown mysql:mysql /var/log/mysql

mysql> SET GLOBAL general_log_file = "/var/log/mysql/query.log";

mysql> SET GLOBAL general_log = 'ON';

OFF

code:text

mysql> SET GLOBAL general_log = 'OFF';

N秒間だけクエリ実行ログを取りたい