Re: Performance Issues
Ok, then letś check the physical log, to me it looks a little small.
An onstat -l would tell us if there is any problem with it before
touching PHYSFILE
I also think the LRUS/cleaners are too few. Have you checked onstat
-F? fg writes should be zero, and it is good to not put too many
buffers per lru queue.
-- Juan de Villeros
On Thu, 9 Dec 2004 07:47:09 -0400, Roger Cariah <rogerc@ppsl.co.tt> wrote:
> Checkpoint takes between 1-3 seconds.
>
>
>
> -----Original Message-----
> From: Obnoxio The Chav [mailto:obnoxio@serendipita.com]
> Sent: Wednesday, 08 December 2004 07:01 PM
> To: Roger Cariah
> Cc: Juan Manuel de Villeros; Roger Cariah; informix-list@iiug.org
> Subject: RE: Performance Issues
>
> Roger Cariah said:
> > The checkpoint intervals are 15 minutes. I don't think that is the reason
> > for the extent of performance degradation being experienced.
>
> I'm hoping you mean that your checkpoints are 15 minutes apart, and not
> that they take 15 minutes? "How long do they take" is what checkpoint
> duration means, not "how far are they apart".
>
> --
>
> Bye now,
> Obnoxio
>
> "C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
> - Coluche
>
> "I'm trying to see things your way, but I can't get my head up my ass"
> - JCH
>
> "Ogni uomo mi guarda come se fossi una testa di cazzo"
> - Marco
>
> I went to the airport to check in and they asked what I did because I
> looked like a terrorist. I said I was a comedian. They said, "Say
> something funny then." I told them I had just graduated from flying
> school.
>
> -- Ahmed Ahmed
>
> The information in this communication and any attachments are deemed by PPSL
> to be confidential and may be legally privileged and protected from
> disclosure. It is intended solely for the addressee. If you are not the
> intended recipient, any use, review, dissemination, distribution or copying
> of this information is strictly prohibited. Please notify the sender and
> delete this message and any attachments immediately from your system.
> PPSL will not be held liable for any incomplete transmission of this message
> nor any delay in its receipt.
>
>
sending to informix-list