I'm working with a script of a 3rd party product that has no support and have run into an issue with MySql connections...they hit the max intermittently. This is the typical error message:<br /><br />PHP Warning: mysql_pconnect() [<a href=http://www.totalchoicehosting.com/forums/lofiversion/index.php/'function.mysql-pconnect'>function.mysql-pconnect</a>]: User xxxxx has already more than 'max_user_connections' active connections in /home/xxxxx/public_html/auction/includes/config.inc.php on line 113<br /><br />According to the online docs mysql_pconnect() "Establishes a persistent connection to a MySQL server". I've only used mysql_connect(). The docs also say "mysql_close() will not close links established by mysql_pconnect()".<br /><br />The docs also give this warning: "Using persistent connections can require a bit of tuning of your Apache and MySQL configurations to ensure that you do not exceed the number of connections allowed by MySQL."<br /><br />Has anyone had experience with this issue?<!--content-->
change the connection from mysql_pconnect to mysql_connect (without the p) and then things should be much better. It's best not to use persistent connections<!--content-->
Thanks for the reply. That is what I was thinking, but I was alarmed at the prospects of a lot of code changes (someone else's code to boot). Oh well...thanks for the confirming opinion.<!--content-->
<!--quoteo(post=200988:date=Feb 23 2007, 04:40 AM:name=TCH-Andy)--><div class='quotetop'>QUOTE(TCH-Andy @ Feb 23 2007, 04:40 AM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=200988"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->change the connection from mysql_pconnect to mysql_connect (without the p) and then things should be much better. It's best not to use persistent connections<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />I am having the same issue....<br /><br />How may I accomplish your suggestion? I use phpBB<br /><br />Don<br />spyderchat.com<!--content-->
change the connection from mysql_pconnect to mysql_connect (without the p) and then things should be much better. It's best not to use persistent connections<!--content-->
Thanks for the reply. That is what I was thinking, but I was alarmed at the prospects of a lot of code changes (someone else's code to boot). Oh well...thanks for the confirming opinion.<!--content-->
<!--quoteo(post=200988:date=Feb 23 2007, 04:40 AM:name=TCH-Andy)--><div class='quotetop'>QUOTE(TCH-Andy @ Feb 23 2007, 04:40 AM) <a href="http://www.totalchoicehosting.com/forums/index.php?act=findpost&pid=200988"><img src='http://www.totalchoicehosting.com/forums/style_images/1/post_snapback.gif' alt='*' border='0' /></a></div><div class='quotemain'><!--quotec-->change the connection from mysql_pconnect to mysql_connect (without the p) and then things should be much better. It's best not to use persistent connections<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />I am having the same issue....<br /><br />How may I accomplish your suggestion? I use phpBB<br /><br />Don<br />spyderchat.com<!--content-->