Re: Postfix + MySql - reducing queries?

Nikolas Hagelstein schrub:
> Hi,
>
> i am running a mysql(4.xx)/postfix(2.0.16)/amvis combination.
> The setup is almost identical to the one described
> in "FILTER_README - Squeezing out more performance".
>
> i am surprised about that much (mostly redundant ones) sqlquerys
> being necessary. Did i missed something? Any optimisation hints?

Hi Niko!

Use proxymap.

In example, if You use
alias_maps =3D mysql:$config_directory/aliases.cf
use:
alias_maps =3D proxy:mysql:$config_directory/aliases.cf

Check master.cf for the line:
proxymap unix - - n - - proxymap

Then add to main.cf:
proxy_read_map =3D proxy:mysql:$config_directory/aliases.cf

or if You are not sure:

postconf | grep proxy_read_map >> main.cf

and add all Your MySQL configs to this line.
You can it format in 'multiple line parameter' of course.
If You don't get all required maps in this parameter
take a look in the log. The affected process will stop and
the proxymap will complain about a unknown map-

This should reduce the number of queries remarkably.
Compare the number of running 'mysqld' before and after
the use of proxymap with pstree or so.

I hope it helps.

--=20
with kind regards
# make love
make: *** No rule to make target `love'. Stop.
Homefucking is killing prostitution.