Agreed - I'd love to be able to turn it on/off on demand.
regards,
P
On Fri, 6 Apr
2001, Tim Bunce wrote:
> On Fri, Apr 06, 2001 at 12:13:22AM -0400, Thalis A. Kalfigopoulos wrote:
> > On Thu, 5 Apr 2001, Roel Vanhout wrote:
> >
> > > Hi all,
> > >
> > > Is there a way to turn the query logging on and off while the database
> > > server is running? Right now I have a script that stops and restarts the
> > > database with loggin on or off depending on the parameters, but this is
> > > not so great; I was wondering if there is another way. Also, is there a
> > > way to query the server if logging is on or off? I'd like to write a
> > > nice gnome applet to start/stop logging but I'm not sure how to get this
> > > value.
> >
> > You can get whether the server is loging or not through
> > $ mysqladmin -p variables
> > and check the value of, you guessed it, the entry 'log'
> >
> > I don't know if you can make the server turn logging on/off while it is running.
>But you can swithc logging on/off for a particular session giving:
> > SET SQL_LOG_OFF=1 (the client must have the Process privilege)
>
> I think run-time changing of some config settings, like logging,
> should be on the to-do for v4, if it isn't already.
>
> Tim.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
