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

Reply via email to