Skip to content

Instantly share code, notes, and snippets.

@higarin

higarin/_summary.md

Last active December 1, 2021 02:25
Show Gist options
  • Save higarin/eeb5b0ca7106ea77afae4938a92c9a1f to your computer and use it in GitHub Desktop.
Save higarin/eeb5b0ca7106ea77afae4938a92c9a1f to your computer and use it in GitHub Desktop.
Download ZIP
MySQL on Docker
Raw
_summary.md
Raw
docker_desktop_on_intel.txt
> sysbench --db-driver=mysql --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=mysql --mysql-db=test oltp_read_write run
sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 6818
write: 1948
other: 974
total: 9740
transactions: 487 (48.62 per sec.)
queries: 9740 (972.32 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 10.0157s
total number of events: 487
Latency (ms):
min: 16.52
avg: 20.56
max: 54.68
95th percentile: 25.74
sum: 10010.88
Threads fairness:
events (avg/stddev): 487.0000/0.00
execution time (avg/stddev): 10.0109/0.00
Raw
docker_desktop_on_m1.txt
> sysbench --db-driver=mysql --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=mysql --mysql-db=test oltp_read_write run
sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 784
write: 224
other: 112
total: 1120
transactions: 56 (5.58 per sec.)
queries: 1120 (111.57 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 10.0373s
total number of events: 56
Latency (ms):
min: 120.08
avg: 179.11
max: 452.68
95th percentile: 0.00
sum: 10030.38
Threads fairness:
events (avg/stddev): 56.0000/0.00
execution time (avg/stddev): 10.0304/0.0
Raw
docker_desktop_on_m1_vol.txt
> sysbench --db-driver=mysql --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=mysql --mysql-db=test oltp_read_write run
sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 910
write: 260
other: 130
total: 1300
transactions: 65 (6.49 per sec.)
queries: 1300 (129.77 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 10.0169s
total number of events: 65
Latency (ms):
min: 115.61
avg: 154.04
max: 442.22
95th percentile: 0.00
sum: 10012.52
Threads fairness:
events (avg/stddev): 65.0000/0.00
execution time (avg/stddev): 10.0125/0.00
Raw
lima_on_intel.txt
> sysbench --db-driver=mysql --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=mysql --mysql-db=test oltp_read_write run
sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 2394
write: 684
other: 342
total: 3420
transactions: 171 (17.04 per sec.)
queries: 3420 (340.76 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 10.0347s
total number of events: 171
Latency (ms):
min: 52.58
avg: 58.67
max: 82.98
95th percentile: 63.32
sum: 10031.92
Threads fairness:
events (avg/stddev): 171.0000/0.00
execution time (avg/stddev): 10.0319/0.00
Raw
lima_on_m1.txt
> sysbench --db-driver=mysql --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=mysql --mysql-db=test oltp_read_write run
sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 10430
write: 2980
other: 1490
total: 14900
transactions: 745 (74.40 per sec.)
queries: 14900 (1488.01 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 10.0130s
total number of events: 745
Latency (ms):
min: 11.89
avg: 13.44
max: 46.36
95th percentile: 0.00
sum: 10011.76
Threads fairness:
events (avg/stddev): 745.0000/0.00
execution time (avg/stddev): 10.0118/0.00
Raw
native_intel.txt
> sysbench --db-driver=mysql --mysql-host=127.0.0.1 --mysql-user=root --mysql-password= --mysql-db=test oltp_read_write run
sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 59640
write: 17040
other: 8520
total: 85200
transactions: 4260 (425.79 per sec.)
queries: 85200 (8515.82 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 10.0032s
total number of events: 4260
Latency (ms):
min: 1.85
avg: 2.35
max: 39.37
95th percentile: 3.07
sum: 9993.18
Threads fairness:
events (avg/stddev): 4260.0000/0.00
execution time (avg/stddev): 9.9932/0.00
Raw
native_m1.txt
> sysbench --db-driver=mysql --mysql-host=127.0.0.1 --mysql-user=root --mysql-password= --mysql-db=test oltp_read_write run
sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 126378
write: 36108
other: 18054
total: 180540
transactions: 9027 (902.54 per sec.)
queries: 180540 (18050.73 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 10.0015s
total number of events: 9027
Latency (ms):
min: 1.03
avg: 1.11
max: 35.68
95th percentile: 0.00
sum: 9998.25
Threads fairness:
events (avg/stddev): 9027.0000/0.00
execution time (avg/stddev): 9.9983/0.00
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment