Cami wrote:
Keep far far away from these queries, they are slow.
But probably keep data consistent...
DELETE FROM quarantine WHERE time_num < UNIX_TIMESTAMP() - 7*24*60*60; (make sure you have an index on time_num)
From http://www.ijs.si/software/amavisd/README.sql.txt : CREATE TABLE quarantine ( mail_id varchar(12) NOT NULL, -- long-term unique mail id chunk_ind integer unsigned NOT NULL, -- chunk number, starting with 1 mail_text text NOT NULL, -- store mail as chunks up to 16 kB PRIMARY KEY (mail_id,chunk_ind), FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE ) ENGINE=InnoDB; I don't see any "time_num" column there. How can that work for you? Paolo ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
