… if needed. In previous versions, compression was only possible with streaming backups + external (usually single-threaded) compression utilities, which also had a… for compiling and running Percona XtraBackup against debug versions of InnoDB. This is only for very advanced users. The new features…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
InnoDB compression is getting some traction, and I see quite contradictory opinions. Someone has successful deployments in productions, and someone says that compression… compressed tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression tables…
Post: Testing InnoDB "Barracuda" format with compression
April 23, 2008 By 3 Comments
…’ as compressed field, doing compress()/uncompress() to store/restore. To test InnoDB compression I use only uncompressed text, though I tested compression on compress()-ed data… from index compression. For test I use dump created with mysqldump, final size 30286M. To create InnoDB compression table I use ENGINE=InnoDB KEY…
Post: InnoDB page sizes: plans and ideas
April 21, 2011 By 8 Comments
… needed ? For InnoDB compression. Right now if you use 16K and trying to compress, the only good choice is to compress to 8K pages (which gives you only 2:1 compress ratio), and you rarely will be able to compress to…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… Innodb table, while data pages and pages for different indexes may well have very different compression ratio. As Innodb indexes are not prefix compressed they have very good compression potential. I also would like to see some stats about compressed…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 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…
