| Author |
Message
|
| PankajS |
 Posted: Thu Feb 24, 2005 10:42 pm Post subject: Do no. of LogPrimary files have any Performance effect ? |
 |
|
Voyager
Joined: 27 Dec 2004
Posts: 82
|
I am using default the Primary and Secondary log file setting on the AIX operating system (3 Primary,2 Secondary).I have Circular Logging.
My message length is at the max 4000 characters(That i am writing into the persistent queue).
Now if i increase the primary log files to say 63.
1) Will it give any performance enhancement to me ?
2) Will it make the writing into the log files faster so that my over all
Transaction time can be reduced.
3) If i increase the number of log file pages(from 256 to say 1000), will
the writing into the files be faster?
Please Give me direction....... |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Feb 25, 2005 5:48 am Post subject: Re: Do no. of LogPrimary files have any Performance effect ? |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| PankajS wrote: |
| Please Give me direction....... |
Here is a direction.
Do not post the same question twice.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| PankajS |
| Posted: Fri Feb 25, 2005 11:09 pm Post subject: |
|
|
Voyager
Joined: 27 Dec 2004
Posts: 82
|
Nice Quote jefflowrey !!! 
I think I should have been more specific .but you will find that the essence of questions is different. The one posted here is more specific to performance impact with some definite scenario.
Here I am interested to know, if there is any relation between size of log and time required to write into the logs and get message from that.
Please clear the doubt
Thanks in advance..  |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat Feb 26, 2005 6:54 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
It really depends....
Are your messages persistent ? (I know you said your queue has the setting)
What is your channel npmspeed ?
I guess the big answer would be the performance impact is negligible unless you are wrapping the logs in less than a minute. There is some overhead about creating a new file.
We work with 2 primaries and 50 secondaries. It allows to minimize the actual space used by the active log. Inactive logs are offloaded once a day to a different file system.
Remember that the primaries are a fixed space requisition. Secondaries use space as needed.
Enjoy  |
|
| Back to top |
|
|
| PankajS |
| Posted: Sun Feb 27, 2005 8:07 pm Post subject: |
|
|
Voyager
Joined: 27 Dec 2004
Posts: 82
|
| Quote: |
you are wrapping the logs in less than a minute. There is some overhead about creating a new file.
|
hay can you just elaborate it ....
I do not understand and the wordings ...
1)To what do we call wrapping of logs ?
2)why will it create a new file(which is that file ,is it secondary log file ?) if the wrapping is not fast (say one min in your example)
Cheers..  |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Feb 28, 2005 11:31 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Depending on activity you can move on to the next log file in 5 to 12 hours or use up 2 files in less then 30 seconds...
|
|
| Back to top |
|
|
|
|
