What if i don't close MySQL database connection ?

[terryds]

I found that the mysql connection will be automatically closed when the php script finish executing the code....Is that right ? How to check if the connection is closed or not? Will it close the connection automatically too if i use PHP Data Objects (PDO) too ?

[birbal]

All php resources will be destroyed at the end of the script including PDO. It wont matter for small script. But if after opening a connection there is lot of time consuming task your script is doing, connection will be still opened. with that kind of simultanouse call to script can exceed your maximum mysql connection. You can check the variable to see what does it holds to ensure you have active connection or not.

Edited June 13, 2013 by birbal