Gossamer Forum
Skip to Content



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.com

Merry Xmas and a Happy New Year!


Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Custom Toolbar for IE and Firefox! - Compare our different Plugin packages *new*
Free CSS Templates
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.com

Merry Xmas and a Happy New Year!


Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Custom Toolbar for IE and Firefox! - Compare our different Plugin packages *new*
Free CSS Templates
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