I need to compress the data between my web server and the mysql server.

From what I noticed, you can put a parameter in your my.cnf which enables all client's (including php) to enable compress.

Has anyone tried this? Does it work? PHP's mailing list archives are not too helpful.

Finally, the php sources also have a define called "HAVE_COMPRESS" which I don't see being set / unset anywhere.

Any ideas / suggestions?