… for regular tables: 19693 sec, for compressed tables: 38278 sec. Compressed tables are create as: ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8, with final size… sec. I expected some overhead for compressed tables, but not such: the throughput with compressed tables are 30 transactions per sec. This…
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… 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: 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… load. This was related to the fact that with DYNAMIC row format InnoDB was able to keep an entire PRIMARY index in… optimizations and I’ve tried to convert this table using COMPRESSED row format. This time conversion took 1,5 hours and results were…
Comment: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
December 30, 2011 By 15 Comments
Juan, just make your log table InnoDb too, to get rid of the table locks. Use something like “ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8″ if you need it to use less disk space.
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
…) format and the fix comes with Innodb Plugin in “Barracuda” format and ROW_FORMAT=DYNAMIC. In this format Innodb stores either whole blob on the row… indexes on blobs which are often stored outside the page. COMPRESSED row format is similar to DYNAMIC when it comes to handling blobs… and compression for normal data and index pages is not enabled. If you’re interested to learn more about Innodb row format check…
Post: Trying Archive Storage Engine
November 12, 2006 By 6 Comments
… row in set (0.62 sec) Lets see what table compression gives us: *************************** 1. row *************************** Name: requests_061111 Engine: ARCHIVE Version: 9 Row_format: Dynamic Rows: 8048913 Avg_row_length: 0 Data…
Comment: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 5, 2008 By 15 Comments
… Barracuda file format only ENABLES new features that require an on-disk format change. Unless you create tables that use compression, or unless your table takes advantage of the new DYNAMIC row format (where… between enabling the default Antelope format and the new Barracuda format. I know you’re not using compression for this test. (And it…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row_length: 241 Data… compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression …
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
… 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…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
… posts ourselves about its fast index creation capabilities and the compressed row format, and how that affects performance. One of the nice things… | +—————————————-+ The _CMP tables show statistics about compression; they contain a lot of useful information about compression, decompression, memory management, fragmentation etc. Beware…
