Re: Fwd: Dynamic enabling of log files

2003-08-21 Thread Prem Soman
hi Nils! can u show me how to change the long_query_time using sql statement or by using mysqladmin. the set long_query_time=xyz; does not work or is this a valid command. i am using mysql 3.23.52 --- Nils Valentin <[EMAIL PROTECTED]> wrote: > Hi Prem, > > > Which version ar

Re: Fwd: Dynamic enabling of log files

2003-08-18 Thread Victoria Reznichenko
Prem Soman <[EMAIL PROTECTED]> wrote: > > i have gone thru what u referred long before, i know > that this "set" method is not fully supported in 3.23 > version, thats why i posed this question, i wanted to > know whether there is any other way to do it. > > when i make changes to my.cnf file i

Re: Fwd: Dynamic enabling of log files

2003-08-17 Thread Nils Valentin
Hi Prem, Which version are you curently using 3.23.xxx ?? Whats the XXX in your version ??? What do the change log files say at the www.mysql.com homepage ? Best regards Nils Valentin Tokyo/Japan Prem Soman wrote: Thanks neils! i have gone thru what u referred long before, i know that th

Re: Fwd: Dynamic enabling of log files

2003-08-17 Thread Prem Soman
Thanks neils! i have gone thru what u referred long before, i know that this "set" method is not fully supported in 3.23 version, thats why i posed this question, i wanted to know whether there is any other way to do it. when i make changes to my.cnf file i am able to do it but it is not immed

Re: Fwd: Dynamic enabling of log files

2003-08-14 Thread Nils Valentin
Hi Prem, That question was just here 2 days ago, so easy to answer. ;-) Logs can be enabled/disabled for the session with SET SQL_LOG_OFF | SQL_LOG_BIN | SQL_LOG_UPDATE. But these commands are not supported in v3.23.52: http://www.mysql.com/doc/en/SET_OPTION.html Best regards Nil