RE: How many logical log is needed

Posted in 2000

JasonYLPang@pg.SLR.com — Sun, 16 Jul 2000 18:06:39 +0800 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFEF0D.88C174BA Content-Type: text/plain; charset="iso-8859-1" I have increased the log space from 2G to 3G. However, I'm still getting the long transaction rollback. why? -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Saturday, July 15, 2000 8:30 PM To: Pang, JasonYL; informix-list@iiug.org Subject: Re: How many logical log is needed From: JasonYLPang@pg.SLR.com > >The size of database is around 40G. Currently, I have 100 logical log with >each log 20MB (Total is 2G). Is my logical log size sufficient to support >my >database? Recently, I'm facing a lot of long transaction. Is it because of >insufficient logical log?? I couldn't tell based on the size of your database and the size of your logs whether you have sufficient space. However, the fact that you're getting lots of long transaction rollbacks hints that you don't have enough log space. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com ------_=_NextPart_001_01BFEF0D.88C174BA Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: How many logical log is needed</TITLE> </HEAD> <BODY> I have increased the log space from 2G to 3G. = However, I'm still getting the long transaction rollback. why? -----Original Message----- From: Obnoxio The Clown [<A = HREF=3D"mailto:obnoxio@hotmail.com">mailto:obnoxio@hotmail.com</A>]</FON= T> Sent: Saturday, July 15, 2000 8:30 PM To: Pang, JasonYL; informix-list@iiug.org Subject: Re: How many logical log is needed From: JasonYLPang@pg.SLR.com > >The size of database is around 40G. Currently, I = have 100 logical log with >each log 20MB (Total is 2G). Is my logical log = size sufficient to support >my >database? Recently, I'm facing a lot of long = transaction. Is it because of >insufficient logical log?? I couldn't tell based on the size of your database = and the size of your logs whether you have sufficient space. However, the fact = that you're getting lots of long transaction rollbacks hints that you = don't have enough log space. _______________________________________________________________= _________ Get Your Private, Free E-mail from MSN Hotmail at <A = HREF=3D"http://www.hotmail.com"; = TARGET=3D"_blank">http://www.hotmail.com</A>; </BODY> </HTML> ------_=_NextPart_001_01BFEF0D.88C174BA--

RE: How many logical log is needed

Related threads

Your privacy choices