DROP PROCEDURE IF EXISTS p1;

DELIMITER $$

CREATE PROCEDURE p1()

BEGIN

  DECLARE i INT DEFAULT 1;

  WHILE i <= 500000

  DO

    BEGIN

      DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' SET @x=1;

      IF (i % 100000 = 0) THEN

        SHOW STATUS LIKE 'Memory_used';

      END IF;

    END;

    SET i=i+1;

  END WHILE;

END;

$$

DELIMITER ;

CALL p1;

+---------------+---------+

| Variable_name | Value   |

+---------------+---------+

| Memory_used   | 5664384 |

+---------------+---------+

1 row in set (2.36 sec)

+---------------+----------+

| Variable_name | Value    |

+---------------+----------+

| Memory_used   | 11264384 |

+---------------+----------+

1 row in set (4.67 sec)

+---------------+----------+

| Variable_name | Value    |

+---------------+----------+

| Memory_used   | 16864384 |

+---------------+----------+

1 row in set (6.96 sec)

+---------------+----------+

| Variable_name | Value    |

+---------------+----------+

| Memory_used   | 22464384 |

+---------------+----------+

1 row in set (9.26 sec)

+---------------+----------+

| Variable_name | Value    |

+---------------+----------+

| Memory_used   | 28064384 |

+---------------+----------+

1 row in set (11.59 sec)