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
