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 3092c25 for performance 3092c25 is described below commit 3092c256447b49a79a6f8330c1974d809541e37e Author: nancyzrh <zhaoy...@126.com> AuthorDate: Sat Oct 5 06:39:01 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 37283 -> 37837 bytes report/scenario_1/insert_single.png | Bin 34765 -> 35258 bytes report/scenario_1/select_single.png | Bin 36996 -> 37721 bytes report/scenario_1/update_single.png | Bin 27658 -> 27788 bytes report/sp_raw/delete_single_raw.png | Bin 44349 -> 44844 bytes report/sp_raw/insert_single_raw.png | Bin 40411 -> 40896 bytes report/sp_raw/select_single_raw.png | Bin 36536 -> 36532 bytes report/sp_raw/update_single_raw.png | Bin 34815 -> 34972 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 da9fd05..d3f44b0 100644 --- a/report/data/3.0_single_delete_merge.log_plot +++ b/report/data/3.0_single_delete_merge.log_plot @@ -15,3 +15,4 @@ summary = 2000000 in 00:00:34 = 58977.9/s Avg: 3 Min: 0 Max: 59 Err: 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%) +summary = 2000000 in 00:00:34 = 59145.3/s Avg: 3 Min: 0 Max: 77 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 655e14f..7fa19e7 100644 --- a/report/data/3.0_single_insert_merge.log_plot +++ b/report/data/3.0_single_insert_merge.log_plot @@ -15,3 +15,4 @@ summary = 2000000 in 00:00:26 = 75774.8/s Avg: 2 Min: 0 Max: 517 Err: 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%) +summary = 2000000 in 00:00:27 = 75315.4/s Avg: 2 Min: 0 Max: 634 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 dbb505e..4f26dd4 100644 --- a/report/data/3.0_single_select_merge.log_plot +++ b/report/data/3.0_single_select_merge.log_plot @@ -15,3 +15,4 @@ summary = 2000000 in 00:00:19 = 102843.6/s Avg: 1 Min: 0 Max: 179 Err: 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%) +summary = 2000000 in 00:00:19 = 103076.8/s Avg: 1 Min: 0 Max: 181 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 c5ddd41..5554876 100644 --- a/report/data/3.0_single_update_merge.log_plot +++ b/report/data/3.0_single_update_merge.log_plot @@ -15,3 +15,4 @@ summary = 2000000 in 00:08:08 = 4096.0/s Avg: 48 Min: 0 Max: 82 Err: 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%) +summary = 2000000 in 00:08:09 = 4090.0/s Avg: 48 Min: 0 Max: 83 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 bd5b8d3..cab0adb 100644 --- a/report/data/3.0_sp_delete_raw_merge.log_plot +++ b/report/data/3.0_sp_delete_raw_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:00:34 = 59532.7/s Avg: 3 Min: 0 Max: 61 Err: 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%) +summary = 2000000 in 00:00:34 = 59472.5/s Avg: 3 Min: 0 Max: 83 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 c3eacfc..5078d7d 100644 --- a/report/data/3.0_sp_insert_raw_merge.log_plot +++ b/report/data/3.0_sp_insert_raw_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:00:55 = 36268.7/s Avg: 5 Min: 0 Max: 327 Err: 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%) +summary = 2000000 in 00:00:54 = 36846.0/s Avg: 5 Min: 0 Max: 398 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 6f4aa41..ef4e96b 100644 --- a/report/data/3.0_sp_select_raw_merge.log_plot +++ b/report/data/3.0_sp_select_raw_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:00:20 = 102490.5/s Avg: 1 Min: 0 Max: 203 Err: 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%) +summary = 2000000 in 00:00:19 = 104155.8/s Avg: 1 Min: 0 Max: 188 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 6874abb..24376d7 100644 --- a/report/data/3.0_sp_update_raw_merge.log_plot +++ b/report/data/3.0_sp_update_raw_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:08:09 = 4093.7/s Avg: 48 Min: 0 Max: 81 Err: 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%) +summary = 2000000 in 00:08:08 = 4095.9/s Avg: 48 Min: 0 Max: 86 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 58e2a03..abaec78 100644 --- a/report/data/4.0_single_delete_merge.log_plot +++ b/report/data/4.0_single_delete_merge.log_plot @@ -15,3 +15,4 @@ summary = 2000000 in 00:00:33 = 59726.5/s Avg: 3 Min: 0 Max: 119 Err: 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%) +summary = 2000000 in 00:00:34 = 59453.0/s Avg: 3 Min: 0 Max: 49 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 5fd43f7..a2043e5 100644 --- a/report/data/4.0_single_insert_merge.log_plot +++ b/report/data/4.0_single_insert_merge.log_plot @@ -15,3 +15,4 @@ summary = 2000000 in 00:00:29 = 68068.9/s Avg: 2 Min: 0 Max: 525 Err: 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%) +summary = 2000000 in 00:00:30 = 66903.1/s Avg: 2 Min: 0 Max: 553 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 033abcd..abe3a9f 100644 --- a/report/data/4.0_single_select_merge.log_plot +++ b/report/data/4.0_single_select_merge.log_plot @@ -15,3 +15,4 @@ summary = 2000000 in 00:00:24 = 84430.9/s Avg: 2 Min: 0 Max: 808 Err: 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%) +summary = 2000000 in 00:00:24 = 82440.2/s Avg: 2 Min: 0 Max: 1225 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 3b529d1..8982435 100644 --- a/report/data/4.0_single_update_merge.log_plot +++ b/report/data/4.0_single_update_merge.log_plot @@ -15,3 +15,4 @@ summary = 2000000 in 00:08:06 = 4115.6/s Avg: 48 Min: 0 Max: 195 Err: 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%) +summary = 2000000 in 00:08:06 = 4112.1/s Avg: 48 Min: 0 Max: 275 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 f57e6be..5a4ff26 100644 --- a/report/data/4.0_sp_delete_raw_merge.log_plot +++ b/report/data/4.0_sp_delete_raw_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:00:33 = 59738.9/s Avg: 3 Min: 0 Max: 63 Err: 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%) +summary = 2000000 in 00:00:34 = 59502.6/s Avg: 3 Min: 0 Max: 67 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 ba0b643..28d7684 100644 --- a/report/data/4.0_sp_insert_raw_merge.log_plot +++ b/report/data/4.0_sp_insert_raw_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:00:55 = 36215.5/s Avg: 5 Min: 0 Max: 530 Err: 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%) +summary = 2000000 in 00:00:55 = 36106.9/s Avg: 5 Min: 0 Max: 544 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 1eb2a56..4ffbcd9 100644 --- a/report/data/4.0_sp_select_raw_merge.log_plot +++ b/report/data/4.0_sp_select_raw_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:00:23 = 85375.2/s Avg: 2 Min: 0 Max: 259 Err: 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%) +summary = 2000000 in 00:00:23 = 85160.7/s Avg: 2 Min: 0 Max: 889 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 5901f88..756423b 100644 --- a/report/data/4.0_sp_update_raw_merge.log_plot +++ b/report/data/4.0_sp_update_raw_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:08:07 = 4104.3/s Avg: 48 Min: 0 Max: 154 Err: 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%) +summary = 2000000 in 00:08:09 = 4089.4/s Avg: 48 Min: 0 Max: 101 Err: 0 (0.00%) diff --git a/report/data/direct_delete_merge.log_plot b/report/data/direct_delete_merge.log_plot index 4956c6e..6992167 100644 --- a/report/data/direct_delete_merge.log_plot +++ b/report/data/direct_delete_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:00:34 = 58941.4/s Avg: 3 Min: 0 Max: 37 Err: 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%) +summary = 2000000 in 00:00:34 = 58627.0/s Avg: 3 Min: 0 Max: 44 Err: 0 (0.00%) diff --git a/report/data/direct_insert_merge.log_plot b/report/data/direct_insert_merge.log_plot index 54a05da..c7e4d51 100644 --- a/report/data/direct_insert_merge.log_plot +++ b/report/data/direct_insert_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:00:52 = 38526.7/s Avg: 5 Min: 0 Max: 235 Err: 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%) +summary = 2000000 in 00:00:52 = 38364.2/s Avg: 5 Min: 0 Max: 251 Err: 0 (0.00%) diff --git a/report/data/direct_select_merge.log_plot b/report/data/direct_select_merge.log_plot index f01eadc..0f4e50f 100644 --- a/report/data/direct_select_merge.log_plot +++ b/report/data/direct_select_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:00:12 = 170183.8/s Avg: 0 Min: 0 Max: 39 Err: 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%) +summary = 2000000 in 00:00:12 = 169865.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 ac3a309..bec70a7 100644 --- a/report/data/direct_update_merge.log_plot +++ b/report/data/direct_update_merge.log_plot @@ -17,3 +17,4 @@ summary = 2000000 in 00:08:14 = 4051.4/s Avg: 49 Min: 0 Max: 111 Err: 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%) +summary = 2000000 in 00:08:15 = 4040.4/s Avg: 49 Min: 0 Max: 126 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 d6279fa..8933c0c 100644 --- a/report/data/encrypt/4.0_sp_delete_enc.log_plot +++ b/report/data/encrypt/4.0_sp_delete_enc.log_plot @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:34 = 59382.4/s Avg: 3 Min: 0 Max: 87 Err: 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%) +summary = 2000000 in 00:00:34 = 59633.8/s Avg: 3 Min: 0 Max: 68 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 2c2be29..826b655 100644 --- a/report/data/encrypt/4.0_sp_insert_enc.log_plot +++ b/report/data/encrypt/4.0_sp_insert_enc.log_plot @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:54 = 36812.8/s Avg: 5 Min: 0 Max: 450 Err: 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%) +summary = 2000000 in 00:00:54 = 36722.2/s Avg: 5 Min: 0 Max: 549 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 f5e0d27..eabacae 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:30 = 65627.6/s Avg: 2 Min: 0 Max: 489 Err: 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%) +summary = 2000000 in 00:00:30 = 66297.6/s Avg: 2 Min: 0 Max: 582 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 0f25e39..bd81c88 100644 --- a/report/data/encrypt/4.0_sp_select_enc.log_plot +++ b/report/data/encrypt/4.0_sp_select_enc.log_plot @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:20 = 101378.8/s Avg: 1 Min: 0 Max: 743 Err: 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%) +summary = 2000000 in 00:00:19 = 103691.4/s Avg: 1 Min: 0 Max: 391 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 b57ffa1..2b1bc8d 100644 --- a/report/data/encrypt/4.0_sp_update_enc.log_plot +++ b/report/data/encrypt/4.0_sp_update_enc.log_plot @@ -13,3 +13,4 @@ summary = 2000000 in 00:08:09 = 4094.0/s Avg: 48 Min: 0 Max: 191 Err: 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%) +summary = 2000000 in 00:08:08 = 4095.4/s Avg: 48 Min: 0 Max: 110 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 3f12471..05dcd1d 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:34 = 59430.1/s Avg: 3 Min: 0 Max: 47 Err: 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%) +summary = 2000000 in 00:00:34 = 59543.3/s Avg: 3 Min: 0 Max: 123 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 e927c04..be688dc 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:16 = 123571.2/s Avg: 1 Min: 0 Max: 294 Err: 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%) +summary = 2000000 in 00:00:16 = 123107.2/s Avg: 1 Min: 0 Max: 325 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 1c607a0..ea6f36e 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:54 = 36741.7/s Avg: 5 Min: 0 Max: 1097 Err: 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%) +summary = 2000000 in 00:00:55 = 36573.8/s Avg: 5 Min: 0 Max: 1068 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 9c9881e..445908c 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:30 = 66480.5/s Avg: 2 Min: 0 Max: 510 Err: 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%) +summary = 2000000 in 00:00:30 = 67645.3/s Avg: 2 Min: 0 Max: 504 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 848933b..5187549 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:35 = 57046.7/s Avg: 3 Min: 0 Max: 333 Err: 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%) +summary = 2000000 in 00:00:34 = 58494.9/s Avg: 3 Min: 0 Max: 434 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 81cefbc..146feaa 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:23 = 87653.9/s Avg: 2 Min: 0 Max: 280 Err: 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%) +summary = 2000000 in 00:00:23 = 86971.6/s Avg: 2 Min: 0 Max: 327 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 d006b34..b02fdb0 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:08:09 = 4088.9/s Avg: 48 Min: 0 Max: 79 Err: 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%) +summary = 2000000 in 00:08:09 = 4092.5/s Avg: 48 Min: 0 Max: 82 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 3117c5b..268811a 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:06:30 = 5133.7/s Avg: 38 Min: 0 Max: 115 Err: 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%) +summary = 2000000 in 00:06:26 = 5178.8/s Avg: 38 Min: 0 Max: 83 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 4e0c426..668e8c7 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:19 = 107851.6/s Avg: 1 Min: 0 Max: 75 Err: 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%) +summary = 2000000 in 00:00:19 = 104635.3/s Avg: 1 Min: 0 Max: 85 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 783b071..3232f48 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:39 = 51855.1/s Avg: 3 Min: 0 Max: 550 Err: 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%) +summary = 2000000 in 00:00:38 = 52256.2/s Avg: 3 Min: 0 Max: 516 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 222cc8d..c8db5a2 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:00:42 = 47692.9/s Avg: 4 Min: 0 Max: 729 Err: 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%) +summary = 2000000 in 00:00:42 = 48086.2/s Avg: 4 Min: 0 Max: 602 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 ac078bf..8fe2a72 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 @@ -13,3 +13,4 @@ summary = 2000000 in 00:06:25 = 5199.7/s Avg: 38 Min: 0 Max: 154 Err: 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%) +summary = 2000000 in 00:06:24 = 5204.7/s Avg: 38 Min: 0 Max: 228 Err: 0 (0.00%) diff --git a/report/data_json/mysql_vs_shardingproxy.json b/report/data_json/mysql_vs_shardingproxy.json index 30fc182..45a2aa0 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 f851567..d6e2a53 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 a200b79..0cad9ab 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 0731c7e..9594b34 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 68eb28f..98c0b29 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 f13f1c9..a82b472 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 2a8814e..24a9877 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 1b87cd0..f775259 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 bae54f4..670d3c6 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 3f3bc28..f983b3b 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 93c8d70..a46d678 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 56a0825..81f129d 100644 Binary files a/report/sp_raw/update_single_raw.png and b/report/sp_raw/update_single_raw.png differ