you may want to activate slow query logs.
On Tue, Jun 15, 2010 at 2:13 PM, Allen Umlas <[email protected]> wrote: > Hi Homer, > > This is LAMP application, basically its a setup which support much of > the web applications with mysql and php support. > > --- On *Tue, 6/15/10, John Homer H Alvero <[email protected]>* wrote: > > > From: John Homer H Alvero <[email protected]> > Subject: Re: [plug] mysql maximum connections reach and terminated > To: "Philippine Linux Users' Group (PLUG) Technical Discussion List" < > [email protected]> > Date: Tuesday, June 15, 2010, 2:03 PM > > > Hello Allen, > > Please give more details about the setup. How do clients connect to the > MySQL server. mysqlclient? php? odbc? some sort of java connector? > > if this is a web application, apache connection settings might also be of > help. > > > On Tue, Jun 15, 2010 at 1:11 PM, Allen Umlas > <[email protected]<http://mc/[email protected]> > > wrote: > >> >> Hi, >> >> I'm currently have a problem regarding with my mysql, I set maximum >> connect which is 1024, but still it reaches on set connections. >> >> set Global maximum_connection = 1024 >> >> Any reason why it reaches? When i check the connections i saw lots of >> TIME_WAIT then mysql process will hang or terminated. >> >> Tux-User >> >> >> _________________________________________________ >> Philippine Linux Users' Group (PLUG) Mailing List >> http://lists.linux.org.ph/mailman/listinfo/plug >> Searchable Archives: http://archives.free.net.ph >> > > > -----Inline Attachment Follows----- > > > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > http://lists.linux.org.ph/mailman/listinfo/plug > Searchable Archives: http://archives.free.net.ph > > > > _________________________________________________ > Philippine Linux Users' Group (PLUG) Mailing List > http://lists.linux.org.ph/mailman/listinfo/plug > Searchable Archives: http://archives.free.net.ph >
_________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
