It doesn't make a difference if you have one or more logsegement.They
are seen as one big segment. The way you describe it (the queue mode at
least) is like the way oracle works (maybe other databases too), but
maxdb seems not to work that way.
See
http://archives.neohapsis.com/archives/dev/sapdb/2004-q3/0153.html
Where I asked more or less the same question (at the bottom of the mail)
Regards,
Filip
On Fri, 2005-05-13 at 10:38, ç æ wrote:
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]>, <[email protected]>
>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: [email protected]
> >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]
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* System Engineer, Verzekeringen NV *
* www.verzekeringen.be *
* Oostkaai 23 B-2170 Merksem *
* 03/6416673 - 0477/340942 *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* System Engineer, Verzekeringen NV *
* www.verzekeringen.be *
* Oostkaai 23 B-2170 Merksem *
* 03/6416673 - 0477/340942 *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
