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 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 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 immediatly reflected since mysqld
> reads
> > from the my.cnf file only when it restarts.... i
> > thought there must be some sort of command line
> > utility or ... to enable and disabke log files
> > without restarting the server.
> >
> > can u also tell me from what version onwards is
> this
> > type of dynamic setting for log files allowed.
> >
> > Regards,
> > Prem S
> >
> > --- Nils Valentin <[EMAIL PROTECTED]> wrote: >
> >
> >>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
> >>
> >>Nils Valenin
> >>Tokyo/Japan
> >>
> >>2003年 8月 13日 水曜日 13:30、Prem Soman
> >>さんは書きました:
> >>
> >>> Note: forwarded message attached.
> >>>
> >>>
> >>
> >
>
________________________________________________________________________
> >
> >>>Want to chat instantly with your online friends?
> >>
> >>Get the FREE Yahoo!
> >>
> >>>Messenger http://uk.messenger.yahoo.com/
> >>
> >>--
> >>---
> >>Valentin Nils
> >>Internet Technology
> >>
> >> E-Mail: [EMAIL PROTECTED]
> >> URL: http://www.knowd.co.jp
> >> Personal URL: http://www.knowd.co.jp/staff/nils
> >>
> >
> >
> >
>
________________________________________________________________________
> > Want to chat instantly with your online friends?
> Get the FREE Yahoo!
> > Messenger http://uk.messenger.yahoo.com/
>
>
________________________________________________________________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
