disk benchmark for database with fio

db_disk_test.sh

#!/bin/bash
set -x
set -e

sec_list="seq-read seq-write random-read random-write active-db"
rw_rate_list="75 80 85 90"
io_thread_list="1 4 8 16 24"

for class in $sec_list; do
  for ratio in $rw_rate_list; do
    for io_thread in $io_thread_list; do
      echo "ratio: ${ratio}, io_thread: ${io_thread}"
      export ratio
      export io_thread
      fio --output-format=json --output="result/rw_${ratio}_io_${io_thread}.json" --section=${class} test.fio
    done
  done
done

visualize
(https://github.com/khailey/fio_scripts)
(https://github.com/intel/fiovisualizer)