#39684 [NEW]: send data from mysql to php takes long time

[v at sas dot nsk dot su]

From: v at sas dot nsk dot su
Operating system: OpenBSD
PHP version: 5.2.0
PHP Bug Type: MySQL related
Bug description: send data from mysql to php takes long time

Description:
------------
Hello!
I have problem:
I have IPB forum installed. After search in IPB (search takes about 3-4
seconds for post table about 300 000 records) mysql shows "Sending Data"
status and takes about 3-5 minutes.

I tested with PHP 5.2, PHP 4.4, PHP 4.2.3 - with same results.
I switched from MySQL 4.2.18 to 4.2.21 and 4.2.22 with same result.

I tested with apache module, fastCGI with NGINX web server - same results.


I tested mysql connections with socket and network connection.

May be I missed some variables from php.ini?
Main question - how I can speedup code for accept "Sending data" stage
between PHP and MySQL more fast?



--
Edit bug report at [url]http://bugs.php.net/?id=39684&edit=1[/url]
--
Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=39684&r=trysnapshot44[/url]
Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=39684&r=trysnapshot52[/url]
Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=39684&r=trysnapshot60[/url]
Fixed in CVS: [url]http://bugs.php.net/fix.php?id=39684&r=fixedcvs[/url]
Fixed in release: [url]http://bugs.php.net/fix.php?id=39684&r=alreadyfixed[/url]
Need backtrace: [url]http://bugs.php.net/fix.php?id=39684&r=needtrace[/url]
Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=39684&r=needscript[/url]
Try newer version: [url]http://bugs.php.net/fix.php?id=39684&r=oldversion[/url]
Not developer issue: [url]http://bugs.php.net/fix.php?id=39684&r=support[/url]
Expected behavior: [url]http://bugs.php.net/fix.php?id=39684&r=notwrong[/url]
Not enough info: [url]http://bugs.php.net/fix.php?id=39684&r=notenoughinfo[/url]
Submitted twice: [url]http://bugs.php.net/fix.php?id=39684&r=submittedtwice[/url]
register_globals: [url]http://bugs.php.net/fix.php?id=39684&r=globals[/url]
PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=39684&r=php3[/url]
Daylight Savings: [url]http://bugs.php.net/fix.php?id=39684&r=dst[/url]
IIS Stability: [url]http://bugs.php.net/fix.php?id=39684&r=isapi[/url]
Install GNU Sed: [url]http://bugs.php.net/fix.php?id=39684&r=gnused[/url]
Floating point limitations: [url]http://bugs.php.net/fix.php?id=39684&r=float[/url]
No Zend Extensions: [url]http://bugs.php.net/fix.php?id=39684&r=nozend[/url]
MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=39684&r=mysqlcfg[/url]

[tony2001@php.net]

ID: 39684
Updated by: [email]tony2001@php.net[/email]
Reported By: v at sas dot nsk dot su
-Status: Open
+Status: Bogus
Bug Type: MySQL related
Operating System: OpenBSD
PHP Version: 5.2.0
New Comment:

Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit [url]http://www.php.net/support.php[/url] as this bug system is not the
appropriate forum for asking support questions. Due to the volume
of reports we can not explain in detail here why your report is not
a bug. The support channels will be able to provide an explanation
for you.

Thank you for your interest in PHP.




Previous Comments:
------------------------------------------------------------------------

[2006-11-29 14:44:28] v at sas dot nsk dot su

Description:
------------
Hello!
I have problem:
I have IPB forum installed. After search in IPB (search takes about 3-4
seconds for post table about 300 000 records) mysql shows "Sending Data"
status and takes about 3-5 minutes.

I tested with PHP 5.2, PHP 4.4, PHP 4.2.3 - with same results.
I switched from MySQL 4.2.18 to 4.2.21 and 4.2.22 with same result.

I tested with apache module, fastCGI with NGINX web server - same
results.

I tested mysql connections with socket and network connection.

May be I missed some variables from php.ini?
Main question - how I can speedup code for accept "Sending data" stage
between PHP and MySQL more fast?




------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=39684&edit=1[/url]