Hi, Unfortunately I dint check SHOW PROCESSLIST as I was overwhelmed with the state of the server and had to bring back the old version online, but the reverse DNS lookups could be the reason, but surprisingly it was infact serving some client requests , also is there a way to stop mysql from doing reverse DNS lookups .. Thanks Kishore Jalleda On 9/16/05, Chris Allen <[EMAIL PROTECTED]> wrote: > > 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 <http://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] > >
