remy at linuxnet
Jun 23, 2012, 7:56 PM
Post #1 of 2
See if one of you could help me.
I have a fresh installation of dbmail 3.0.2. (mysql 5.1.46; postfix
2.7.1 in a openSuSE 11.3 everthing in the same server).
And I use fetchmail to get mails from just one account to be delivered
through postfix to dbmail. Everything is working fine, my doubt is about
delay. When I run fetchmail, I get my postfix queue filled with
thousands of messages quickly and following /var/log/mail I could see it
takes more than 2 seconds to deliver each one.
(some supposedly relevant parameters from supposedly relevant config files:)
key_buffer_size = 16M
max_allowed_packet = 180M
table_open_cache = 64
sort_buffer_size = 4M
net_buffer_length = 32K
read_buffer_size = 2M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 32M
postfix - main.cf
lmtp_destination_concurrency_limit = 30
lmtp_host_lookup = native ( to avoid dns issues, it uses /etc/hosts)
mailbox_transport = dbmail-lmtp:localhost:24
max_db_connections = 80 [. as you can see here, I tried to improve its
performance, without success though]
sqlsocket = /var/run/mysql/mysql.sock
On the other hand I have another server in another place running same
version of programs but dbmail 2.2.17. In this one, when I want it to
work faster I just improve all the parameters about the processes:
and then I get a lot of dbmail-lmtp process, and they do the job really
fast, of course, at cost of a lot of memory...
of course, I'm aware of the "Server Changes", that's why in the other
deployment I've tried improve the "max_db_connectons", because I guess
it plays as a kind of substitute, so to speak, to all the other
processes parameters listed above. Probably I'm wrong.
Now I ask you: is there a way to make it behaves just like my old dbmail
2.2.17? Let's suppose I have memory to spend and I would like it to
deliver all my local messages really fast.
Actually by now, It's still not a serious issue, but I fear It will be.
And also I'm really curious to understand why it happens.
Thanks in advance.
DBmail mailing list
DBmail [at] dbmail