Как научить MySQL заглядывать в прошлое

DELIMITER $
DROP PROCEDURE IF EXISTS speed_test$
CREATE PROCEDURE speed_test(n INT)
BEGIN
    DECLARE i INT DEFAULT 0;
    WHILE i < n DO
        INSERT INTO docs (num, date, warehouse, partner)
        VALUES (CONCAT('тест', i), DATE(NOW()), 'Склад Новосибирск', 'Радуга, ЗАО');
        SET i := i + 1;
    END WHILE;
END$

-- 1. с триггерами и протоколированием
DELIMITER ;
BEGIN;
CALL speed_test(10000);
ROLLBACK;
MariaDB [test-habr]> DELIMITER ;
MariaDB [test-habr]> BEGIN;
Query OK, 0 rows affected (0.00 sec)
MariaDB [test-habr]> CALL speed_test(10000);
Query OK, 1 row affected (6.89 sec)
MariaDB [test-habr]> ROLLBACK;
Query OK, 0 rows affected (0.88 sec)

-- 2. с триггерами, протоколирование отключено программно
DELIMITER ;
BEGIN;
SET @disable_all_prot_trg = 1;
CALL speed_test(10000);
SET @disable_all_prot_trg = NULL;
ROLLBACK;
MariaDB [test-habr]> DELIMITER ;
MariaDB [test-habr]> BEGIN;
Query OK, 0 rows affected (0.00 sec)
MariaDB [test-habr]> SET @disable_all_prot_trg = 1;
Query OK, 0 rows affected (0.00 sec)
MariaDB [test-habr]> CALL speed_test(10000);
Query OK, 1 row affected (2.17 sec)
MariaDB [test-habr]> SET @disable_all_prot_trg = NULL;
Query OK, 0 rows affected (0.00 sec)
MariaDB [test-habr]> ROLLBACK;
Query OK, 0 rows affected (0.12 sec)

-- 3. без триггеров
DELIMITER ;
DROP TRIGGER IF EXISTS docs_aft_ins_trg;
BEGIN;
CALL speed_test(10000);
ROLLBACK;
MariaDB [test-habr]> DELIMITER ;
MariaDB [test-habr]> DROP TRIGGER IF EXISTS docs_aft_ins_trg;
Query OK, 0 rows affected (0.00 sec)
MariaDB [test-habr]> BEGIN;
Query OK, 0 rows affected (0.00 sec)
MariaDB [test-habr]> CALL speed_test(10000);
Query OK, 1 row affected (1.37 sec)
MariaDB [test-habr]> ROLLBACK;
Query OK, 0 rows affected (0.12 sec)