Hi,I'm using mysql5.4-beta now.when I use flow command ,it does not works,is mysql5.4 bug?
The command mysqladmin -p -r --sleep=1 --count=100 extended-status It run only one time. Thanks! -----邮件原件----- 发件人: mos [mailto:mo...@fastmail.fm] 发送时间: 2009年5月18日 2:14 收件人: mysql@lists.mysql.com 主题: Problem setting up slow logging in my,ini file I'm having a problem defining slow logging file in my.ini (Windows XP). I'm using MySQL 5.1.30. In the MySQL reference manual it says: As of MySQL 5.1.29, the --log-slow-queries option is deprecated and will be removed (along with the log_slow_queries system variable) in MySQL 7.0. Instead, use the --slow_query_log option to enable the slow query log and the --slow_query_log_file=file_name option to set the slow query log file name. So my.ini has: [mysqld] general_log=1 log-output=FILE general_log_file=LOG.TXT slow_query_log=1 slow_query_log_file=SLOWLOG.TXT After I restart MySQL, the variables have: Variable_name Value ------------------------------- ------------------------------ log ON log_bin OFF log_output FILE log_queries_not_using_indexes OFF log_slow_queries ON log_warnings 1 slow_query_log ON slow_query_log_file OFF sql_log_bin ON sql_log_off OFF sql_log_update ON So why is the variable "slow_query_log_file" set to "OFF" because it is not boolean and should be a file name? Why isn't it set to the file name "SLOWLOG.TXT"? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=yanwei.z...@opi-corp.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
