Re: Re: PHP 4.0 Bug #4223 Updated: PHP calls MySQL with apache user instead of connected user
| From: | Zak Greant | Date: | Sun, 30 Jul 2000 16:08:10 +0000 |
| Subject: | Re: Re: PHP 4.0 Bug #4223 Updated: PHP calls MySQL with apache user instead of connected user | ||
| References: | 1 2 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-26961@lists.php.net to get a copy of this message | ||
AFAIK there is no way to set a timeout for the persistant connections in PHP
zak
----- Original Message -----
From: "Louis van Dompselaar" <louis@sitebysite.nl>
To: "Bug Database" <php-dev@lists.php.net>
Sent: Sunday, July 30, 2000 6:38 AM
Subject: [PHP-DEV] Re: PHP 4.0 Bug #4223 Updated: PHP calls MySQL with
apache user instead of connected user
> As far as I can gather it has something to do with the
> wait_timeout of MySQL. This was set pretty low. I think
> the persistent connections outlived the connections on the
> database side during quiet periods. The error doesn't
> seem to appear if I up this timeout or bring down the
> life span of the apache child processes. Is there a
> way to set a timeout on the persistent connections
> on the php side? That would enable one to match it
> against the MySQL timeout and make sure it never happens.
>
> > ID: 4223
> > Updated by: zak
> > Reported By: louis@sitebysite.nl
> > Status: Feedback
> > Bug Type: MySQL related
> > Assigned To:
> > Comments:
> >
> > ** Warning - uneducated guess **
> >
> > This seems like it might be a mysql configuration issue.
> >
> > Please review the MySQL documentation on performance - try increasing
the max number of connections, etc...
> >
> > Also, what user does you web server run as - www by chance?
> >
> > Full Bug description available at: http://bugs.php.net/?id=4223¥Òé;o
> > &}ö^C6Ù[
>
> --
> Louis van Dompselaar louis@sitebysite.nl
> Site by Site B.V. Duivendrechtsekade 85, 1096 AJ Amsterdam
> Tel: 020 665 7148 fax: 020 665 7279 http://www.sitebysite.nl/
>
> --
> PHP Development Mailing List <http://www.php.net/>
> To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net
> For additional commands, e-mail: php-dev-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>