You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2019/09/29 10:38:19 UTC

[incubator-shardingsphere-benchmark] 19/49: for performance

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

commit 4270a8a1d8e7ceec5e5a551529f74675a88436af
Author: nancyzrh <zh...@126.com>
AuthorDate: Fri Sep 20 13:27:47 2019 +0800

    for performance
---
 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/encrypt/4.0_sp_delete_enc.log_plot      |   1 -
 report/data/encrypt/4.0_sp_insert_enc.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/4.0_sp_delete_ms.log_plot  |   1 -
 .../master_slave/4.0_sp_delete_ms_sharding.log_plot |   1 -
 report/data/master_slave/4.0_sp_insert_ms.log_plot  |   1 -
 .../master_slave/4.0_sp_insert_ms_sharding.log_plot |   1 -
 report/data/master_slave/4.0_sp_select_ms.log_plot  |   1 -
 .../master_slave/4.0_sp_select_ms_sharding.log_plot |   1 -
 report/data/master_slave/4.0_sp_update_ms.log_plot  |   1 -
 .../master_slave/4.0_sp_update_ms_sharding.log_plot |   1 -
 report/scenario_1/select_single.png                 | Bin 27249 -> 27659 bytes
 report/scenario_1/update_single.png                 | Bin 27409 -> 28104 bytes
 report/sp_raw/delete_single_raw.png                 | Bin 29486 -> 31173 bytes
 report/sp_raw/insert_single_raw.png                 | Bin 29166 -> 30368 bytes
 report/sp_raw/select_single_raw.png                 | Bin 26160 -> 26939 bytes
 report/sp_raw/update_single_raw.png                 | Bin 29459 -> 29952 bytes
 24 files changed, 18 deletions(-)

diff --git a/report/data/4.0_single_select_merge.log_plot b/report/data/4.0_single_select_merge.log_plot
index 9054421..761d675 100644
--- a/report/data/4.0_single_select_merge.log_plot
+++ b/report/data/4.0_single_select_merge.log_plot
@@ -2,4 +2,3 @@ summary = 2000000 in 00:00:24 = 84093.7/s Avg:     2 Min:     0 Max:   926 Err:
 summary = 2000000 in 00:00:22 = 89059.1/s Avg:     2 Min:     0 Max:   377 Err:     0 (0.00%)
 summary = 2000000 in 00:00:23 = 88354.8/s Avg:     2 Min:     0 Max:   972 Err:     0 (0.00%)
 summary = 2000000 in 00:00:23 = 88350.9/s Avg:     2 Min:     0 Max:   638 Err:     0 (0.00%)
-summary = 2000000 in 00:00:23 = 88350.9/s Avg:     2 Min:     0 Max:   638 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 502148e..0e80328 100644
--- a/report/data/4.0_single_update_merge.log_plot
+++ b/report/data/4.0_single_update_merge.log_plot
@@ -2,4 +2,3 @@ summary = 2000000 in 00:08:09 = 4085.9/s Avg:    48 Min:     0 Max:   125 Err:
 summary = 2000000 in 00:08:10 = 4085.2/s Avg:    48 Min:     0 Max:    83 Err:     0 (0.00%)
 summary = 2000000 in 00:08:07 = 4108.0/s Avg:    48 Min:     0 Max:    91 Err:     0 (0.00%)
 summary = 2000000 in 00:08:07 = 4106.6/s Avg:    48 Min:     0 Max:   218 Err:     0 (0.00%)
-summary = 2000000 in 00:08:07 = 4106.6/s Avg:    48 Min:     0 Max:   218 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 9209d5c..ceb804c 100644
--- a/report/data/4.0_sp_delete_raw_merge.log_plot
+++ b/report/data/4.0_sp_delete_raw_merge.log_plot
@@ -4,4 +4,3 @@ summary = 2000000 in 00:00:36 = 56044.4/s Avg:     3 Min:     0 Max:    56 Err:
 summary = 2000000 in 00:00:36 = 55991.0/s Avg:     3 Min:     0 Max:   102 Err:     0 (0.00%)
 summary = 2000000 in 00:00:34 = 59428.3/s Avg:     3 Min:     0 Max:    59 Err:     0 (0.00%)
 summary = 2000000 in 00:00:33 = 59731.8/s Avg:     3 Min:     0 Max:    62 Err:     0 (0.00%)
-summary = 2000000 in 00:00:33 = 59731.8/s Avg:     3 Min:     0 Max:    62 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 2531e50..c7b115f 100644
--- a/report/data/4.0_sp_insert_raw_merge.log_plot
+++ b/report/data/4.0_sp_insert_raw_merge.log_plot
@@ -4,4 +4,3 @@ summary = 2000000 in 00:00:57 = 35338.8/s Avg:     5 Min:     0 Max:   407 Err:
 summary = 2000000 in 00:00:57 = 34935.7/s Avg:     5 Min:     0 Max:   455 Err:     0 (0.00%)
 summary = 2000000 in 00:00:55 = 36414.0/s Avg:     5 Min:     0 Max:   496 Err:     0 (0.00%)
 summary = 2000000 in 00:00:55 = 36052.3/s Avg:     5 Min:     0 Max:   684 Err:     0 (0.00%)
-summary = 2000000 in 00:00:55 = 36052.3/s Avg:     5 Min:     0 Max:   684 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 0ba8d5e..a15f264 100644
--- a/report/data/4.0_sp_select_raw_merge.log_plot
+++ b/report/data/4.0_sp_select_raw_merge.log_plot
@@ -4,4 +4,3 @@ summary = 2000000 in 00:00:22 = 88940.3/s Avg:     2 Min:     0 Max:   573 Err:
 summary = 2000000 in 00:00:22 = 90637.2/s Avg:     2 Min:     0 Max:   697 Err:     0 (0.00%)
 summary = 2000000 in 00:00:22 = 91516.4/s Avg:     2 Min:     0 Max:  1124 Err:     0 (0.00%)
 summary = 2000000 in 00:00:22 = 89078.9/s Avg:     2 Min:     0 Max:   475 Err:     0 (0.00%)
-summary = 2000000 in 00:00:22 = 89078.9/s Avg:     2 Min:     0 Max:   475 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 bd0aeba..4f70dd6 100644
--- a/report/data/4.0_sp_update_raw_merge.log_plot
+++ b/report/data/4.0_sp_update_raw_merge.log_plot
@@ -4,4 +4,3 @@ summary = 2000000 in 00:08:12 = 4065.6/s Avg:    49 Min:     0 Max:   147 Err:
 summary = 2000000 in 00:07:20 = 4545.7/s Avg:    43 Min:     0 Max:   193 Err:     0 (0.00%)
 summary = 2000000 in 00:08:09 = 4094.0/s Avg:    48 Min:     0 Max:   102 Err:     0 (0.00%)
 summary = 2000000 in 00:08:07 = 4105.5/s Avg:    48 Min:     0 Max:   122 Err:     0 (0.00%)
-summary = 2000000 in 00:08:07 = 4105.5/s Avg:    48 Min:     0 Max:   122 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 0f7ec9e..2f96b26 100644
--- a/report/data/encrypt/4.0_sp_delete_enc.log_plot
+++ b/report/data/encrypt/4.0_sp_delete_enc.log_plot
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:06:18 = 5294.6/s Avg:    37 Min:     0 Max:    77 Err:     0 (0.00%)
 summary = 2000000 in 00:00:34 = 59523.8/s Avg:     3 Min:     0 Max:    99 Err:     0 (0.00%)
-summary = 2000000 in 00:00:34 = 59523.8/s Avg:     3 Min:     0 Max:    99 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 aa0de90..88a377c 100644
--- a/report/data/encrypt/4.0_sp_insert_enc.log_plot
+++ b/report/data/encrypt/4.0_sp_insert_enc.log_plot
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:01:00 = 33286.2/s Avg:     5 Min:     0 Max:   475 Err:     0 (0.00%)
 summary = 2000000 in 00:00:54 = 37342.7/s Avg:     5 Min:     0 Max:   480 Err:     0 (0.00%)
-summary = 2000000 in 00:00:54 = 37342.7/s Avg:     5 Min:     0 Max:   480 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 51c2e9a..9d53bf1 100644
--- a/report/data/encrypt/4.0_sp_select_enc.log_plot
+++ b/report/data/encrypt/4.0_sp_select_enc.log_plot
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:00:19 = 106168.4/s Avg:     1 Min:     0 Max:   367 Err:     0 (0.00%)
 summary = 2000000 in 00:00:20 = 100948.9/s Avg:     1 Min:     0 Max:   742 Err:     0 (0.00%)
-summary = 2000000 in 00:00:20 = 100948.9/s Avg:     1 Min:     0 Max:   742 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 ecd3be3..82fc4be 100644
--- a/report/data/encrypt/4.0_sp_update_enc.log_plot
+++ b/report/data/encrypt/4.0_sp_update_enc.log_plot
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:06:20 = 5265.4/s Avg:    37 Min:     0 Max:   106 Err:     0 (0.00%)
 summary = 2000000 in 00:08:08 = 4097.7/s Avg:    48 Min:     0 Max:    79 Err:     0 (0.00%)
-summary = 2000000 in 00:08:08 = 4097.7/s Avg:    48 Min:     0 Max:    79 Err:     0 (0.00%)
diff --git a/report/data/master_slave/4.0_sp_delete_ms.log_plot b/report/data/master_slave/4.0_sp_delete_ms.log_plot
index 1fbf1c9..0ba149c 100644
--- a/report/data/master_slave/4.0_sp_delete_ms.log_plot
+++ b/report/data/master_slave/4.0_sp_delete_ms.log_plot
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:00:36 = 55406.3/s Avg:     3 Min:     0 Max:    65 Err:     0 (0.00%)
 summary = 2000000 in 00:00:34 = 59518.5/s Avg:     3 Min:     0 Max:    48 Err:     0 (0.00%)
-summary = 2000000 in 00:00:34 = 59518.5/s Avg:     3 Min:     0 Max:    48 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 5afbafd..1475c0e 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
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:00:18 = 113007.1/s Avg:     1 Min:     0 Max:   119 Err:     0 (0.00%)
 summary = 2000000 in 00:00:18 = 109920.3/s Avg:     1 Min:     0 Max:   170 Err:     0 (0.00%)
-summary = 2000000 in 00:00:18 = 109920.3/s Avg:     1 Min:     0 Max:   170 Err:     0 (0.00%)
diff --git a/report/data/master_slave/4.0_sp_insert_ms.log_plot b/report/data/master_slave/4.0_sp_insert_ms.log_plot
index 122f079..21d1add 100644
--- a/report/data/master_slave/4.0_sp_insert_ms.log_plot
+++ b/report/data/master_slave/4.0_sp_insert_ms.log_plot
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:00:57 = 35379.4/s Avg:     5 Min:     0 Max:   608 Err:     0 (0.00%)
 summary = 2000000 in 00:00:54 = 37256.4/s Avg:     5 Min:     0 Max:   471 Err:     0 (0.00%)
-summary = 2000000 in 00:00:54 = 37256.4/s Avg:     5 Min:     0 Max:   471 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 3c63e05..641f3eb 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
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:00:39 = 50840.1/s Avg:     3 Min:     0 Max:   605 Err:     0 (0.00%)
 summary = 2000000 in 00:00:39 = 51872.6/s Avg:     3 Min:     0 Max:   556 Err:     0 (0.00%)
-summary = 2000000 in 00:00:39 = 51872.6/s Avg:     3 Min:     0 Max:   556 Err:     0 (0.00%)
diff --git a/report/data/master_slave/4.0_sp_select_ms.log_plot b/report/data/master_slave/4.0_sp_select_ms.log_plot
index 5efdda8..42632e1 100644
--- a/report/data/master_slave/4.0_sp_select_ms.log_plot
+++ b/report/data/master_slave/4.0_sp_select_ms.log_plot
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:00:21 = 97092.1/s Avg:     1 Min:     0 Max:   333 Err:     0 (0.00%)
 summary = 2000000 in 00:00:21 = 95306.2/s Avg:     1 Min:     0 Max:  1478 Err:     0 (0.00%)
-summary = 2000000 in 00:00:21 = 95306.2/s Avg:     1 Min:     0 Max:  1478 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 0aadd55..eea29e0 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
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:00:44 = 45852.6/s Avg:     4 Min:     0 Max:  1627 Err:     0 (0.00%)
 summary = 2000000 in 00:00:43 = 46114.8/s Avg:     4 Min:     0 Max:  2070 Err:     0 (0.00%)
-summary = 2000000 in 00:00:43 = 46114.8/s Avg:     4 Min:     0 Max:  2070 Err:     0 (0.00%)
diff --git a/report/data/master_slave/4.0_sp_update_ms.log_plot b/report/data/master_slave/4.0_sp_update_ms.log_plot
index b6a4773..ffe7371 100644
--- a/report/data/master_slave/4.0_sp_update_ms.log_plot
+++ b/report/data/master_slave/4.0_sp_update_ms.log_plot
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:08:13 = 4059.5/s Avg:    49 Min:     0 Max:    88 Err:     0 (0.00%)
 summary = 2000000 in 00:08:09 = 4089.8/s Avg:    48 Min:     0 Max:   101 Err:     0 (0.00%)
-summary = 2000000 in 00:08:09 = 4089.8/s Avg:    48 Min:     0 Max:   101 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 fcf51f8..91085a5 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
@@ -1,3 +1,2 @@
 summary = 2000000 in 00:06:26 = 5181.8/s Avg:    38 Min:     0 Max:   263 Err:     0 (0.00%)
 summary = 2000000 in 00:06:26 = 5185.0/s Avg:    38 Min:     0 Max:    91 Err:     0 (0.00%)
-summary = 2000000 in 00:06:26 = 5185.0/s Avg:    38 Min:     0 Max:    91 Err:     0 (0.00%)
diff --git a/report/scenario_1/select_single.png b/report/scenario_1/select_single.png
index d5de3ff..c4a5fb7 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 fac2afc..0ebf583 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 c57f600..96031cd 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 3ebc880..143034f 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 0f3fe69..1f70b6b 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 5f198ab..3239228 100644
Binary files a/report/sp_raw/update_single_raw.png and b/report/sp_raw/update_single_raw.png differ