数据库

mysql 删除数据过大，慢慢删除

云博小周宇1 Min Read
      • DELETE from pop_product.schedule_task_2 where r_id< 13390405 and status=2 limit 200000;  
      •   pt-archiver –source h=localhost,P=3306,S=‘/tmp/mysql.sock‘,u=,p=‘‘,D=pop_product,t=schedule_task_2 \
        –purge –where “r_id< 13390405 and status=2” \
        –charset=utf8 –no-check-charset –statistics –limit=3000 –txn-size 3000 –progress 3000