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

