Re: [vchkpw] vdelivermail is soo slow..
Brian wrote: Hello All, 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 SIZERES STATE C TIME WCPUCPU COMMAND 93447 www18 0 15384K 13288K lockf 1 3:06 2.20% 2.20% httpd 68988 vpopmail 56 0 1376K 944K RUN1 0:00 17.94% 1.71% vdelivermai snip 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: 127.0.0.:allow,RELAYCLIENT=,RBLSMTPD=,QMAILQUEUE=/var/qmail/bin/qmail-scanner-queue 192.168.1.:allow,RELAYCLIENT=,RBLSMTPD=,QMAILQUEUE=/var/qmail/bin/qmail-scanner-queue :allow,QMAILQUEUE=/var/qmail/bin/qmail-scanner-queue This is useless to us if its vdelivermail that is screwing up and not qmail-smtpd. snip and yesterday I was getting intermittent errors like this: 2004-04-06 09:28:48.197123500 delivery 19551: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/ 2004-04-06 09:28:48.211717500 delivery 19534: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/ 2004-04-06 09:28:48.232450500 delivery 19544: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/ This cant be good. snip 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 TIA - Brian X-Istence
Re: [vchkpw] vdelivermail is soo slow..
On Wednesday 07 April 2004 09:29 am, Brian wrote: [snip bunch of vdelivermail's fighting for cpu] 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. do all of those users have lots and lots of mail in their accounts, and you're running and old filesystem such as ext2/3 or UFS without DIR_HASH? If so, you're seeing filesystem chokage, and need to either clean out those mail directories or get a better filesystem. -Jeremy -- Jeremy Kitchen Systems Administrator [EMAIL PROTECTED] Kitchen @ #qmail on EFNet - Join the party! . Inter7 Internet Technologies, Inc. www.inter7.com 866.528.3530 toll free 847.492.0470 int'l 847.492.0632 fax GNUPG key ID: 93BDD6CE
[vchkpw] vdelivermail is soo slow..
Hello All, 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 SIZERES STATE C TIME WCPUCPU COMMAND 93447 www18 0 15384K 13288K lockf 1 3:06 2.20% 2.20% httpd 68988 vpopmail 56 0 1376K 944K RUN1 0:00 17.94% 1.71% vdelivermai 62048 vpopmail 55 0 1376K 944K RUN1 0:00 14.86% 1.42% vdelivermai 65547 vpopmail 54 0 1376K 944K RUN1 0:00 14.86% 1.42% vdelivermai 68537 vpopmail 55 0 1376K 944K RUN1 0:00 14.86% 1.42% vdelivermai 69065 vpopmail 53 0 1376K 944K RUN1 0:00 10.25% 0.98% vdelivermai 68932 vpopmail 53 0 1372K 940K RUN0 0:00 9.74% 0.93% vdelivermai 68634 vpopmail 53 0 1372K 940K RUN0 0:00 7.69% 0.73% vdelivermai 65358 vpopmail 52 0 1372K 940K RUN0 0:00 7.18% 0.68% vdelivermai 68423 vpopmail 52 0 1372K 940K RUN0 0:00 6.66% 0.63% vdelivermai 69546 vpopmail 53 0 1372K 940K RUN1 0:00 6.66% 0.63% vdelivermai 69565 vpopmail 53 0 1372K 940K RUN0 0:00 6.66% 0.63% vdelivermai 68777 vpopmail 52 0 1372K 940K RUN0 0:00 6.15% 0.59% vdelivermai 69294 vpopmail 52 0 1372K 940K RUN0 0:00 6.15% 0.59% vdelivermai 68841 vpopmail 52 0 1372K 940K RUN0 0:00 5.64% 0.54% vdelivermai 70020 vpopmail 52 0 1372K 940K RUN1 0:00 5.64% 0.54% vdelivermai 70316 vpopmail 53 0 1372K 940K RUN1 0:00 5.13% 0.49% vdelivermai 70342 vpopmail 52 0 1372K 940K RUN0 0:00 5.13% 0.49% vdelivermai 70136 vpopmail 52 0 1372K 940K RUN0 0:00 4.61% 0.44% vdelivermai 70139 vpopmail 52 0 1372K 940K RUN1 0:00 3.59% 0.34% vdelivermai 68330 vpopmail 51 0 1372K 940K RUN0 0:00 3.08% 0.29% vdelivermai 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. 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: 127.0.0.:allow,RELAYCLIENT=,RBLSMTPD=,QMAILQUEUE=/var/qmail/bin/qmail-scanner-queue 192.168.1.:allow,RELAYCLIENT=,RBLSMTPD=,QMAILQUEUE=/var/qmail/bin/qmail-scanner-queue :allow,QMAILQUEUE=/var/qmail/bin/qmail-scanner-queue I'm using qmail-scanner 1.21 compiled by hand with this configure statement: ./configure \ --admin postmaster \ --add-dscr-hdrs yes \ --domain poklib.org \ --log-details syslog \ --skip-text-msgs yes \ --scanners clamdscan,verbose_spamassassin \ --notify sender \ --debug no \ --unzip yes \ --batch \ --install and yesterday I was getting intermittent errors like this: 2004-04-06 09:28:48.197123500 delivery 19551: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/ 2004-04-06 09:28:48.211717500 delivery 19534: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/ 2004-04-06 09:28:48.232450500 delivery 19544: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/ and even after just restarting it all: 2004-04-06 11:20:58.672465500 delivery 637: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/ 2004-04-06 11:20:58.675404500 delivery 620: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/ 2004-04-06 12:42:10.905863500 delivery 18: deferral: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/ but so far today things have been ok.. except that vdeliver mail is *so* high.. 2004-04-07 09:41:06.857760500 delivery 956: success: did_0+0+1/ This is on a FreeBSD 4.9-p3 system ( I know I have to patch to p4 ) vpopmail-5.4.0 and mysql 3.23.57 (compiled for freebsd 4.8) 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 TIA - Brian
