Unanswered: Trying to Figure Out Persistent Connections
It is my understanding that when using mysql_pconnect (PHP), the server will attempt to find a connection with the identical hostname, username, and password before creating a new connection.
To test this, I created a simple script that connects to the database, runs a query and the closes the connection (mysql_close()). I then loaded this script and hit the refresh button 5 times in a row (with a slight pause between each).
I then ran "show full processlist;" and found that 5 separate connections had been created: