… keep it compressed. Unfortunately MySQL does not provide compressed BLOB/TEXT columns (I would really love to have COMPRESSED attribute for the BLOB/TEXT columns which would make them transparently compressed) but…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
… on blobs which are often stored outside the page. COMPRESSED row format is similar to DYNAMIC when it comes to handling blobs and will use the same strategy storing BLOBs completely off page. It however will always compress blobs which do not…
Post: Idea: Couple of more string types
April 18, 2008 By 12 Comments
… BLOB COMPRESSED/ TEXT COMPRESSED) which would transparently compress the blobs when they are inserted and retrieved from the database – this would allow to avoid having COMPRESS… clobbers things or compressing/uncompressing on the client. It would be best if last one is optimized so if BLOB is not…
Comment: Blob Storage in Innodb
February 10, 2010 By 13 Comments
… TAIL which gets compressed. So if you have 10K blob (does not fit into the page) which can be compressed to 4K (will…_options: row_format=COMPRESSED Comment: 1 row in set (0.00 sec) In this this is highly compressible long blob gets some 50 times smaller 
Also note this less than 1MB blob takes about 1.5M…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… go with gzip compression instead of implementing “classical” approach of index prefix compression ? HT: The reason is that index prefix compression prevents one… whole record R. Also, a gzip compression potentially compresses the database more than just prefix compression. The downside in gzip is increased usage… 8100 bytes InnoDB will not allocate additional space for blobs, even if each blob is larger than 768. 2. InnoDB will allocate…
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
… data is, the worse compression will work). Something important to note is that the result of the COMPRESS function is always binary, so for example, you should use a BLOB instead of a TEXT… approaches can be combined. For example, using the single BLOB field with COMPRESS/UNCOMPRESS can yield great results. Finally, let me mention…
Post: My Innodb Feature wishes
May 4, 2006 By 30 Comments
… is caused by the fact Innodb does not have prefix compression for its indexes, as MyISAM has which in certain cases… to have gzip like page compression but it would only give up to 2 times space compression. Insert buffer for delete. For… outside of it. The other item with blobs – currently if I’m not mistaken blobs are stored each in its own “segment…
Comment: Blob Storage in Innodb
February 17, 2010 By 13 Comments
… important, use row compression and pay the CPU price on your DB server, or have your application compress/decompress upon INSERT/SELECT… for indexing or searching. If you think you need multiple blob columns, then as Peter suggested, consider combining them into 1 blob and on the application side splitting up the blobs. That might not so easy either…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…, clustered by (user_id,message_id). [+] Row compression Falcon uses some nice fast row compression methods, for example using only as many… often. [+] Blob handling optimizations Jim loves BLOBs as his own child, so Falcon is optimized in Blob handling for example having direct blob writes…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… optimizations and I’ve tried to convert this table using COMPRESSED row format. This time conversion took 1,5 hours and… pages compression (by default it is trying to compress 16kb pages down to 8kb) new innodb plugin performs TEXT/BLOB/VARCHAR fields compression off-page so every large TEXT field could become as small as a few bytes if its compression…
