mysql 5.5.21
设置了一下参数,但是slow1.log
+------------------------------------+-----------------------+
| Variable_name | Value |
+------------------------------------+-----------------------+
| log_slow_admin_statements | ON |
| log_slow_filter | |
| log_slow_queries | ON |
| log_slow_rate_limit | 1 |
| log_slow_rate_type | session |
| log_slow_slave_statements | OFF |
| log_slow_sp_statements | ON |
| log_slow_verbosity | |
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_log_file | /mysql/data/slow1.log |
| slow_query_log_timestamp_always | ON |
| slow_query_log_timestamp_precision | second |
| slow_query_log_use_global_control | |
+------------------------------------+-----------------------+
[mysql@mysql56 ~]$ more mysqlslow1.txt
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
# Thread_id: N Schema: ttp Last_errno: N Killed: N
# Query_time: N.N Lock_time: N.N Rows_sent: N Rows_examined: N Rows_affected: N Rows_read: N
# Bytes_sent: N Tmp_tables: N Tmp_disk_tables: N Tmp_table_sizes: N
# InnoDB_trx_id: N
use ttp;
SET timestamp=N;
select count(*) from dd4
无时间日期,很奇怪,请问一下,是不是哪里设置有问题?