<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16561"></HEAD>
<BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Segoe UI">
<DIV>Some of you who have pages that are supported through the state's database server may have noticed some issues this morning with pages not populating with data pulled in through mySQL databases on the state server. For example, OLIS has a library search tool and continuing education course listings and registration set up with mySQL that were not working.</DIV>
<DIV> </DIV>
<DIV>DoIT quickly fixed the problem, but let me know that this is a recurring problem and those of us using mySQL databases can help out by closing the connection to the database. I am not that familiar with mySQL, so I cannot offer a solution, but we (OLIS) will be working on a solution for our website. If anyone finds a solution and/or has more expertise in this area and would like to share, that would be super.</DIV>
<DIV> </DIV>
<DIV>DoIT describes the problem this way:</DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff>It appears that the majority of Web Developers are using mysql_pconnect to make their connections to their DBs.</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>What is causing the problem is that they are NOT releasing or closing that connection when they exit their code.</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>This results in our running out of connections.</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>While pconnect is the preferred method of connecting to the DB, you MUST remember to release or close the connections when done!</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>If you don't wnat to close your connection, the just use mysql_connect.</FONT></DIV>
<DIV><BR>Additional information:</DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff>Apparently there is no "pconnect close" option in PHP.</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>The simpler, better solution is to change mysql_pconnect to mysql_connect.</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>The latter drops the connection immediately when the web page closes.</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>Mysql_pconnect doesn't drop until the MySQL daemon is restarted or the server is rebooted which amounts to the same thing.</FONT></DIV>
<DIV><FONT color=#0000ff></FONT> </DIV>
<DIV><FONT color=#0000ff>In 99.9% of the cases, pconnect is a bad idea.</FONT></DIV>
<DIV> </DIV></BODY></HTML>