create table e_test (id int, cnt int) engine = InnoDb;

DELIMITER $$
CREATE EVENT e_test
    ON SCHEDULE EVERY 1 minute
    STARTS CURRENT_TIMESTAMP 
    ENDS CURRENT_TIMESTAMP  + INTERVAL 3 minute
    DO
    begin
      declare max_id , i int;
        
        select max(id) + 1
          from e_test
          into max_id; 
        
        SET i = 0 ;
        SET max_id = ifnull(max_id,0); 
        
        while (i < 180) do 
            
            insert into e_test values (max_id , i) ; 
            
            SET i = i + 1;
            
            select sleep(1);
        
        end while ; 
    end ; $$      
DELIMITER ;

# Id, User, Host, db, Command, Time, State, Info
'23', 'root', '192.168.56.1:53619', 'master', 'Sleep', '30', '', NULL
'24', 'root', '192.168.56.1:53620', 'master', 'Query', '0', 'starting', 'SHOW FULL PROCESSLIST'
'771', 'event_scheduler', 'localhost', NULL, 'Daemon', '17', 'Waiting for next activation', NULL
'1082', 'root', '192.168.56.1:54960', NULL, 'Sleep', '3491', '', NULL
'1083', 'root', '192.168.56.1:54961', NULL, 'Sleep', '3', '', NULL
'4568', 'root', '192.168.56.1', 'master', 'Connect', '1', 'User sleep', 'select sleep(1)'
'4628', 'root', '192.168.56.1', 'master', 'Connect', '1', 'User sleep', 'select sleep(1)'