Hi.
I have read and (probably) understood what has to be done on MySQL
before migrating from 2.3 to 2.4.
/* I am currently filling-up a test database in order to test if the
maintainance is actually faster with these DELETE CASCADE statements.
All 2.4 native. */
I am wondering if any DELETEion improvement can be achieved with 2.3.3
if I skip this (source: http://www.ijs.si/software/amavisd/README.sql.txt)
ALTER TABLE msgs ADD quar_loc varchar(255) DEFAULT '';
and just apply these to the existing DB:
ALTER TABLE quarantine
ADD FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE;
ALTER TABLE msgrcpt
ADD FOREIGN KEY (mail_id) REFERENCES msgs(mail_id) ON DELETE CASCADE;
--ALTER TABLE msgs
-- ADD FOREIGN KEY (sid) REFERENCES maddr(id) ON DELETE RESTRICT;
--ALTER TABLE msgrcpt
-- ADD FOREIGN KEY (rid) REFERENCES maddr(id) ON DELETE RESTRICT;
Moreover why are these commented out? CREATE TABLE statements do have them.
We have a 50GB (fifty GigaB) quarantine table on the production server,
and the last quarantine purge run took 14 hours to complete. All traffic
was queued because of DB locks and timeouts. We clean every second day
for spam >30 days and viruses >15 days, but will probably move to
once-a-week.
So, what I'm asking is: can I apply just "ALTER TABLE... ON DELETE
RESTRICT|CASCADE" statements to my 2.3.x MySQL installation and expect
delete speed improvements? The DB schema should stay compatible with
amavisd-new 2.3.3, or not? Should I need to re-create indexes?
Has anyone done some tests?
TIA,
Paolo Cravero
-------------------------------------------------------
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/
