… TEXT field was compressed which we felt indicated there would be a benefit derived from table compression. With the original InnoDB Antelope file… innodb_file_format=BARRACUDA; One caveat: you must be running with innodb_file_per_table=1 as the InnoDB system tablespace cannot be compressed, see this page for further details on how to enable compression…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… compress for the whole table. Among other things compression for data pages and uncompressed index pages can be significantly different. Q2: Does Innodb…_PAGE_COMPRESS_LIMIT (UNIV_PAGE_SIZE / 2) Q5: When Innodb free space becomes available for use within same object? When does Innodb make…
Post: Innodb Caching (part 2)
May 10, 2011 By 7 Comments
… trying standard Innodb page size, 4KB page size as 16K page size compressed to 4. The data in this case compresses perfectly (all pages could be compressed to desired 4K) value…. Compression results come as a huge disappointment. The compressed .idb file was only 620MB so if Innodb would chose to keep only compressed pages…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… this 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…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin… 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…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
… would make them transparently compressed) but you well can do it yourself by using COMPRESS/UNCOMPRESS functions or compressing/decompressing things on the… with true data size and performance gains, especially for Innodb tables. With Innodb tables BLOB gets its own page (allocated outside of…
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
… last version of xtrabackup and compress it I noticed that gzip is unacceptable slow for both compression and decompression operations. Actually Peter… results also by request from comments. For compression test I took ~12GB of InnoDB data files generated by tpcc benchmark with 100… in all cases Level 1 of compression shows better tradeoff between size of archive and compression/decompression time There is no obvious…
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
… limit is a consequence of InnoDB storing two rows on a page. If you’re using compression, however, you can store a… data is, the worse compression will work). Something important to note is that the result of the COMPRESS function is always binary… be combined. For example, using the single BLOB field with COMPRESS/UNCOMPRESS can yield great results. Finally, let me mention that…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… is done on physical level here (cold backup, slave backup, innodb hot backup or snapshot backup) as this is only way… LZO default compression file compressed in 10.5 seconds and resulted in 390MB compressed file, this gives us 97MB/sec compression speed which is good enough to compress…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
… performance implications it causes. First lets see how key compression works. Key compression applies on the block boundaries – first index value is… compared to integer keys. Integer keys still best but for Innodb for example difference is not so large. Let us try… packing them it is almost no brainer Summary: Key prefix compression is cool feature and may give great space savings. Defaults…
