Pixiv ID: 122027816 Author ID: 23986039
基于上一篇文章的物理机测试
sysbench 1.0.20 (using system LuaJIT 2.1.1720049189)
MariaDB 11.7.2-MariaDB Arch Linux
测试用命令
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
| sysbench --mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=root \
--mysql-password=7ac997d1-6ecf-4e20-b82b-5dc91a128b5b \
/usr/share/sysbench/oltp_common.lua \
--tables=10 \
--table_size=100000 \
prepare
sysbench --threads=4 \
--time=20 \
--report-interval=5 \
--mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=root \
--mysql-password=7ac997d1-6ecf-4e20-b82b-5dc91a128b5b \
/usr/share/sysbench/oltp_read_write.lua \
--tables=10 \
--table_size=100000 \
run
sysbench --mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=root \
--mysql-password=7ac997d1-6ecf-4e20-b82b-5dc91a128b5b \
/usr/share/sysbench/oltp_common.lua \
--tables=10 \
cleanup
|
Ext4 双盘 RAID0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 292558
write: 83521
other: 41771
total: 417850
transactions: 20874 (1043.13 per sec.)
queries: 417850 (20881.04 per sec.)
ignored errors: 23 (1.15 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0083s
total number of events: 20874
Latency (ms):
min: 2.39
avg: 3.83
max: 46.17
95th percentile: 5.88
sum: 79986.98
Threads fairness:
events (avg/stddev): 5218.5000/8.20
execution time (avg/stddev): 19.9967/0.00
|
Ext4 单盘
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 271124
write: 77415
other: 38715
total: 387254
transactions: 19349 (967.24 per sec.)
queries: 387254 (19358.44 per sec.)
ignored errors: 17 (0.85 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0032s
total number of events: 19349
Latency (ms):
min: 2.37
avg: 4.13
max: 46.95
95th percentile: 6.55
sum: 79977.86
Threads fairness:
events (avg/stddev): 4837.2500/18.18
execution time (avg/stddev): 19.9945/0.00
|
Btrfs RAID0
Btrfs 无压缩 默认挂载
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 116074
write: 33147
other: 16576
total: 165797
transactions: 8285 (413.96 per sec.)
queries: 165797 (8284.06 per sec.)
ignored errors: 6 (0.30 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0113s
total number of events: 8285
Latency (ms):
min: 5.78
avg: 9.66
max: 162.32
95th percentile: 14.46
sum: 80001.14
Threads fairness:
events (avg/stddev): 2071.2500/6.80
execution time (avg/stddev): 20.0003/0.00
|
Btrfs 无压缩 关闭CoW挂载
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 116354
write: 33220
other: 16615
total: 166189
transactions: 8304 (415.07 per sec.)
queries: 166189 (8306.88 per sec.)
ignored errors: 7 (0.35 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0050s
total number of events: 8304
Latency (ms):
min: 4.97
avg: 9.63
max: 224.52
95th percentile: 14.73
sum: 79991.16
Threads fairness:
events (avg/stddev): 2076.0000/10.17
execution time (avg/stddev): 19.9978/0.00
|
Btrfs ZSTD压缩 默认挂载
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 115752
write: 33039
other: 16525
total: 165316
transactions: 8257 (412.62 per sec.)
queries: 165316 (8261.29 per sec.)
ignored errors: 11 (0.55 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0082s
total number of events: 8257
Latency (ms):
min: 5.50
avg: 9.69
max: 186.90
95th percentile: 14.73
sum: 79996.60
Threads fairness:
events (avg/stddev): 2064.2500/3.90
execution time (avg/stddev): 19.9991/0.00
|
Btrfs 无压缩 noatime,clear_cache,nospace_cache
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 125552
write: 35868
other: 17934
total: 179354
transactions: 8966 (447.95 per sec.)
queries: 179354 (8960.78 per sec.)
ignored errors: 2 (0.10 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0128s
total number of events: 8966
Latency (ms):
min: 5.86
avg: 8.92
max: 129.35
95th percentile: 13.70
sum: 80004.42
Threads fairness:
events (avg/stddev): 2241.5000/12.84
execution time (avg/stddev): 20.0011/0.00
|
Btrfs mdadm RAID0
Btrfs 无压缩 默认挂载
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 122780
write: 35065
other: 17535
total: 175380
transactions: 8765 (437.94 per sec.)
queries: 175380 (8762.82 per sec.)
ignored errors: 5 (0.25 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0114s
total number of events: 8765
Latency (ms):
min: 5.78
avg: 9.13
max: 169.64
95th percentile: 13.95
sum: 80005.41
Threads fairness:
events (avg/stddev): 2191.2500/8.17
execution time (avg/stddev): 20.0014/0.00
|
Btrfs 无压缩 关闭CoW挂载
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 115220
write: 32891
other: 16450
total: 164561
transactions: 8220 (410.77 per sec.)
queries: 164561 (8223.35 per sec.)
ignored errors: 10 (0.50 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0096s
total number of events: 8220
Latency (ms):
min: 6.05
avg: 9.73
max: 114.33
95th percentile: 14.46
sum: 80000.09
Threads fairness:
events (avg/stddev): 2055.0000/9.46
execution time (avg/stddev): 20.0000/0.00
|
Btrfs ZSTD压缩 默认挂载
1
2
3
4
5
6
7
8
| SQL statistics:
queries performed:
read: 117530
write: 33556
other: 16782
total: 167868
transactions: ### Btrfs 无压缩 noatime,clear_cache,nospace_cache
|
(419.03 per sec.)1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| queries: 167868 (8386.97 per sec.)
ignored errors: 8 (0.40 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0126s
total number of events: 8387
Latency (ms):
min: 5.81
avg: 9.54
max: 175.69
95th percentile: 14.73
sum: 80008.38
Threads fairness:
events (avg/stddev): 2096.7500/14.87
execution time (avg/stddev): 20.0021/0.00
|
ZFS mdadm RAID0 ashift=9
ZFS 无压缩 默认挂载
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 207130
write: 59129
other: 29573
total: 295832
transactions: 14778 (738.71 per sec.)
queries: 295832 (14787.73 per sec.)
ignored errors: 17 (0.85 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0041s
total number of events: 14778
Latency (ms):
min: 2.30
avg: 5.41
max: 148.17
95th percentile: 8.74
sum: 79974.28
Threads fairness:
events (avg/stddev): 3694.5000/16.95
execution time (avg/stddev): 19.9936/0.00
|
ZFS 无压缩 默认挂载 recordsize=4K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 233044
write: 66524
other: 33272
total: 332840
transactions: 16626 (830.94 per sec.)
queries: 332840 (16634.89 per sec.)
ignored errors: 20 (1.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0066s
total number of events: 16626
Latency (ms):
min: 2.44
avg: 4.81
max: 143.68
95th percentile: 7.30
sum: 79981.24
Threads fairness:
events (avg/stddev): 4156.5000/7.37
execution time (avg/stddev): 19.9953/0.00
|
ZFS 无压缩 默认挂载 recordsize=16K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 261674
write: 74704
other: 37361
total: 373739
transactions: 18670 (933.18 per sec.)
queries: 373739 (18680.54 per sec.)
ignored errors: 21 (1.05 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0053s
total number of events: 18670
Latency (ms):
min: 2.27
avg: 4.28
max: 103.63
95th percentile: 6.32
sum: 79978.53
Threads fairness:
events (avg/stddev): 4667.5000/19.09
execution time (avg/stddev): 19.9946/0.00
|
ZFS 无压缩 默认挂载 recordsize=32K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 263704
write: 75254
other: 37642
total: 376600
transactions: 18806 (940.00 per sec.)
queries: 376600 (18823.95 per sec.)
ignored errors: 30 (1.50 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0049s
total number of events: 18806
Latency (ms):
min: 2.35
avg: 4.25
max: 116.69
95th percentile: 6.32
sum: 79980.08
Threads fairness:
events (avg/stddev): 4701.5000/31.24
execution time (avg/stddev): 19.9950/0.00
|
ZFS 默认压缩 默认挂载
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 188118
write: 53673
other: 26848
total: 268639
transactions: 13411 (670.37 per sec.)
queries: 268639 (13428.26 per sec.)
ignored errors: 26 (1.30 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0043s
total number of events: 13411
Latency (ms):
min: 2.31
avg: 5.96
max: 159.75
95th percentile: 9.06
sum: 79975.66
Threads fairness:
events (avg/stddev): 3352.7500/8.44
execution time (avg/stddev): 19.9939/0.00
|
ZFS RAID0 ashift=9
ZFS 无压缩 默认挂载
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 183610
write: 52417
other: 26218
total: 262245
transactions: 13103 (654.82 per sec.)
queries: 262245 (13105.60 per sec.)
ignored errors: 12 (0.60 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0075s
total number of events: 13103
Latency (ms):
min: 2.41
avg: 6.10
max: 125.97
95th percentile: 9.73
sum: 79981.35
Threads fairness:
events (avg/stddev): 3275.7500/16.30
execution time (avg/stddev): 19.9953/0.00
|
ZFS 无压缩 默认挂载 recordsize=4K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 231322
write: 66054
other: 33032
total: 330408
transactions: 16509 (825.22 per sec.)
queries: 330408 (16515.88 per sec.)
ignored errors: 14 (0.70 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0041s
total number of events: 16509
Latency (ms):
min: 2.35
avg: 4.84
max: 173.88
95th percentile: 7.17
sum: 79978.61
Threads fairness:
events (avg/stddev): 4127.2500/2.05
execution time (avg/stddev): 19.9947/0.00
|
ZFS 无压缩 默认挂载 recordsize=16K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 218288
write: 62299
other: 31159
total: 311746
transactions: 15567 (778.03 per sec.)
queries: 311746 (15580.89 per sec.)
ignored errors: 25 (1.25 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0071s
total number of events: 15567
Latency (ms):
min: 2.41
avg: 5.14
max: 102.61
95th percentile: 7.56
sum: 79986.51
Threads fairness:
events (avg/stddev): 3891.7500/21.05
execution time (avg/stddev): 19.9966/0.00
|
ZFS 无压缩 默认挂载 recordsize=32K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 201474
write: 57519
other: 28768
total: 287761
transactions: 14377 (718.65 per sec.)
queries: 287761 (14384.11 per sec.)
ignored errors: 14 (0.70 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0043s
total number of events: 14377
Latency (ms):
min: 2.43
avg: 5.56
max: 118.12
95th percentile: 8.13
sum: 79977.07
Threads fairness:
events (avg/stddev): 3594.2500/5.63
execution time (avg/stddev): 19.9943/0.00
|
ZFS 默认压缩 默认挂载
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 227192
write: 64849
other: 32436
total: 324477
transactions: 16208 (807.53 per sec.)
queries: 324477 (16166.44 per sec.)
ignored errors: 20 (1.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0691s
total number of events: 16208
Latency (ms):
min: 2.36
avg: 4.95
max: 190.31
95th percentile: 7.70
sum: 80174.10
Threads fairness:
events (avg/stddev): 4052.0000/22.05
execution time (avg/stddev): 20.0435/0.03
|
ZFS RAID0 ashift=12
ZFS 无压缩 默认挂载
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 204400
write: 58342
other: 29178
total: 291920
transactions: 14578 (728.67 per sec.)
queries: 291920 (14591.42 per sec.)
ignored errors: 22 (1.10 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0051s
total number of events: 14578
Latency (ms):
min: 2.37
avg: 5.49
max: 163.37
95th percentile: 8.58
sum: 79979.49
Threads fairness:
events (avg/stddev): 3644.5000/16.29
execution time (avg/stddev): 19.9949/0.00
|
ZFS 无压缩 默认挂载 recordsize=4K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 206094
write: 58822
other: 29422
total: 294338
transactions: 14701 (734.67 per sec.)
queries: 294338 (14709.36 per sec.)
ignored errors: 20 (1.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0076s
total number of events: 14701
Latency (ms):
min: 2.39
avg: 5.44
max: 143.66
95th percentile: 7.56
sum: 79980.70
Threads fairness:
events (avg/stddev): 3675.2500/7.89
execution time (avg/stddev): 19.9952/0.00
|
ZFS 无压缩 默认挂载 recordsize=16K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
| SQL statistics:
queries performed:
read: 246512
write: 70376
other: 35197
total: 352085
transactions: 17589 (879.07 per sec.)
queries: 352085 (17596.61 per sec.)
ignored errors: 19 (0.95 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0060s
total number of events: 17589
Latency (ms):
min: 2.36
avg: 4.55
max: 93.83
95th percentile: 6.79
sum: 79977.98
Threads fairness:
events (avg/stddev): 4397.2500/27.00
execution time (avg/stddev): 19.9945/0.00
|
ZFS 无压缩 默认挂载 recordsize=32K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
| SQL statistics:
queries performed:
read: 253358
write: 72321
other: 36172
total: 361851
transactions: 18075 (903.49 per sec.)
queries: 361851 (18087.29 per sec.)
ignored errors: 22 (1.10 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0046s
total number of events: 18075
Latency (ms):
min: 2.41
avg: 4.42
max: 80.70
95th percentile: 7.04
sum: 79979.69
Threads fairness:
events (avg/stddev): 4518.7500/22.84
execution time (avg/stddev): 19.9949/0.00
|
ZFS 默认压缩 默认挂载
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| SQL statistics:
queries performed:
read: 265958
write: 75905
other: 37965
total: 379828
transactions: 18968 (946.29 per sec.)
queries: 379828 (18949.23 per sec.)
ignored errors: 29 (1.45 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 20.0431s
total number of events: 18968
Latency (ms):
min: 2.37
avg: 4.22
max: 83.23
95th percentile: 6.43
sum: 80050.68
Threads fairness:
events (avg/stddev): 4742.0000/15.02
execution time (avg/stddev): 20.0127/0.01
|
