Repost - nobody has any ideas? I've run some stress tests, sending
several thousand page requests, and the number of mysql processes
goes up and down but over time continues to rise. It's up to about
22 now. When it gets to about 30, every request from the web server
will be will fail.
Could some of these processes be threads that are orphaned for some
reason (perhaps Apache continuing to expire its own processes?) and
hang around, idle? I speculate that there is some maximum number of
processes and finally MySQL can't won't start another thread/process.
GB
On Tuesday 01 May 2001 05:26 pm, Gary E Bickford opined:
> I am running MySQL (3.23.27 at this point) with Apache1.3.12 and
> PHP3 on a PC running Redhat 6.0. My problem has survived upgrades
> of all components from earlier versions.
>
> Every PHP page has at least one query to a MySQL database for
> session tracking (home-rolled code, not PHPLib or anything off the
> shelf) There are also on some pages other queries, to a different
> database, same server (same mysql). Most of the latter are Phorum
> queries.
>
> Periodically the number of mysql instances that show up in 'ps
> auxww'1 gets to about 30 and mysql no longer listens to PHP/Apache.
> However I can still use the mysql shell with no problem, so MySQL
> is still running but can't hear anything from PHP.
>
> The only way to fix it is to run 'apachectl restart' or equivalent.
> 'graceful' doesn't do it. I"m not sure if restarting MySQL instead
> works. After Apache is restarted, the mysql processes are down to
> 3 and everybody's happy again.
>
> I have been trying for months to figure out what is happening and
> how to fix it. I had heard at one point that there was a problem
> with Redhat 5.2 kernel that caused a similar problem, but I
> upgraded that but no joy.
>
> Temporarily I have built a kluge cron job that restarts apache
> every so often, which worked as long as the server was low volume.
> But now usage is dramatically increasing due to some new web sites
> that have been installed and announced to the entire corporation.
> So the problem is triggered before the restart cleans up the mess.
> I can't have it restarting every 20 minutes.
>
> I've also changed every instance of pconnect() to connect() where I
> can, but no difference.
>
> Can anybody tell me anything useful? I'm supposed to come back
> with a firm fixit schedule tomorrow morning, so please email me
> directly as well as on the list - I'm afraid I'll miss it in the
> volume on the list. If I don't get this fixed very shortly my
> consulting contract with this company will no doubt begin to fade
> out!!
>
> Thanks in advance,
> Gary Bickford
>
>
> -------------------------------------------------------------------
>-- Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
