RE: a question about auto log backup

[王 旭]

But there are some question.
   If my instance have three log segments.In nature only one be used,isn't 
it?If a instance have more log segments,the database will do backup 
continually.At the same time ensuring security,I think it must bring some 
spaces waste and capability waste.

  I have two suppose about the auto log backup,please help analyze it 
correctness.

  One,It be achieved as pool mode.
      
      There are one pool which keep three log segments.Only one log 
segment be used.When  
   it full.The DBMS random write log into another log segment. At the same 
time DBMS 
   backup the segment that be full and then clear it.At last,the log 
segment put in pool 
   again.

  Two,It be achieved as queue mode.
      
      There are one queue which keep three log segments.The first log 
segment be used.When 
  it full.The DBMS random write log into the second log segment. At the 
same time DBMS 
  backup the first segment and then clear it.At last,the log segment put 
in queue at the 
  last again.

thanks!

From: "Hahn, Uwe" <[EMAIL PROTECTED]>
To: "? ?" <[EMAIL PROTECTED]>, <maxdb@lists.mysql.com>
Subject: RE: a question about auto log backup
Date: Fri, 13 May 2005 08:45:41 +0200
Not with the builtin auto log backup.
Kind regards
Uwe

>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Friday, May 13, 2005 7:21 AM
>To: maxdb@lists.mysql.com
>Subject: a question about auto log backup
>
>    My database area include three log segments.Now,i set the
>Log backup in
>auto mode.I find the backup operations be made when the first
>log segment
>is full.But I wish backup be made after second log segment is
>full.Can i
>get this effect?
>
>thanks!
>
>_________________________________________________________________
>与联机的朋友进行交流，请使用 MSN Messenger:  http://messenger.msn.com/cn
>
>
>--
>MaxDB Discussion Mailing List
>For list archives: http://lists.mysql.com/maxdb
>To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]

_________________________________________________________________
享用世界上最大的电子邮件系统― MSN Hotmail。  http://www.hotmail.com  

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]