Large table Batch Delete script MySQL version

It is often necessary to periodically delete historical data from certain tables, which are often very large, and in order to mitigate the impact on the online environment, they must be deleted in small batches.

Previously shared version of SQL Server.

Here is the MySQL version:

1 delimiter $$2 Drop procedure if existsProc_delete_old_data;3 Create procedureProc_delete_old_data ()4 begin5 Lp:loop6     Delete  fromMyTablewhereCreatedtime<=Date_sub (Curdate (), Interval1 Month) limit the;7     ifRow_count ()<  the  Then8 leave LP;9     End if;Ten     SelectSleep1); One EndLoop; A End $$ -  - delimiter; the SetBinlog_format=STATEMENT; -Call Proc_delete_old_data;

This address: http://www.cnblogs.com/ajiangg/p/6604317.html

Large table Batch Delete script MySQL version