MYSQL_CLIENT_COMPRESS not working?
| From: | Sebastian Stadtlich | Date: | Fri, 28 Feb 2003 11:32:20 +0000 |
| Subject: | MYSQL_CLIENT_COMPRESS not working? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-137543@lists.php.net to get a copy of this message | ||
Hi all
Is this a Bug? or a feature that i don't understand ?
This is what I do:
mytest.php :
----------------------
$mycmsconn=mysql_connect("$dbip","$dblogin","$dbpass",false,MYSQL_CLIENT
_COMPRESS) ;
$mycmsdataquery="SELECT * FROM foo";
$mycmsdataresult = mysql_query($mycmsdataquery,$mycmsconn);
$mycmsdatarow = mysql_fetch_array($mycmsdataresult);
-----------------------
I test versus my firewall :
29 2486 3685K ACCEPT tcp -- any any anywhere
anywhere state ESTABLISHED tcp spt:mysql
29 1249 65053 ACCEPT tcp -- any any anywhere
anywhere state NEW,ESTABLISHED tcp dpt:mysql
then i restart my firewall and do :
mytest.php :
------------------------
$mycmsconn=mysql_connect("$dbip","$dblogin","$dbpass",false,MYSQL_CLIENT
_COMPRESS) ;
$mycmsdataquery="SELECT * FROM foo";
$mycmsdataresult = mysql_query($mycmsdataquery,$mycmsconn);
$mycmsdatarow = mysql_fetch_array($mycmsdataresult);
------------------------
/etc/init.d/firewall.sh status | grep mysql
29 2486 3684K ACCEPT tcp -- any any anywhere
anywhere state ESTABLISHED tcp spt:mysql
29 1249 65053 ACCEPT tcp -- any any anywhere
anywhere state NEW,ESTABLISHED tcp dpt:mysql
( needless to say that the database server is on a remote host....)
No compresion here?
could anybody please verify this? then i would file in a bug report on
bugs.php.net...
regards
Sebastian