SET tmp_table_size=10*1024*1024*1024;
SET max_heap_table_size=10*1024*1024*1024;

CREATE TABLE t1 (a CHAR(127)) ENGINE = MEMORY;
INSERT INTO t1 VALUES ( REPEAT('a', 127) );
INSERT INTO t1 VALUES ( REPEAT('a', 127) );
INSERT INTO t1 SELECT a FROM t1;
INSERT INTO t1 SELECT a FROM t1;
INSERT INTO t1 SELECT a FROM t1;
INSERT INTO t1 SELECT a FROM t1;
INSERT INTO t1 SELECT a FROM t1;
INSERT INTO t1 SELECT a FROM t1;
INSERT INTO t1 SELECT a FROM t1;
INSERT INTO t1 SELECT a FROM t1;

DELIMITER |;
CREATE PROCEDURE p1(iterations INTEGER)
BEGIN
  DECLARE res INTEGER;
  WHILE iterations > 0 DO
    SELECT 1 INTO res FROM t1 ORDER BY a LIMIT 1;
    SET iterations = iterations - 1;  
 END WHILE;
END|
DELIMITER ;|

--start_timer
CALL p1(15000);
--end_timer

DROP TABLE t1;
DROP PROCEDURE p1;