[PHP-DEV] Bug #10588 Updated: MySQL access slows to a crawl

[sniper]

ID: 10588
Updated by: sniper
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DEV] Bug #10588 Updated: MySQL access slows to a crawl

[andi]

ID: 10588
Updated by: andi
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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


-- 
PHP Development Mailing List 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]