MYSQL 5.1.12为什么不生成查询日志文件
my.ini内容如下
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
log=f:\mysql\data\query.log
log_output=FILE
show variables like '%LOG% ' 参数如下
back_log | 50
binlog_cache_size | 32768
binlog_format | MIXED
expire_logs_days | 0
general_log | ON
general_log_file | f:\mysql\data\query.log
innodb_locks_unsafe_for_binlog | OFF
innodb_log_arch_dir |
innodb_log_archive | OFF
innodb_log_buffer_size | 1048576
innodb_log_file_size | 10485760
innodb_log_files_in_group | 2
innodb_log_group_home_dir | .\
innodb_mirrored_log_groups | 1
innodb_flush_log_at_trx_commit | 1
log | ON
log_bin | OFF
log_bin_trust_function_creators | OFF
log_error | .\mycomputer.err
log_output | FILE
log_queries_not_using_indexes | OFF
log_slave_updates | OFF
log_slow_queries | OFF
log_warnings | 1
max_binlog_cache_size | 4294967295
max_binlog_size | 1073741824
max_relay_log_size | 0
ndb_extra_logging | 0
relay_log_purge | ON
relay_log_space_limit | 0
slow_query_log | OFF
slow_query_log_file | F:\mysql\Data\query-slow.log
sync_binlog | 0
[解决办法]
log_bin | OFF
似乎是这个该为 ON ?
也是在网上看的...
