各位专家,我在配置mysql通用日志的时候发现日志根本无法写入,什么数据也没有,我的log功能已经打开了用show variables like 'log%';查看状态如下:mysql> show variables like 'log%';
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| log | ON |
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_bin_trust_routine_creators | OFF |
| log_error | /var/lib/mysql/localhost.localdomain.err |
| log_output | FILE |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
+---------------------------------+------------------------------------------+
10 rows in set (0.00 sec)现在执行查询在对应的log文件里都没有记录,是什么原因啊
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| log | ON |
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_bin_trust_routine_creators | OFF |
| log_error | /var/lib/mysql/localhost.localdomain.err |
| log_output | FILE |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
+---------------------------------+------------------------------------------+
10 rows in set (0.00 sec)现在执行查询在对应的log文件里都没有记录,是什么原因啊
在my.ini或my.cnf中
在my.ini加入log-bin='路径';
my.cnf中加入ect/log/...'
如下开启:
SET global general_log =ON;这样就会有个log文件记录所有的操作!
已经开启了啊,general_log已经是On了
linux系统 my.cnf下面show variables like 'general_log'看到的也是on
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
loose-default-character-set = utf8
log = /home/psms/log/sql.log
log-output = file
my.cnf中mysqld的配置 谢谢~~~