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

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

2003-09-05 Thread Thierno Cissé
? 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 wrote: No, it turns out

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

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

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 an

RE: MySQL 4.0.14 stops responding to PHP 4.3.2

2003-09-03 Thread Dan Greene
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 Another option is that you are not closing your connections, so you can't get a new connection to do anything with. Also new to MySQL, I'm

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 once.

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 existing