mysql的log问题

Question

在/etc/my.cnf下的[mysqld]项修改，增加了行
log-error=/usr/local/mysql/log/error.log
log=/usr/local/mysql/log/mysql.log
long_query_time=2
log-slow-queries=/usr/local/mysql/log/slowquery.log
#之后只看到一个error.log这个文件,mysql.log和slowquery.log这两个文件就没有办法看到是怎么回事。请高手指教啊

Answer 1

general_log 参数没有打开。general-log=ON
slow_query_log =ON

Answer 2

我在my.cnf里面添加了这两行之后服务没有办法启动了。注释了就可以。
mysql>set global general_log=on;
#提示
ERROR 1193 (HY000):Unknown system variable 'general_log'
这个为什么我添加不了的？
mysql>show variable like '%log%'
里面也没有general_log这个项目

Answer 3

mysql>show variables like '%log%';
查出来里面的log项是ON的；
可就是看不到文件

Answer 4

general-log=ON注意细节。

Answer 5

mysql>set global general-log=ON;
回车之后也是提示了错误.不过错误提示有所改变。从'general_log'变成了'general'
ERROR 1193 (HY000):Unknown system variable 'general'

Answer 6

flush log这个功能我看了参考手册之后还是不太清楚怎么去使用。麻烦5楼说的详细一点。谢谢了

Answer 7

mysql> show variables like'%log%';
#查询出来的内容
+--------------------------------+--------------------------------+| Variable_name                  | Value                          |+--------------------------------+--------------------------------+| back_log                       | 50                             || bdb_log_buffer_size            | 32768                          || bdb_logdir                     |                                || binlog_cache_size              | 32768                          || expire_logs_days               | 0                              || innodb_flush_log_at_trx_commit | 1                              || innodb_locks_unsafe_for_binlog | OFF                            || innodb_log_arch_dir            |                                || innodb_log_archive             | OFF                            || innodb_log_buffer_size         | 1048576                        || innodb_log_file_size           | 5242880                        || innodb_log_files_in_group      | 2                              || innodb_log_group_home_dir      | ./                             || innodb_mirrored_log_groups     | 1                              || log                            | ON                             || log_bin                        | OFF                            || log_error                      | /usr/local/mysql/log/error.log || log_slave_updates              | OFF                            || log_slow_queries               | OFF                            || log_update                     | OFF                            || log_warnings                   | 1                              || max_binlog_cache_size          | 4294967295                     || max_binlog_size                | 1073741824                     || max_relay_log_size             | 0                              || relay_log_purge                | ON                             || relay_log_space_limit          | 0                              || sync_binlog                    | 0                              |+--------------------------------+--------------------------------+

Answer 8

| log                            | ON                             |已经是ON了，你确认你找不到LOG文件？

Answer 9

不过error.log这个文件到是生成了

Answer 10

#\usr\bin\mysqladmin -u root -p flush-logs
输入密码之后居然提示说
Unknown error;