RE: Large sites using dbmail?

Hi Andrew - 

> email accounts: 6000
> email storage: 150G and growing
> Are there any sites out there of similar size or larger using dbmail?

Yep. We're up to about 150G now - just pricing up a fibre channel array now
to plan for the future growth. We've got about 50,000 mail accounts loaded;
but only about 10,000 are checking every regularly.

> Please provide details on your setup as well as any gotchas you
encountered.

Database is on a dedicated linux box -- dual Xeon 2.4 with SCSI U160 HDs (at
moment) and about 12G of memory. 
We run (currently) six dedicated smtp servers; and 3 pop/imap servers.
Handles the load nicely in general -- although we do virus and spam
filtering so sometimes the front-end servers get a it loaded.

Biggest problem for me at the moment is MySQL tuning. We keep 'running out
of thread memory' and I can't seem to find the right mysql config settings
to solve it. I'm certain MySQL will handle more connections; but I suspect
I'm going to have to pay for the mysql.com to 'optimize' my database so it
hums along.

We recently had a problem with quota calculations taking too long to
calculate; although we are running an older version so this may be fixed. I
simply disabled the quota calc (added 2 lines in the code) and substantially
reduced the database CPU. 

Database load was about 50-100%; but with the quota calcs disabled this
dropped to about 10-50%. MySQL rocks :)


/Mark