Re: about flush logs

2004-04-16 Thread Lou Olsten
When I do a FLUSH LOGS my bin log does increment and a new one is created.
My query log does not behave this way, however.  Just the bin log.  It
creates files with the .00x extension where x is an incremental number.

Lou
- Original Message - 
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 8:09 AM
Subject: Re: about flush logs


 Tang, Grace H [EMAIL PROTECTED] wrote:
  In my box, mysql server version is 4.0.18.
 
  I tried  flush logs. Nothing happened in the mysql data directory.
All the log files
  were not replaced.
 
  Does flush logs rename the old log files and create new log files?

 FLUSH LOGS closes and reopens all logs. In doesn't rename anything. For
update log if you didn't specify extention, FLUSH LOGS creates new log file.



 -- 
 For technical support contracts, goto https://order.mysql.com/?ref=ensita
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Egor Egorov
  / /|_/ / // /\ \/ /_/ / /__   [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]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: about flush logs

2004-04-14 Thread Egor Egorov
Tang, Grace H [EMAIL PROTECTED] wrote:
 In my box, mysql server version is 4.0.18.
 
 I tried  flush logs. Nothing happened in the mysql data directory. All the log 
 files
 were not replaced.
  
 Does flush logs rename the old log files and create new log files?

FLUSH LOGS closes and reopens all logs. In doesn't rename anything. For update log if 
you didn't specify extention, FLUSH LOGS creates new log file.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [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]



about flush logs

2004-04-13 Thread Tang, Grace H
In my box, mysql server version is 4.0.18.
 
I tried  flush logs. Nothing happened in the mysql data directory. All the log 
files were not replaced.
 
Does flush logs rename the old log files and create new log files?
Thanks.
 
Grace Tang
Software engineer
Computer Associates (China) Co., Ltd.
Beijing RD Department
Units 7-10, 19/F, Tower E3, Oriental Plaza
1 East Chang An Ave. Dong Cheng District
Beijing 100738, China
Tel:   (86 10)  8518 5358  Ext. 273
Fax:   (86 10)  8518 8453
Mail: [EMAIL PROTECTED], [EMAIL PROTECTED]