Re: Question about the level of compression used in

#1

--=-cu8tevbBtdY59M/i/444
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Mon, 2006-05-01 at 17:59 -0700, Mark Callaghan wrote:

Quote:

The function my_compress (in mysys/my_compress.c) uses the default level=20
of zlib compression when compressing network packets. For my=20
unscientific sample data 'gzip -1' is 2.5 to 3X faster than 'gzip' (the=20
default level of compression made the result file 25% smaller than the=20
fastest level). With a mysqld compiled to use the fastest level of zlib=20
compression, fetches of large amounts of data were faster when using the=20
fastest level of zlib compression rather than the default. These=20
results held even when the client and server were reasonably far apart=20
(ping time is 60ms).
=20
My belief is that compression of network packets is more likely to be=20
useful when the fastest level of zlib compression is used. Of course,=20
MySql clients with really high latency connections to servers or uses=20
where network traffic is significantly more expensive than server CPU=20
time may disagree.

It sounds like it would be a good thing to make configurable. Possibly
per connection as well

I'm sure we'd be willing to help where needed if you wanted to write a
patch.
--=20
Stewart Smith, Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616 (AT) sip (DOT) us.mysql.com
Mobile: +61 4 3 8844 332

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html

--=-cu8tevbBtdY59M/i/444
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQBEWtUaKglWCUL+FDoRAqaNAJwJ0yQoU4ffNwJazrq0RQ GRu3S8mACgtrvd
GkF0z0THPYLLvpWQCEOUIdA=
=gYXw
-----END PGP SIGNATURE-----

--=-cu8tevbBtdY59M/i/444--

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Question about the level of compression used in

mailing.database.mysql-internals mailing.database.mysql-internals

Re: Question about the level of compression used in - 05-04-2006 , 11:31 PM