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';