… (-f) The row format can be -4 (REDUNDANT) or -5 (COMPACT). From 5.0.3 the default format is COMPACT. More information about row format on the… table row format from the Information Schema: mysql (information_schema) > SELECT ROW_FORMAT from TABLES WHERE TABLE_SCHEMA=’employees’ AND TABLE_NAME=’salaries’; +————+ | ROW_FORMAT | +————+ | Compact | +————+ ~/recovery…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…: Comment: InnoDB free: 6144 kB *************************** 2. row *************************** Name: cbool Engine: InnoDB Version: 10 Row_format: Compact Rows: 2097678 Avg_row_length: 34 Data_length: 71942144 Max…: Comment: InnoDB free: 4096 kB *************************** 3. row *************************** Name: tbool Engine: InnoDB Version: 10 Row_format: Compact Rows: 2097405 Avg_row_length: 37 Data_length: 78233600 Max…
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
… one row: mysql> show table status like “test_innodb” \G *************************** 1. row *************************** Name: test_innodb Engine: InnoDB Version: 10 Row_format: Compact Rows: 1 Avg_row_length… like “test_innodb” \G *************************** 1. row *************************** Name: test_innodb Engine: InnoDB Version: 10 Row_format: Compact Rows: 1069 Avg_row_length: 199 Data_length: 212992 Max…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… compression. With the original InnoDB Antelope file format you have the choice of ROW_FORMAT=COMPACT and ROW_FORMAT=REDUNDANT where InnoDB stored the first 768… file format (available since InnoDB plugin 1.1 or MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT=COMPRESSED…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
… real data. This is not exactly what happens 
With COMPACT and REDUNDANT row formats (used in before Innodb plugin and named “Antelope” in…) and 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…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… TABLE STATUS LIKE ‘t’\G *************************** 1. row *************************** Name: t Engine: InnoDB Version: 10 Row_format: Compact Rows: 4195067 Avg_row_length: 29 Data_length: 125452288 Max… TABLE STATUS LIKE ‘t’\G *************************** 1. row *************************** Name: t Engine: InnoDB Version: 10 Row_format: Compact Rows: 4195067 Avg_row_length: 29 Data_length: 125452288 Max…
Comment: Finding out largest tables on MySQL Server
October 6, 2008 By 27 Comments
… table status like ‘table’ \G *************************** 1. row *************************** Name: table Engine: InnoDB Version: 10 Row_format: Compact Rows: 14898977 Avg_row_length: 150 Data_length: 2237661184 Max… table status like ‘table’ \G *************************** 1. row *************************** Name: table Engine: InnoDB Version: 10 Row_format: Compact Rows: 15120698 Avg_row_length: 147 Data_length: 2237661184 Max…
Comment: Blob Storage in Innodb
February 10, 2010 By 13 Comments
… row affected (0.02 sec) mysql> show table status like “comptest” \G *************************** 1. row *************************** Name: comptest Engine: InnoDB Version: 10 Row_format: Compact Rows: 1 Avg_row… 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…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row_length: 241 Data_length: 1616904192 Max…-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log-at-trx…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
… table status like “sample” \G; *************************** 1. row *************************** Name: sample Engine: InnoDB Version: 10 Row_format: Compact Rows: 1638757 Avg_row_length: 61 Data_length: 100253696 Max….27 sec) Table with rather small row size, containing 1638400 rows. Now lets lock all rows in this table and see how long…
