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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: TheBOFH at nc dot rr dot com
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Wed May 07 04:01:27 2025 UTC