dble icon indicating copy to clipboard operation
dble copied to clipboard

stress test on `between`, CPU high

Open actiontech-bot opened this issue 8 years ago • 0 comments

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 + 100 rs = db_query("select * from user_creditcard_info where id between "..rand_num.." and "..bak_num)

Log java.log.zip

Analysis image

actiontech-bot avatar Aug 25 '17 11:08 actiontech-bot