Bug #10588 Updated: MySQL access slows to a crawl

ID: 10588 Updated by: sniper Reported By: TheBOFH@nc.rr.com Old-Status: Feedback Status: Closed Bug Type: MySQL related Operating system: PHP Version: 4.0.5 Assigned To: Comments: No feedback, assumed fixed in PHP 4.0.6. If not, reopen. Previous Comments: --------------------------------------------------------------------------- [2001-06-04 04:49:01] sniper@php.net Please try PHP 4.0.6RC2 from: http://www.php.net/~andi/php-4.0.6RC2.tar.gz as there has been one critical fix into the pgsql code which might have caused this.. --Jani --------------------------------------------------------------------------- [2001-05-01 16:02:05] andi@php.net Can you try compiling with --with-mysql (without /usr/local/mysql). Maybe the built-in client will work better for you. Please report back. Thanks. --------------------------------------------------------------------------- [2001-05-01 15:55:52] TheBOFH@nc.rr.com 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 --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=10588&edit=2