Re: Many processes in SHOW PROCESSLIST;

2002-03-05 Thread Steven Roussey
> > PMFJI, but has anyone done any testing to see if persistent > > connections with MySQL and PHP is actually faster in practice? > > Without testing, I suspect that it is faster but that the gains are > very small. If this was Oracle, it'd be a whole different story. The > connection

Re: Many processes in SHOW PROCESSLIST;

2002-03-05 Thread BD
At 10:24 PM 3/4/2002 , you wrote: >On Mon, Mar 04, 2002 at 01:47:42PM -0600, BD wrote: > > > > Jeremy, > > > > PMFJI, but has anyone done any testing to see if persistent > > connections with MySQL and PHP is actually faster in practice? > >What's PMFJU? "Pardon me for jumping in" >Wit

Re: Many processes in SHOW PROCESSLIST;

2002-03-04 Thread Jeremy Zawodny
On Mon, Mar 04, 2002 at 01:47:42PM -0600, BD wrote: > > Jeremy, > > PMFJI, but has anyone done any testing to see if persistent > connections with MySQL and PHP is actually faster in practice? What's PMFJU? Without testing, I suspect that it is faster but that the gains are very small.

Re: Many processes in SHOW PROCESSLIST;

2002-03-04 Thread BD
At 01:13 PM 3/4/2002 , you wrote: >On Mon, Mar 04, 2002 at 11:19:54AM +0100, Takacs Istvan wrote: > > Hi, > > > > We use mysql 1.23.47 as a database for our PHP based accounting > > system. We use mysql_pconnect() to get a connection to the DB. > > This morning we couldn't log in because mysql se

Re: Many processes in SHOW PROCESSLIST;

2002-03-04 Thread Jeremy Zawodny
On Mon, Mar 04, 2002 at 11:19:54AM +0100, Takacs Istvan wrote: > Hi, > > We use mysql 1.23.47 as a database for our PHP based accounting > system. We use mysql_pconnect() to get a connection to the DB. > This morning we couldn't log in because mysql sent back a 'too many > open connection!' (or

Many processes in SHOW PROCESSLIST;

2002-03-04 Thread Takacs Istvan
Hi, We use mysql 1.23.47 as a database for our PHP based accounting system. We use mysql_pconnect() to get a connection to the DB. This morning we couldn't log in because mysql sent back a 'too many open connection!' (or someting like that) error message. If I use the command SHOW PROCESSLIST tha