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!
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.
- OLTP iops ,bw, latency are important to size correctly to avoid latency. but rate= parameter doesn't seem to work.
- DSS Should I just focus on iops and bw here
- 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-lReceived on Sun Jan 01 2023 - 15:16:50 CET
