?????????÷???????? ./mysqldumpslow --help

??????5.1.6?汾???????????????????????????????????????????е??????

????????log_output???????????????????????file???????????????table

????????log_output???????????????????????????????б??

mysql> show variables like 'log_output';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_output    | FILE  |
+---------------+-------+
1 row in set (0.00 sec)

mysql> set global log_output='TABLE';
Query OK?? 0 rows affected (0.00 sec)

mysql> show variables like 'log_output';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_output    | TABLE |
+---------------+-------+
1 row in set (0.00 sec)

mysql> select sleep(15);
+-----------+
| sleep(15) |
+-----------+
|         0 |
+-----------+
1 row in set (15.02 sec)

mysql> select * from mysql.slow_logG;
*************************** 1. row ***************************
    start_time: 2013-04-14 01:22:29
     user_host: root[root] @ localhost []
    query_time: 00:00:15
     lock_time: 00:00:00
     rows_sent: 1
 rows_examined: 0
            db: test
last_insert_id: 0
     insert_id: 0
     server_id: 1
      sql_text: select sleep(15)
1 row in set (0.00 sec)

??????????????????????????15????????SQL???????slow_log??

?????????????????????????п????????????????????????????????????????????????????