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
