delete from my_table_name where id not in(select id from (SELECT min(id) as id FROM my_table_name group by `col1`,`col2`) as t1) limit 1000;
delete from my_table_name where id not in(select id from (SELECT min(id) as id FROM my_table_name group by `col1`,`col2`) as t1) limit 1000;