dble
dble copied to clipboard
stress test on `between`, CPU high
Raised by: helingyun Steps:
- Prepare: 2 data-nodes, 2 tables on each node, 50000000 rows in each table
- Sysbench 2048 threads:
rand_num = sb_rand(1, oltp_table_size-100) bak_num = rand_num + 100 rs = db_query("select * from user_creditcard_info where id between "..rand_num.." and "..bak_num)
Log java.log.zip
Analysis
