MySQL will try its level best to move the indexes into RAM and will keep as much of them there as possible. It will try to move the tables there as well, if it can. If your database is over 64 MB, you're in trouble. I don't know how many users you have or how big your mail spool is, but if you're going to be running a serious DB server, you need lots of RAM; half a GB or better. As always, ymmv. Also if you're running a more modern version of *nix/*nux, then you need RAM. I'm running RH8.0 on a PII-450 with 256MB of RAM as a development machine. It would run much better if I had more RAM and my databases aren't that big.
Curtis Jesse Norell said: > > 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 <dbmail@dbmail.org> > To: dbmail@dbmail.org > 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 >> Dbmail@dbmail.org >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > -- End Original Message -- > > > -- > Jesse Norell > [EMAIL PROTECTED] > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail
