RE: [PHP] mysql_pconnect issue

2008-05-12 Thread Chetan Rane
e Engineer -Original Message- From: Forcey [mailto:[EMAIL PROTECTED] Sent: Monday, May 12, 2008 10:08 AM To: Chris Cc: bruce; php-general@lists.php.net Subject: Re: [PHP] mysql_pconnect issue On Mon, May 12, 2008 at 12:27 PM, Chris <[EMAIL PROTECTED]> wrote: > b

Re: [PHP] mysql_pconnect issue

2008-05-11 Thread Forcey
On Mon, May 12, 2008 at 12:27 PM, Chris <[EMAIL PROTECTED]> wrote: > bruce wrote: > > hi... > > > > running into a problem that i can't seem to solve... > > > > using mysql_pconnect() and i'm trying to figure out what parameters have to > > be used in order to connect to a local mysql session

Re: [PHP] mysql_pconnect issue

2008-05-11 Thread Chris
bruce wrote: > hi... > > running into a problem that i can't seem to solve... > > using mysql_pconnect() and i'm trying to figure out what parameters have to > be used in order to connect to a local mysql session, where mysql is > accessed using the defaults (ie, no user/passwd/hostIP) Use 'loca

Re: [PHP] mysql_pconnect / persistent database conections

2005-01-28 Thread Ben Edwards
On Thu, 27 Jan 2005 22:14:52 -0800, Steve Slater <[EMAIL PROTECTED]> wrote: > At 10:43 AM 1/27/2005, Richard Lynch wrote: > >Ben Edwards wrote: > > > Been meaning to investigate persistent database connections for a > > > while. Coming from a rdbms background (oracle with a bit of whatcom > > > sq

Re: [PHP] mysql_pconnect / persistent database conections

2005-01-28 Thread Tom
Ben Edwards wrote: Been meaning to investigate persistent database connections for a while. Coming from a rdbms background (oracle with a bit of whatcom sqlanywhare) I have always felt that the overhead of opening a connection at the beginning of each page was a little resource intensive. MySQL

Re: [PHP] mysql_pconnect / persistent database conections

2005-01-27 Thread Steve Slater
At 10:43 AM 1/27/2005, Richard Lynch wrote: Ben Edwards wrote: > Been meaning to investigate persistent database connections for a > while. Coming from a rdbms background (oracle with a bit of whatcom > sqlanywhare) I have always felt that the overhead of opening a > connection at the beginning of

Re: [PHP] mysql_pconnect / persistent database conections

2005-01-27 Thread Richard Lynch
Ben Edwards wrote: > Been meaning to investigate persistent database connections for a > while. Coming from a rdbms background (oracle with a bit of whatcom > sqlanywhare) I have always felt that the overhead of opening a > connection at the beginning of each page was a little resource > intensive

Re: [PHP] mysql_pconnect & mysql_connect

2002-01-30 Thread Nick Wilson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Jeff Sheltren blurted > Actually, from what I understand, with the persistent connection, it is > left open even after the script is finished - that's why it's called > persistent. Read this excerpt from the link I sent you: Yes, a

Re: [PHP] mysql_pconnect & mysql_connect

2002-01-30 Thread jtjohnston
Actually, from what I understand, with the persistent connection, it is left open even after the script is finished - that's why it's called persistent. Jeff, (Not Jim :) - it's getting way late for my tired eyes :) Sorry. Thanks. I suppose I had to read it one more time. That at least makes sen

Re: [PHP] mysql_pconnect & mysql_connect

2002-01-30 Thread Jeff Sheltren
At 11:40 PM 1/2/2002 -0500, jtjohnston wrote: >Jim, > >Thanks. What I don't really get is what persistent means. > >A problem I'm having with my mysql server is that it is a whole bunch of >messages with in the space of 5 minutes like: > >020130 16:11:08 C:\PROGRA~1\EASYPHP\MySql\bin\mysqld.exe:

Re: [PHP] mysql_pconnect & mysql_connect

2002-01-30 Thread jtjohnston
Jim, Thanks. What I don't really get is what persistent means. A problem I'm having with my mysql server is that it is a whole bunch of messages with in the space of 5 minutes like: 020130 16:11:08 C:\PROGRA~1\EASYPHP\MySql\bin\mysqld.exe: Forcing close of thread 3 user: 'root' All I have to

Re: [PHP] mysql_pconnect & mysql_connect

2002-01-30 Thread Jeff Sheltren
At 11:09 PM 1/2/2002 -0500, jtjohnston wrote: >What is the difference between: > >$myconnection = mysql_connect($server,$user,$pass); >and >$myconnection = mysql_pconnect($server,$user,$pass); > >I read the faq. mysql_pconnect creates a persistent connection to the server... check here: http://ww

Re: [PHP] mysql_pconnect to remote system

2001-10-23 Thread Andrey Hristov
The setting of the your user in Mysql is maybe to connecto only from localhost (their machine) if you want to connect from anywhere else you receive an error. Maybe this is your case. Decide : 1)post your error message here for better solution (use mysql_error) or 2)contact your ISP if your thi

RE: [PHP] mysql_pconnect()

2001-09-19 Thread Jack Dempsey
#.. -Original Message- From: Kurth Bemis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 9:38 PM To: Rasmus Lerdorf; Christian Dechery Cc: [EMAIL PROTECTED] Subject: Re: [PHP] mysql_pconnect() its barley decent :-) ~kurth >We have gone to some trouble to provide dec

Re: [PHP] mysql_pconnect()

2001-09-19 Thread Kurth Bemis
its barley decent :-) ~kurth >We have gone to some trouble to provide decent documentation for PHP. > >http://www.php.net/manual/en/features.persistent-connections.php > >-Rasmus > >On Thu, 13 Sep 2001, Christian Dechery wrote: > > > what is the real advantage or use of mysql_pconnect() ?? > > >

Re: [PHP] mysql_pconnect()

2001-09-19 Thread Rasmus Lerdorf
We have gone to some trouble to provide decent documentation for PHP. http://www.php.net/manual/en/features.persistent-connections.php -Rasmus On Thu, 13 Sep 2001, Christian Dechery wrote: > what is the real advantage or use of mysql_pconnect() ?? > > can I do transactions between pages or som

RE: [PHP] mysql_pconnect

2001-07-25 Thread Don Read
On 25-Jul-2001 Dan Goodliffe wrote: > Just a question out of pure curiosity... > > If an SQL link is opened using, mysql_pconnect when does it actually close? > When its 'sleep' time exceeds 'wait_timeout' defined in the server (or possibly never on a working site). $ mysqladmin var | grep