MYSQL_CLIENT_COMPRESS not working?

From: 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

« previous php.general (#137543) next »