--source include/have_sequence.inc

--connect(con1,localhost,root,,)

--send

  select * from seq_1_to_10000000 where seq%1000000 = 0;

--connection default

--let $run= 10

while ($run)

{

  --sleep 1

  query_vertical select * from information_schema.processlist where id != connection_id();

  --dec $run

}

--connection con1

--reap

select * from information_schema.processlist where id != connection_id();

ID	5

USER	root

HOST	localhost

DB	test

COMMAND	Query

TIME	10

STATE	Sending data

INFO	select * from seq_1_to_10000000 where seq%1000000 = 0

TIME_MS	10031.634

STAGE	0

MAX_STAGE	0

PROGRESS	0.000

MEMORY_USED	106424

MAX_MEMORY_USED	106424

EXAMINED_ROWS	0

QUERY_ID	23

INFO_BINARY	select * from seq_1_to_10000000 where seq%1000000 = 0

TID	2218428

connection con1;

seq

1000000

2000000

3000000

4000000

5000000

6000000

7000000

8000000

9000000

10000000