php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #10588 MySQL access slows to a crawl
Submitted: 2001-05-01 15:55 UTC Modified: 2001-06-21 23:33 UTC
From: TheBOFH at nc dot rr dot com Assigned:
Status: Closed Package: MySQL related
PHP Version: 4.0.5 OS: RH Linux 6.2
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2001-05-01 15:55 UTC] TheBOFH at nc dot rr dot 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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-05-01 16:02 UTC] 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-06-04 04:49 UTC] 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-06-21 23:33 UTC] sniper@php.net 
No feedback, assumed fixed in PHP 4.0.6. If not, reopen.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Fri Apr 19 17:01:30 2024 UTC