Bug #10588 Updated: MySQL access slows to a crawl

ID: 10588 Updated by: andi Reported By: TheBOFH@nc.rr.com Status: Open Bug Type: Performance problem PHP Version: 4.0.5 Assigned To: Comments: 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. Previous Comments: --------------------------------------------------------------------------- [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