logを有効にする
mysql> set global general_log = 'ON'; Query OK, 0 rows affected (0.04 sec)
logがONになっている
mysql> show variables like 'log%'; +---------------------------------+------------------------------------+ | Variable_name | Value | +---------------------------------+------------------------------------+ | log | ON | | log_bin | ON | | log_bin_trust_function_creators | OFF | | log_bin_trust_routine_creators | OFF | | log_error | /var/lib/mysql/hoge.err | | log_output | FILE | | log_queries_not_using_indexes | OFF | | log_slave_updates | OFF | | log_slow_queries | ON | | log_warnings | 1 | +---------------------------------+------------------------------------+ 10 rows in set (0.00 sec)
これで随時ログが吐かれる
100610 22:16:17 36240 Connect hoge@localhost on hoge 36240 Query SELECT id, provider_id, name, host, created, modified FROM sites WHERE provider_id = '101' ORDER BY id ASC 36240 Quit
ちなみに、ログを無効にしたければOFFをセットするだけ
mysql> set global general_log = 'OFF';