hhmmmm

Klei­ner Befehl, große Aus­wir­kung … und das war noch die klei­nere Tabelle:


mysql> set @a=to_days(current_date());
Query OK, 0 rows affected (0.00 sec)


mysql> delete from dspam_token_data
-> where (innocent_hits*2) + spam_hits < 5
-> and @a-to_days(last_hit) > 60;
Query OK, 9496191 rows affected (6 hours 2 min 23.92 sec)