We have been having some performance issues on one of our larger sites, and I'm trying to figure out the best way to go about fixing them. We use the adoDB abstraction library. Since day one, we've used persistent connections, and I think that might be at least part of the problem. So if I switch from the persistent connection, PConnect() to the non-persistent, Connect(), I want to make sure of one particular thing:
My understanding is that PHP automatically cleans up a database connection after it has executed the query. Therefore, I don't need to use the close() function. Is that correct? On a related note, our main issue is that the site keeps slowing down and we are getting a 'Too Many Connections' error from MySQL. I had the number of connections increased from 100 to 150 on both Apache and MySQL two weeks ago, but we are still having the problem, although less frequently. One thing I'd like to be able to do is check how many connections have physically been made to the database. I did this a couple of weeks ago, but now I can't find the MySQL query returns that information. If anyone could throw that out to me, I'd greatly appreciate it. -- Randal Rust R.Squared Communications www.r2communications.com _______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
