Delete millions of rows from MySQL/TiDB

mysql-big-deletes.py

import os
import pymysql


if __name__ == '__main__':
    ret = 1
    conn = pymysql.connect(
        host='tidb-cluster.dm',
        port=4000,
        user='dm',
        password=os.getenv('DBPW'),
        db='dm',
        charset='utf8mb4',
        autocommit=True)
    with conn.cursor() as cur:
        while ret:
            ret = cur.execute("delete from <bigdatatable> where <conditions> limit 200000")
            print(ret)