IDS Forum

Re: How to avoid blocking checkpoints?

Posted By: GUSTAVO ECHENIQUE
Date: Wednesday, 17 May 2017, at 5:59 p.m.

In Response To: How to avoid blocking checkpoints? (GUSTAVO ECHENIQUE)

Dear Friends:

Many thanks to all who helped me, such as Art Kagel, Jacques Renaut, Andreas Legner, etc.

My configuration was as follows:

#############################################################
# Shared Memory Parameters

LOCKS 200000 # Maximum number of locks
BUFFERS 300000 # Maximum number of shared buffers
NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 128 # Physical log buffer size (Kbytes)
LOGBUFF 128 # Logical log buffer size (Kbytes)
LOGSMAX 20 # Maximum number of logical log files
CLEANERS 128 # Number of buffer cleaner processes
SHMBASE 0xc000000 # Shared memory base address
SHMVIRTSIZE 131072 # initial virtual shared memory segment size
SHMADD 16384 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL 300 # Check point interval (in sec)
LRUS 128 # Number of LRU queues
LRU_MAX_DIRTY 2 # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY 1 # LRU percent dirty end cleaning limit
LTXHWM 50 # Long transaction high water mark percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)

##################################################################

I added an additional AIO, as Art and Jacques told me, I also changed the amount of cleaners to 128 as Art suggested, and changed the configuration of the RAID 5 array to RAID 10.

Blocking checkpoints continue to appear, less durable than before, but the maximum was almost 4 minutes.

I clarify that I tested this configuration with a dbimport of a base. Could this have been the problem?

Anyway, I can not understand that the IDS does not "know" that it has 15K rpm, and 6Gbps disks, however old the version of it.

I say this because on a server that has 10K rpm disks, and only two RAID 5 disk arrays (one for the operating system and the other for the database, temporary files, logical logs, physical log), it takes practically the same thing To perform the dbimport.

But that's what least worries me. What really worries me is that certain processes take exactly the same thing as on a Windows 2000 server, with 2Gbps disks.

I am disconcerted.

Messages In This Thread

• How to avoid blocking checkpoints?
  GUSTAVO ECHENIQUE -- Monday, 15 May 2017, at 1:01 p.m.
  • Re: How to avoid blocking checkpoints?
    JACQUES RENAUT -- Monday, 15 May 2017, at 1:47 p.m.
    • Re: How to avoid blocking checkpoints?
      Andreas Legner -- Monday, 15 May 2017, at 5:28 p.m.
  • Re: How to avoid blocking checkpoints?
    Art Kagel -- Monday, 15 May 2017, at 2:42 p.m.
    • Re: How to avoid blocking checkpoints?
      GUSTAVO ECHENIQUE -- Monday, 15 May 2017, at 5:30 p.m.
      • Re: How to avoid blocking checkpoints?
        david@smooth1.co.uk -- Monday, 15 May 2017, at 5:47 p.m.
      • Re: How to avoid blocking checkpoints?
        Art Kagel -- Monday, 15 May 2017, at 5:54 p.m.
  • Re: How to avoid blocking checkpoints?
    GUSTAVO ECHENIQUE -- Wednesday, 17 May 2017, at 5:59 p.m.
    • Re: How to avoid blocking checkpoints?
      ERIC VERCELLETTO -- Saturday, 20 May 2017, at 3:50 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.