At 03:47 PM 7/2/2008, Steve wrote: > > I've noticed that MailZu now takes very very long to execute it's > > queries. I believe this to be because the maddr table no longer has > > an index on the email column. Would adding that index in there as a > > non-unique really fubar anything? > > >I don't think so. What engine are you using in MySQL for the table >maddr? InnoDB or MYISAM?
All the storage data is in InnoDB. Includes maddr, msgrcpt, msgs, quarantine tables. At the time it was highly recommended to use InnoDB for these tables, I assume that still the case? Because the DB was getting so bogged down yesterday after upgrading the tables per the docs, I did already add they index on the email col. So far so good. The Index size is 200M instead of the usual 100M, but other than eating a little memory I haven't noticed any adverse affects, and it definitly sped up the queries for our scripts and the MailZu scripts by a factor of about 500. - Nathan ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/