Documentation
Rate This Document
Findability
Accuracy
Completeness
Readability
SubmitClose

SQL 1 (I/O-intensive)

Purpose

SQL 1 is an I/O-intensive scenario. You can optimize I/O parameters for the optimal performance.

Procedure

  • Set the following I/O parameters. sd$i indicates the names of all drives that are tested.
    1
2
    echo 128 > /sys/block/sd$i/queue/nr_requests
echo 512 > /sys/block/sd$i/queue/read_ahead_kb
  • Set the parameters of dirty pages in the memory.
    1
2
    /proc/sys/vm/vm.dirty_expire_centisecs  500
/proc/sys/vm/vm.dirty_writeback_centisecs   100
  • For the remaining parameters in this scenario, use the values defined in General Tuning.