This is an automated email from the ASF dual-hosted git repository. zhaoyanan pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/incubator-shardingsphere-benchmark.git
The following commit(s) were added to refs/heads/master by this push: new 59531ca for performance 59531ca is described below commit 59531ca8f4278b00a7c68ef37feece783948a749 Author: nancyzrh <zhaoy...@126.com> AuthorDate: Fri Oct 4 06:38:48 2019 +0800 for performance --- report/data/3.0_single_delete_merge.log_plot | 1 + report/data/3.0_single_insert_merge.log_plot | 1 + report/data/3.0_single_select_merge.log_plot | 1 + report/data/3.0_single_update_merge.log_plot | 1 + report/data/3.0_sp_delete_raw_merge.log_plot | 1 + report/data/3.0_sp_insert_raw_merge.log_plot | 1 + report/data/3.0_sp_select_raw_merge.log_plot | 1 + report/data/3.0_sp_update_raw_merge.log_plot | 1 + report/data/4.0_single_delete_merge.log_plot | 1 + report/data/4.0_single_insert_merge.log_plot | 1 + report/data/4.0_single_select_merge.log_plot | 1 + report/data/4.0_single_update_merge.log_plot | 1 + report/data/4.0_sp_delete_raw_merge.log_plot | 1 + report/data/4.0_sp_insert_raw_merge.log_plot | 1 + report/data/4.0_sp_select_raw_merge.log_plot | 1 + report/data/4.0_sp_update_raw_merge.log_plot | 1 + report/data/direct_delete_merge.log_plot | 1 + report/data/direct_insert_merge.log_plot | 1 + report/data/direct_select_merge.log_plot | 1 + report/data/direct_update_merge.log_plot | 1 + report/data/encrypt/4.0_sp_delete_enc.log_plot | 1 + report/data/encrypt/4.0_sp_insert_enc.log_plot | 1 + .../encrypt/4.0_sp_insert_enc_sharding.log_plot | 1 + report/data/encrypt/4.0_sp_select_enc.log_plot | 1 + report/data/encrypt/4.0_sp_update_enc.log_plot | 1 + report/data/master_slave/3.0_sp_delete_ms.log_plot | 1 + .../master_slave/3.0_sp_delete_ms_sharding.log_plot | 1 + report/data/master_slave/3.0_sp_insert_ms.log_plot | 1 + .../master_slave/3.0_sp_insert_ms_sharding.log_plot | 1 + report/data/master_slave/3.0_sp_select_ms.log_plot | 1 + .../master_slave/3.0_sp_select_ms_sharding.log_plot | 1 + report/data/master_slave/3.0_sp_update_ms.log_plot | 1 + .../master_slave/3.0_sp_update_ms_sharding.log_plot | 1 + .../master_slave/4.0_sp_delete_ms_sharding.log_plot | 1 + .../master_slave/4.0_sp_insert_ms_sharding.log_plot | 1 + .../master_slave/4.0_sp_select_ms_sharding.log_plot | 1 + .../master_slave/4.0_sp_update_ms_sharding.log_plot | 1 + report/data_json/mysql_vs_shardingproxy.json | 2 +- report/data_json/sharding_proxy_master_slave.json | 2 +- .../sharding_proxy_master_slave_sharding.json | 2 +- ...sharding_proxy_single_database_single_table.json | 2 +- report/scenario_1/delete_single.png | Bin 36584 -> 37283 bytes report/scenario_1/insert_single.png | Bin 34228 -> 34765 bytes report/scenario_1/select_single.png | Bin 35726 -> 36996 bytes report/scenario_1/update_single.png | Bin 27557 -> 27658 bytes report/sp_raw/delete_single_raw.png | Bin 43302 -> 44349 bytes report/sp_raw/insert_single_raw.png | Bin 39964 -> 40411 bytes report/sp_raw/select_single_raw.png | Bin 36463 -> 36536 bytes report/sp_raw/update_single_raw.png | Bin 34274 -> 34815 bytes 49 files changed, 41 insertions(+), 4 deletions(-) diff --git a/report/data/3.0_single_delete_merge.log_plot b/report/data/3.0_single_delete_merge.log_plot index bf8a915..da9fd05 100644 --- a/report/data/3.0_single_delete_merge.log_plot +++ b/report/data/3.0_single_delete_merge.log_plot @@ -14,3 +14,4 @@ summary = 2000000 in 00:00:34 = 59415.9/s Avg: 3 Min: 0 Max: 77 Err: summary = 2000000 in 00:00:34 = 58977.9/s Avg: 3 Min: 0 Max: 59 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 59292.6/s Avg: 3 Min: 0 Max: 56 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 59396.5/s Avg: 3 Min: 0 Max: 72 Err: 0 (0.00%) +summary = 2000000 in 00:00:34 = 58517.2/s Avg: 3 Min: 0 Max: 84 Err: 0 (0.00%) diff --git a/report/data/3.0_single_insert_merge.log_plot b/report/data/3.0_single_insert_merge.log_plot index e8a66e7..655e14f 100644 --- a/report/data/3.0_single_insert_merge.log_plot +++ b/report/data/3.0_single_insert_merge.log_plot @@ -14,3 +14,4 @@ summary = 2000000 in 00:00:27 = 74830.7/s Avg: 2 Min: 0 Max: 569 Err: summary = 2000000 in 00:00:26 = 75774.8/s Avg: 2 Min: 0 Max: 517 Err: 0 (0.00%) summary = 2000000 in 00:00:27 = 74310.8/s Avg: 2 Min: 0 Max: 499 Err: 0 (0.00%) summary = 2000000 in 00:00:26 = 75640.1/s Avg: 2 Min: 0 Max: 501 Err: 0 (0.00%) +summary = 2000000 in 00:00:28 = 72716.7/s Avg: 2 Min: 0 Max: 500 Err: 0 (0.00%) diff --git a/report/data/3.0_single_select_merge.log_plot b/report/data/3.0_single_select_merge.log_plot index 4e3ef0d..dbb505e 100644 --- a/report/data/3.0_single_select_merge.log_plot +++ b/report/data/3.0_single_select_merge.log_plot @@ -14,3 +14,4 @@ summary = 2000000 in 00:00:20 = 99532.2/s Avg: 1 Min: 0 Max: 216 Err: summary = 2000000 in 00:00:19 = 102843.6/s Avg: 1 Min: 0 Max: 179 Err: 0 (0.00%) summary = 2000000 in 00:00:20 = 101419.9/s Avg: 1 Min: 0 Max: 160 Err: 0 (0.00%) summary = 2000000 in 00:00:19 = 103659.2/s Avg: 1 Min: 0 Max: 172 Err: 0 (0.00%) +summary = 2000000 in 00:00:20 = 99850.2/s Avg: 1 Min: 0 Max: 227 Err: 0 (0.00%) diff --git a/report/data/3.0_single_update_merge.log_plot b/report/data/3.0_single_update_merge.log_plot index ec64a66..c5ddd41 100644 --- a/report/data/3.0_single_update_merge.log_plot +++ b/report/data/3.0_single_update_merge.log_plot @@ -14,3 +14,4 @@ summary = 2000000 in 00:08:08 = 4099.2/s Avg: 48 Min: 0 Max: 80 Err: summary = 2000000 in 00:08:08 = 4096.0/s Avg: 48 Min: 0 Max: 82 Err: 0 (0.00%) summary = 2000000 in 00:08:08 = 4098.2/s Avg: 48 Min: 0 Max: 80 Err: 0 (0.00%) summary = 2000000 in 00:08:09 = 4090.1/s Avg: 48 Min: 0 Max: 102 Err: 0 (0.00%) +summary = 2000000 in 00:08:09 = 4093.4/s Avg: 48 Min: 0 Max: 95 Err: 0 (0.00%) diff --git a/report/data/3.0_sp_delete_raw_merge.log_plot b/report/data/3.0_sp_delete_raw_merge.log_plot index 9cb668a..bd5b8d3 100644 --- a/report/data/3.0_sp_delete_raw_merge.log_plot +++ b/report/data/3.0_sp_delete_raw_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:00:34 = 59580.6/s Avg: 3 Min: 0 Max: 73 Err: summary = 2000000 in 00:00:34 = 59532.7/s Avg: 3 Min: 0 Max: 61 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 59506.1/s Avg: 3 Min: 0 Max: 124 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 59433.6/s Avg: 3 Min: 0 Max: 121 Err: 0 (0.00%) +summary = 2000000 in 00:00:34 = 59382.4/s Avg: 3 Min: 0 Max: 124 Err: 0 (0.00%) diff --git a/report/data/3.0_sp_insert_raw_merge.log_plot b/report/data/3.0_sp_insert_raw_merge.log_plot index d12f545..c3eacfc 100644 --- a/report/data/3.0_sp_insert_raw_merge.log_plot +++ b/report/data/3.0_sp_insert_raw_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:00:55 = 36407.3/s Avg: 5 Min: 0 Max: 447 Err: summary = 2000000 in 00:00:55 = 36268.7/s Avg: 5 Min: 0 Max: 327 Err: 0 (0.00%) summary = 2000000 in 00:00:56 = 35998.4/s Avg: 5 Min: 0 Max: 374 Err: 0 (0.00%) summary = 2000000 in 00:00:55 = 36477.7/s Avg: 5 Min: 0 Max: 452 Err: 0 (0.00%) +summary = 2000000 in 00:00:54 = 36747.8/s Avg: 5 Min: 0 Max: 406 Err: 0 (0.00%) diff --git a/report/data/3.0_sp_select_raw_merge.log_plot b/report/data/3.0_sp_select_raw_merge.log_plot index 467fe11..6f4aa41 100644 --- a/report/data/3.0_sp_select_raw_merge.log_plot +++ b/report/data/3.0_sp_select_raw_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:00:19 = 106866.2/s Avg: 1 Min: 0 Max: 193 Err: summary = 2000000 in 00:00:20 = 102490.5/s Avg: 1 Min: 0 Max: 203 Err: 0 (0.00%) summary = 2000000 in 00:00:20 = 101952.4/s Avg: 1 Min: 0 Max: 218 Err: 0 (0.00%) summary = 2000000 in 00:00:19 = 103135.3/s Avg: 1 Min: 0 Max: 214 Err: 0 (0.00%) +summary = 2000000 in 00:00:19 = 105803.3/s Avg: 1 Min: 0 Max: 190 Err: 0 (0.00%) diff --git a/report/data/3.0_sp_update_raw_merge.log_plot b/report/data/3.0_sp_update_raw_merge.log_plot index 7e4c732..6874abb 100644 --- a/report/data/3.0_sp_update_raw_merge.log_plot +++ b/report/data/3.0_sp_update_raw_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:08:08 = 4097.4/s Avg: 48 Min: 0 Max: 89 Err: summary = 2000000 in 00:08:09 = 4093.7/s Avg: 48 Min: 0 Max: 81 Err: 0 (0.00%) summary = 2000000 in 00:08:09 = 4094.1/s Avg: 48 Min: 0 Max: 79 Err: 0 (0.00%) summary = 2000000 in 00:08:09 = 4089.4/s Avg: 48 Min: 0 Max: 86 Err: 0 (0.00%) +summary = 2000000 in 00:08:09 = 4093.7/s Avg: 48 Min: 0 Max: 87 Err: 0 (0.00%) diff --git a/report/data/4.0_single_delete_merge.log_plot b/report/data/4.0_single_delete_merge.log_plot index c4225e5..58e2a03 100644 --- a/report/data/4.0_single_delete_merge.log_plot +++ b/report/data/4.0_single_delete_merge.log_plot @@ -14,3 +14,4 @@ summary = 2000000 in 00:00:34 = 59408.9/s Avg: 3 Min: 0 Max: 77 Err: summary = 2000000 in 00:00:33 = 59726.5/s Avg: 3 Min: 0 Max: 119 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 59421.2/s Avg: 3 Min: 0 Max: 68 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 59529.1/s Avg: 3 Min: 0 Max: 62 Err: 0 (0.00%) +summary = 2000000 in 00:00:34 = 59313.7/s Avg: 3 Min: 0 Max: 62 Err: 0 (0.00%) diff --git a/report/data/4.0_single_insert_merge.log_plot b/report/data/4.0_single_insert_merge.log_plot index 2582164..5fd43f7 100644 --- a/report/data/4.0_single_insert_merge.log_plot +++ b/report/data/4.0_single_insert_merge.log_plot @@ -14,3 +14,4 @@ summary = 2000000 in 00:00:28 = 71184.5/s Avg: 2 Min: 0 Max: 627 Err: summary = 2000000 in 00:00:29 = 68068.9/s Avg: 2 Min: 0 Max: 525 Err: 0 (0.00%) summary = 2000000 in 00:00:29 = 69225.7/s Avg: 2 Min: 0 Max: 561 Err: 0 (0.00%) summary = 2000000 in 00:00:29 = 69669.4/s Avg: 2 Min: 0 Max: 560 Err: 0 (0.00%) +summary = 2000000 in 00:00:29 = 68617.7/s Avg: 2 Min: 0 Max: 473 Err: 0 (0.00%) diff --git a/report/data/4.0_single_select_merge.log_plot b/report/data/4.0_single_select_merge.log_plot index 709f5a0..033abcd 100644 --- a/report/data/4.0_single_select_merge.log_plot +++ b/report/data/4.0_single_select_merge.log_plot @@ -14,3 +14,4 @@ summary = 2000000 in 00:00:23 = 88731.1/s Avg: 2 Min: 0 Max: 583 Err: summary = 2000000 in 00:00:24 = 84430.9/s Avg: 2 Min: 0 Max: 808 Err: 0 (0.00%) summary = 2000000 in 00:00:23 = 85459.1/s Avg: 2 Min: 0 Max: 527 Err: 0 (0.00%) summary = 2000000 in 00:00:24 = 84563.0/s Avg: 2 Min: 0 Max: 899 Err: 0 (0.00%) +summary = 2000000 in 00:00:25 = 80463.5/s Avg: 2 Min: 0 Max: 767 Err: 0 (0.00%) diff --git a/report/data/4.0_single_update_merge.log_plot b/report/data/4.0_single_update_merge.log_plot index f25caba..3b529d1 100644 --- a/report/data/4.0_single_update_merge.log_plot +++ b/report/data/4.0_single_update_merge.log_plot @@ -14,3 +14,4 @@ summary = 2000000 in 00:08:07 = 4106.0/s Avg: 48 Min: 0 Max: 156 Err: summary = 2000000 in 00:08:06 = 4115.6/s Avg: 48 Min: 0 Max: 195 Err: 0 (0.00%) summary = 2000000 in 00:08:09 = 4093.9/s Avg: 48 Min: 0 Max: 220 Err: 0 (0.00%) summary = 2000000 in 00:08:07 = 4109.0/s Avg: 48 Min: 0 Max: 83 Err: 0 (0.00%) +summary = 2000000 in 00:08:07 = 4110.5/s Avg: 48 Min: 0 Max: 184 Err: 0 (0.00%) diff --git a/report/data/4.0_sp_delete_raw_merge.log_plot b/report/data/4.0_sp_delete_raw_merge.log_plot index d1bd054..f57e6be 100644 --- a/report/data/4.0_sp_delete_raw_merge.log_plot +++ b/report/data/4.0_sp_delete_raw_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:00:34 = 59569.9/s Avg: 3 Min: 0 Max: 86 Err: summary = 2000000 in 00:00:33 = 59738.9/s Avg: 3 Min: 0 Max: 63 Err: 0 (0.00%) summary = 2000000 in 00:00:33 = 59730.0/s Avg: 3 Min: 0 Max: 71 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 59667.7/s Avg: 3 Min: 0 Max: 55 Err: 0 (0.00%) +summary = 2000000 in 00:00:33 = 60141.3/s Avg: 3 Min: 0 Max: 89 Err: 0 (0.00%) diff --git a/report/data/4.0_sp_insert_raw_merge.log_plot b/report/data/4.0_sp_insert_raw_merge.log_plot index 7fb431a..ba0b643 100644 --- a/report/data/4.0_sp_insert_raw_merge.log_plot +++ b/report/data/4.0_sp_insert_raw_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:00:55 = 36274.6/s Avg: 5 Min: 0 Max: 471 Err: summary = 2000000 in 00:00:55 = 36215.5/s Avg: 5 Min: 0 Max: 530 Err: 0 (0.00%) summary = 2000000 in 00:00:55 = 36204.3/s Avg: 5 Min: 0 Max: 392 Err: 0 (0.00%) summary = 2000000 in 00:00:55 = 36620.0/s Avg: 5 Min: 0 Max: 441 Err: 0 (0.00%) +summary = 2000000 in 00:00:56 = 35987.4/s Avg: 5 Min: 0 Max: 458 Err: 0 (0.00%) diff --git a/report/data/4.0_sp_select_raw_merge.log_plot b/report/data/4.0_sp_select_raw_merge.log_plot index 40358ce..1eb2a56 100644 --- a/report/data/4.0_sp_select_raw_merge.log_plot +++ b/report/data/4.0_sp_select_raw_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:00:22 = 90772.9/s Avg: 2 Min: 0 Max: 480 Err: summary = 2000000 in 00:00:23 = 85375.2/s Avg: 2 Min: 0 Max: 259 Err: 0 (0.00%) summary = 2000000 in 00:00:23 = 86084.4/s Avg: 2 Min: 0 Max: 735 Err: 0 (0.00%) summary = 2000000 in 00:00:24 = 83563.1/s Avg: 2 Min: 0 Max: 1088 Err: 0 (0.00%) +summary = 2000000 in 00:00:24 = 84591.6/s Avg: 2 Min: 0 Max: 782 Err: 0 (0.00%) diff --git a/report/data/4.0_sp_update_raw_merge.log_plot b/report/data/4.0_sp_update_raw_merge.log_plot index 76a2f30..5901f88 100644 --- a/report/data/4.0_sp_update_raw_merge.log_plot +++ b/report/data/4.0_sp_update_raw_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:08:07 = 4106.2/s Avg: 48 Min: 0 Max: 88 Err: summary = 2000000 in 00:08:07 = 4104.3/s Avg: 48 Min: 0 Max: 154 Err: 0 (0.00%) summary = 2000000 in 00:08:07 = 4109.2/s Avg: 48 Min: 0 Max: 99 Err: 0 (0.00%) summary = 2000000 in 00:08:08 = 4095.0/s Avg: 48 Min: 0 Max: 101 Err: 0 (0.00%) +summary = 2000000 in 00:08:08 = 4100.0/s Avg: 48 Min: 0 Max: 92 Err: 0 (0.00%) diff --git a/report/data/direct_delete_merge.log_plot b/report/data/direct_delete_merge.log_plot index a05bee5..4956c6e 100644 --- a/report/data/direct_delete_merge.log_plot +++ b/report/data/direct_delete_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:00:34 = 59555.7/s Avg: 3 Min: 0 Max: 41 Err: summary = 2000000 in 00:00:34 = 58941.4/s Avg: 3 Min: 0 Max: 37 Err: 0 (0.00%) summary = 2000000 in 00:00:35 = 57893.8/s Avg: 3 Min: 0 Max: 35 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 58986.6/s Avg: 3 Min: 0 Max: 47 Err: 0 (0.00%) +summary = 2000000 in 00:00:34 = 58217.4/s Avg: 3 Min: 0 Max: 38 Err: 0 (0.00%) diff --git a/report/data/direct_insert_merge.log_plot b/report/data/direct_insert_merge.log_plot index 2d278e2..54a05da 100644 --- a/report/data/direct_insert_merge.log_plot +++ b/report/data/direct_insert_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:00:52 = 38454.9/s Avg: 5 Min: 0 Max: 270 Err: summary = 2000000 in 00:00:52 = 38526.7/s Avg: 5 Min: 0 Max: 235 Err: 0 (0.00%) summary = 2000000 in 00:00:52 = 38635.4/s Avg: 5 Min: 0 Max: 226 Err: 0 (0.00%) summary = 2000000 in 00:00:52 = 38549.0/s Avg: 5 Min: 0 Max: 287 Err: 0 (0.00%) +summary = 2000000 in 00:00:52 = 38627.2/s Avg: 5 Min: 0 Max: 299 Err: 0 (0.00%) diff --git a/report/data/direct_select_merge.log_plot b/report/data/direct_select_merge.log_plot index f56fbd5..f01eadc 100644 --- a/report/data/direct_select_merge.log_plot +++ b/report/data/direct_select_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:00:11 = 175870.6/s Avg: 0 Min: 0 Max: 40 Err: summary = 2000000 in 00:00:12 = 170183.8/s Avg: 0 Min: 0 Max: 39 Err: 0 (0.00%) summary = 2000000 in 00:00:11 = 175085.4/s Avg: 0 Min: 0 Max: 41 Err: 0 (0.00%) summary = 2000000 in 00:00:12 = 169837.0/s Avg: 0 Min: 0 Max: 39 Err: 0 (0.00%) +summary = 2000000 in 00:00:12 = 170386.8/s Avg: 0 Min: 0 Max: 40 Err: 0 (0.00%) diff --git a/report/data/direct_update_merge.log_plot b/report/data/direct_update_merge.log_plot index bc31768..ac3a309 100644 --- a/report/data/direct_update_merge.log_plot +++ b/report/data/direct_update_merge.log_plot @@ -16,3 +16,4 @@ summary = 2000000 in 00:08:14 = 4048.2/s Avg: 49 Min: 0 Max: 219 Err: summary = 2000000 in 00:08:14 = 4051.4/s Avg: 49 Min: 0 Max: 111 Err: 0 (0.00%) summary = 2000000 in 00:08:14 = 4049.4/s Avg: 49 Min: 0 Max: 88 Err: 0 (0.00%) summary = 2000000 in 00:08:16 = 4031.9/s Avg: 49 Min: 0 Max: 77 Err: 0 (0.00%) +summary = 2000000 in 00:08:14 = 4051.3/s Avg: 49 Min: 0 Max: 101 Err: 0 (0.00%) diff --git a/report/data/encrypt/4.0_sp_delete_enc.log_plot b/report/data/encrypt/4.0_sp_delete_enc.log_plot index e49c7d3..d6279fa 100644 --- a/report/data/encrypt/4.0_sp_delete_enc.log_plot +++ b/report/data/encrypt/4.0_sp_delete_enc.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:34 = 59491.9/s Avg: 3 Min: 0 Max: 85 Err: summary = 2000000 in 00:00:34 = 59382.4/s Avg: 3 Min: 0 Max: 87 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 59632.1/s Avg: 3 Min: 0 Max: 68 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 59594.8/s Avg: 3 Min: 0 Max: 56 Err: 0 (0.00%) +summary = 2000000 in 00:00:34 = 59591.2/s Avg: 3 Min: 0 Max: 53 Err: 0 (0.00%) diff --git a/report/data/encrypt/4.0_sp_insert_enc.log_plot b/report/data/encrypt/4.0_sp_insert_enc.log_plot index 79dc445..2c2be29 100644 --- a/report/data/encrypt/4.0_sp_insert_enc.log_plot +++ b/report/data/encrypt/4.0_sp_insert_enc.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:55 = 36595.9/s Avg: 5 Min: 0 Max: 434 Err: summary = 2000000 in 00:00:54 = 36812.8/s Avg: 5 Min: 0 Max: 450 Err: 0 (0.00%) summary = 2000000 in 00:00:54 = 36920.1/s Avg: 5 Min: 0 Max: 459 Err: 0 (0.00%) summary = 2000000 in 00:00:54 = 36969.9/s Avg: 5 Min: 0 Max: 442 Err: 0 (0.00%) +summary = 2000000 in 00:00:54 = 36959.0/s Avg: 5 Min: 0 Max: 421 Err: 0 (0.00%) diff --git a/report/data/encrypt/4.0_sp_insert_enc_sharding.log_plot b/report/data/encrypt/4.0_sp_insert_enc_sharding.log_plot index 6791897..f5e0d27 100644 --- a/report/data/encrypt/4.0_sp_insert_enc_sharding.log_plot +++ b/report/data/encrypt/4.0_sp_insert_enc_sharding.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:30 = 66052.4/s Avg: 2 Min: 0 Max: 460 Err: summary = 2000000 in 00:00:30 = 65627.6/s Avg: 2 Min: 0 Max: 489 Err: 0 (0.00%) summary = 2000000 in 00:00:30 = 66549.1/s Avg: 2 Min: 0 Max: 503 Err: 0 (0.00%) summary = 2000000 in 00:00:31 = 64766.8/s Avg: 2 Min: 0 Max: 657 Err: 0 (0.00%) +summary = 2000000 in 00:00:31 = 65030.1/s Avg: 2 Min: 0 Max: 556 Err: 0 (0.00%) diff --git a/report/data/encrypt/4.0_sp_select_enc.log_plot b/report/data/encrypt/4.0_sp_select_enc.log_plot index 022f697..0f25e39 100644 --- a/report/data/encrypt/4.0_sp_select_enc.log_plot +++ b/report/data/encrypt/4.0_sp_select_enc.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:19 = 105003.4/s Avg: 1 Min: 0 Max: 649 Err: summary = 2000000 in 00:00:20 = 101378.8/s Avg: 1 Min: 0 Max: 743 Err: 0 (0.00%) summary = 2000000 in 00:00:19 = 104465.9/s Avg: 1 Min: 0 Max: 1030 Err: 0 (0.00%) summary = 2000000 in 00:00:19 = 103082.2/s Avg: 1 Min: 0 Max: 964 Err: 0 (0.00%) +summary = 2000000 in 00:00:20 = 100115.1/s Avg: 1 Min: 0 Max: 747 Err: 0 (0.00%) diff --git a/report/data/encrypt/4.0_sp_update_enc.log_plot b/report/data/encrypt/4.0_sp_update_enc.log_plot index 096308f..b57ffa1 100644 --- a/report/data/encrypt/4.0_sp_update_enc.log_plot +++ b/report/data/encrypt/4.0_sp_update_enc.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:08:09 = 4093.9/s Avg: 48 Min: 0 Max: 87 Err: summary = 2000000 in 00:08:09 = 4094.0/s Avg: 48 Min: 0 Max: 191 Err: 0 (0.00%) summary = 2000000 in 00:08:08 = 4094.9/s Avg: 48 Min: 0 Max: 81 Err: 0 (0.00%) summary = 2000000 in 00:08:09 = 4088.9/s Avg: 48 Min: 0 Max: 161 Err: 0 (0.00%) +summary = 2000000 in 00:08:09 = 4092.1/s Avg: 48 Min: 0 Max: 85 Err: 0 (0.00%) diff --git a/report/data/master_slave/3.0_sp_delete_ms.log_plot b/report/data/master_slave/3.0_sp_delete_ms.log_plot index c16b5d5..3f12471 100644 --- a/report/data/master_slave/3.0_sp_delete_ms.log_plot +++ b/report/data/master_slave/3.0_sp_delete_ms.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:34 = 59262.8/s Avg: 3 Min: 0 Max: 87 Err: summary = 2000000 in 00:00:34 = 59430.1/s Avg: 3 Min: 0 Max: 47 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 59637.4/s Avg: 3 Min: 0 Max: 73 Err: 0 (0.00%) summary = 2000000 in 00:00:34 = 59633.8/s Avg: 3 Min: 0 Max: 62 Err: 0 (0.00%) +summary = 2000000 in 00:00:34 = 59412.4/s Avg: 3 Min: 0 Max: 48 Err: 0 (0.00%) diff --git a/report/data/master_slave/3.0_sp_delete_ms_sharding.log_plot b/report/data/master_slave/3.0_sp_delete_ms_sharding.log_plot index 565e56c..e927c04 100644 --- a/report/data/master_slave/3.0_sp_delete_ms_sharding.log_plot +++ b/report/data/master_slave/3.0_sp_delete_ms_sharding.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:16 = 123130.0/s Avg: 1 Min: 0 Max: 351 Err: summary = 2000000 in 00:00:16 = 123571.2/s Avg: 1 Min: 0 Max: 294 Err: 0 (0.00%) summary = 2000000 in 00:00:16 = 123609.4/s Avg: 1 Min: 0 Max: 354 Err: 0 (0.00%) summary = 2000000 in 00:00:16 = 123640.0/s Avg: 1 Min: 0 Max: 359 Err: 0 (0.00%) +summary = 2000000 in 00:00:17 = 121080.0/s Avg: 1 Min: 0 Max: 284 Err: 0 (0.00%) diff --git a/report/data/master_slave/3.0_sp_insert_ms.log_plot b/report/data/master_slave/3.0_sp_insert_ms.log_plot index 785f9f4..1c607a0 100644 --- a/report/data/master_slave/3.0_sp_insert_ms.log_plot +++ b/report/data/master_slave/3.0_sp_insert_ms.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:54 = 36718.8/s Avg: 5 Min: 0 Max: 1032 Err: summary = 2000000 in 00:00:54 = 36741.7/s Avg: 5 Min: 0 Max: 1097 Err: 0 (0.00%) summary = 2000000 in 00:00:54 = 37295.3/s Avg: 5 Min: 0 Max: 923 Err: 0 (0.00%) summary = 2000000 in 00:00:55 = 36648.8/s Avg: 5 Min: 0 Max: 934 Err: 0 (0.00%) +summary = 2000000 in 00:00:54 = 37036.4/s Avg: 5 Min: 0 Max: 1020 Err: 0 (0.00%) diff --git a/report/data/master_slave/3.0_sp_insert_ms_sharding.log_plot b/report/data/master_slave/3.0_sp_insert_ms_sharding.log_plot index 7706798..9c9881e 100644 --- a/report/data/master_slave/3.0_sp_insert_ms_sharding.log_plot +++ b/report/data/master_slave/3.0_sp_insert_ms_sharding.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:30 = 65969.6/s Avg: 2 Min: 0 Max: 514 Err: summary = 2000000 in 00:00:30 = 66480.5/s Avg: 2 Min: 0 Max: 510 Err: 0 (0.00%) summary = 2000000 in 00:00:30 = 65690.1/s Avg: 2 Min: 0 Max: 473 Err: 0 (0.00%) summary = 2000000 in 00:00:30 = 66332.8/s Avg: 2 Min: 0 Max: 685 Err: 0 (0.00%) +summary = 2000000 in 00:00:30 = 66856.1/s Avg: 2 Min: 0 Max: 503 Err: 0 (0.00%) diff --git a/report/data/master_slave/3.0_sp_select_ms.log_plot b/report/data/master_slave/3.0_sp_select_ms.log_plot index 8a97421..848933b 100644 --- a/report/data/master_slave/3.0_sp_select_ms.log_plot +++ b/report/data/master_slave/3.0_sp_select_ms.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:36 = 56238.2/s Avg: 3 Min: 0 Max: 252 Err: summary = 2000000 in 00:00:35 = 57046.7/s Avg: 3 Min: 0 Max: 333 Err: 0 (0.00%) summary = 2000000 in 00:00:33 = 59831.9/s Avg: 3 Min: 0 Max: 389 Err: 0 (0.00%) summary = 2000000 in 00:00:35 = 57949.2/s Avg: 3 Min: 0 Max: 312 Err: 0 (0.00%) +summary = 2000000 in 00:00:35 = 57902.2/s Avg: 3 Min: 0 Max: 411 Err: 0 (0.00%) diff --git a/report/data/master_slave/3.0_sp_select_ms_sharding.log_plot b/report/data/master_slave/3.0_sp_select_ms_sharding.log_plot index db5a4ae..81cefbc 100644 --- a/report/data/master_slave/3.0_sp_select_ms_sharding.log_plot +++ b/report/data/master_slave/3.0_sp_select_ms_sharding.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:22 = 90892.6/s Avg: 2 Min: 0 Max: 231 Err: summary = 2000000 in 00:00:23 = 87653.9/s Avg: 2 Min: 0 Max: 280 Err: 0 (0.00%) summary = 2000000 in 00:00:21 = 94366.3/s Avg: 2 Min: 0 Max: 258 Err: 0 (0.00%) summary = 2000000 in 00:00:22 = 90110.4/s Avg: 2 Min: 0 Max: 228 Err: 0 (0.00%) +summary = 2000000 in 00:00:21 = 96246.4/s Avg: 1 Min: 0 Max: 249 Err: 0 (0.00%) diff --git a/report/data/master_slave/3.0_sp_update_ms.log_plot b/report/data/master_slave/3.0_sp_update_ms.log_plot index 09a1a40..d006b34 100644 --- a/report/data/master_slave/3.0_sp_update_ms.log_plot +++ b/report/data/master_slave/3.0_sp_update_ms.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:08:10 = 4082.7/s Avg: 48 Min: 0 Max: 98 Err: summary = 2000000 in 00:08:09 = 4088.9/s Avg: 48 Min: 0 Max: 79 Err: 0 (0.00%) summary = 2000000 in 00:08:08 = 4095.7/s Avg: 48 Min: 0 Max: 101 Err: 0 (0.00%) summary = 2000000 in 00:08:09 = 4093.9/s Avg: 48 Min: 0 Max: 79 Err: 0 (0.00%) +summary = 2000000 in 00:08:09 = 4088.5/s Avg: 48 Min: 0 Max: 85 Err: 0 (0.00%) diff --git a/report/data/master_slave/3.0_sp_update_ms_sharding.log_plot b/report/data/master_slave/3.0_sp_update_ms_sharding.log_plot index 309a75d..3117c5b 100644 --- a/report/data/master_slave/3.0_sp_update_ms_sharding.log_plot +++ b/report/data/master_slave/3.0_sp_update_ms_sharding.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:06:29 = 5147.2/s Avg: 38 Min: 0 Max: 102 Err: summary = 2000000 in 00:06:30 = 5133.7/s Avg: 38 Min: 0 Max: 115 Err: 0 (0.00%) summary = 2000000 in 00:06:31 = 5116.8/s Avg: 39 Min: 0 Max: 113 Err: 0 (0.00%) summary = 2000000 in 00:06:28 = 5159.3/s Avg: 38 Min: 0 Max: 87 Err: 0 (0.00%) +summary = 2000000 in 00:06:29 = 5142.6/s Avg: 38 Min: 0 Max: 96 Err: 0 (0.00%) diff --git a/report/data/master_slave/4.0_sp_delete_ms_sharding.log_plot b/report/data/master_slave/4.0_sp_delete_ms_sharding.log_plot index a43ea37..4e0c426 100644 --- a/report/data/master_slave/4.0_sp_delete_ms_sharding.log_plot +++ b/report/data/master_slave/4.0_sp_delete_ms_sharding.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:18 = 111613.4/s Avg: 1 Min: 0 Max: 187 Err: summary = 2000000 in 00:00:19 = 107851.6/s Avg: 1 Min: 0 Max: 75 Err: 0 (0.00%) summary = 2000000 in 00:00:19 = 105808.9/s Avg: 1 Min: 0 Max: 118 Err: 0 (0.00%) summary = 2000000 in 00:00:19 = 107689.0/s Avg: 1 Min: 0 Max: 155 Err: 0 (0.00%) +summary = 2000000 in 00:00:19 = 103023.7/s Avg: 1 Min: 0 Max: 98 Err: 0 (0.00%) diff --git a/report/data/master_slave/4.0_sp_insert_ms_sharding.log_plot b/report/data/master_slave/4.0_sp_insert_ms_sharding.log_plot index 02b5810..783b071 100644 --- a/report/data/master_slave/4.0_sp_insert_ms_sharding.log_plot +++ b/report/data/master_slave/4.0_sp_insert_ms_sharding.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:38 = 52038.6/s Avg: 3 Min: 0 Max: 489 Err: summary = 2000000 in 00:00:39 = 51855.1/s Avg: 3 Min: 0 Max: 550 Err: 0 (0.00%) summary = 2000000 in 00:00:39 = 51919.7/s Avg: 3 Min: 0 Max: 792 Err: 0 (0.00%) summary = 2000000 in 00:00:38 = 52595.6/s Avg: 3 Min: 0 Max: 639 Err: 0 (0.00%) +summary = 2000000 in 00:00:38 = 52148.5/s Avg: 3 Min: 0 Max: 556 Err: 0 (0.00%) diff --git a/report/data/master_slave/4.0_sp_select_ms_sharding.log_plot b/report/data/master_slave/4.0_sp_select_ms_sharding.log_plot index 6effd00..222cc8d 100644 --- a/report/data/master_slave/4.0_sp_select_ms_sharding.log_plot +++ b/report/data/master_slave/4.0_sp_select_ms_sharding.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:00:42 = 47551.1/s Avg: 4 Min: 0 Max: 1188 Err: summary = 2000000 in 00:00:42 = 47692.9/s Avg: 4 Min: 0 Max: 729 Err: 0 (0.00%) summary = 2000000 in 00:00:42 = 47528.5/s Avg: 4 Min: 0 Max: 794 Err: 0 (0.00%) summary = 2000000 in 00:00:42 = 48086.2/s Avg: 4 Min: 0 Max: 634 Err: 0 (0.00%) +summary = 2000000 in 00:00:42 = 47556.8/s Avg: 4 Min: 0 Max: 736 Err: 0 (0.00%) diff --git a/report/data/master_slave/4.0_sp_update_ms_sharding.log_plot b/report/data/master_slave/4.0_sp_update_ms_sharding.log_plot index 18782ca..ac078bf 100644 --- a/report/data/master_slave/4.0_sp_update_ms_sharding.log_plot +++ b/report/data/master_slave/4.0_sp_update_ms_sharding.log_plot @@ -12,3 +12,4 @@ summary = 2000000 in 00:06:26 = 5183.4/s Avg: 38 Min: 0 Max: 122 Err: summary = 2000000 in 00:06:25 = 5199.7/s Avg: 38 Min: 0 Max: 154 Err: 0 (0.00%) summary = 2000000 in 00:06:25 = 5201.2/s Avg: 38 Min: 0 Max: 101 Err: 0 (0.00%) summary = 2000000 in 00:06:26 = 5184.6/s Avg: 38 Min: 0 Max: 294 Err: 0 (0.00%) +summary = 2000000 in 00:06:27 = 5171.6/s Avg: 38 Min: 0 Max: 304 Err: 0 (0.00%) diff --git a/report/data_json/mysql_vs_shardingproxy.json b/report/data_json/mysql_vs_shardingproxy.json index 15bf62c..30fc182 100644 --- a/report/data_json/mysql_vs_shardingproxy.json +++ b/report/data_json/mysql_vs_shardingproxy.json @@ -1 +1 @@ -{"SELECT": [{"type": "3.0version", "data": [{"Samples": 2000000, "Throughout": "102396.1", "Avg": "1", "Min": "0", "Max": "211", "Err": "0"}, {"Samples": 2000000, "Throughout": "105836.9", "Avg": "1", "Min": "0", "Max": "197", "Err": "0"}, {"Samples": 2000000, "Throughout": "107834.2", "Avg": "1", "Min": "0", "Max": "182", "Err": "0"}, {"Samples": 2000000, "Throughout": "102595.7", "Avg": "1", "Min": "0", "Max": "142", "Err": "0"}, {"Samples": 2000000, "Throughout": "105158.0", "Avg": "1 [...] \ No newline at end of file +{"SELECT": [{"type": "3.0version", "data": [{"Samples": 2000000, "Throughout": "102396.1", "Avg": "1", "Min": "0", "Max": "211", "Err": "0"}, {"Samples": 2000000, "Throughout": "105836.9", "Avg": "1", "Min": "0", "Max": "197", "Err": "0"}, {"Samples": 2000000, "Throughout": "107834.2", "Avg": "1", "Min": "0", "Max": "182", "Err": "0"}, {"Samples": 2000000, "Throughout": "102595.7", "Avg": "1", "Min": "0", "Max": "142", "Err": "0"}, {"Samples": 2000000, "Throughout": "105158.0", "Avg": "1 [...] \ No newline at end of file diff --git a/report/data_json/sharding_proxy_master_slave.json b/report/data_json/sharding_proxy_master_slave.json index 9945a08..f851567 100644 --- a/report/data_json/sharding_proxy_master_slave.json +++ b/report/data_json/sharding_proxy_master_slave.json @@ -1 +1 @@ -{"INSERT": [{"type": "3.0version", "data": [{"Samples": 2000000, "Throughout": "36965.2", "Avg": "5", "Min": "0", "Max": "1072", "Err": "0"}, {"Samples": 2000000, "Throughout": "37139.5", "Avg": "5", "Min": "0", "Max": "1166", "Err": "0"}, {"Samples": 2000000, "Throughout": "36681.8", "Avg": "5", "Min": "0", "Max": "914", "Err": "0"}, {"Samples": 2000000, "Throughout": "36912.6", "Avg": "5", "Min": "0", "Max": "1057", "Err": "0"}, {"Samples": 2000000, "Throughout": "36948.8", "Avg": "5", [...] \ No newline at end of file +{"INSERT": [{"type": "3.0version", "data": [{"Samples": 2000000, "Throughout": "36965.2", "Avg": "5", "Min": "0", "Max": "1072", "Err": "0"}, {"Samples": 2000000, "Throughout": "37139.5", "Avg": "5", "Min": "0", "Max": "1166", "Err": "0"}, {"Samples": 2000000, "Throughout": "36681.8", "Avg": "5", "Min": "0", "Max": "914", "Err": "0"}, {"Samples": 2000000, "Throughout": "36912.6", "Avg": "5", "Min": "0", "Max": "1057", "Err": "0"}, {"Samples": 2000000, "Throughout": "36948.8", "Avg": "5", [...] \ No newline at end of file diff --git a/report/data_json/sharding_proxy_master_slave_sharding.json b/report/data_json/sharding_proxy_master_slave_sharding.json index 201f7bc..a200b79 100644 --- a/report/data_json/sharding_proxy_master_slave_sharding.json +++ b/report/data_json/sharding_proxy_master_slave_sharding.json @@ -1 +1 @@ -{"UPDATE": [{"type": "3.0version", "data": [{"Samples": 2000000, "Throughout": "5186.6", "Avg": "38", "Min": "0", "Max": "100", "Err": "0"}, {"Samples": 2000000, "Throughout": "5168.0", "Avg": "38", "Min": "0", "Max": "78", "Err": "0"}, {"Samples": 2000000, "Throughout": "5176.7", "Avg": "38", "Min": "0", "Max": "89", "Err": "0"}, {"Samples": 2000000, "Throughout": "5191.3", "Avg": "38", "Min": "0", "Max": "87", "Err": "0"}, {"Samples": 2000000, "Throughout": "5133.4", "Avg": "38", "Min" [...] \ No newline at end of file +{"UPDATE": [{"type": "3.0version", "data": [{"Samples": 2000000, "Throughout": "5186.6", "Avg": "38", "Min": "0", "Max": "100", "Err": "0"}, {"Samples": 2000000, "Throughout": "5168.0", "Avg": "38", "Min": "0", "Max": "78", "Err": "0"}, {"Samples": 2000000, "Throughout": "5176.7", "Avg": "38", "Min": "0", "Max": "89", "Err": "0"}, {"Samples": 2000000, "Throughout": "5191.3", "Avg": "38", "Min": "0", "Max": "87", "Err": "0"}, {"Samples": 2000000, "Throughout": "5133.4", "Avg": "38", "Min" [...] \ No newline at end of file diff --git a/report/data_json/sharding_proxy_single_database_single_table.json b/report/data_json/sharding_proxy_single_database_single_table.json index 0597f96..0731c7e 100644 --- a/report/data_json/sharding_proxy_single_database_single_table.json +++ b/report/data_json/sharding_proxy_single_database_single_table.json @@ -1 +1 @@ -{"SELECT": [{"type": "3.0version", "data": [{"Samples": 2000000, "Throughout": "103428.7", "Avg": "1", "Min": "0", "Max": "204", "Err": "0"}, {"Samples": 2000000, "Throughout": "103316.5", "Avg": "1", "Min": "0", "Max": "172", "Err": "0"}, {"Samples": 2000000, "Throughout": "102254.7", "Avg": "1", "Min": "0", "Max": "155", "Err": "0"}, {"Samples": 2000000, "Throughout": "103476.8", "Avg": "1", "Min": "0", "Max": "165", "Err": "0"}, {"Samples": 2000000, "Throughout": "96857.0", "Avg": "1" [...] \ No newline at end of file +{"SELECT": [{"type": "3.0version", "data": [{"Samples": 2000000, "Throughout": "103428.7", "Avg": "1", "Min": "0", "Max": "204", "Err": "0"}, {"Samples": 2000000, "Throughout": "103316.5", "Avg": "1", "Min": "0", "Max": "172", "Err": "0"}, {"Samples": 2000000, "Throughout": "102254.7", "Avg": "1", "Min": "0", "Max": "155", "Err": "0"}, {"Samples": 2000000, "Throughout": "103476.8", "Avg": "1", "Min": "0", "Max": "165", "Err": "0"}, {"Samples": 2000000, "Throughout": "96857.0", "Avg": "1" [...] \ No newline at end of file diff --git a/report/scenario_1/delete_single.png b/report/scenario_1/delete_single.png index d873bd5..68eb28f 100644 Binary files a/report/scenario_1/delete_single.png and b/report/scenario_1/delete_single.png differ diff --git a/report/scenario_1/insert_single.png b/report/scenario_1/insert_single.png index 09a671d..f13f1c9 100644 Binary files a/report/scenario_1/insert_single.png and b/report/scenario_1/insert_single.png differ diff --git a/report/scenario_1/select_single.png b/report/scenario_1/select_single.png index 322baf9..2a8814e 100644 Binary files a/report/scenario_1/select_single.png and b/report/scenario_1/select_single.png differ diff --git a/report/scenario_1/update_single.png b/report/scenario_1/update_single.png index e710882..1b87cd0 100644 Binary files a/report/scenario_1/update_single.png and b/report/scenario_1/update_single.png differ diff --git a/report/sp_raw/delete_single_raw.png b/report/sp_raw/delete_single_raw.png index b6ffbff..bae54f4 100644 Binary files a/report/sp_raw/delete_single_raw.png and b/report/sp_raw/delete_single_raw.png differ diff --git a/report/sp_raw/insert_single_raw.png b/report/sp_raw/insert_single_raw.png index ea3b959..3f3bc28 100644 Binary files a/report/sp_raw/insert_single_raw.png and b/report/sp_raw/insert_single_raw.png differ diff --git a/report/sp_raw/select_single_raw.png b/report/sp_raw/select_single_raw.png index be6f8da..93c8d70 100644 Binary files a/report/sp_raw/select_single_raw.png and b/report/sp_raw/select_single_raw.png differ diff --git a/report/sp_raw/update_single_raw.png b/report/sp_raw/update_single_raw.png index 29aa037..56a0825 100644 Binary files a/report/sp_raw/update_single_raw.png and b/report/sp_raw/update_single_raw.png differ