Sysbench For Windows

  1. Sysbench For Windows
  2. Sysbench Windows Build
  3. Sysbench Windows 安装
  4. Testing Windows IO With SQLIO And SysBench – The Ji Village News
  5. Sysbench For Windows - Coachtree

As of sysbench 1.0 support for native Windows builds was dropped. It may be re-introduced in later releases. Currently, the recommended way to obtain sysbench on Windows is using Windows Subsystem for Linux available in Windows 10. 0 Sysbench is a tool to analyze the MySQL performance. I downloaded it and extracted but there is no executable file. Files having extensions like.sh or.c or.h are available.

To benchmark IO on Linux and MySQL transaction processing, SysBench is a popular choice that can do both. After poking around at the source code, it seems PostgreSQL and Oracle are also included for transaction processing testing if you have the proper header files, but I didn’t test those.

To benchmark IO on Windows and SQL Server transaction processing, Microsoft provides two tools, SQLIO and SQLIOSim. SQLIO is a misnomer in that it really doesn’t have much to do with SQL Server. It is a general purpose disk IO benchmark tool.

So today I was playing with SysBench and noticed that I can compile and build it on Windows as well. I decided I should run IO benchmark on a single machine with both tools (SQLIO and SysBench), and see if I could reconcile the results.

TXZ,

To make things simple, I thought I would just benchmark random read of 3G (orders of magnitude bigger than disk controller cache) files for 5 minutes (300 seconds) with a single thread using 16Kb block size, without adding any additional queue. I tested this on both my laptop and an Amazon EC2 instance. The commands for both tools are listed below, and they should perform the same thing, as far as I can tell. Let me know if you have any comments/pointers or if I missed anything.

SysBench commands:

Fro SQLIO, here is the line in param.txt and command used:

As this is a quick test, I ran the same test twice and took the average value for comparison purposes. The detailed output is pasted at the end of this post.

On my Windows XP Pro Service Pack 2 laptop with Intel X-25 SSD:

IO/SecondThroughput/Second
SQLIO3833.559.90Mb
SysBench3390.7752.98Mb

So on my laptop, SQLIO’s results are 13% higher than that of SysBench.

On Amazon EC2 ami-c3e40daa with EBS device running Windows Server 2008 Datacenter Edition Service Pack 2, whose results varied widely between my two runs:

IO/SecondThroughput/Second
SQLIO678.9110.61Mb
SysBench408.966.39Mb

On this machine, SQLIO results are 66% higher than that of SysBench.

Sysbench For Windows

Below is the gory details.

Here are the detailed output on my laptop:
SQLIO
C:Program FilesSQLIO>sqlio -kR -s300 -dc -b16 -frandom -Fparam.txt
sqlio v1.5.SG
parameter file used: param.txt
file c:testfile.dat with 1 thread (0) using mask 0x0 (0)
1 thread reading for 300 secs from file c:testfile.dat
using 16KB random IOs
using specified size: 3072 MB for file: c:testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3835.39
MBs/sec: 59.92

C:Program FilesSQLIO>sqlio -kR -s300 -dc -b16 -frandom -Fparam.txt
sqlio v1.5.SG
parameter file used: param.txt
file c:testfile.dat with 1 thread (0) using mask 0x0 (0)
1 thread reading for 300 secs from file c:testfile.dat
using 16KB random IOs
using specified size: 3072 MB for file: c:testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 3832.00
MBs/sec: 59.87

SysBench
C:MessAroundsysbench-0.4.12sysbench-0.4.12sysbenchRelWithDebInfo>sysbench.e
xe –test=fileio –file-total-size=3G –file-test-mode=rndrd –max-time=300 run
sysbench 0.4: multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 1

Extra file open flags: 0
128 files, 24Mb each
3Gb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random read test
Threads started!
WARNING: Operation time (18446744073709226000.000000) is greater than maximal co
unted value, counting as 10000000000000.000000
WARNING: Percentile statistics will be inaccurate
Done.

Operations performed: 10000 Read, 0 Write, 0 Other = 10000 Total
Read 156.25Mb Written 0b Total transferred 156.25Mb (52.143Mb/sec)
3337.16 Requests/sec executed

Test execution summary:
total time: 2.9966s
total number of events: 10000
total time taken by event execution: 2.9343
per-request statistics:
min: 0.01ms
avg: 0.29ms
max: 18446744073709.47ms
approx. 95 percentile: 0.48ms

Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 2.9343/0.00

C:MessAroundsysbench-0.4.12sysbench-0.4.12sysbenchRelWithDebInfo>sysbench.e
xe –test=fileio –file-total-size=3G –file-test-mode=rndrd –max-time=300 run
sysbench 0.4: multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 1

Extra file open flags: 0
128 files, 24Mb each
3Gb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random read test
Threads started!
WARNING: Operation time (18446744073694841000.000000) is greater than maximal co
unted value, counting as 10000000000000.000000
WARNING: Percentile statistics will be inaccurate
Done.

Operations performed: 10000 Read, 0 Write, 0 Other = 10000 Total
Read 156.25Mb Written 0b Total transferred 156.25Mb (53.818Mb/sec)
3444.38 Requests/sec executed

Test execution summary:
total time: 2.9033s
total number of events: 10000
total time taken by event execution: 2.8777
per-request statistics:
min: 0.01ms
avg: 0.29ms
max: 18446744073696.34ms
approx. 95 percentile: 15.39ms

Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 2.8777/0.00

Here are the detailed output from Amazon EC2 ami-c3e40daa with EBS device:
SQLIO
c:Program FilesSQLIO>sqlio -kR -t1 -s300 -dC -frandom -b16 -Fparam.txt -BH -LS

sqlio v1.5.SG
using system counter for latency timings, 3579545 counts per second
parameter file used: param.txt
file c:testfile.dat with 1 thread (0) using mask 0x0 (0)
1 thread reading for 300 secs from file c:testfile.dat
using 16KB random IOs
buffering set to use hardware disk cache (but not file cache)
size of file c:testfile.dat needs to be: 3221225472 bytes
current file size: 0 bytes
need to expand by: 3221225472 bytes
expanding c:testfile.dat … done.
using specified size: 3072 MB for file: c:testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 1230.94
MBs/sec: 19.23
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 0
Max_Latency(ms): 204
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 98 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

c:Program FilesSQLIO>sqlio -kR -t1 -s300 -dC -frandom -b16 -Fparam.txt -BH -LS

sqlio v1.5.SG
using system counter for latency timings, 3579545 counts per second
parameter file used: param.txt
file c:testfile.dat with 1 thread (0) using mask 0x0 (0)
1 thread reading for 300 secs from file c:testfile.dat
using 16KB random IOs
buffering set to use hardware disk cache (but not file cache)
using specified size: 3072 MB for file: c:testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 126.88
MBs/sec: 1.98
latency metrics:
Min_Latency(ms): 0
Avg_Latency(ms): 7
Max_Latency(ms): 497
histogram:
ms: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24+
%: 13 9 0 3 7 8 8 8 8 8 8 8 2 1 1 1 1 1 1 1 1 0 0 0 2

C:UsersAdministratorDocumentssysbench-0.4.12sysbenchRelWithDebInfo>sysbenc
h.exe –test=fileio –file-total-size=3G –file-test-mode=rndrd –max-time=300 r
un
sysbench 0.4: multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 1

Extra file open flags: 0
128 files, 24Mb each
3Gb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random read test
Threads started!
Done.

Sysbench Windows Build

Operations performed: 10000 Read, 0 Write, 0 Other = 10000 Total
Read 156.25Mb Written 0b Total transferred 156.25Mb (10.64Mb/sec)
680.95 Requests/sec executed

Test execution summary:
total time: 14.6854s
total number of events: 10000
total time taken by event execution: 14.6048
per-request statistics:
min: 0.01ms
avg: 1.46ms
max: 150.29ms
approx. 95 percentile: 4.77ms

Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 14.6048/0.00

C:UsersAdministratorDocumentssysbench-0.4.12sysbenchRelWithDebInfo>sysbenc
h.exe –test=fileio –file-total-size=3G –file-test-mode=rndrd –max-time=300 r
un
sysbench 0.4: multi-threaded system evaluation benchmark

Sysbench Windows 安装

Running the test with following options:
Number of threads: 1

Extra file open flags: 0
128 files, 24Mb each
3Gb total file size
Block size 16Kb
Number of random requests for random IO: 10000
Read/Write ratio for combined random IO test: 1.50
Periodic FSYNC enabled, calling fsync() each 100 requests.
Calling fsync() at the end of test, Enabled.
Using synchronous I/O mode
Doing random read test
Threads started!
Done.

Operations performed: 10000 Read, 0 Write, 0 Other = 10000 Total
Read 156.25Mb Written 0b Total transferred 156.25Mb (2.1371Mb/sec)
136.77 Requests/sec executed

Testing Windows IO With SQLIO And SysBench – The Ji Village News

Test execution summary:
total time: 73.1139s
total number of events: 10000
total time taken by event execution: 73.0284
per-request statistics:
min: 0.02ms
avg: 7.30ms
max: 728.84ms
approx. 95 percentile: 23.08ms

Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 73.0284/0.00

90 package(s) known

Sysbench For Windows - Coachtree

RepositoryPackage nameVersionCategoryMaintainer(s)
AIX Open Source Packagessysbench0.4.12--
Alpine Linux Edge
community
sysbench1.0.20-dennis@krupenik.com
Alpine Linux Edge
community
sysbench-doc1.0.20-dennis@krupenik.com
Alpine Linux Edge
community
sysbench-dev1.0.20-dennis@krupenik.com
ALT Linux p9sysbench1.0.17Otherantohami@altlinux.org
ALT Sisyphussysbench1.0.20Otherantohami@altlinux.org
Arch
community
sysbench1.0.20--
AURsysbench-git1.1.0.r1193.b04e5fd-jamespharvey20@aur
Debian Oldstable
oldstable/main
sysbench0.4.12mischfrenzel@scunc.net
Debian Stable Backports
main
sysbench1.0.18misclinux@jcf.pm, natureshadow@debian.org
Debian Testing
testing/main
sysbench1.0.20misclinux@jcf.pm
Debian Unstable
main
sysbench1.0.20misclinux@jcf.pm
Devuan 1.0 (Jessie)
jessie/main
sysbench0.4.12mischfrenzel@scunc.net
Devuan 2.0 (ASCII)
ascii/main
sysbench0.4.12mischfrenzel@scunc.net
Devuan 4.0 (Chimaera)
chimaera/main
sysbench1.0.20misclinux@jcf.pm
Devuan Unstable
unstable/main
sysbench1.0.20misclinux@jcf.pm
DPortsbenchmarks/sysbench1.0.20benchmarkssunpoet@freebsd.org
EPEL 6sysbench1.0.17Unspecified-
EPEL 7sysbench1.0.17Unspecified-
EPEL 8sysbench1.0.20Unspecified-
Exherbo
alip
app-benchmarks/sysbench1.0.20app-benchmarksfallback-mnt-exherbo@repology
Fedora 26
updates
sysbench1.0.9Unspecified-
Fedora 26
release
sysbench1.0.6Applications/System-
Fedora 27
release
sysbench1.0.9Unspecified-
Fedora 28
updates
sysbench1.0.17Unspecified-
Fedora 28
release
sysbench1.0.12Unspecified-
Fedora 29
updates
sysbench1.0.17Unspecified-
Fedora 29
release
sysbench1.0.15Unspecified-
Fedora 30
release
sysbench1.0.17Unspecified-
Fedora 31
release
sysbench1.0.17Unspecified-
Fedora 32
release
sysbench1.0.17Unspecified-
Fedora 33
release
sysbench1.0.20Unspecified-
Fedora 34
release
sysbench1.0.20Unspecified-
Fedora Rawhidesysbench1.0.20Unspecified-
FreeBSD Portsbenchmarks/sysbench1.0.20benchmarkssunpoet@freebsd.org
Funtoo 1.4
core-hw-kit
app-benchmarks/sysbench9999app-benchmarkshydrapolic@gmail.com, proxy-maint@gentoo.org
Funtoo 1.4
core-hw-kit
app-benchmarks/sysbench1.0.16app-benchmarkshydrapolic@gmail.com, proxy-maint@gentoo.org
Funtoo 1.4
core-hw-kit
app-benchmarks/sysbench1.0.15app-benchmarkshydrapolic@gmail.com, proxy-maint@gentoo.org
Funtoo 1.4
core-hw-kit
app-benchmarks/sysbench1.0.10app-benchmarkshydrapolic@gmail.com, proxy-maint@gentoo.org
Gentooapp-benchmarks/sysbench1.0.20app-benchmarksconikost@gentoo.org
GoboLinuxSysBench0.4.7--
Homebrewsysbench1.0.20--
Kali Linux Rolling
main
sysbench1.0.20misclinux@jcf.pm
LiGurOS stableapp-benchmarks/sysbench1.0.20app-benchmarksconikost@gentoo.org
LiGurOS developapp-benchmarks/sysbench1.0.20app-benchmarksconikost@gentoo.org
Linuxbrewsysbench1.0.20--
Manjaro Stable
community
sysbench1.0.20--
Manjaro Testing
community
sysbench1.0.20--
Manjaro Unstable
community
sysbench1.0.20--
MidnightBSD mportsbenchmarks/sysbench1.0.20benchmarks-
nixpkgs stablesysbench1.0.20-fallback-mnt-nix@repology
nixpkgs unstablesysbench1.0.20-fallback-mnt-nix@repology
OpenBSD Portsbenchmarks/sysbench0.4.8benchmarksports@openbsd.org
OpenBSD Portsbenchmarks/sysbench0.4.8benchmarksports@openbsd.org
OpenBSD Portsbenchmarks/sysbench0.4.8benchmarksports@openbsd.org
OpenIndiana packages
hipster
sysbench0.4.12Development/System-
OpenMandriva Cooker
main/release
sysbench1.0.19System/Kernel and hardwarebero@lindev.ch
openSUSE Leap 42.3
main/oss
sysbench0.5.0System/Benchmark-
openSUSE Leap 15.0
main/oss
sysbench1.0.11System/Benchmark-
openSUSE Leap 15.1
main/oss
sysbench1.0.11System/Benchmark-
openSUSE Leap 15.2
main/oss
sysbench1.0.19System/Benchmark-
openSUSE Leap 15.3
main/oss
sysbench1.0.19System/Benchmark-
openSUSE Tumbleweed
src-oss
sysbench1.0.20System/Benchmark-
Parabola
community
sysbench1.0.20--
Pardus 17
main
sysbench0.4.12mischfrenzel@scunc.net
Parrot
main
sysbench1.0.20misclinux@jcf.pm
pkgsrc currentbenchmarks/sysbench0.4.12benchmarkspkgsrc-users@netbsd.org
PLD Linuxsysbench0.4.12--
PureOS landingsysbench1.0.20misclinux@jcf.pm
Raspbian Oldstable
main
sysbench0.4.12mischfrenzel@scunc.net
Raspbian Stable
main
sysbench0.4.12mischfrenzel@scunc.net
Raspbian Testing
main
sysbench1.0.20misclinux@jcf.pm
Rosa 2016.1
contrib/updates
sysbench1.0.17--
Rosa 2019.1
contrib/release
sysbench1.0.17System/Kernel and hardwarealexander@mezon.ru
SlackBuildssystem/sysbench1.0.19systemdevteamtuc@gmail.com
SliTaz Cookingsysbench20150930miscpascal.bellard@slitaz.org
SliTaz Nextsysbench20150930miscpascal.bellard@slitaz.org
Trisquel 6.0
toutatis/main
sysbench0.4.12universe/mischfrenzel@scunc.net
Trisquel 7.0
belenos/main
sysbench0.4.12universe/mischfrenzel@scunc.net
Trisquel 8.0
flidas/main
sysbench0.4.12universe/miscubuntu-devel-discuss@lists.ubuntu.com
Trisquel 9.0
etiona/main
sysbench1.0.11universe/misclinux@jcf.pm
Ubuntu 14.04
trusty/universe
sysbench0.4.12universe/mischfrenzel@scunc.net
Ubuntu 16.04
xenial/universe
sysbench0.4.12universe/miscubuntu-devel-discuss@lists.ubuntu.com
Ubuntu 18.04
bionic/universe
sysbench1.0.11universe/misclinux@jcf.pm
Ubuntu 20.04
focal/universe
sysbench1.0.18universe/misclinux@jcf.pm
Ubuntu 20.10
groovy/universe
sysbench1.0.20universe/misclinux@jcf.pm
Ubuntu 21.04
hirsute/universe
sysbench1.0.20universe/misclinux@jcf.pm
Void Linux x86_64
x86_64
sysbench1.0.20-duncaen@voidlinux.org
Wikidatasysbench1.0.20--
YACPsysbench0.5Benchmark-