Oninit Logo
The Down System Specialists
+1-913-674-0360
+44-2081-337529
Partnerships Contact

Oninit BenchIt Toolkit: LRUs

Everyone knows that the LRUs are crucial to good performance, the following shows the performance difference at the extremes.

 
        Load    Trans   Run   TPS        Avg Trans
                        Time                Time

1       5       11576   300   38.587     0.025916
1       10      11581   301   38.475     0.025991
1       20      11587   301   38.495     0.025977
1       30      11609   309   37.570     0.026617

BUFFERPOOL    size=2K,buffers=1200000,lrus=128,lru_min_dirty=0.100000,lru_max_dirty=0.200000

1       5       581482  300 1938.273     0.000516
1       10      792848  300 2642.827     0.000378
1       20      917432  300 3058.107     0.000327
1       30      1235902 300 4119.673     0.000243

BUFFERPOOL    size=2K,buffers=1200000,lrus=128,lru_min_dirty=80.000000,lru_max_dirty=95.000000

Then it was noticed the OS was detecting disk warning so the dbspaces were moved to another disk.

 
1       5       790026  300 2633.420     0.000380
1       10      1341482 300 4471.606     0.000224
1       20      1644233 300 5480.777     0.000182
1       30      1621288 300 5404.293     0.000185

BUFFERPOOL    size=2K,buffers=1200000,lrus=128,lru_min_dirty=80.000000,lru_max_dirty=95.000000

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.