Archive old MySQL rows to another table

adsArchiver.sql

CREATE DEFINER=`grs`@`localhost` PROCEDURE `ads_archive_updater`()
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT 'Ads archive updater'
BEGIN
	START TRANSACTION;
		
		SELECT COUNT(*) FROM Ads INTO @adsTotal;
		SELECT COUNT(*) AS `totalBefore` FROM AdsArchive INTO @archiveBefore;
		
		SELECT `ID` FROM Ads ORDER BY `ID` DESC LIMIT 1000000, 1 INTO @minimalAdId;
		
		INSERT IGNORE INTO AdsArchive SELECT * FROM Ads WHERE `ID` < @minimalAdId LIMIT 500000;
		
		SELECT FOUND_ROWS() INTO @archivedRows;
		
		SELECT COUNT(*) AS `totalAfter` FROM AdsArchive INTO @archiveAfter;
		
		DELETE FROM Ads WHERE `ID` < @minimalAdId LIMIT 500000;
		
		SELECT ROW_COUNT() INTO @deletedRows;
		
		SELECT @adsTotal AS `adsTotal`, 
				 @archiveBefore AS `archiveBefore`, 
				 @archiveAfter AS `archiveAfter`, 
				 @minimalAdId AS `minimalAdId`, 
				 @archivedRows AS `archivedRows`,
				 @deletedRows AS `deletedRows`;

	COMMIT; 
	# ROLLBACK;
END