Re: PHP 4.0 Bug #4223 Updated: PHP calls MySQL with apache user instead of connected user
| From: | Louis van Dompselaar | Date: | Sun, 30 Jul 2000 13:38:05 +0000 |
| Subject: | Re: PHP 4.0 Bug #4223 Updated: PHP calls MySQL with apache user instead of connected user | ||
| References: | 1 | Groups: | php.dev |
| Request: | Send a blank email to php-dev+get-26953@lists.php.net to get a copy of this message | ||
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
--
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/