… versions, compression was only possible with streaming backups + external (usually single-threaded) compression utilities…entire backup to restore a single table). Percona XtraBackup now supports streaming incremental…Percona XtraBackup against debug versions of InnoDB. This is only for very advanced…
Post: Testing InnoDB "Barracuda" format with compression
April 23, 2008 By 3 Comments
… from index compression. For test I use dump created with mysqldump, final size 30286M. To create InnoDB compression table I use ENGINE=InnoDB KEY_BLOCK_SIZE=8 and to test fast index creation I create table only with primary…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
… –oltp-table-size=25000000 run Results: Load time for regular tables: 19693 sec, for compressed tables: 38278 sec. Compressed tables are create as: ROW_FORMAT=COMPRESSED KEY…. With compressed tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression tables we…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… 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 tables, such as what is the average size pages were compressed…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… for 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 results…
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… block sizes with ability to set parameter per table and per index would make InnoDB really flexible for different type of use…
Comment: Modeling InnoDB Scalability on Multi-Core Servers
January 31, 2012 By 11 Comments
… disabled. 120131 16:00:43 InnoDB: The InnoDB memory heap is disabled 120131 16:00:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120131 16:00:43 InnoDB: Compressed tables use zlib 1.2.3 120131 16:00:43 InnoDB: Using Linux native AIO 120131 16:00:43 InnoDB: Initializing…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… will 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 row size limitation
April 7, 2011 By 11 Comments
… production for a while. Suppose you have the following table structure: CREATE TABLE example ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, fname… 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…
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… interesting dataset on it. The only table customer has on this server is one huge innodb table with a set of TEXT fields… pages compression (by default it is trying to compress 16kb pages down to 8kb) new innodb plugin performs TEXT/BLOB/VARCHAR fields compression off…
