I'm at a loss and all I can come up with is this:
last pid: 70373; load averages: 4.32, 3.48, 3.53
up 33+19:31:48 09:32:36
148 processes: 26 running, 122 sleeping
CPU states: 5.6% user, 0.0% nice, 94.0% system, 0.2% interrupt, 0.2% idle
Mem: 125M Active, 262M Inact, 67M Wired, 19M Cache, 61M Buf, 28M Free
Swap: 512M Total, 512M Free
PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND
93447 www 18 0 15384K 13288K lockf 1 3:06 2.20% 2.20% httpd
68988 vpopmail 56 0 1376K 944K RUN 1 0:00 17.94% 1.71% vdelivermai
Ouch, that looks painfull. Do the messages get delivered at all?
This is a snapshot from top as I'm trying to send an email to a local ezmlm list that goes to about 50 local people.
This shouldnt be slow at all. I have a mailling list that goes to 300 local people, with vdelivermail and never have this problem, however, i do not use MySQL.
I get 50 vdelivermails (which is fine) but they are all slow to deliver.
I've had this server for almost a year (dual 933's 512Ecc U160 drives) and it does nothing but qmail+vpopmail and a webmail client.
I have clam antivirus and spamassassin which I'm calling through qmail-scanner.
this is my tcp.rules file:
This is useless to us if its vdelivermail that is screwing up and not qmail-smtpd.
and yesterday I was getting intermittent errors like this:
2004-04-06 09:28:48.197123500 delivery 19551: deferral: vmysql:_sql_error:_Can't_create_database_'vpopmail'._Database_exists/
2004-04-06 09:28:48.211717500 delivery 19534: deferral: vmysql:_sql_error:_Can't_create_database_'vpopmail'._Database_exists/
2004-04-06 09:28:48.232450500 delivery 19544: deferral: vmysql:_sql_error:_Can't_create_database_'vpopmail'._Database_exists/
This cant be good.
but so far today things have been ok.. except that vdeliver mail is *so* high..
Have you tried recompiling vpopmail from scratch/ports tree, and installing a new copy. It shouldnt make a difference, but if it does then something was wrong with your old binaries.
2004-04-07 09:41:06.857760500 delivery 956: success: did_0+0+1/
How long does it take approxamitly for each mail to be delivered with vdelivermail? And do you have it compiled with the spamassassin patch or not.
This is on a FreeBSD 4.9-p3 system ( I know I have to patch to p4 )
Go patch yourself :P
vpopmail-5.4.0 and mysql 3.23.57 (compiled for freebsd 4.8)
Should be fine.
Uptime: 23 hours 32 min 43 sec
Threads: 3 Questions: 18086 Slow queries: 0 Opens: 19 Flush tables: 1 Open tables: 13 Queries per second avg: 0.213