Does WP not close its mysql connections properly? I've done a search and saw many others talking about these idle connections.
I got in touch with my host (yahoo) about the persistent "500 internal server" I've been getting and here is what they said:
* If your PHP script does not close a connection once it is done using it, that connection will remain open for approximately 20 hours before the system resets it automatically.
* For an application which has multiple access points (for example: phpBB), this can cause the system to return errors rapidly, as connections which are no longer in use have not been closed.
* We recommend authenticating the PHP access connection so that once the connection is no longer in use, it is closed by the PHP code.
I'm not a mysql guru, so do not exactly know what to do here. A couple of others suggested use of mysql_pconnect() instead of mysql_connect(). Any ideas on this? If I want to try this where would I change the code.