This is a discussion on Priority aging within the Informix forums, part of the Database Server Software category; --> Question for the group. Does IDS 9.4 priority age long running sessions inside the database engine? I know you ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Question for the group. Does IDS 9.4 priority age long running sessions inside the database engine? I know you can set the NOAGE parameter to keep the OS from aging the oninit processes when they are scheduled on the physical CPUs. But does IDS age any of the user sessions when scheduling them onto the CPUvps? I ask this because I have a daemon process that gets really slow after several days. The OS ages the process about 20% (nice 20 to 24). But when I stop and restart the process it gets more than 20% faster again. More like 200%. There is pleanty of idle CPU when it gets slow and no I/O waits. Love to hear peoples thoughts. Corey AIX 5.3-TL4 IDS 9.4 FC6 |
| |||
| I don't think the engine does anything like that. The poor performance has to be caused by something else. Could the OS aging of your daemon process be causing the problem even if there appears to be pleny of CPU cycles available? Andrew cgates wrote: > Question for the group. Does IDS 9.4 priority age long running > sessions inside the database engine? I know you can set the NOAGE > parameter to keep the OS from aging the oninit processes when they are > scheduled on the physical CPUs. But does IDS age any of the user > sessions when scheduling them onto the CPUvps? > > I ask this because I have a daemon process that gets really slow after > several days. The OS ages the process about 20% (nice 20 to 24). But > when I stop and restart the process it gets more than 20% faster again. > More like 200%. > > There is pleanty of idle CPU when it gets slow and no I/O waits. > > Love to hear peoples thoughts. > > Corey > > AIX 5.3-TL4 > IDS 9.4 FC6 |
| ||||
| You of course set the NOAGE parameter, don't you? (I couldn't quite tell from your post.) cgates wrote: > Question for the group. Does IDS 9.4 priority age long running > sessions inside the database engine? I know you can set the NOAGE > parameter to keep the OS from aging the oninit processes when they are > scheduled on the physical CPUs. But does IDS age any of the user > sessions when scheduling them onto the CPUvps? > > I ask this because I have a daemon process that gets really slow after > several days. The OS ages the process about 20% (nice 20 to 24). But > when I stop and restart the process it gets more than 20% faster again. > More like 200%. > > There is pleanty of idle CPU when it gets slow and no I/O waits. > > Love to hear peoples thoughts. > > Corey > > AIX 5.3-TL4 > IDS 9.4 FC6 |