I don't know if this is relevant to you - but I had exactly the same experience when upgrading to MySQL v4.1. It turned out that MySQL was trying to do reverse DNS lookups before authenticating the connecting hosts - and was failing slowly on each because the database machine didn't have external net access.
Adding all the local machines to /etc/hosts solved the problem immediately. Chris Allen. On Fri, Sep 16, 2005 at 01:30:34PM +0300, Gleb Paharenko wrote: > Hello. > > > > What is SHOW PROCESSLIST reporting when the server is reaching the > > max_connections limit? > > > > > > > > > > Kishore Jalleda <[EMAIL PROTECTED]> wrote: > > >Hi All, > > > Last night I upgraded our Master server to 4.1.14 standard log from 4.0.17, > > >I upgraded the slave a week ago and the replication was working perfectly, > > >once I upgraded and started mysql, it started fine without any errors but > > >the server was steadily creating mysql processes at the rate of like 20/sec > > >until it reached the Max_connections limit set at 800, while it was doing > > >this it was serving the web clients only randomly , also the load was very > > >very low neither was it taking up any memory, it was just creating processes > > >, I remember seeing this behaviour even earlier with 4.0.17 when the server > > >just started but after a certain point the no of processes return to normal. > > > So I had to switch back to 4.0.x, and it works perfectly fine, Also I did > > >not dump the databases just zipped the old datadir and unzipped it into the > > >new datadir, anybody else experience this behaviour at startup( I am aware > > >that once the server is back online it is flooded with requests), the OS is > > >Redhat 7.3, the server currently does 200-400 qps quiet comfortably . > > > Any help would be appreciated, let me know if you need more info > > > Kishore Jalleda > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
