…=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… symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id` int(10…_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Notice that in the case of child… Metadata files come in to play Creating a Metadata File The format of the metadata file is XML-based. I have included the metadata file…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…: #####fixed 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_log_buffer_size = 128M innodb…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 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: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…Also, we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now conflicts,…other tools: –user, –host, –port, –password, –socket, –defaults-file. So now the command line is what … like the pt-query-digest –output json format in future releases after receiving real-world …
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could… data to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I’ve tried was DYNAMIC row format. After 3… data file and 30% drop in our I/O load. This was related to the fact that with DYNAMIC row format InnoDB was…
Post: Future InnoDB File Formats
April 15, 2008 By 14 Comments
Looking into InnoDB docs I found list of names of future InnoDB file formats: Antelope, Barracuda, Cheetah, Dragon, Elk, Fox, Gazelle, Hornet, Impala, Jaguar…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… innodb_file_format=BARRACUDA (don’t forget to set it in my.cnf!): SET GLOBAL innodb_file_format=BARRACUDA; One caveat: you must be running with innodb_file_per_table=1 as the InnoDB system tablespace cannot be…
Post: Testing InnoDB "Barracuda" format with compression
April 23, 2008 By 3 Comments
New features of InnoDB – compression format and fast index creation sound so promising so I spent … dump into table with default format and all indexes (case 1) – 152m34.792s size of final .ibd file for (case 1) – 43032M What if load data and indexes separately: load dump into table with default format and without…
