… 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: 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: 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 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: 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: 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: 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: 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…
