Postfix - MySQL

Hello NG,

i have setup and working postfix - mysql.
all works fine, but when i recieve a lot of mails, postfix open a
lot of mysql connections, so the load of the box goes to 15 or higher.

How can i say, that i only have 10 connections to the mysql server, where i
start
the query´s ??

Oliver Dreier schrieb:

> Hello NG,
>
> i have setup and working postfix - mysql.
> all works fine, but when i recieve a lot of mails, postfix open a
> lot of mysql connections, so the load of the box goes to 15 or higher.
>
> How can i say, that i only have 10 connections to the mysql server, where i
> start
> the query´s ??

Just look in your mysql my.cnf (somewhere in /etc/) for max_connections
(the global setting) and max_user_connections, which is a per-user limit.

BUT: if you lock out postfix from using mysql, mails will bounce and
will not be delivered. Consider ugrading your hardware, you seem to have
rather high amount of email traffic compared to your hardware.

Cheers,
Jan