|
把下面的参数在my.cnf设置下(可以使用set global 命令在线设置):
slow_query_log = 1
slow_query_log_file = /home/oracle/mysql5.1.37/log/slow.log
long_query_time = 1
root@(none) 09:23:03>show variables like '%slow%';
+---------------------+---------------------------------------+
| Variable_name | Value |
+---------------------+---------------------------------------+
| log_slow_queries | ON |
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_log_file | /home/oracle/mysql5.1.37/log/slow.log |
+---------------------+---------------------------------------+
root@(none) 09:23:36>show variables like '%long%';
+-----------------+----------+
| Variable_name | Value |
+-----------------+----------+
| long_query_time | 1.000000 |
+-----------------+----------+
1 row in set (0.00 sec)
[ 本帖最后由 philip_zhong 于 2010-8-24 09:27 编辑 ] |
|