RE: [Info-ingres] Transaction log size (was Huge copy out/in)
- From: Laframboise André <andre.laframboise@xxxxxxxxxxxxx>
- Date: Thu, 15 Jun 2006 08:31:30 -0400
Thanks Peter,
Would anyone know how high the log block count can go ?
Can it reach into the millions ?
If the block count has the same problem as the transaction
begin/ends fields, it can't go beyond 99 million (8 digits).
After 99 million, it then starts displaying 10 million instead
of 100 million (drops the last digit).
Andre
-----Original Message-----
From: Peter Gale
To: 'Laframboise André'; 'Betty & Karl Schendel ';
info-ingres-admin@xxxxxxxxxxxxxxx; info-ingres@xxxxxxxxxxxxxxx
Sent: 15/06/2006 1:18 AM
Subject: RE: [Info-ingres] Transaction log size (was Huge copy out/in)
Hi Andre,
The block size cannot be any bigger than 32k according to cbf.
--
Peter
T: +44 (0)1398 341777
PGale@xxxxxxxxxxxxxxx
-----Original Message-----
From: info-ingres-admin@xxxxxxxxxxxxxxx
[mailto:info-ingres-admin@xxxxxxxxxxxxxxx] On Behalf Of Laframboise
André
Sent: 15 June 2006 05:51
To: 'Betty & Karl Schendel '; 'info-ingres-admin@xxxxxxxxxxxxxxx ';
'info-ingres@xxxxxxxxxxxxxxx '
Subject: RE: [Info-ingres] Transaction log size (was Huge copy out/in)
Hi Karl,
I'd like to increase the transaction log to approx 40-50 GB.
My current log is 1.8GB with 16K block size and 80 log buffers.
What's considered a larger block size ? 32K or 64K ?
I assumed 16K was relatively large as most systems I've seen have 4K.
Andre
-----Original Message-----
From: info-ingres-admin@xxxxxxxxxxxxxxx
To: info-ingres@xxxxxxxxxxxxxxx
Sent: 13/06/2006 5:02 AM
Subject: Re: [Info-ingres] Huge copy out/in
-snip-
I've seen 96 Gb, but you have to increase the log blocksize or some
of the block counts overflow and horrible things happen. For larger
block sizes you might be able to beat 96 Gb, I haven't done the math.
If logstat -header doesn't show any negatives you should be OK.
*Warning* I assume you are NOT talking about a single transaction.
Except for the most recent Ingres 2006's, if a single transaction
uses or reserves more than 4 Gb you are in deep trouble because of
overflow on the logspace reservation counters.
Karl
_______________________________________________
Info-ingres mailing list
Info-ingres@xxxxxxxxxxxxxxx
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
_______________________________________________
Info-ingres mailing list
Info-ingres@xxxxxxxxxxxxxxx
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
.
- Prev by Date: RE: [Info-ingres] Transaction log size (was Huge copy out/in)
- Next by Date: Re: [Info-ingres] Transaction log size (was Huge copy out/in)
- Previous by thread: RE: [Info-ingres] Transaction log size (was Huge copy out/in)
- Next by thread: Re: [Info-ingres] Transaction log size (was Huge copy out/in)
- Index(es):
Relevant Pages
|
|
