… examines very little data. It seems that InnoDB performs better when a larger number of rows must be joined together (Q4.1… user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…representation of it in a browser-displayable format. It lets you click through the hierarchy… AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `… Names, number of children, parents, count of columns, row counts, and comments — a great way for…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…were conducted with approximately 78GiB of data (32 tables, 10M rows each) and a 4GiB buffer pool. The cache devices were… innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
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: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… so. However, if you can, you should consider moving to InnoDB altogether. There are very few reasons to stay with MyISAM… would be good if your async master can use ROW based binlog format as well to achieve better consistency, if you have…
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… above) 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 page…. 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: 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 bytes… via a null-operation like this: ALTER TABLE `t1` ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16; In our case even though…
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… and I’ve tried to convert this table using COMPRESSED row format. This time conversion took 1,5 hours and results were…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… default format is COMPACT. More information about row format on the following link: http://dev.mysql.com/doc/refman/5.5/en/innodb-physical-record.html You can also get the table row format from the Information Schema: mysql (information_schema) > SELECT ROW_FORMAT from…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…: NULL Create_options: Comment: InnoDB free: 6144 kB *************************** 2. row *************************** Name: cbool Engine: InnoDB Version: 10 Row_format: Compact Rows: 2097678 Avg_row_length: 34 Data_length…: NULL Create_options: Comment: InnoDB free: 4096 kB *************************** 3. row *************************** Name: tbool Engine: InnoDB Version: 10 Row_format: Compact Rows: 2097405 Avg_row_length: 37 Data_length…
