fio tool to size BW, throughput and latency Oracle, Postgres , Mysql workloads

From: kunwar singh <krishsingh.111_at_gmail.com>
Date: Sun, 1 Jan 2023 09:16:50 -0500
Message-ID: <CAJSrDUosWBE7_C7URksSRu6Ou9q3J6Nq+=pkJnRgzcWCX=jXFQ_at_mail.gmail.com>



Happy new year Listers!

I am trying to run fio <https://fio.readthedocs.io/en/latest/fio_doc.html> and I cannot get the right combination of commands for below systems I am sizing for.

  1. OLTP iops ,bw, latency are important to size correctly to avoid latency. but rate= parameter doesn't seem to work.
  2. DSS Should I just focus on iops and bw here
  3. Mixed How do I play with fio to get the right set of commands using rwmixread/write?

Few questions:
- Do I have to ensure all the disks are created in the target before I run
the tests?
- Can you please share your examples of fio commands for 1,2,3 above

  • How to set the numjobs correctly?
-- 
Cheers,
Kunwar

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jan 01 2023 - 15:16:50 CET

Original text of this message