June 18, 2013

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

…=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

…) 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

…: #####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

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

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

…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

… 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

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

… 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

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…