Hi Allen, >From the issue you have described, you may be right to say that "some >application (are) not closing in certain time" or may not be closing the DB >connections at all. So your fix should go into this direction. See to it that your DB apps are properly closing their connections. However, if you are dealing with clients wherein it becomes almost impossible to manage their network connectivity (WiFi), you may have to play with your Kernel TCP KEEPALIVE settings. Linux default is about 2 hours. You may need to lessen this value considerably. Info may be found here: http://tldp.org/HOWTO/html_single/TCP-Keepalive-HOWTO/ But please do note that such adjustments will affect *ALL* of your TCP (idle) connections.
HTH & Regards, Vic --- On Fri, 16/7/10, [email protected] <[email protected]> wrote: > Message: 1 > Date: Thu, 15 Jul 2010 10:14:53 -0700 (PDT) > From: Allen Umlas <[email protected]> > Subject: [plug] mysql max_connections > To: plug list <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > > Hi Guys, > > ???????? I have some sort of problem with mysql server, > time_wait connections is reach too much high. It might be > some application not closing in certain time probably might > be a reason.So i did set max_connections to 500 but still it > reach. How can i made a bash or any script that will send me > an email if that time_wait connection reaches certain define > number that i might be aware.I usually use this command to > monitor time_wait and counts for particular connection. > > netstat -ant |grep ":3306" |awk '/tcp/ && > /TIME_WAIT/ {print $6,$4}'|sort|uniq -c > > Tux_user _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
