SET @a=CONCAT(REPEAT(_utf8'a' COLLATE utf8_unicode_ci, 360));

SELECT BENCHMARK(500000, WEIGHT_STRING(@a,1024,960,128));

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (pk SERIAL, field CHAR(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci);

INSERT t1 (field)

WITH  RECURSIVE int_seq AS (

  SELECT 1 AS val

  UNION ALL

  SELECT val + 1

  FROM int_seq

  WHERE val < 1000

) SELECT CONCAT('a',val%255,REPEAT('b',100)) FROM int_seq;

DROP PROCEDURE IF EXISTS p1;

DELIMITER $$

CREATE PROCEDURE p1()

BEGIN

  DECLARE a INT DEFAULT 100000;

  WHILE (a > 0)

  DO

    SELECT field INTO @a FROM t1 WHERE pk BETWEEN 1 AND 11 ORDER BY field LIMIT 1;

    SET a=a-1;

  END WHILE;

END;

$$

DELIMITER ;

CALL p1;