Hi Paul, The dbmail_domains table is just one we had created for doing virtual_domains in postfix and doing sql transport lookups:
| dbmail_domains | CREATE TABLE `dbmail_domains` ( `ID` int(10) NOT NULL AUTO_INCREMENT, `domainName` varchar(255) DEFAULT NULL, `client_idnr` bigint(21) NOT NULL DEFAULT '0', `transport` varchar(255) NOT NULL DEFAULT 'lmtp:192.168.1.9:26', `plesk` tinyint(1) DEFAULT '0', `dbmail_island` tinyint(1) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB AUTO_INCREMENT=7573 DEFAULT CHARSET=utf8 | mysql> select * from dbmail_domains limit 1; +----+----------------+-------------+------------------------+-------+---------------+ | ID | domainName | client_idnr | transport | plesk | dbmail_island | +----+----------------+-------------+------------------------+-------+---------------+ | 6 | testdomain.com | 0 | lmtp:[192.168.1.61]:28 | 0 | 1 | +----+----------------+-------------+------------------------+-------+---------------+ We're just wondering how we fare up in terms of size and usage of dbmail compared to what others have seen. We've a dbmail setup with a single island and we've now decided to add an additional island in after we'd reached 10k users as we had started to see some real performance losses. Realistically we should have done this a lot sooner!!!:) Does anyone know how far people have taken dbmail+mysql in terms of users/capacity? I've heard postgresql is much better at performing but at the moment we're happy with mysql. Kind Regards James Greig -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul J Stevens Sent: 09 May 2011 08:07 To: DBMail mailinglist Subject: Re: [Dbmail] figures On 05/08/2011 08:18 PM, James Greig wrote: > Hi guys, > > Been a while since i've posted on here. We're making changes to our dbmail > setup but thought i'd post to see how we fare up against other people using > dbmail. We've finally got round to splitting things off onto separate dbmail > islands as per a modified setup of the scaling pdf. Our first dbmail island > has the following stats if anyone's interested. > > mysql> select count(*) from dbmail_users; > | 10127 | Nice. I don't run anything that large. > mysql> select count(*) from dbmail_domains; Eh, where did that table come from? Now what was your question again? -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin NFG Net Facilities Group BV___________________________Utrecht_NL _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
