On 15 Mar 2004, at 12:34, Victoria Reznichenko wrote:
[EMAIL PROTECTED] wrote:Hello colleagues: I would like to know if it's possible to start the log file production at run time, i.e. without stopping and restarting the database ...
No, you should restart MySQL server.
Which is really irritating if you're debugging a problem with a busy production server. You don't want the general query log on all the time, but you don't want to have to have database downtime (even if it's only momentary) to switch the logging on and then off again.
Tim
-- Dr Tim Cutts Informatics Systems Group Wellcome Trust Sanger Institute Hinxton, Cambridge, CB10 1SA, UK
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]