This is a discussion on Postfix + MySql - reducing queries? within the mailing.postfix.users forums, part of the Mail Servers and Related category; Hi, i am running a mysql(4.xx)/postfix(2.0.16)/amvis combination. The setup is almost identical to ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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? Regards, niko Query log: [SMTPD] 3490 Query select goto from alias where address = 'user@mydomain' 3490 Query select goto from alias where address = '@mydomain' 3491 Query select maildir from mailbox where address = 'user@mydomain' [pre cleanup ?!] 3490 Query select goto from alias where address = 'user@mydomain' 3490 Query select goto from alias where address = '@mydomain' 3491 Query select maildir from mailbox where address = 'user@mydomain' 3488 Query select goto from alias where address = 'mydomain' 3489 Query select description from domain where domain = 'mydomain' [amavis policy query -> removed] [reinjektion to cleanup] 3488 Query select goto from alias where address = 'mydomain' 3489 Query select description from domain where domain = 'mydomain' 3493 Connect maildbuser@localhost on maildb 3493 Query select goto from alias where address = 'user@mydomain' 3493 Query select goto from alias where address = '@mydomain' 3494 Connect maildbuser@localhost on maildb 3494 Query select maildir from mailbox where address = 'user@mydomain' 3495 Connect maildbuser@localhost on maildb 3495 Query select goto from alias where address = 'user@mydomain' 3495 Query select goto from alias where address = '@mydomain' 3496 Connect maildbuser@localhost on maildb 3496 Query select maildir from mailbox where address = 'user@mydomain' |