In your my.cnf conf I don’t see barracuda file format and did you create your table using row_format = compressed with InnoDB which enables tablespace compression ?
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… InnoDB’s new Barracuda file format (available since InnoDB plugin 1.1 or MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT=COMPRESSED… via a null-operation like this: ALTER TABLE `t1` ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16; In our case even though the…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
…. How blobs are stored in Innodb ? This depends on 3 factors. Blob size; Full row size and Innodb row format. But before we look into… specified and compression for normal data and index pages is not enabled. If you’re interested to learn more about Innodb row format check out this page in Innodb docs: It is worth to note I…
Post: Adventures in archiving
February 11, 2013 By 16 Comments
… `compressed_row` ( `id` int(11) NOT NULL AUTO_INCREMENT, `dat` varchar(1000) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED KEY… disk Engine Compression Ratio 7.1M Archive 173.07:1 304M InnoDB row_format=compressed key_block_size=4 4.04:1 648M compress() 1.897:1 1.2G InnoDB 1:1 Immediately…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I’ve tried was DYNAMIC row format. After 3,5… row format InnoDB was able to keep an entire PRIMARY index in memory (TEXT and BLOB fields are stored off-page in this format… optimizations and I’ve tried to convert this table using COMPRESSED row format. This time conversion took 1,5 hours and results were…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
… tables: 19693 sec, for compressed tables: 38278 sec. Compressed tables are create as: ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8, with …compressed tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression…
Comment: Blob Storage in Innodb
February 10, 2010 By 13 Comments
… table status like “comptest” \G *************************** 1. row *************************** Name: comptest Engine: InnoDB Version: 10 Row_format: Compressed Rows: 1 Avg_row_length: 32768 Data_length: 32768 Max_data… Checksum: NULL Create_options: row_format=COMPRESSED Comment: 1 row in set (0.00 sec) In this this is highly compressible long blob gets some…
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…uses dynamic or static record format ? (static record format for sort used by…least MySQL 5.1 with row level replication readily available. …
Comment: Adventures in archiving
February 14, 2013 By 16 Comments
Just been playing around with innodb compression and KEY_BLOCK_SIZE. One should really try *all* permitted …; create table $table_01 like $table; alter table $table_01 row_format=compressed key_block_size=1; insert into $table_01 select * from…; create table $table_16 like $table; alter table $table_16 row_format=compressed key_block_size=16; insert into $table_16 select * from…
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
… InnoDB storing two rows on a page. If you’re using compression, however, you can store a single row on a page. If your row has variable length columns and the complete row size… approaches you can take to solve this: Upgrade to Barracuda format This is probably the simplest approach, and as Barracuda only…
