Gossamer Forum
Home : Products : Gossamer Links : PHP Front End :

mysql_pconnect

Quote Reply
mysql_pconnect
Can anyone tell me if the PHP version of Links SQL uses persistent mysql connections? I'm currently using the cgi version, but I'm running into some trouble with too many mysql connections. Since many other parts of my site are done with PHP and use mysql_pconnect, I'd like to keep using those same connections if possible.

Thanks in advance for any information or advice.

Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund
Quote Reply
Re: [hennagaijin] mysql_pconnect In reply to
A lot of people use timeouts on their SQL connections. This stops runaway connections from getting away. Maybe something like 30 seconds before it is removed?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] mysql_pconnect In reply to
I understand. What I'm asking, though, is if the default PHP version of Links SQL uses persistent connections or not. Do you know whether it uses mysql_connect or mysql_pconnect?

Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund
Quote Reply
Re: [hennagaijin] mysql_pconnect In reply to
I'm not sure. In SQL.inc.phpthey have;

if (!$this->DB->PConnect($DB_CFG['host'] . ':' . $DB_CFG['port'], $DB_CFG['login'], $DB_CFG['password'], $DB_CFG['database'])) {

I can't actually find a reference directly to then calling pconnection though...I think Adrian from GT will be a better person to answer this Smile

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [hennagaijin] mysql_pconnect In reply to
Yeah I just took a look and I think they use pconnect()
Quote Reply
Re: [Paul] mysql_pconnect In reply to
Thanks for your help.

Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund