On Fri, 18 Aug 2006 10:48:43 +0200
"GamCo - Gawie Marais" <gawie@???> wrote:
> We are currently using TCP connections to the MySQL database from
> Exim. We have been using MySQL 4.x which is giving us a lot of
> problems with connections and threads used by Exim, due to the
> multiple lookups per any one mail that comes into our mail system. Up
> to a stage where the MySQL database falls over with memory problems.
> Once restarted the MySQL database works perfectly for a couple of
> days again.
I'd suggest using flat files dumped regularly from the database or
using a "proxy" for MySQL which will cache the connections. I think
SQLRelay could perform that task.
> We have been thinking of having the Database server and the Exim
> server running on the same hardware in stead of having one server for
> Exim and one for MySQL.
Have you considered running a slave MySQL server using replication on
the local machine?
