dble
dble copied to clipboard
actiontech
A High Scalability Middle-ware for MySQL Sharding
steps: dble: ``` mysql> set @abc=3; Query OK, 0 rows affected (0.00 sec) mysql> set @$=5; ERROR 1064 (HY000): java.sql.SQLSyntaxErrorException: syntax error, expect EQ, actual IDENTIFIER $ mysql> set @.=6;...
Raised by: helingyun **Steps:** 1. Sysbench makes stress test * SQL: ``` case1 : select a.k from test1 a inner join test2 b where a.k = b.k limit 4000000 case2...
Raised by: @zhunina Steps: 1. Execute ``` create table binary_columns( id int primary key, c_binary binary(255) ); ``` 2. Load Data: `load data local infile '/opt/loaddata/binary_columns' into table binary_columns fields...
Raised by: helingyun Steps: 1. set limit on network band-width by TC 2. Found errors in Dble logs: ``` 2017-05-22 14:51:25.105 WARN [Timer0] (io.mycat.backend.mysql.nio.handler.SingleNodeHandler.backConnectionErr(SingleNodeHandler.j ava:182)) - execute sql err :...
Raised by: helingyun Steps: 1. Prepare data: 2 nodes, 2 tables on each node, 50000000 rows in each table 2. Sysbench 2048-thread queries: `select min(my_max_money),my_creditcard,my_comsume_money from user_creditcard_info where id between...
Raised by: helingyun Steps: 1. Prepare data: 2 nodes, 2 tables on each node, 50000000 rows in each table 2. Sysbench 2048-thread queries: `select my_name,my_idcard,my_phone from user_info WHERE id between...
Raised by: @yanhuqing666 As titled.
Raised by: @yanhuqing666 MySQL 5.7 has CLIENT_DEPRECATE_EOF capability, and protocol changes.
Raised by: helingyun **Steps:** 1. Prepare: 2 data-nodes, 2 tables on each node, 50000000 rows in each table 2. Sysbench 2048 threads: `rand_num = sb_rand(1, oltp_table_size-100) bak_num = rand_num +...
Raised by: helingyun **Steps:** 1. Prepare: 2 data-nodes, 2 tables on each node, 50000000 rows in each table 2. Sysbench 2048 threads: `select ... id between a and a+100 order...
Metadata
Owner
Metadata
A High Scalability Middle-ware for MySQL Sharding