Re: SOLVED Re: MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-05 Thread Parker Morse
On Friday, Sep 5, 2003, at 13:41 US/Eastern, Thierno Cissé wrote: Finally you seem to say that you 've setting max_connections with a limit. Can you tell how many 100 or 200 ? No. It turns out that setting max_connections to 0 is the same as setting no limit at all. This was my initial misundersta

RE: SOLVED Re: MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-05 Thread Thierno Cissé
ture with MySQL 4.0.14 ? Regards Thierno6C -Original Message- From: Parker Morse [mailto:[EMAIL PROTECTED] Sent: vendredi 5 septembre 2003 15:01 To: [EMAIL PROTECTED] Subject: SOLVED Re: MySQL 4.0.14 stops responding to PHP 4.3.2 On Thursday, Sep 4, 2003, at 12:47 US/Eastern, Parker Morse

SOLVED Re: MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-05 Thread Parker Morse
On Thursday, Sep 4, 2003, at 12:47 US/Eastern, Parker Morse wrote: No, it turns out this is not the key. With mysql_connect() I'm actually failing MORE often than with mysql_pconnect - so far it hasn't stayed up 15 minutes without error. (Fortunately, I have a cron job checking on it and restart

Re: MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-04 Thread Steven Roussey
> No, it turns out this is not the key. With mysql_connect() I'm actually > failing MORE often than with mysql_pconnect - so far it hasn't stayed > up 15 minutes without error. (Fortunately, I have a cron job checking > on it and restarting.) After the failed connection attempt, there will be a

Re: MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-04 Thread Parker Morse
On Thursday, Sep 4, 2003, at 10:03 US/Eastern, Parker Morse wrote: On Thursday, Sep 4, 2003, at 01:27 US/Eastern, Antony Dovgal wrote: Please, read http://www.php.net/manual/en/features.persistent-connections.php I recommend you not to use *_pconnect. There are some big problems with persistent c

Re: MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-04 Thread Parker Morse
On Thursday, Sep 4, 2003, at 01:27 US/Eastern, Antony Dovgal wrote: Please, read http://www.php.net/manual/en/features.persistent-connections.php I recommend you not to use *_pconnect. There are some big problems with persistent connections and these problems are 'by design'. Use SQLrelay if you

Re: MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-03 Thread Antony Dovgal
On Wed, 3 Sep 2003 18:23:00 -0400 "Dan Greene" <[EMAIL PROTECTED]> wrote: > not knowing anything about PHP (java geek, myself), I'm guessing that your > connections are timing out, > and php is not configured to try to reconnect PHP always reconnects, but *_pconnect seeks for the already exi

Re: MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-03 Thread Antony Dovgal
On Wed, 3 Sep 2003 11:42:35 -0400 Parker Morse <[EMAIL PROTECTED]> wrote: > Periodically our PHP sites will fail to connect using mysql_pconnect(). > We currently have three sites on the colo box (two more are waiting on > shared hosting until I can solve this problem) and they all fail at > on

RE: MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-03 Thread Dan Greene
se is somewhat lacking in PHP/MySQL, Dan Greene > -Original Message- > From: Parker Morse [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 03, 2003 11:43 AM > To: [EMAIL PROTECTED] > Subject: MySQL 4.0.14 stops responding to PHP 4.3.2 > > > I've be

MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-03 Thread Parker Morse
I've been using MySQL and PHP for a while in a shared hosting environment, but recently we shifted to a co-located server, so I am new to administering mysqld. Periodically our PHP sites will fail to connect using mysql_pconnect(). We currently have three sites on the colo box (two more are wai