query select with large result set in stress test, dble restart or abort client connection

[actiontech-bot]

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 : select a.k from test1 a inner join test2 b where a.k = b.k limit 100  

* Command:

./sysbench --test=../db/select.lua --mysql-table-engine=innodb --mysql-user=action --mysql-password=action --mysql-port=8066 --mysql-host=10.186.17.107 --mysql-db=hly_test  --max-requests=0  --max-time=120 --oltp-tables-count=2 --report-interval=1 --oltp-nontrx-mode=select --oltp-table-size=50000000 --num-threads=512  run   

2. Case1 found:

   1. Make stress for a while, stop sysbench, dble cpu usage lasts high, and then it's restarted for unknown reason.
   2. Make stress for a while, client connections will be abort.

3. Case2 works find

[actiontech-bot]

Case1 found2 log attached: hs_err_pid79463.log.zip