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
