>
> We have around 7500 mailboxes currently. We handle around 80 000 mails
> daily
> to those mailboxes. We have a greylist solution in Exim that works with a
> MySQL database backend and we make use of DNSBL lists. All our servers are
> running FreeBSD 5.x and 6.x
>
While I don't disagree with the other suggestions in this thread about
dumping to db files (esp cdb files),
> Does anyone have a reference on how to create these files from a mysql db
? I would definitely like to have a look at the option.
I'm curious about how many mysql queries you're doing per email. Is it the 4
you mentioned or more on top of that? Unless you're also loading the MySQL
server up with other applications or are doing a whole boatload of queries
per email, 80k emails per day resulting in 320k queries/day shouldn't cause
MySQL to hardly break a sweat.
> We are doing 2 queries per any one mail that comes into the system. One on
receiving the mail and one coming back from amavis after virus scanning. We
have greylisting implemented so that would be another query. We are also
dealing with constant pop3 connection validations.
> The only other application running on the database is a web frontend to
administer the mailboxes, but not much activity going on besides
adding/removing/changing passwords on a daily basis.
Your MySQL box sounds plenty fast enough. If you're seeing memory problems,
you might consider upgrading your MySQL (and preferably use the binary
supplied by MySQL). You might also want to lower some of the memory usage in
my.cnf. As far as multiple queries go, assuming you have the query cache
turned on and aren't making continuous changes to the tables involved, the
query cache should reduce the overhead of the subsequent duplicate queries
to almost nothing, as far as the mysql box is concerned. Do you have a
steady increase in the Qcache_hits field of 'show status'? If not, you might
double check the duplicate queries to make sure they are completely
identical.
> We upgraded from 4.x to 5.x which got rid of all our mysql memory
problems. I think that's about the only positive change we made over the
past weeks...
I can't speak to the FreeBSD part and I promise I'm not trying to start a
flame, but you might want to try running MySQL on a recent linux distro to
see if it helps with your memory issues.
--
## List details at
http://www.exim.org/mailman/listinfo/exim-users
## Exim details at
http://www.exim.org/
## Please use the Wiki with this list -
http://www.exim.org/eximwiki/
