Thanx for your help, I found sampels for smale, medium, large and huge systems. Now I have something to do ;-)
in debian is it in /usr/share/doc/mysql-server/examples/ thanx, Brian ----- Original Message ----- From: "Dave Goodrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 24, 2004 8:33 PM Subject: Re: [vchkpw] vchkpw with mysql > Brian wrote: > > > current my settings on my debian host > > > > key_buffer = 16M > > max_allowed_packet = 1M > > > > that's the only places where I can change something .. > Where is this? /etc/my.cnf? There are a lot of tunable vars that can be > set in your my.cnf file. Look in your MySQL source, maybe in > /usr/local/share/mysql, there are some sample *.cnf files in there. A > lot depends on how much memory your system has, and how much it is using. > > > > > right to change this? I'm not a mysql professional :-( > Sure, that is why it is there. Just make sure you know what you are > changing, I'm no MySQL guru either. > > I would first get your bin log running and see what is going on with the > mysql daemon. The select may not even be happening which is what I saw. > > http://dev.mysql.com/doc/mysql/en/Binary_log.html > > I'm no expert and may not be the best person to guide you through this ;^) > > DAve > > > > > > thanx for your help, Brian > > > > > > ----- Original Message ----- > > From: "Dave Goodrich" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, August 24, 2004 7:52 PM > > Subject: Re: [vchkpw] vchkpw with mysql > > > > > > > >>I have seen some similar issues with using vpopmail and MySQL. Most > >>notably a failure to authenticate becasue MySQL doesn't respond > >>correctly. Not sure if it was timing out or what. The solution was to > >>give MySQL more resources over the default install. > >> > >>I upped my key, index, and table cache, increased my thread cache, now I > >>have no problems. I use MySQL heavliy though, three cluster machines > >>hitting it all day, plus spamassassin uses it as well. YMMV. > >> > >>DAve > >> > >>Brian wrote: > >> > >> > >>>Hello List, > >>> > >>>I have installed vpopmail with mysql-support. It's running well but > > > > sometimes my mail client ask about username and password. Error message is > > the user is not found. > > > >>>vpopmail[1003]: vchkpw-pop3: vpopmail user not found > > > > [EMAIL PROTECTED]:99.99.99.99 > > > >>> > >>>The User exist in the database and next time it's running well again. > >>> > >>>someone know this problem? > >>> > >>>thanx, Brian > >>> > >> > >>-- > >>Systems Administrator > >>http://www.tls.net > >>Get rid of Unwanted Emails...get TLS Spam Blocker! > >> > >> > > > > > > > > -- > Systems Administrator > http://www.tls.net > Get rid of Unwanted Emails...get TLS Spam Blocker! > >
