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=arch...@jab.org
