TechNNX

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;