Write cache low
Hi everybody there Following is onmonitor performance statistics and onconfig file listing. Can somebody help me improve write cache please ? STATUS: Profile Userthreads Spaces Databases Logs Archive ... Display system profile information. -----------------------------On-Line------- Press CTRL-W for Help. -------- Boot Time Fri Jun 11 09:38:06 1999 Current Time Tue Jun 29 08:41:48 1999 Disk Reads Buff. Reads %Cached Disk Writes Buff. Writes %Cached 278948 1742303 83.99 1631 4654 64.95 Over Lock Over Userthread User Time Sys. Time Checkpoints 0 0 328 26 9 ixda-RA idx-RA da-RA RA-pgsused Latch Waits 4106 16 267754 271831 16 Buff. Waits Lock Waits Lock Req. Deadlocks DLTimeouts Check Waits 7550 0 5472106 0 0 0 CALLS: Open Start Read Write 9075 19201 171118 52 Total Calls Rewrite Delete Commit Rollback 235726 144 22 162 0
Add more buffers. If you want more try posting your complete ONCONFIG file. Art S. Kagel "Shevkar, Mukund" wrote: > > Hi everybody there > Following is onmonitor performance statistics and onconfig file listing. > Can somebody help me improve write cache please ? > STATUS: Profile Userthreads Spaces Databases Logs Archive ... > Display system profile information. > > -----------------------------On-Line------- Press CTRL-W for Help. -------- > Boot Time Fri Jun 11 09:38:06 1999 > Current Time Tue Jun 29 08:41:48 1999 > > Disk Reads Buff. Reads %Cached Disk Writes Buff. Writes %Cached > 278948 1742303 83.99 1631 4654 64.95 > > Over Lock Over Userthread User Time Sys. Time Checkpoints > 0 0 328 26 9 > > ixda-RA idx-RA da-RA RA-pgsused Latch Waits > 4106 16 267754 271831 16 > > Buff. Waits Lock Waits Lock Req. Deadlocks DLTimeouts Check Waits > 7550 0 5472106 0 0 0 > > CALLS: Open Start Read Write > 9075 19201 171118 52 > Total Calls > Rewrite Delete Commit Rollback 235726 > 144 22 162 0
Shevkar, Mukund wrote: > Following is onmonitor performance statistics and onconfig file > listing. The onconfig file was missing, but not critical. > Can somebody help me improve write cache please ? > STATUS: Profile Userthreads Spaces Databases Logs Archive ... > Display system profile information. > > -----------------------------On-Line------- Press CTRL-W for Help > Boot Time Fri Jun 11 09:38:06 1999 > Current Time Tue Jun 29 08:41:48 1999 > > Disk Reads Buff. Reads %Cached Disk Writes Buff. Writes %Cached > 278948 1742303 83.99 1631 4654 64.95 You've done about 4000 reads for every write; the write cache ratio doesn't matter at all. Your read cache ratio is too low for comfort; as Art said, you need to increase the number of buffers you're using -- or not worry about performance too much. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>