… is highly compressible and light compression can compress results at faster than wire speed for 1Gb networks. Plus if we can get MySQL protocol to support such light compression in addition to zlib we could stream compressed results directly from storage and only de-compress it…
Post: Large result sets vs. compression protocol
December 20, 2007 By 6 Comments
… in a specific one, MYSQL_CLIENT_COMPRESS. This flag tells the client application to enable compression in the network protocol when talking to mysqld. It reduces network traffic but at the cost of some CPU time: server has to compress… client, and client and MySQL are on different boxes, and the connection is 100 Mbit, consider using compression. It’s a matter…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…the amazing MySQL manual, especially the option and variable….commanual profiling_history_sizeblogpercona.commanual protocol_versionblogpercona.commanual proxy_userblogpercona.commanual… skip_thread_priorityblogpercona.commanual slave_compressed_protocolblogpercona.commanual slave_exec_modeblogpercona…
