ID: 47017
Updated by: u...@php.net
Reported By: surfchen at gmail dot com
-Status: Assigned
+Status: To be documented
Bug Type: MySQL related
Operating System: Any
PHP Version: 5.3CVS-2009-01-06 (snap)
Assigned To: mysql
New Comment:
mysqlnd now supports the compressed protocol.
Previous Comments:
------------------------------------------------------------------------
[2009-10-09 14:20:02] u...@php.net
The patch is ready and tested. It will be committed once PHP 5.3.1 has
been released.
------------------------------------------------------------------------
[2009-02-03 11:52:12] johan...@php.net
MYSQL_CLIENT_COMPRESS, in most cases, costs CPU but doesn't result in a
measurable gain in throughput. It will most likely not be implemented in
mysqlnd till 5.3.0 is released.
------------------------------------------------------------------------
[2009-01-19 09:56:17] surfchen at gmail dot com
typo:
there is error,warning => there is no error,warning
------------------------------------------------------------------------
[2009-01-08 12:22:35] surfchen at gmail dot com
> Is the bug that the connection cannot be used after setting the flag
or that the compressed protocol is not supported?
This is can be used for mysql_get_server_info()(maybe this function was
getting these info on connecting) and similar functions,but can't be
used for mysql_query().What's more,when using for mysql_set_charset(),a
large memory was allocated(Fatal error: Allowed memory size of 134217728
bytes exhausted (tried to allocate 807601282 bytes)),It's so
strange.(memory problem is another topic, sorry for explaining here.)
> Do you use the compression and how does it make your application run
faster?
I can't follow your meaning.This question seems not related to our
topic.
> Is your MySQL server on the local network or remote?
I have tested both unix socket and tcp in my box.No "network".And my
mysql server have compression enabled(it need to be enable?I forget.).It
can be connected and used with php ext/mysql driven by lib libmysql with
the MYSQL_CLIENT_COMPRESS.so it's not a server problem.
Let me desc more detail.
I don't know mysqlnd how to link and use compression lib,but I have
compile with "./configure --with-mysql=mysqlnd --with-zlib
--with-zlib-dir=/usr/local" and I can see "ZLib Support => enabled" in
php -i(means that the zlib dir are correct.), and During the
compilation,there is error ,warning or notice tell me that "you was
doing incorrectly".
This bug is raised whether enable zts or not.
------------------------------------------------------------------------
[2009-01-08 10:48:51] and...@php.net
Is the bug that the connection cannot be used after setting the flag or
that the compressed protocol is not supported? Do you use the
compression and how does it make your application run faster? Is your
MySQL server on the local network or remote?
Thanks you!
Andrey
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/47017
--
Edit this bug report at http://bugs.php.net/?id=47017&edit=1
