Log production option enabling
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 ... I would like to know also of it's possible to change at run time the directory where the log files are stored after their generation. I'm working with 3.23 release. Thanks a lot Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Log production option enabling
[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. I would like to know also of it's possible to change at run time the directory where the log files are stored after their generation. By default log files are stored in the MySQL data directory. I'm working with 3.23 release. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Log production option enabling
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]
Re: Log production option enabling
Tim Cutts [EMAIL PROTECTED] wrote: 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. You can enable/disable logging for session with SET SQL_LOG_OFF statement if user has SUPER privilege. It's supported from version 4.0: http://www.mysql.com/doc/en/SET_OPTION.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]