Hello, You don't have to use tcp with mysql; we're running (or have run) several setups using unix sockets. Haven't tried it with recent cvs, but in older setups you just set MAIL_HOST and AUTH_HOST to "localhost" in config.h, and make sure mysql is setup to listen on a socket.
---- Original Message ---- From: Ulrich Spoerlein <[email protected]> To: [email protected] Subject: Re: [Dbmail] Performance Issues Sent: Mon, 10 Feb 2003 19:10:26 +0100 > On Mon, 10.02.2003 at 10:46:14 -0700, Tim Uckun wrote: > > > > >Ok, I did the following, to get the Maildir Folder into the database > > >(MySQL running on a P200, 64MB): > > >foreach file in *;do cat $file|dbmail-smtp -u q; done > > > > There have been numerous complaints about the speed of IMAP in dbmail. I > > don't know if a definitive answer has ever been given but I remember > > somebody saying that the problems went away when they moved the database to > > a better box. Maybe p200 64MB is just not big enough to run dbmail > > especially if IMAP is needed. > > Can you do a top and tell us if your memory or CPU is overwhelmed? I > > remember somebody complaining about dbmail hogging the CPU once. > > I can't give you exact values right now, but during the mail "import" > dbmail & mysql the load was only 0.8. I think creating thousands of > sockets and IP packets just takes too long. Being able to connect to the > Database over TCP/IP _is_ nice, but where it isn't needed it slows > things down unnecessarily. > > When moving the mails inside the database, the load was 1.0 with mysql > grabbing all available CPU Power (didn't look for RAM usage :( > > Btw, I will install an additional 64MB sometime next week, the problem > is the small Cache Tag on that board, i.e. only the first 64MB are > cached :( > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- End Original Message -- -- Jesse Norell [EMAIL PROTECTED]
