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
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
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
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
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