-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
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)
i can connect via the cli, by doing
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'
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
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.
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
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.
Anyway, I found
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.
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
Hello,
When I use mysqladmin processlist to view the mysql process, there are
a few process in Sleep status. I wonder what makes it sleep, so I
wrote a little script like this:
#!/usr/bin/php4
?
mysql_pconnect(192.168.16.210,myaccount,password);
system(sleep 10);
?
This script will make a
What is the difference between:
$myconnection = mysql_connect($server,$user,$pass);
and
$myconnection = mysql_pconnect($server,$user,$pass);
I read the faq.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
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:
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
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
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
-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
Ok, after all the problems trying to get into the flat file and stuff, i
decided it will just be easier to use mysql... Only problem is the database
is on the machine that is going to host the site when it's done... (Redhat
Linux) and is being developed in my office on a windows box...
So i need
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
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
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
#..
-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
Just a question out of pure curiosity...
If an SQL link is opened using, mysql_pconnect when does it actually close?
Thanks in advance
Dan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To
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
23 matches
Mail list logo
