generate fragmented table

gistfile1.sql

DELIMITER $$

CREATE PROCEDURE `createfragTable`()
BEGIN

    DECLARE ii INT DEFAULT 0;

    DROP TABLE IF EXISTS fragme;
    CREATE  TABLE fragme (
      `id` INT NOT NULL AUTO_INCREMENT ,
      `col0` BLOB NULL ,
      `col1` BLOB NULL ,
      `col2` BLOB NULL ,
      `col3` BLOB NULL ,
      `col4` BLOB NULL ,
      `col5` BLOB NULL ,
      `col6` BLOB NULL ,
      `col7` BLOB NULL ,
      `col8` BLOB NULL ,
      `col9` BLOB NULL ,
      PRIMARY KEY (`id`) 
    );
 
    -- seed the table
    INSERT INTO fragme (col0,col1,col2,col3,col4,col5,col6,col7,col8,col9)
    SELECT UUID(), UUID(),UUID(),UUID(),UUID(),UUID(),UUID(),UUID(),UUID(),UUID()
    ;

    WHILE ii <= 20 DO
        INSERT INTO fragme (col0,col1,col2,col3,col4,col5,col6,col7,col8,col9)
        SELECT col0,col1,col2,col3,col4,col5,col6,col7,col8,col9 
        FROM fragme
        ;
        SET ii = ii + 1;
    END WHILE;


END
$$

DELIMITER ;

call createfragTable();
DELETE FROM fragme
WHERE id % 2 = 0;