On 8/21/05, David Erickson <[EMAIL PROTECTED]> wrote: > Great suggestions but that doesn't seem to the be problem.. I restarted > mysql earlier today, and continued to have problems afterward. And I just > checked max_used_Conns and it is 7, and my actual limit is 100. Any other > ideas? > > -David > > > -----Original Message----- > > From: Roman Volf [mailto:[EMAIL PROTECTED] > > Sent: Sunday, August 21, 2005 10:44 AM > > To: [EMAIL PROTECTED] > > Subject: Re: [vchkpw] Sporadic mail auth failures > > > > Roman Volf wrote: > > > > > Rick Macdougall wrote: > > > > > >> Hi, > > >> > > >> It happens occasionally when you don't allow enough connections to > > >> your MySQL server. Try increasing the connections in the my.cnf (and > > >> look at increasing some of the buffers etc as well). > > >> > > >> Regards, > > >> > > >> Rick > > >> > > > You can check this by doing: > > > > > > [EMAIL PROTECTED] ~]$ mysqladmin -u root -p extended-status|grep > > > connections > > > Enter password: > > > | Max_used_connections | 25 | > > > > > > Then compare that number to the number specified in my.cnf. > > > > > > > > > > > Or, to check the current setting for max_connections, do: > > > > [EMAIL PROTECTED] ~]$ mysqladmin -u root -p variables|grep connections > > Enter password: > > | max_connections | > > 100 > > > > > > -- > > Roman Volf > > Keystreams Internet Solutions > > [EMAIL PROTECTED] > > > > -- > > No virus found in this incoming message. > > Checked by AVG Anti-Virus. > > Version: 7.0.338 / Virus Database: 267.10.13/78 - Release Date: 8/19/2005 > > > >
Maybe you can try turning on mysqld logging in my.cnf and see if anything strange pops up there? [mysqld] log=/path/to/your/logfile Don't do like me and forget to turn logging back off when you're done :) -- Jason [EMAIL PROTECTED]
