May 25, 2012

Post: MySQL Blob Compression performance benefits

MySQL code and having them work on the application side as well which gives you best of both approaches. Onecompressed data storage. Before going ahead with compression I usually run some checks to see how much compression

Post: High-Performance Click Analysis with MySQL

can write CSV files with any programming language.  Naturally, CSV files don’t store as compactly on disk as [Compressed… takes one row, and an ad that gets one impression takes exactly the same: onecan be overcome, but how much time do you have?  And the gains are simply limited by some of MySQL

Post: Identifying the load with the help of pt-query-digest and Percona Server

… server. As we can see here the one causing the highest load …the # MISC part, it tells you how much of “load” is not covered by…can use to gather more data about the underlying tables involved and the query execution plan used by MySQL…name column, or you might even compress the values stored in the …

Post: Heikki Tuuri Innodb answers - Part I

how your data will compress for the whole table. Among other things compression for data pages and uncompressed index pages can…Cool. This is one of little known new features in MySQL 5.1 Q15: How frequently does … 8xN bytes will be allocated) Question: How much space InnoDB allocates for each blob …

Post: Falcon Storage Engine Design Review

… cache is great as it means it can have much more data cached in the same cache…We should however see how “compact” they would be in real world cases and how much performance it will… in MySQL anyway though). Very interesting to see how this one will compare to transparent gzip page compression

Post: MySQL Users Conference - Innodb

can‘t be compressed to specified page size and will have to consume more than one…. It is also rather interesting how is sort file structured for building … sorted so they should be much faster for IO Bound Index …from Google released so many MySQL patches so we can call patched version GoogleSQL…

Post: How would you compress your MySQL Backup

MySQL Database most people compress them – which cancompressed file. This gives us compression speed of about 21MB/sec – clearly much less than even single SATA hard drive can

Post: Trying Archive Storage Engine

one of server used for web request profiling stats…mysql mysql 984628803 Nov 12 11:29 requests_061111.ARZ -rw-rw—- 1 mysql mysql 9162 Nov 12 11:00 requests_061111.frm Canhow much table would take if compressed with bzip2 – it took a while to compress but result was 310MB 40% better than compressed

Post: The case for getting rid of duplicate “sets”

… process data in sets, which can be much faster than processing it serially…you distribute computation you work faster. How can we effectively reduce the data …one minus-two, at least two fifteens, etc select * from compressed join search_set using (val) where compressed.cnt >= search_set.cnt; mysql

Post: Innodb row size limitation

…; Now you insert some test data into it: mysql> INSERT INTO example -> VALUES ( ->   NULL, ->Â…code in a lot of places. How much you can win with this approach depends a lot…COMPRESS/UNCOMPRESS can yield great results. Finally, let me mention that handling of overflow pages involves other things one