…MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog…compressed…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
…COMPRESS/UNCOMPRESS functions or compressing/decompressing things on the client. This choice of server side vs client size compression…compression (some XML data) while in practice table size reduced over 5 times and performance…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression…my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default…the numbers in my next blog post. I will compare performance of various cluster sizes …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… the freshest data to their own clients, with no delays. Finally, the analysis …t store as compactly on disk as [Compressed] MyISAM or Archive. These are just … on data archiving on my own blog a while back. The benefits … The problem is that MySQL doesn’t tend to perform well on a data warehousing…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…which helps improve the performance of queries against a MySQL database by distributing … virtual machines. Baseline: The MySQL command line client was used to execute … 23GB of data. After loading, ICE compressed this data to about 2GB. … data set in a previous blog post. Previous testing was limited …
