Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from smtp-aa.freelists.org (smtp-aa.freelists.org [23.23.80.81]) by malta2546.startdedicated.com (Postfix) with ESMTPS id 9929E10031E8B7 for ; Sun, 1 Jan 2023 17:01:18 +0100 (CET) Received: from turing.freelists.org (turing.freelists.org [10.0.0.164]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits)) (No client certificate requested) by smtp-aa.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id B90463F98D; Sun, 1 Jan 2023 16:01:17 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 97AEC3F603; Sun, 1 Jan 2023 16:01:17 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1672588877; bh=jxbP7slX6IWaf/WDbjb/Sh02sWqpsLffSwXYlCHZeHI=; h=From:Sender:Sender:From; b=BYdoJtFKql8tPhdyhVBwVcxs3L83kbXLv9kFmKJmCYjyQ4b3L5LMpExQE9VV0OlGn leiJuB3Z4Vp9ZdY13vYd19t3DbbCnQABnH159HO0GhqLOsTqa/OhKYjFfuxm8qhHuh hSWpzDQkBkQPYvOSSPYZU23ez8MKNKPM+KLytm8o= X-Virus-Scanned: by FreeLists at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id FLWtNH6bhEVp; Sun, 1 Jan 2023 16:01:17 +0000 (UTC) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id EFB103FA22; Sun, 1 Jan 2023 16:00:31 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1672588876; bh=jxbP7slX6IWaf/WDbjb/Sh02sWqpsLffSwXYlCHZeHI=; h=From:Sender:Sender:From; b=PFDj717Zntpi6Ds6KaerHklIQaZfgFj7xyxFlyTkWAk1rHahOtpfuhDhHL4rbg+bc hvB/RHWknfdV0xD/Xetfz9XpjX17+NxKL6KSjKBvI5eo+q1BiDqj9PWiQVp3hsmMBm zpKqBPJSXZOZMFbD7Pko95Yt4Q7gBl2ptkKkGBQ8= Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 01 Jan 2023 15:59:47 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id D94263F7EF for ; Sun, 1 Jan 2023 15:59:46 +0000 (UTC) Authentication-Results: turing.freelists.org; dkim=pass (2048-bit key; unprotected) header.d=gmail.com header.i=@gmail.com header.a=rsa-sha256 header.s=20210112 header.b=QoSFG670; dkim-atps=neutral Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id XlhiZmKVxHL2 for ; Sun, 1 Jan 2023 15:59:46 +0000 (UTC) Received: from mail-vs1-f44.google.com (mail-vs1-f44.google.com [209.85.217.44]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by turing.freelists.org (Postfix) with ESMTPS id B94523F603 for ; Sun, 1 Jan 2023 15:59:46 +0000 (UTC) Received: by mail-vs1-f44.google.com with SMTP id p30so20733590vsr.1 for ; Sun, 01 Jan 2023 07:59:46 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=8PMSp51gceFY7LTIDfI31J4DgcRU4/l5sliuPwVwlI0=; b=sEMI9sE7EA3usEz+zXFWni196u1XI3ma9E7OEEGovkRZH5u0F4UjErTvirXiAojZYe Q3ezkWJ3Ds5LVkdUQ/PUyQK3j9qDx1jvv9QV8YwFsfDhgP14eUO+vV4/KJhxPnBMXW/U n3T9c6wIt2+xsHfXx7hEV5dfMcEpawFQ4o9CkRkQsupd/5dQhfUmkPFiXN8+07nV47SI PIfzJlujG/13Inuj6yGnGyLesYozb4+YQK2Av0acMwIpjaS0OW8kRvvvZx5gV1tabJ0o yswvadlZL/W2iRNmos3WQIh+yCY2EqT2bhd8Ck/ZYATpzq5BjgrIn1F3R3dYUfY9CVIH RtAw== X-Gm-Message-State: AFqh2kp/YYy2ZG3dpbL9VVesBK5Kc3/T+AATljFvI2KUV/my9tVLZTVw 1c32i49ghCF7/CXfUud6i+iZPxGeWKu2I13C4Uc= X-Google-Smtp-Source: AMrXdXu8B7fhGumXQ6FNAGhVBbuFJQhF5K7Pgg+AJckhH1cu9PaC0ZiiLpaapo54EcWJUuF7OZT4hZP1KkFo/jb0m78= X-Received: by 2002:a05:6102:944:b0:3b0:7bc1:db3f with SMTP id a4-20020a056102094400b003b07bc1db3fmr3838735vsi.28.1672588786193; Sun, 01 Jan 2023 07:59:46 -0800 (PST) MIME-Version: 1.0 References: <468c01d91df0$968140f0$c383c2d0$@rsiz.com> In-Reply-To: <468c01d91df0$968140f0$c383c2d0$@rsiz.com> From: kunwar singh Date: Sun, 1 Jan 2023 10:59:35 -0500 Message-ID: Subject: Re: fio tool to size BW, throughput and latency Oracle, Postgres , Mysql workloads To: "Mark W. Farnham" Cc: ORACLE-L Content-Type: multipart/alternative; boundary="00000000000074d9c305f135ec13" X-archive-position: 83309 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: krishsingh.111@gmail.com Precedence: normal Reply-To: krishsingh.111@gmail.com List-Help: List-Unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-Subscribe: List-Owner: List-post: List-Archive: X-list: oracle-l --00000000000074d9c305f135ec13 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 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=E2=80=99d 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 SL= OB > 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/samplefiocomm= andslinux.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@freelists.org [mailto: > oracle-l-bounce@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 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=3D 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 ru= n > the tests? > > - Can you please share your examples of fio commands for 1,2,3 above > > - How to set the numjobs correctly? > > > > -- > > Cheers, > Kunwar > --=20 Cheers, Kunwar --00000000000074d9c305f135ec13 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks Mark. I ruled out SLOB earlier as I want to size fo= r Mysql and Postgres workloads as well. Still I will go over the SLOB docum= entation again , it has been a few years since using SLOB.=C2=A0
Yes I = am aware of the OCI documentation , but couldn't get to making it work = for sizing our needs.=C2=A0

On Sun, Jan 1, 2023 at 9:52 AM Mark W. Far= nham <mwf@rsiz.com> wrote:

I suppose you could cr= eate your own test from the system up, but most likely you can learn what y= ou need to know from SLOB, and I=E2=80=99d bet a dozen donuts that https://kevinclosson.= net/slob/ will provide you with better information than anything you co= bble together with system tools. (Individual systems tools might help you f= ind what is misconfigured if SLOB shows poor results compared to what you t= hink the resources you have deployed.)

=C2=A0

Good luck.

=C2=A0

This: https://docs.oracle.com/en-us/iaas/Content/Block/References/samplef= iocommandslinux.htm

=C2=A0

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.

<= p class=3D"MsoNormal">=C2=A0

mwf

=C2=A0

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce= @freelists.org] On Behalf Of kunwar singh
Sent: Sunday= , January 01, 2023 9:17 AM
To: ORACLE-L
Subject: fio to= ol to size BW, throughput and latency Oracle, Postgres , Mysql workloads=

=C2=A0

<= p class=3D"MsoNormal">Happy new year Listers!

=C2=A0

I= am trying to run fio=C2=A0and I cannot get the right combination = of commands for below systems I am sizing=C2=A0for.

=

=C2=A0

1. OLTP

iops = ,bw, latency are important to=C2=A0size correctly to avoid latency. but rat= e=3D parameter doesn't seem to work.=C2=A0

=

=C2=A0

2. DSS

Should I ju= st focus on iops and bw here

=C2=A0

3. Mixed<= /u>

How do I play with fio to g= et the right set of commands using rwmixread/write?

=

=C2=A0

Few questions:

- Do I have to ensure all the disks are created in the target before I ru= n the tests?

- Can you p= lease share your examples of fio commands for 1,2,3 above=C2=A0

- How to set the numjobs correctly?=

=C2=A0

--

Cheers,
Kunwar

<= /div>


--
Cheers,
Kunwar
--00000000000074d9c305f135ec13-- -- http://www.freelists.org/webpage/oracle-l