{"id":1080,"date":"2015-09-18T12:52:45","date_gmt":"2015-09-18T12:52:45","guid":{"rendered":"http:\/\/10sa.com\/sql_stories\/?p=1080"},"modified":"2015-09-18T12:52:45","modified_gmt":"2015-09-18T12:52:45","slug":"how-to-read-fio-results","status":"publish","type":"post","link":"http:\/\/10sa.com\/sql_stories\/?p=1080","title":{"rendered":"How to read FIO results"},"content":{"rendered":"<p>Terminology:<br \/>\nfio = <a href=\"https:\/\/github.com\/axboe\/fio\/\">https:\/\/github.com\/axboe\/fio\/<\/a><br \/>\nus = microsecond = (1 \/ 1 000 000) second<br \/>\nstdev = <a href=\"https:\/\/en.wikipedia.org\/wiki\/Standard_deviation\">standard deviation<\/a><\/p>\n<p>Quick explanation:<br \/>\n1. Latency:<br \/>\n<img loading=\"lazy\" width=\"599\" height=\"370\" class=\"alignnone size-medium wp-image-1081\" src=\"http:\/\/10sa.com\/sql_stories\/wp-content\/uploads\/2015\/09\/StandardDeviation.png\" srcset=\"http:\/\/10sa.com\/sql_stories\/wp-content\/uploads\/2015\/09\/StandardDeviation.png 599w, http:\/\/10sa.com\/sql_stories\/wp-content\/uploads\/2015\/09\/StandardDeviation-300x185.png 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/p>\n<p><img width=\"600px\" src=\"http:\/\/10sa.com\/sql_stories\/wp-content\/uploads\/2015\/09\/Fio-explanation1.jpg\" alt=\"Fio-explanation\"  \/><\/p>\n<p>2. IOps<br \/>\n<img src=\"http:\/\/10sa.com\/sql_stories\/wp-content\/uploads\/2015\/09\/FIO-IO-Average.jpg\" alt=\"FIO-IO-Average\"><\/p>\n<p>Detailed information are available in FIO&#8217;s How-To (\u00a7 6.0 Interpreting the output)<\/p>\n<p>Example of my configuration (random writes):<\/p>\n<pre lang='bash'>\r\n[global]\r\nbs=4k\r\nioengine=libaio\r\niodepth=4\r\n# was 1g\r\nsize=1g\r\ndirect=1\r\nruntime=60\r\n# directory=\/bcache\r\ndirectory=\/emcpower\r\nfilename=ssd.test.file\r\n\r\n\r\n[rnd-read]\r\nthread=1 # works on threads instead of forking jobs\r\ngroup_reporting=1 # (group to which it belongs to)\r\nnrfiles=20\r\nname=Random read\r\nrw=randread\r\n# stonewall\r\nnumjobs=20\r\n\r\n<\/pre>\n<p>and results:<\/p>\n<pre>\r\nRandom read: (g=0): rw=randread, bs=4K-4K\/4K-4K\/4K-4K, ioengine=libaio, iodepth=4\r\n...\r\nfio-2.2.10\r\nStarting 20 threads\r\n\r\nRandom read: (groupid=0, jobs=20): err= 0: pid=20356: Fri Sep 18 14:50:30 2015\r\n  read : io=20480MB, bw=1719.2MB\/s, iops=440319, runt= 11907msec\r\n    slat (usec): min=3, max=1424, avg= 8.62, stdev= 4.36\r\n    clat (usec): min=30, max=4547, avg=171.08, stdev=74.76\r\n     lat (usec): min=74, max=4556, avg=179.86, stdev=74.85\r\n    clat percentiles (usec):\r\n     |  1.00th=[   85],  5.00th=[   93], 10.00th=[   99], 20.00th=[  109],\r\n     | 30.00th=[  121], 40.00th=[  137], 50.00th=[  153], 60.00th=[  171],\r\n     | 70.00th=[  193], 80.00th=[  221], 90.00th=[  270], 95.00th=[  314],\r\n     | 99.00th=[  422], 99.50th=[  466], 99.90th=[  572], 99.95th=[  612],\r\n     | 99.99th=[  740]\r\n    bw (KB  \/s): min=85432, max=89608, per=5.01%, avg=88263.86, stdev=448.71\r\n    lat (usec) : 50=0.01%, 100=10.26%, 250=76.45%, 500=12.99%, 750=0.28%\r\n    lat (usec) : 1000=0.01%\r\n    lat (msec) : 2=0.01%, 4=0.01%, 10=0.01%\r\n  cpu          : usr=5.98%, sys=25.04%, ctx=3909260, majf=0, minf=1604\r\n  IO depths    : 1=0.1%, 2=0.1%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, >=64=0.0%\r\n     submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%\r\n     complete  : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%\r\n     issued    : total=r=5242880\/w=0\/d=0, short=r=0\/w=0\/d=0, drop=r=0\/w=0\/d=0\r\n     latency   : target=0, window=0, percentile=100.00%, depth=4\r\n\r\nRun status group 0 (all jobs):\r\n   READ: io=20480MB, aggrb=1719.2MB\/s, minb=1719.2MB\/s, maxb=1719.2MB\/s, mint=11907msec, maxt=11907msec\r\n\r\nDisk stats (read\/write):\r\n    dm-7: ios=5146410\/0, merge=0\/0, ticks=872432\/0, in_queue=906207, util=100.00%, aggrios=5242880\/0, aggrmerge=0\/0, aggrticks=884520\/0, aggrin_queue=0, aggrutil=0.00%\r\n    bcache0: ios=5242880\/0, merge=0\/0, ticks=884520\/0, in_queue=0, util=0.00%, aggrios=2641920\/6, aggrmerge=0\/5, aggrticks=0\/0, aggrin_queue=0, aggrutil=0.01%\r\n    md0: ios=5283840\/0, merge=0\/0, ticks=0\/0, in_queue=0, util=0.00%, aggrios=2641920\/0, aggrmerge=0\/0, aggrticks=433228\/0, aggrin_queue=439215, aggrutil=100.00%\r\n  nvme0n1: ios=2650725\/0, merge=0\/0, ticks=436106\/0, in_queue=442247, util=99.96%\r\n  nvme1n1: ios=2633115\/0, merge=0\/0, ticks=430351\/0, in_queue=436183, util=100.00%\r\n  emcpowera: ios=0\/13, merge=0\/10, ticks=0\/1, in_queue=1, util=0.01%\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Terminology: fio = https:\/\/github.com\/axboe\/fio\/ us = microsecond = (1 \/ 1 000 000) second stdev = standard deviation Quick explanation: 1. Latency: 2. IOps Detailed information are available in FIO&#8217;s How-To (\u00a7 6.0 Interpreting the output) Example of my configuration (random writes): [global] bs=4k ioengine=libaio iodepth=4 # was 1g size=1g direct=1 runtime=60 # directory=\/bcache directory=\/emcpower [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[19,18],"tags":[],"_links":{"self":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/1080"}],"collection":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1080"}],"version-history":[{"count":13,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/1080\/revisions"}],"predecessor-version":[{"id":1101,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/1080\/revisions\/1101"}],"wp:attachment":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1080"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}