Bluehost.com Web Hosting $6.95

Postfix + MySql - reducing queries?

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 ...


Go Back   Usenet Forums > Mail Servers and Related > mailing.postfix.users

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-04-2004
Nikolas Hagelstein
 
Posts: n/a
Default Postfix + MySql - reducing queries?

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'



Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 06:30 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0