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

Kunwar,

The Oracle documentation page
<https://docs.oracle.com/en-us/iaas/Content/Block/References/samplefiocommandslinux.htm> about FIO is pretty awesome and you might already be working from it?

I wrote the attached shell script based on that page, and I use it to test and compare I/O latency and I/O throughput (and IOPS) from the Linux guest OS across all different kinds of configurations.  As usual, the ".txt" file-extension is intended just to get past email servers filters, so please rename it?

Hope this helps,

-Tim

On 1/1/2023 7:59 AM, kunwar singh wrote:
> Thanks Mark. I ruled out SLOB earlier as I want to size for Mysql and
> Postgres workloads as well. Still I will go over the SLOB
> documentation again , it has been a few years since using SLOB.
> Yes I am aware of the OCI documentation , but couldn't get to making
> it work for sizing our needs.
>
> On Sun, Jan 1, 2023 at 9:52 AM Mark W. Farnham <mwf_at_rsiz.com> wrote:
>
> I suppose you could create your own test from the system up, but
> most likely you can learn what you need to know from SLOB, and I’d
> bet a dozen donuts that https://kevinclosson.net/slob/ will
> provide you with better information than anything you cobble
> together with system tools. (Individual systems tools might help
> you find what is misconfigured if SLOB shows poor results compared
> to what you think the resources you have deployed.)
>
> Good luck.
>
> This:
> https://docs.oracle.com/en-us/iaas/Content/Block/References/samplefiocommandslinux.htm
>
> probably has commands you can pattern match to your case if you
> really want to do it yourself. Even if you proceed because you
> want to learn a bit, I would check your answer with SLOB.
>
> mwf
>
> *From:*oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *kunwar singh
> *Sent:* Sunday, January 01, 2023 9:17 AM
> *To:* ORACLE-L
> *Subject:* fio tool to size BW, throughput and latency Oracle,
> Postgres , Mysql workloads
>
> 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
>
>
>
> --
> Cheers,
> Kunwar

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




text/plain attachment: fio.sh.txt