MySQL实现循环插入千万级数据

CREATE TABLE `mysql_genarate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uuid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5999001 DEFAULT CHARSET=utf8;

CREATE DEFINER=`root`@`localhost` PROCEDURE `test_two1`( )
	BEGIN 
	DECLARE i INT DEFAULT 0;
	WHILE i < 3000 DO
		INSERT INTO mysql_genarate ( uuid ) VALUES( UUID( ) );
		SET i = i + 1;
	END WHILE;
END

CREATE DEFINER=`root`@`localhost` PROCEDURE `insertPro`( IN sum INT )
	BEGIN
	DECLARE count INT DEFAULT 0;
	DECLARE i INT DEFAULT 0;
	SET @exesql = concat( "insert into mysql_genarate(uuid) values" );
	SET @exedata = "";
	SET count = 0;
	SET i = 0;
	WHILE count < sum DO
		SET @exedata = concat( @exedata, ",(UUID())" );
		SET count = count + 1;
		SET i = i + 1;
		IF i % 1000 = 0 THEN
			SET @exedata = SUBSTRING( @exedata, 2 );
			SET @exesql = concat( "insert into mysql_genarate(uuid) values ", @exedata );
			PREPARE stmt FROM @exesql;
			EXECUTE stmt;
			DEALLOCATE PREPARE stmt;
			SET @exedata = "";
		END IF;
	END WHILE;
	IF length( @exedata ) > 0 THEN
		SET @exedata = SUBSTRING( @exedata, 2 );
		SET @exesql = concat( "insert into mysql_genarate(uuid) values ", @exedata );
		PREPARE stmt FROM @exesql;
		EXECUTE stmt;
		DEALLOCATE PREPARE stmt;
	END IF;
END