mysql配置文件my.ini配置为:
log-bin=1
log-queries-not-using-indexes=1
log-error="D/windows/EtimServer/Server/working/mysql/logs/error.log"
log="D/windows/EtimServer/Server/working/mysql/logs/mysql.log"
long_query_time=2
log-slow-queries="D/windows/EtimServer/Server/working/mysql/logs/slowquery.log"
log-queries-not-using-indexes="D/windows/EtimServer/Server/working/mysql/logs/nouseindex.log"
重启服务后,查询show variables like 'log_%'
+---------------------------------+----------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+----------------------------------------------------------+
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_bin_trust_routine_creators | OFF |
| log_error | D\windows\EtimServer\Server\working\mysql\logs\error.log |
| log_output | FILE |
| log_queries_not_using_indexes | ON |
| log_slave_updates | OFF |
| log_slow_queries | ON |
| log_warnings | 1 |
+---------------------------------+----------------------------------------------------------+
可见日志启用成功!
客户端登录mysql,执行几条简单查询语句
可是却不见D/windows/EtimServer/Server/working/mysql/logs目录生成配置中定义的log文件
各位大侠知道什么原因吗?
2010年8月28日 10:58