Différences

Ci-dessous, les différences entre deux révisions de la page.

@@ Ligne 1: / Ligne 1: @@
+<code sql>
+DELETE FROM phplist_linktrack where DATEDIFF(NOW(), latestclick) > 100 LIMIT 10000;
+DELETE FROM phplist_linktrack_userclick WHERE DATEDIFF(NOW(), date) > 100 LIMIT 10000;
+</code>
+<code sql>
+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;
+</code>

TechNNX