…’re interested in a specific one, MYSQL_CLIENT_COMPRESS. This flag tells the client application to enable compression in the network protocol when talking to… times worse with compression. The bottom line: if you’re fetching big result sets to the client, and client and MySQL are on different…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
… to keep it compressed. Unfortunately MySQL does not provide compressed BLOB/TEXT columns (I would really love to have COMPRESSED attribute for … by using COMPRESS/UNCOMPRESS functions or compressing/decompressing things on the client. This choice of server side vs client size compression depends on …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…the amazing MySQL manual, especially the option and variable …_set_clientblogpercona.commanual character_set_client_handshakeblogpercona.commanual character_set_connectionblogpercona…. skip_thread_priorityblogpercona.commanual slave_compressed_protocolblogpercona.commanual slave_exec_modeblogpercona….
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… is highly compressible and light compression can compress results at faster than wire speed for 1Gb networks. Plus if we can get MySQL protocol… such light compression in addition to zlib we could stream compressed results directly from storage and only de-compress it on the client. Delayed…
Comment: When should you store serialized objects in the database?
January 22, 2010 By 42 Comments
… to Monty to have compressed columns and change the client-server API to recognize them such that the client API would do the… the server could do it if the client version was old. Unfortunately, MySQL‘s compress/uncompress puts a length header in front of… are welcome to my suggestion to have compressed columns and integrate it at the client/server api level, especially with prepared statements…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… is the excellent compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression is not RLE, I doubt it will have the same impact. For large datasets effective compression…,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
… the underlying storage for the virtual machines. Baseline: The MySQL command line client was used to execute the a script file containing… loading, there was approximately 23GB of data. After loading, ICE compressed this data to about 2GB. The test virtual machine was… shard has about 335MB-350MB of data (23GB raw data, compressed to about 2GB total data. then spread over six servers…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…systems to provide the freshest data to their own clients, with no delays. Finally, the analysis is usually … files don’t store as compactly on disk as [Compressed] MyISAM or Archive. These are just some ideas I…that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, …
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… performance when using compressed tables and has been removed (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (Yasufumi Kinoshita… was on the FEDERATED engine and a replication environment, its client connection to the remote server was closed leading to an… Slave SQL thread. Bugs Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch…
Post: Idea: Couple of more string types
April 18, 2008 By 12 Comments
… – this would allow to avoid having COMPRESS()/UNCOMPRESS() everywhere which clobbers things or compressing/uncompressing on the client. It would be best if… decompress it on the client and compress bad. Though this is likely to require more significant changes in MySQL so I would not…
