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=gcdmg-mysql-2@m.gmane.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 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=3Dfile_name option to set the slow quer=
y log
> file name.
> So my.ini has:
>
> [mysqld]
> general_log=3D1
> log-output=3DFILE
> general_log_file=3DLOG.TXT
> slow_query_log=3D1
> slow_query_log_file=3DSLOWLOG.TXT
>
> After I restart MySQL, the variables have:
> Variable_name                 =C2=
=A0  Value
> -------------------------------  ------------------------------
> log                    =
         ON
> log_bin                   =
       OFF
> log_output                  =
    FILE
> log_queries_not_using_indexes    OFF
> log_slow_queries                 =
ON
> log_warnings                 =C2=
=A0   1
> slow_query_log                 =
  ON
> slow_query_log_file              OFF
> sql_log_bin                 =C2=
=A0    ON
> sql_log_off                 =C2=
=A0    OFF
> sql_log_update                 =
  ON
>
>
> So why is the variable "slow_query_log_file" set to "OFF" because it is n=
ot
> boolean and should be a file name?  Why isn't it set to the file nam=
e
> "SLOWLOG.TXT"?
>
> TIA
> Mike
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dlists@o=
lindata.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

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=
=20
it should default the location to the mysql/data directory which is where=20
I'd like it to be. The only way I got it to work was to set the global=20
variable after MySQL was running. It doesn't not appear I can get to=20
specify the slow log file from the my.ini file.

Mike



>On Sun, May 17, 2009 at 12:13 PM, mos 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=3Dfile_name option to set the slow=20
> query log
> > file name.
> > So my.ini has:
> >
> > [mysqld]
> > general_log=3D1
> > log-output=3DFILE
> > general_log_file=3DLOG.TXT
> > slow_query_log=3D1
> > slow_query_log_file=3DSLOWLOG.TXT
> >
> > After I restart MySQL, the variables have:
> > Variable_name =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 Value
> > ------------------------------- =C2 ------------------------------
> > log =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2=
=C2 ON
> > log_bin =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2=
OFF
> > log_output =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 FILE
> > log_queries_not_using_indexes =C2 =C2 OFF
> > log_slow_queries =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 ON
> > log_warnings =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 1
> > slow_query_log =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 ON
> > slow_query_log_file =C2 =C2 =C2 =C2 =C2 =C2 =C2 OFF
> > sql_log_bin =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 ON
> > sql_log_off =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 OFF
> > sql_log_update =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 =C2 ON
> >
> >
> > So why is the variable "slow_query_log_file" set to "OFF" because it is=
not
> > boolean and should be a file name? =C2 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: =C2 =C2=
http://lists.mysql.com/mysql?unsub=3Dlists@olindata.com
> >
> >


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

mysql5.4 bugs about mysqladmin??

Hi,I'm using mysql5.4-beta now.when I use flow command ,it does not =
works,is
mysql5.4 bug?

The command=20
mysqladmin -p -r --sleep=3D1 --count=3D100 extended-status

It run only one time.

Thanks!


-----ÓʼþÔ­¼þ-----
·¢¼þÈË: mos [mailto:mos99@fastmail.fm]=20
·¢ËÍʱ¼ä: 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=20
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=20
removed (along with the
log_slow_queries system variable) in MySQL 7.0. Instead, use the=20
--slow_query_log option to enable the slow query
log and the --slow_query_log_file=3Dfile_name option to set the slow =
query=20
log file name.
So my.ini has:

[mysqld]
general_log=3D1
log-output=3DFILE
general_log_file=3DLOG.TXT
slow_query_log=3D1
slow_query_log_file=3DSLOWLOG.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=20
boolean and should be a file name? Why isn't it set to the file name=20
"SLOWLOG.TXT"?

TIA
Mike=20


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Dyanwei.zhou@opi-corp.co m





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg