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:32 UTC
[incubator-shardingsphere-benchmark] 07/12: add sharding proxy
single db single table
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>