… Barracuda file format (available since InnoDB plugin 1.1 or MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT=COMPRESSED. In our case we only wanted MySQL to try…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
… 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…=16 –max-requests=0 –rand-type=uniform –max-time=1800 –mysql-user=root –report-interval=10 run this will report us… sec. I expected some overhead for compressed tables, but not such: the throughput with compressed tables are 30 transactions per sec. This…
Post: Adventures in archiving
February 11, 2013 By 16 Comments
…for further testing. InnoDB’s inbuilt row compression MySQL‘s inbuilt compress() function leveraging zlib to provide compression of data. MySQL‘s Archive storage engine. …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…
Comment: Blob Storage in Innodb
February 10, 2010 By 13 Comments
… Create_options: Comment: 1 row in set (0.00 sec) mysql> alter table comptest row_format=compressed; Query OK, 1 row affected (0.62 sec) Records… Warnings: 0 mysql> show table status like “comptest” \G *************************** 1. row *************************** Name: comptest Engine: InnoDB Version: 10 Row_format: Compressed Rows: 1 Avg_row_length: 32768 Data…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…format_checkblogpercona.commanual innodb_file_format…row_lock_time_maxblogpercona.commanual Innodb_row_lock_waitsblogpercona.commanual Innodb_rows_deletedblogpercona.commanual Innodb_rows_insertedblogpercona.commanual Innodb_rows_readblogpercona.commanual Innodb_rows…slave_compressed_…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
… COMPACT (MySQL 5.0 and above) format and the fix comes with Innodb Plugin in “Barracuda” format and ROW_FORMAT=DYNAMIC. In this format Innodb stores… indexes on blobs which are often stored outside the page. COMPRESSED row format is similar to DYNAMIC when it comes to handling blobs…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…very different compression ratio. As Innodb indexes are not prefix compressed they have very good compression potential… it uses dynamic or static record format ? (static record format for sort used by MyISAM … because they target at least MySQL 5.1 with row level replication readily available. …
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
…see what table compression gives us: *************************** 1. row *************************** Name: requests_061111 Engine: ARCHIVE Version: 9 Row_format: Dynamic Rows: 8048913 Avg_row_length:…-rw-rw—- 1 mysql mysql 19 Nov 12 11:31 requests_061111.ARM -rw-rw—- 1 mysql mysql 984628803 Nov 12…
Post: Innodb row size limitation
April 7, 2011 By 12 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… changes to your application if you choose XML as format and you use MySQL‘s built in functions for handling this data…
