DELETE FROM phplist_linktrack where DATEDIFF(NOW(), latestclick) > 100 LIMIT 10000; DELETE FROM phplist_linktrack_userclick WHERE DATEDIFF(NOW(), date) > 100 LIMIT 10000; CREATE TABLE phplist_linktrack_new LIKE phplist_linktrack; ALTER TABLE phplist_linktrack_new DISABLE KEYS; INSERT INTO phplist_linktrack_new SELECT * FROM phplist_linktrack; ALTER TABLE phplist_linktrack RENAME phplist_linktrack_old; ALTER TABLE phplist_linktrack_new RENAME phplist_linktrack; ALTER TABLE phplist_linktrack ENABLE KEYS; DROP TABLE phplist_linktrack_old;