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
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
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
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
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
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
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
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
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 mysql_pcon
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
This script will make a mysql_pconnect(), sleep for 10 seconds and then
end the script. In the s
-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
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
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:
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
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
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 PROT
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
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
#..
-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
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() ??
> >
>
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
what is the real advantage or use of mysql_pconnect() ??
can I do transactions between pages or something? Cuz other than that, I
don't see the point of having a persistent connection... performance maybe?
_
. Christian Dechery
. . Gaita-L Owner / Web Developer
. . h
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
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 contac
24 matches
Mail list logo