On Wed, 1 Oct 2003 21:17:09 -0700 (PDT) Chris Shiflett <[EMAIL PROTECTED]> wrote:
> --- Nicole <[EMAIL PROTECTED]> wrote: > > So I switched to connect, with no luck in fixing the "too many > > connections" problem. > > Now that's some helpful information. The first thing you need to do is > forget about persistent connections being the problem. > > I don't claim to be an expert at debugging MySQL issues such as this, > but I have always found Jeremy Zawodny's mytop to be a very handy > tool: > > http://jeremy.zawodny.com/mysql/mytop/ You problem may well be that 100 apache processes * dozens of tables = thousands of open mysql-connected threads, and they are not being closed for a default 8 HOURS. You can see them in PhpMyAdmin's process list. You'll want something like this in your mysql.ini file to reduce the time-outs: [mysqld] set-variable = max_connections=750 set-variable = wait_timeout=60 set-variable = thread_cache_size=40 # after 60 secs, expire any waiting threads # but keep up to 40 available in a cache for easy re-use. JZ mentions thread caching here: http://jeremy.zawodny.com/blog/archives/000173.html Running a PHP cache like PHP Accellerator will also help, so the PHP isn't being reparsed all the time as well. Alister -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
