RE: [PHP] mysql_pconnect issue

2008-05-12 Thread Chetan Rane
-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: bruce wrote: hi... running

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 'localhost'

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, where mysql

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.

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 sqlanywhare) I

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 / 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 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:

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

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: Forcing

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

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, and

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

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

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() ?? can I do

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 decent

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