the client the settings are reset...
-----Urspr=FCngliche Nachricht-----
Von: Victoria Reznichenko [mailto:vi******************@ensita.net]=20
Gesendet: Mittwoch, 16. Juli 2003 11:19
An: my***@lists.mysql.com
Betreff: Re: switch query logging while the server is running
Ch**************@biomax.de wrote:
Description:
It would be nice if general query logging could be switched on and off
while the MySQL server is running, and not only at startup time.
While debugging an application that uses foreign database access
libraries, this would be very helpful. One could switch on logging,
perform an activity, switch off logging, and look what has happened.
Otherwise, the server has to be restarted to change logging, which
is a bit annoying...How-To-Repeat:
mysql> show variables like 'log';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log | ON |
+---------------+-------+
1 row in set (0.00 sec)
=20
mysql> set log off;
ERROR 1193: Unknown system variable 'log'
mysql> set session log off;
ERROR 1193: Unknown system variable 'log'
mysql>
This variable is called SQL_LOG_OFF. Please, read the manual:
http://www.mysql.com/doc/en/SET_OPTION.html
--=20
For technical support contracts, goto =
https://order.mysql.com/?ref=3Densita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Vi******************@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/my***********...******@cern.ch
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw