--source include/have_sequence.inc

--source include/have_innodb.inc

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

# This is to create some activity worth purging

--delimiter $

CREATE TABLE x (id INT PRIMARY KEY, val TEXT) ENGINE=InnoDB $

--send

  LOOP

    START TRANSACTION;

    INSERT INTO x VALUES (1, 'abc');

    DELETE FROM x WHERE id = 1;

    COMMIT;

  END LOOP $

--delimiter ;

--connection default

CREATE TABLE cor (a INT) ENGINE=InnoDB;

--send CREATE OR REPLACE TABLE cor ENGINE=InnoDB AS SELECT seq FROM seq_1_to_10000000

--connect (con2,localhost,root,,)

# This is a monitor

--disable_query_log

while (1)

{

  --let $status= `show engine innodb status`

  --eval SELECT SUBSTRING("$status", LOCATE("Purge done for trx's n:o", "$status"), 85) AS st

  --sleep 1

}

Purge done for trx's n:o < 32 undo n:o < 1 state: running

History list length 4936

st

Purge done for trx's n:o < 32 undo n:o < 1 state: running

History list length 8240

...

...

...

Purge done for trx's n:o < 32 undo n:o < 1 state: running

History list length 532453