MIME-Version: 1.0
From: kunwar singh <krishsingh.111@gmail.com>
Date: Sun, 1 Jan 2023 09:16:50 -0500
Message-ID: <CAJSrDUosWBE7_C7URksSRu6Ou9q3J6Nq+=pkJnRgzcWCX=jXFQ@mail.gmail.com>
Subject: fio tool to size BW, throughput and latency Oracle, Postgres , Mysql workloads
To: ORACLE-L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="000000000000f9e06505f1347cb3"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: krishsingh.111@gmail.com
--000000000000f9e06505f1347cb3
Content-Type: text/plain; charset="UTF-8"

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

--000000000000f9e06505f1347cb3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Happy new year Listers!<div><br></div><div>I am trying to =
run <a href=3D"https://fio.readthedocs.io/en/latest/fio_doc.html">fio</a>=
=C2=A0and I cannot get the right combination of commands for below systems =
I am sizing=C2=A0for.</div><div><br></div><div>1. OLTP</div><div>iops ,bw, =
latency are important to=C2=A0size correctly to avoid latency. but rate=3D =
parameter doesn&#39;t seem to work.=C2=A0</div><div><br></div><div>2. DSS</=
div><div>Should I just focus on iops and bw here</div><div><br></div><div>3=
. Mixed</div><div>How do I play with fio to get the right set of commands u=
sing rwmixread/write?</div><div><br></div><div>Few questions:</div><div>- D=
o I have to ensure all the disks are created in the target before I run the=
 tests?</div><div>- Can you please share your examples of fio commands for =
1,2,3 above=C2=A0</div><div>- How to set the numjobs correctly?</div><div><=
div><br></div>-- <br><div dir=3D"ltr" class=3D"gmail_signature" data-smartm=
ail=3D"gmail_signature">Cheers,<br>Kunwar</div></div></div>

--000000000000f9e06505f1347cb3--
--
http://www.freelists.org/webpage/oracle-l