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/18 09:00:25 UTC
[incubator-shardingsphere-benchmark] branch master updated (85b1d2e
-> aad924c)
This is an automated email from the ASF dual-hosted git repository.
zhaoyanan pushed a change to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-shardingsphere-benchmark.git.
from 85b1d2e add report pic
new 64761ac add sp_raw
new fbb4941 add data masking
new 0aab2e8 add sharding data masking data
new 1ccd4bc add sharding proxy single db single table
new 50c2141 add sp master slave
new 0bdd202 modify sp_raw
new 60b30f5 modify sharding proxy single db single table
new 0f99102 modify perf
new aad924c Merge pull request #1 from geomonlin/master
The 12 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
Summary of changes:
report/notes/data Sharding data Masking.html | 61 ++++++++++++++++++++++
report/notes/data masking.html | 61 ++++++++++++++++++++++
...harding proxy single database single table.html | 60 +++++++++++++++++++++
report/notes/sp_master_slave.html | 61 ++++++++++++++++++++++
report/notes/sp_raw.html | 60 +++++++++++++++++++++
report/perf.html | 2 +-
6 files changed, 304 insertions(+), 1 deletion(-)
create mode 100644 report/notes/data Sharding data Masking.html
create mode 100644 report/notes/data masking.html
create mode 100644 report/notes/sharding proxy single database single table.html
create mode 100644 report/notes/sp_master_slave.html
create mode 100644 report/notes/sp_raw.html
[incubator-shardingsphere-benchmark] 07/12: add sharding proxy
single db single table
Posted by zh...@apache.org.
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 1ccd4bc639b2ff7eed53b721a062a97187f25674
Author: geomon <16...@qq.com>
AuthorDate: Wed Sep 18 11:51:53 2019 +0800
add sharding proxy single db single table
---
...harding proxy single database single table.html | 61 ++++++++++++++++++++++
1 file changed, 61 insertions(+)
diff --git a/report/notes/sharding proxy single database single table.html b/report/notes/sharding proxy single database single table.html
new file mode 100644
index 0000000..40aef41
--- /dev/null
+++ b/report/notes/sharding proxy single database single table.html
@@ -0,0 +1,61 @@
+<!doctype html>
+<html>
+<head>
+<meta charset='UTF-8'><meta name='viewport' content='width=device-width initial-scale=1'>
+<title>sharding proxy single database single table</title></head>
+<body><p> </p>
+<p><img src='../scenario_1/select_single.png' alt='insert_single' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Multi table(e.g:t_test_0,t_test_1......)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a SingleDataBase and SingleTable model.We used id, k, c, pad fields in the table.Database fragmentation key is ID, Table fragmentation key is K.
+Sql Example: SELECT id,k FROM t_test WHERE id = # AND k = #
+Comparative type: SELECT
+</code></pre>
+<p><img src='../scenario_1/update_single.png' alt='update_single' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Multi table(e.g:t_test_0,t_test_1......)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a SingleDataBase and SingleTable model.We used id, k, c, pad fields in the table.Database fragmentation key is ID, Table fragmentation key is K.
+Sql Example: UPDATE t_test SET pad = # WHERE id = # AND k = #
+Comparative type: UPDATE
+</code></pre>
+<p><img src='../scenario_1/delete_single.png' alt='delete_single' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Multi table(e.g:t_test_0,t_test_1......)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a SingleDataBase and SingleTable model.We used id, k, c, pad fields in the table.Database fragmentation key is ID, Table fragmentation key is K.
+Sql Example: DELETE FROM t_test WHERE id = # AND k = #
+Comparative type: DELETE
+</code></pre>
+<p><img src='../scenario_1/insert_single.png' alt='insert_single' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Multi table(e.g:t_test_0,t_test_1......)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a SingleDataBase and SingleTable model.We used id, k, c, pad fields in the table.Database fragmentation key is ID, Table fragmentation key is K.
+Sql Example: INSERT INTO t_test(k,c,pad) VALUES(#,#,#)
+Comparative type: INSERT
+</code></pre>
+<p> </p>
+</body>
+</html>
[incubator-shardingsphere-benchmark] 10/12: modify sharding proxy
single db single table
Posted by zh...@apache.org.
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 60b30f5bda01872eccec26aa77dc4c2d2c84307b
Author: geomon <16...@qq.com>
AuthorDate: Wed Sep 18 15:10:24 2019 +0800
modify sharding proxy single db single table
---
report/notes/sharding proxy single database single table.html | 5 ++---
1 file changed, 2 insertions(+), 3 deletions(-)
diff --git a/report/notes/sharding proxy single database single table.html b/report/notes/sharding proxy single database single table.html
index 40aef41..741572d 100644
--- a/report/notes/sharding proxy single database single table.html
+++ b/report/notes/sharding proxy single database single table.html
@@ -3,8 +3,7 @@
<head>
<meta charset='UTF-8'><meta name='viewport' content='width=device-width initial-scale=1'>
<title>sharding proxy single database single table</title></head>
-<body><p> </p>
-<p><img src='../scenario_1/select_single.png' alt='insert_single' referrerPolicy='no-referrer' /></p>
+<body><p><img src='../scenario_1/select_single.png' alt='insert_single' referrerPolicy='no-referrer' /></p>
<pre><code>Comparative Version:
Mysql: 5.1.42(red curve)
ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
@@ -58,4 +57,4 @@ Comparative type: INSERT
</code></pre>
<p> </p>
</body>
-</html>
+</html
[incubator-shardingsphere-benchmark] 09/12: modify sp_raw
Posted by zh...@apache.org.
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 0bdd202750df9dc675f097153e7e498af0a0114c
Author: geomon <16...@qq.com>
AuthorDate: Wed Sep 18 15:09:34 2019 +0800
modify sp_raw
---
report/notes/sp_raw.html | 3 +--
1 file changed, 1 insertion(+), 2 deletions(-)
diff --git a/report/notes/sp_raw.html b/report/notes/sp_raw.html
index 8e46f56..808de4a 100644
--- a/report/notes/sp_raw.html
+++ b/report/notes/sp_raw.html
@@ -3,8 +3,7 @@
<head>
<meta charset='UTF-8'><meta name='viewport' content='width=device-width initial-scale=1'>
<title>sp_raw</title></head>
-<body><p> </p>
-<p><img src='../sp_raw/select_single_raw.png' alt='select_single_raw' referrerPolicy='no-referrer' /></p>
+<body><p><img src='../sp_raw/select_single_raw.png' alt='select_single_raw' referrerPolicy='no-referrer' /></p>
<pre><code>Comparative Version:
Mysql: 5.1.42(red curve)
ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
[incubator-shardingsphere-benchmark] 03/12: add report pic
Posted by zh...@apache.org.
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 85b1d2e597d45f5abe0e8fbfd091cd20df93167f
Author: nancyzrh <zh...@126.com>
AuthorDate: Wed Sep 18 09:58:15 2019 +0800
add report pic
---
report/perf.html | 3 +++
report/scenario_1.html | 6 ++++++
report/scenario_1/delete_single.png | Bin 0 -> 26118 bytes
report/scenario_1/insert_single.png | Bin 0 -> 23674 bytes
report/scenario_1/select_single.png | Bin 0 -> 26514 bytes
report/scenario_1/update_single.png | Bin 0 -> 26447 bytes
report/sp_master_slave.html | 2 ++
report/sp_raw.html | 6 ++++++
report/sp_raw/delete_single_raw.png | Bin 0 -> 32476 bytes
report/sp_raw/insert_single_raw.png | Bin 0 -> 29157 bytes
report/sp_raw/select_single_raw.png | Bin 0 -> 30607 bytes
report/sp_raw/update_single_raw.png | Bin 0 -> 27684 bytes
12 files changed, 17 insertions(+)
diff --git a/report/perf.html b/report/perf.html
new file mode 100644
index 0000000..73c69ab
--- /dev/null
+++ b/report/perf.html
@@ -0,0 +1,3 @@
+<div>
+<a href="./scenario_1.html">sharding proxy single database single table</a><br/><a href="./sp_raw.html">mysql vs sharding proxy</a>
+</div>
diff --git a/report/scenario_1.html b/report/scenario_1.html
new file mode 100644
index 0000000..798b426
--- /dev/null
+++ b/report/scenario_1.html
@@ -0,0 +1,6 @@
+<div>
+<img src='./scenario_1/insert_single.png'>
+<img src='./scenario_1/select_single.png'>
+<img src='./scenario_1/update_single.png'>
+<img src='./scenario_1/delete_single.png'>
+</div>
diff --git a/report/scenario_1/delete_single.png b/report/scenario_1/delete_single.png
new file mode 100644
index 0000000..45a01d4
Binary files /dev/null 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
new file mode 100644
index 0000000..81c6047
Binary files /dev/null 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
new file mode 100644
index 0000000..a337200
Binary files /dev/null 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
new file mode 100644
index 0000000..5bdaab1
Binary files /dev/null and b/report/scenario_1/update_single.png differ
diff --git a/report/sp_master_slave.html b/report/sp_master_slave.html
new file mode 100644
index 0000000..42e45bd
--- /dev/null
+++ b/report/sp_master_slave.html
@@ -0,0 +1,2 @@
+<div>
+</div>
diff --git a/report/sp_raw.html b/report/sp_raw.html
new file mode 100644
index 0000000..962e5a1
--- /dev/null
+++ b/report/sp_raw.html
@@ -0,0 +1,6 @@
+<div>
+<img src='./sp_raw/insert_single_raw.png'>
+<img src='./sp_raw/select_single_raw.png'>
+<img src='./sp_raw/update_single_raw.png'>
+<img src='./sp_raw/delete_single_raw.png'>
+</div>
diff --git a/report/sp_raw/delete_single_raw.png b/report/sp_raw/delete_single_raw.png
new file mode 100644
index 0000000..e675916
Binary files /dev/null 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
new file mode 100644
index 0000000..6de934e
Binary files /dev/null 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
new file mode 100644
index 0000000..0c7c3ff
Binary files /dev/null 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
new file mode 100644
index 0000000..38bb96f
Binary files /dev/null and b/report/sp_raw/update_single_raw.png differ
[incubator-shardingsphere-benchmark] 08/12: add sp master slave
Posted by zh...@apache.org.
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 50c2141f0e8ccac0b89e0038fc38fb4fbd358606
Author: geomon <16...@qq.com>
AuthorDate: Wed Sep 18 11:52:27 2019 +0800
add sp master slave
---
report/notes/sp_master_slave.html | 61 +++++++++++++++++++++++++++++++++++++++
1 file changed, 61 insertions(+)
diff --git a/report/notes/sp_master_slave.html b/report/notes/sp_master_slave.html
new file mode 100644
index 0000000..de80ae5
--- /dev/null
+++ b/report/notes/sp_master_slave.html
@@ -0,0 +1,61 @@
+<!doctype html>
+<html>
+<head>
+<meta charset='UTF-8'><meta name='viewport' content='width=device-width initial-scale=1'>
+<title>sp_master_slave</title></head>
+<body><p><img src='../sp_raw/select_single_raw.png' alt='select_single_raw' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: single
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a MasterSlave model.Including One master, one subordinate.We used id, k, c, pad fields in the table.
+Sql Example:SELECT id,k FROM t_test WHERE id = 1
+Comparative type: SELECT
+</code></pre>
+<p><img src='../sp_raw/select_single_raw.png' alt='select_single_raw' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: single
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a MasterSlave model.Including One master, one subordinate.We used id, k, c, pad fields in the table.
+Sql Example: UPDATE t_test SET pad = # WHERE id = #
+Comparative type: UPDATE
+</code></pre>
+<p><img src='../sp_raw/select_single_raw.png' alt='select_single_raw' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: single
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a MasterSlave model.Including One master, one subordinate.We used id, k, c, pad fields in the table.
+Sql Example: DELETE FROM t_test WHERE id = 1
+</code></pre>
+<p><img src='../sp_raw/select_single_raw.png' alt='select_single_raw' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: single
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a MasterSlave model.Including One master, one subordinate.We used id, k, c, pad fields in the table.
+Sql Example: INSERT INTO t_test(k,c,pad) VALUES(#,#,#)
+Comparative type: INSERT
+</code></pre>
+<p> </p>
+<p> </p>
+<p> </p>
+</body>
+</html>
[incubator-shardingsphere-benchmark] 06/12: add sharding data
masking data
Posted by zh...@apache.org.
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 0aab2e82d54e743398f290044db9b845a55598a1
Author: geomon <16...@qq.com>
AuthorDate: Wed Sep 18 11:50:31 2019 +0800
add sharding data masking data
---
report/notes/data Sharding data Masking.html | 61 ++++++++++++++++++++++++++++
1 file changed, 61 insertions(+)
diff --git a/report/notes/data Sharding data Masking.html b/report/notes/data Sharding data Masking.html
new file mode 100644
index 0000000..4d319a9
--- /dev/null
+++ b/report/notes/data Sharding data Masking.html
@@ -0,0 +1,61 @@
+<!doctype html>
+<html>
+<head>
+<meta charset='UTF-8'><meta name='viewport' content='width=device-width initial-scale=1'>
+<title>data Sharding data Masking</title></head>
+<body><p> </p>
+<p> </p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Multiple tables(e.g:t_test_0,t_test_1,......)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a Data Sharding and Data Masking model.We used id, k, c, pad fields in the table.Including multiple databases and multiple tables.Database fragmentation key is ID, Table fragmentation key is K.
+Sql Example: SELECT id,k FROM t_test WHERE id = # AND k = #
+Comparative type: SELECT
+</code></pre>
+<p><img src='D:/git/shardingsphere-benchmark/report/scenario_1/update_single.png' alt='update_single' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Multiple tables(e.g:t_test_0,t_test_1,......)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a Data Sharding and Data Masking model.We used id, k, c, pad fields in the table.Including multiple databases and multiple tables.Database fragmentation key is ID, Table fragmentation key is K.
+Sql Example: UPDATE t_test SET pad = # WHERE id = # AND k = #
+Comparative type: UPDATE
+</code></pre>
+<p> </p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Multiple tables(e.g:t_test_0,t_test_1,......)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a Data Sharding and Data Masking model.We used id, k, c, pad fields in the table.Including multiple databases and multiple tables.Database fragmentation key is ID, Table fragmentation key is K.
+Sql Example: DELETE FROM t_test WHERE id = # AND k = #
+Comparative type: DELETE
+</code></pre>
+<p> </p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Multiple tables(e.g:t_test_0,t_test_1,......)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a Data Sharding and Data Masking model.We used id, k, c, pad fields in the table.Including multiple databases and multiple tables.Database fragmentation key is ID, Table fragmentation key is K.
+Sql Example: INSERT INTO t_test(k,c,pad) VALUES(#,#,#)
+Comparative type: INSERT
+</code></pre>
+<p> </p>
+</body>
+</html>
[incubator-shardingsphere-benchmark] 01/12: init
Posted by zh...@apache.org.
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 a851fac82d73dd9359f8f2bce60808a9a530b964
Author: nancyzrh <zh...@126.com>
AuthorDate: Tue Sep 17 15:19:53 2019 +0800
init
---
README.md | 1 +
1 file changed, 1 insertion(+)
diff --git a/README.md b/README.md
new file mode 100644
index 0000000..e8a37a7
--- /dev/null
+++ b/README.md
@@ -0,0 +1 @@
+# shardingsphere-benchmark
[incubator-shardingsphere-benchmark] 05/12: add data masking
Posted by zh...@apache.org.
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 fbb4941c1937e691833f382e1f25c1394360010b
Author: geomon <16...@qq.com>
AuthorDate: Wed Sep 18 11:49:30 2019 +0800
add data masking
---
report/notes/data masking.html | 61 ++++++++++++++++++++++++++++++++++++++++++
1 file changed, 61 insertions(+)
diff --git a/report/notes/data masking.html b/report/notes/data masking.html
new file mode 100644
index 0000000..4cd84c6
--- /dev/null
+++ b/report/notes/data masking.html
@@ -0,0 +1,61 @@
+<!doctype html>
+<html>
+<head>
+<meta charset='UTF-8'><meta name='viewport' content='width=device-width initial-scale=1'>
+<title>data masking</title></head>
+<body><p> </p>
+<p> </p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Single table(e.g:t_test)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a Data Masking model.We used id, k, c, pad fields in the table.Including a database and a table.
+Sql Example: SELECT id,k FROM t_test WHERE id = # AND k = #
+Comparative type: SELECT
+</code></pre>
+<p> </p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Single table(e.g:t_test)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a Data Masking model.We used id, k, c, pad fields in the table.Including a database and a table.
+Sql Example: UPDATE t_test SET k = # WHERE id = # AND k = #
+Comparative type: UPDATE
+</code></pre>
+<p> </p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Single table(e.g:t_test)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a Data Masking model.We used id, k, c, pad fields in the table.Including a database and a table.
+Sql Example: DELETE FROM t_test WHERE id = # AND k = #
+Comparative type: DELETE
+</code></pre>
+<p> </p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: Single table(e.g:t_test)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a Data Masking model.We used id, k, c, pad fields in the table.Including a database and a table.
+Sql Example: INSERT INTO t_test(k,c,pad) VALUES(#,#,#)
+Comparative type: INSERT
+</code></pre>
+<p> </p>
+</body>
+</html>
[incubator-shardingsphere-benchmark] 02/12: submit perf data
Posted by zh...@apache.org.
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 3d07de914a12d7b023bef3b89d926981ec030ca4
Author: nancyzrh <zh...@126.com>
AuthorDate: Tue Sep 17 21:17:00 2019 +0800
submit perf data
---
report/data/3.0_single_delete_merge.log_plot | 2 ++
report/data/3.0_single_insert_merge.log_plot | 2 ++
report/data/3.0_single_select_merge.log_plot | 2 ++
report/data/3.0_single_update_merge.log_plot | 2 ++
report/data/3.0_sp_delete_raw_merge.log_plot | 4 ++++
report/data/3.0_sp_insert_raw_merge.log_plot | 4 ++++
report/data/3.0_sp_select_raw_merge.log_plot | 4 ++++
report/data/3.0_sp_update_raw_merge.log_plot | 4 ++++
report/data/4.0_single_delete_merge.log_plot | 2 ++
report/data/4.0_single_insert_merge.log_plot | 2 ++
report/data/4.0_single_select_merge.log_plot | 2 ++
report/data/4.0_single_update_merge.log_plot | 2 ++
report/data/4.0_sp_delete_raw_merge.log_plot | 4 ++++
report/data/4.0_sp_insert_raw_merge.log_plot | 4 ++++
report/data/4.0_sp_select_raw_merge.log_plot | 4 ++++
report/data/4.0_sp_update_raw_merge.log_plot | 4 ++++
report/data/direct_delete_merge.log_plot | 4 ++++
report/data/direct_insert_merge.log_plot | 4 ++++
report/data/direct_select_merge.log_plot | 4 ++++
report/data/direct_update_merge.log_plot | 4 ++++
20 files changed, 64 insertions(+)
diff --git a/report/data/3.0_single_delete_merge.log_plot b/report/data/3.0_single_delete_merge.log_plot
new file mode 100644
index 0000000..ae979a4
--- /dev/null
+++ b/report/data/3.0_single_delete_merge.log_plot
@@ -0,0 +1,2 @@
+summary = 2000000 in 00:00:38 = 53307.7/s Avg: 3 Min: 0 Max: 96 Err: 0 (0.00%)
+summary = 2000000 in 00:00:36 = 55783.3/s Avg: 3 Min: 0 Max: 92 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
new file mode 100644
index 0000000..76abe4f
--- /dev/null
+++ b/report/data/3.0_single_insert_merge.log_plot
@@ -0,0 +1,2 @@
+summary = 2000000 in 00:00:26 = 78428.3/s Avg: 2 Min: 0 Max: 570 Err: 0 (0.00%)
+summary = 2000000 in 00:00:26 = 77818.0/s Avg: 2 Min: 0 Max: 530 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
new file mode 100644
index 0000000..e845a08
--- /dev/null
+++ b/report/data/3.0_single_select_merge.log_plot
@@ -0,0 +1,2 @@
+summary = 2000000 in 00:00:19 = 103428.7/s Avg: 1 Min: 0 Max: 204 Err: 0 (0.00%)
+summary = 2000000 in 00:00:19 = 103316.5/s Avg: 1 Min: 0 Max: 172 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
new file mode 100644
index 0000000..edb0eda
--- /dev/null
+++ b/report/data/3.0_single_update_merge.log_plot
@@ -0,0 +1,2 @@
+summary = 2000000 in 00:08:11 = 4070.5/s Avg: 49 Min: 0 Max: 95 Err: 0 (0.00%)
+summary = 2000000 in 00:08:11 = 4074.7/s Avg: 49 Min: 0 Max: 90 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
new file mode 100644
index 0000000..d8c53b6
--- /dev/null
+++ b/report/data/3.0_sp_delete_raw_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:00:36 = 55643.7/s Avg: 3 Min: 0 Max: 84 Err: 0 (0.00%)
+summary = 2000000 in 00:00:36 = 55981.6/s Avg: 3 Min: 0 Max: 50 Err: 0 (0.00%)
+summary = 2000000 in 00:00:36 = 56047.5/s Avg: 3 Min: 0 Max: 91 Err: 0 (0.00%)
+summary = 2000000 in 00:00:36 = 55265.4/s Avg: 3 Min: 0 Max: 64 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
new file mode 100644
index 0000000..0ec2629
--- /dev/null
+++ b/report/data/3.0_sp_insert_raw_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:00:57 = 35372.6/s Avg: 5 Min: 0 Max: 474 Err: 0 (0.00%)
+summary = 2000000 in 00:00:57 = 35042.2/s Avg: 5 Min: 0 Max: 493 Err: 0 (0.00%)
+summary = 2000000 in 00:00:57 = 35336.3/s Avg: 5 Min: 0 Max: 395 Err: 0 (0.00%)
+summary = 2000000 in 00:00:57 = 35315.1/s Avg: 5 Min: 0 Max: 474 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
new file mode 100644
index 0000000..808ce90
--- /dev/null
+++ b/report/data/3.0_sp_select_raw_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:00:20 = 102396.1/s Avg: 1 Min: 0 Max: 211 Err: 0 (0.00%)
+summary = 2000000 in 00:00:19 = 105836.9/s Avg: 1 Min: 0 Max: 197 Err: 0 (0.00%)
+summary = 2000000 in 00:00:19 = 107834.2/s Avg: 1 Min: 0 Max: 182 Err: 0 (0.00%)
+summary = 2000000 in 00:00:19 = 102595.7/s Avg: 1 Min: 0 Max: 142 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
new file mode 100644
index 0000000..2e6cf96
--- /dev/null
+++ b/report/data/3.0_sp_update_raw_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:08:13 = 4058.3/s Avg: 49 Min: 0 Max: 96 Err: 0 (0.00%)
+summary = 2000000 in 00:08:12 = 4068.0/s Avg: 49 Min: 0 Max: 80 Err: 0 (0.00%)
+summary = 2000000 in 00:08:11 = 4070.8/s Avg: 49 Min: 0 Max: 84 Err: 0 (0.00%)
+summary = 2000000 in 00:08:12 = 4066.0/s Avg: 49 Min: 0 Max: 101 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
new file mode 100644
index 0000000..6bfe0ae
--- /dev/null
+++ b/report/data/4.0_single_delete_merge.log_plot
@@ -0,0 +1,2 @@
+summary = 2000000 in 00:00:36 = 55889.3/s Avg: 3 Min: 0 Max: 83 Err: 0 (0.00%)
+summary = 2000000 in 00:00:36 = 55363.3/s Avg: 3 Min: 0 Max: 57 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
new file mode 100644
index 0000000..381a7a3
--- /dev/null
+++ b/report/data/4.0_single_insert_merge.log_plot
@@ -0,0 +1,2 @@
+summary = 2000000 in 00:00:29 = 69878.8/s Avg: 2 Min: 0 Max: 543 Err: 0 (0.00%)
+summary = 2000000 in 00:00:28 = 71275.8/s Avg: 2 Min: 0 Max: 558 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
new file mode 100644
index 0000000..07ee041
--- /dev/null
+++ b/report/data/4.0_single_select_merge.log_plot
@@ -0,0 +1,2 @@
+summary = 2000000 in 00:00:24 = 84093.7/s Avg: 2 Min: 0 Max: 926 Err: 0 (0.00%)
+summary = 2000000 in 00:00:22 = 89059.1/s Avg: 2 Min: 0 Max: 377 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
new file mode 100644
index 0000000..39b46bc
--- /dev/null
+++ b/report/data/4.0_single_update_merge.log_plot
@@ -0,0 +1,2 @@
+summary = 2000000 in 00:08:09 = 4085.9/s Avg: 48 Min: 0 Max: 125 Err: 0 (0.00%)
+summary = 2000000 in 00:08:10 = 4085.2/s Avg: 48 Min: 0 Max: 83 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
new file mode 100644
index 0000000..5a01669
--- /dev/null
+++ b/report/data/4.0_sp_delete_raw_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:00:36 = 55923.7/s Avg: 3 Min: 0 Max: 73 Err: 0 (0.00%)
+summary = 2000000 in 00:00:36 = 55923.7/s Avg: 3 Min: 0 Max: 73 Err: 0 (0.00%)
+summary = 2000000 in 00:00:36 = 56044.4/s Avg: 3 Min: 0 Max: 56 Err: 0 (0.00%)
+summary = 2000000 in 00:00:36 = 55991.0/s Avg: 3 Min: 0 Max: 102 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
new file mode 100644
index 0000000..bba300e
--- /dev/null
+++ b/report/data/4.0_sp_insert_raw_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:00:58 = 34261.8/s Avg: 5 Min: 0 Max: 421 Err: 0 (0.00%)
+summary = 2000000 in 00:00:58 = 34261.8/s Avg: 5 Min: 0 Max: 421 Err: 0 (0.00%)
+summary = 2000000 in 00:00:57 = 35338.8/s Avg: 5 Min: 0 Max: 407 Err: 0 (0.00%)
+summary = 2000000 in 00:00:57 = 34935.7/s Avg: 5 Min: 0 Max: 455 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
new file mode 100644
index 0000000..3137ebf
--- /dev/null
+++ b/report/data/4.0_sp_select_raw_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:00:21 = 93637.3/s Avg: 2 Min: 0 Max: 259 Err: 0 (0.00%)
+summary = 2000000 in 00:00:21 = 93637.3/s Avg: 2 Min: 0 Max: 259 Err: 0 (0.00%)
+summary = 2000000 in 00:00:22 = 88940.3/s Avg: 2 Min: 0 Max: 573 Err: 0 (0.00%)
+summary = 2000000 in 00:00:22 = 90637.2/s Avg: 2 Min: 0 Max: 697 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
new file mode 100644
index 0000000..2cf3054
--- /dev/null
+++ b/report/data/4.0_sp_update_raw_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:08:10 = 4081.9/s Avg: 48 Min: 0 Max: 119 Err: 0 (0.00%)
+summary = 2000000 in 00:08:10 = 4081.9/s Avg: 48 Min: 0 Max: 119 Err: 0 (0.00%)
+summary = 2000000 in 00:08:12 = 4065.6/s Avg: 49 Min: 0 Max: 147 Err: 0 (0.00%)
+summary = 2000000 in 00:07:20 = 4545.7/s Avg: 43 Min: 0 Max: 193 Err: 0 (0.00%)
diff --git a/report/data/direct_delete_merge.log_plot b/report/data/direct_delete_merge.log_plot
new file mode 100644
index 0000000..5d5b65e
--- /dev/null
+++ b/report/data/direct_delete_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:00:35 = 57296.7/s Avg: 3 Min: 0 Max: 36 Err: 0 (0.00%)
+summary = 2000000 in 00:00:35 = 57196.8/s Avg: 3 Min: 0 Max: 38 Err: 0 (0.00%)
+summary = 2000000 in 00:00:35 = 56435.0/s Avg: 3 Min: 0 Max: 36 Err: 0 (0.00%)
+summary = 2000000 in 00:00:35 = 56702.2/s Avg: 3 Min: 0 Max: 40 Err: 0 (0.00%)
diff --git a/report/data/direct_insert_merge.log_plot b/report/data/direct_insert_merge.log_plot
new file mode 100644
index 0000000..96bf895
--- /dev/null
+++ b/report/data/direct_insert_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:00:54 = 37123.7/s Avg: 5 Min: 0 Max: 254 Err: 0 (0.00%)
+summary = 2000000 in 00:00:55 = 36512.3/s Avg: 5 Min: 0 Max: 314 Err: 0 (0.00%)
+summary = 2000000 in 00:00:55 = 36573.1/s Avg: 5 Min: 0 Max: 248 Err: 0 (0.00%)
+summary = 2000000 in 00:00:54 = 37094.7/s Avg: 5 Min: 0 Max: 263 Err: 0 (0.00%)
diff --git a/report/data/direct_select_merge.log_plot b/report/data/direct_select_merge.log_plot
new file mode 100644
index 0000000..e56d2f6
--- /dev/null
+++ b/report/data/direct_select_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:00:12 = 163746.5/s Avg: 0 Min: 0 Max: 112 Err: 0 (0.00%)
+summary = 2000000 in 00:00:12 = 167771.2/s Avg: 0 Min: 0 Max: 39 Err: 0 (0.00%)
+summary = 2000000 in 00:00:12 = 162087.7/s Avg: 0 Min: 0 Max: 41 Err: 0 (0.00%)
+summary = 2000000 in 00:00:12 = 164839.7/s Avg: 0 Min: 0 Max: 41 Err: 0 (0.00%)
diff --git a/report/data/direct_update_merge.log_plot b/report/data/direct_update_merge.log_plot
new file mode 100644
index 0000000..7f6bca9
--- /dev/null
+++ b/report/data/direct_update_merge.log_plot
@@ -0,0 +1,4 @@
+summary = 2000000 in 00:07:32 = 4420.8/s Avg: 45 Min: 0 Max: 165 Err: 0 (0.00%)
+summary = 2000000 in 00:07:31 = 4431.3/s Avg: 45 Min: 0 Max: 111 Err: 0 (0.00%)
+summary = 2000000 in 00:07:32 = 4422.2/s Avg: 45 Min: 0 Max: 132 Err: 0 (0.00%)
+summary = 2000000 in 00:08:17 = 4024.4/s Avg: 49 Min: 0 Max: 108 Err: 0 (0.00%)
[incubator-shardingsphere-benchmark] 11/12: modify perf
Posted by zh...@apache.org.
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 0f99102ff4e9c891db00ddcc7a043515b266414a
Author: geomon <16...@qq.com>
AuthorDate: Wed Sep 18 15:11:08 2019 +0800
modify perf
---
report/perf.html | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/report/perf.html b/report/perf.html
index 73c69ab..0aedb7b 100644
--- a/report/perf.html
+++ b/report/perf.html
@@ -1,3 +1,3 @@
<div>
-<a href="./scenario_1.html">sharding proxy single database single table</a><br/><a href="./sp_raw.html">mysql vs sharding proxy</a>
+<a href="./notes/sharding proxy single database single table.html">sharding proxy single database single table</a><br/><a href="./notes/sp_raw.html">mysql vs sharding proxy</a>
</div>
[incubator-shardingsphere-benchmark] 04/12: add sp_raw
Posted by zh...@apache.org.
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 64761ac167fca7e987689a00d77c5043b1296008
Author: geomon <16...@qq.com>
AuthorDate: Wed Sep 18 11:48:02 2019 +0800
add sp_raw
---
report/notes/sp_raw.html | 61 ++++++++++++++++++++++++++++++++++++++++++++++++
1 file changed, 61 insertions(+)
diff --git a/report/notes/sp_raw.html b/report/notes/sp_raw.html
new file mode 100644
index 0000000..8e46f56
--- /dev/null
+++ b/report/notes/sp_raw.html
@@ -0,0 +1,61 @@
+<!doctype html>
+<html>
+<head>
+<meta charset='UTF-8'><meta name='viewport' content='width=device-width initial-scale=1'>
+<title>sp_raw</title></head>
+<body><p> </p>
+<p><img src='../sp_raw/select_single_raw.png' alt='select_single_raw' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: single Table(e.g:t_test)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a model for connecting directly to a database through a proxy.We used id, k, c, pad fields in the table.Including a database and a table.
+Sql Example: SELECT id,k FROM t_test WHERE id = # AND k = #
+Comparative type: SELECT
+</code></pre>
+<p><img src='../sp_raw/update_single_raw.png' alt='update_single_raw' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: single Table(e.g:t_test)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a model for connecting directly to a database through a proxy.We used id, k, c, pad fields in the table.Including a database and a table.
+Sql Example: UPDATE t_test SET k = # WHERE id = # AND k = #
+Comparative type: UPDATE
+</code></pre>
+<p><img src='../sp_raw/delete_single_raw.png' alt='delete_single_raw' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: single Table(e.g:t_test)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a model for connecting directly to a database through a proxy.We used id, k, c, pad fields in the table.Including a database and a table.
+Sql Example: DELETE FROM t_test WHERE id = # AND k = #
+Comparative type: DELETE
+</code></pre>
+<p><img src='../sp_raw/insert_single_raw.png' alt='insert_single_raw' referrerPolicy='no-referrer' /></p>
+<pre><code>Comparative Version:
+ Mysql: 5.1.42(red curve)
+ ShardingSphere-proxy: 3.0(blue curve) or 4.0(aqua curve)
+Table Number: single Table(e.g:t_test)
+Data Volume: 200w
+Axis:
+ X: (TEST TIMES)/DAY
+ Y: TPS
+Scene Description：This is a model for connecting directly to a database through a proxy.We used id, k, c, pad fields in the table.Including a database and a table.
+Sql Example: INSERT INTO t_test(k,c,pad) VALUES(#,#,#)
+Comparative type: INSERT
+</code></pre>
+<p> </p>
+</body>
+</html>
[incubator-shardingsphere-benchmark] 12/12: Merge pull request #1
from geomonlin/master
Posted by zh...@apache.org.
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 aad924c87ec82227a7c145a48b58d5c1848dc4d5
Merge: 85b1d2e 0f99102
Author: nancyzrh <zh...@126.com>
AuthorDate: Wed Sep 18 17:00:21 2019 +0800
Merge pull request #1 from geomonlin/master
Add notes
report/notes/data Sharding data Masking.html | 61 ++++++++++++++++++++++
report/notes/data masking.html | 61 ++++++++++++++++++++++
...harding proxy single database single table.html | 60 +++++++++++++++++++++
report/notes/sp_master_slave.html | 61 ++++++++++++++++++++++
report/notes/sp_raw.html | 60 +++++++++++++++++++++
report/perf.html | 2 +-
6 files changed, 304 insertions(+), 1 deletion(-)