Re: [Mailzu-users] Disabling "Email Administrator" function

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

(hope this doesn't get sent twice, since Thunderbird crashed while 
sending the first!)

Sam Tran wrote:

Hi

 > I was wondering what type of speed MailZu users experience when they
 > display their quarantine or the site wide quarantine (for admins). It
 > obviously depends on the size of the database and how it was
 > optimized. MailZu RC3 uses LEFT JOINs when doing SELECT for the

Unfortunately our current userbase is limited to a very small domain 
(this one I'm using), but I've just finished installing one of the three 
machines that will host amavisd+ClamAV in production for a larger 
userbase (circa 80k).

I think my current data is not too meaningful, anyway here it is.

Our current setup is (3 servers):
- amavisd on one machine. Bayes is on local filesystem
- MySQL 4.1 on a Athlon 64 3500+ with RH7.3 and somewhat a broken driver 
for the SCSI controller (I fear it is not full duplex or something...). 
This PC hosts also OpenLDAP server for amavisd&MailZu
- MailZu on a Linux RH ES3 virtual machine (host server quite unloaded)

The MySQL DB looks like this:
-rw-rw----    1 mysql    mysql          65 Aug  4 11:31 db.opt
-rw-rw----    1 mysql    mysql        8622 Aug  4 11:33 maddr.frm
-rw-rw----    1 mysql    mysql    16777216 Oct  6 16:00 maddr.ibd
-rw-rw----    1 mysql    mysql        8782 Aug  4 11:33 msgrcpt.frm
-rw-rw----    1 mysql    mysql    41943040 Oct  6 16:00 msgrcpt.ibd
-rw-rw----    1 mysql    mysql        9154 Aug  4 11:33 msgs.frm
-rw-rw----    1 mysql    mysql    83886080 Oct  6 16:00 msgs.ibd
-rw-rw----    1 mysql    mysql        8646 Aug  4 11:33 quarantine.frm
-rw-rw----    1 mysql    mysql  9827254272 Oct  6 15:26 quarantine.ib

but I think quarantine table is not full.

"select count(*) from quarantine where chunk_ind=1;" returns 4379.
quarantine table has 5055 total rows.

My own quarantine has 1727 spams, and there is no annoying wait time.
My client is Mozilla Firefox 1.0.7 on WinXP Pentium Mobile 1.7G.

I can run some batch tests if you want.

Paolo