On Wed, Jun 16, 2010 at 11:41 PM, Peter Santiago <[email protected]> wrote: > John Homer H Alvero wrote: >> you may want to activate slow query logs. >> >> >> >> >> On Tue, Jun 15, 2010 at 2:13 PM, Allen Umlas <[email protected] >> <mailto:[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] >> <mailto:[email protected]>>/* wrote: >> > [snip] > > Hi Allen, > > http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html > > Please check if your LAMP application is using persistent connections.
If you'll elect to use persistent connections, you may have to limit their number as you cannot have unlimited numbers of persistent connections without having unlimited memory. There's nothing wrong with using persistent connections as long as your application is designed for that case (e.g. instead of the web application connecting directly connecting to MySQL, your application connects to a middleware that does the connection to MySQL). You may wish to investigate use of caching should you wish to avoid hitting the maximum number of connections, along with avoiding more expensive trips to the database. -- Paolo _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
