Deleting millions of rows from MySQL

deleting.py

import MySQLdb

rows_at_a_time = 100000

conn = # ...
cursor = conn.cursor()

while True:
  cursor.execute("DELETE FROM mytable WHERE id < 2000000 LIMIT %d" % rows_at_a_time)
  if cursor.rowcount < rows_at_a_time:
    break