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 <1623537...@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>