Bug #10588: MySQL access slows to a crawl

From: TheBOFH@nc.rr.com Operating system: RH Linux 6.2 PHP version: 4.0.5 PHP Bug Type: Performance problem Bug description: MySQL access slows to a crawl Installed 4.0.5 with Apache 1.3.19, mod_ssl 2.8.2 and OpenSSL 0.9.6a (and originally mod_perl 1.25). Installation went fine, but then I noticed that most access to MySQL (3.23.36) had slowed significantly. Checking Apache's error logs, I noticed frequent Segfaults (11)occurring. Rebuilt Apache without mod_perl. No change in performance. Rolled back to 4.0.4pl1 and things are back to normal. All apps mentioned herein built on this system, no RPMs. PostgreSQL access times appear unaffected. Configuration: ./configure --with-xml --enable-track-vars --with-apxs=/usr/local/apache/bin/apxs --enable-magic-quotes --disable-debug --with-gettext --with-mysql=/usr/local/mysql --with-gd=../gd-1.8.4 --with-pgsql=/usr/local/pgsql -- Edit Bug report at: http://bugs.php.net/?id=10588&edit=1