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_nameValue --- -- log ON log_bin OFF log_output FILE log_queries_not_using_indexesOFF 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
Re: Problem setting up slow logging in my,ini file
Try putting in a full existing pathname the server has write access to as opposed to just a file name. Walter Heck On Sun, May 17, 2009 at 12:13 PM, mos mo...@fastmail.fm wrote: 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=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem setting up slow logging in my,ini file
At 01:22 PM 5/17/2009, Walter Heck - OlinData.com wrote: Try putting in a full existing pathname the server has write access to as opposed to just a file name. Walter Heck Walter, That didn't work either if I put it in the my.ini file. Without a path it should default the location to the mysql/data directory which is where I'd like it to be. The only way I got it to work was to set the global variable after MySQL was running. It doesn't not appear I can get to specify the slow log file from the my.ini file. Mike On Sun, May 17, 2009 at 12:13 PM, mos mo...@fastmail.fm wrote: 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=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org