You can look into increasing the number of allowed connections that MySQL
will accept... are you using connect or pconnect?
At 04:23 PM 5/3/2001 -0700, Gary Bickford wrote:
>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
---------------------------------------------------------------------
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"By working faithfully eight hours a day you may eventually get to be boss
and work twelve hours a day." - Robert Frost, 1874 - 1963
---------------------------------------------------------------------
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
