Multiple MySQL Queries - with Postfix-mysql, courier-authmysql, maildrop-mysql...
Ok I've been successfully running an email server for the past 2 years using the following:
- Debian Sarge
- 2.4.27 smp kernel
- courier-pop, courier-imap, courier-authmysql
- postfix-mysql, postfix-tls
- maildrop, maildropmysql
Basically it handles multiple domains, for virtual users, virus/spam protection, etc.
Now I've just been doing some cleaning up everything, and trying to get it run more efficiently, as I'm going to be setting up a new server soon.
I was looking at the mysql.log (/var/mysql/mysql.log), that I had turned on, and interesting was seeing multiple queiries for every email that the server received.
Here's an example, I was sending an email from an external address, to an address on the server:
I don't think its maildrop, as there is only 1 mysql query from maildrop, the last one.
So I'm assuming its something to do with postfix, as before those logs above its connecting as postfix: "Connect postfix@localhost on xxxxx".
So has anyone seen this before? Multiple queries for just one incoming email?
Meaning the mysql server is doing far more than it should have to.
Courier-mysql seems to be ok, as I only get 1 query in the log when I check my email.
Thanks, any help, advice, or comments would be greatly appreciated.
I used too debian sarge and I have postfix+mysql+spamassassin,amavisd-new,clamav...
I try running maildrop + mysql but it's not working
How you compiled maildrop with mysql, from source?
Can you write your configurations about maildropmysql and mai.cf,master.cf?
Maybe if I get time I can look into it futher, as it would be nice to get postfix to cut down on mysql queries. Its doing on average 100 per minute with all the email its handling.
|All times are GMT +2. The time now is 12:05.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.