Informix

  • 1.  LRUs Writes / Chunk Writes

    Posted 17 days ago

    Hello

    Reading Onstat -F, there are LRUs writes more than Chunk writes 

    should LRUs Writes be 0 or at least less than chunk writes ?

    Thanks :)


    ------------------------------
    John Smith
    ------------------------------


  • 2.  RE: LRUs Writes / Chunk Writes

    Posted 17 days ago
    John:

    That's an open debate.
    • Chunk writes are more efficient overall for the storage system
    • LRU writes minimize the overhead of checkpoints and reduce the number of chunk writes which can overwhelm the system

    Mostly I know that when I tune a system to be about 70-75% LRU writes it runs faster. Especially for OLTP workloads, but bulk loads type workload also to some extent.

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------