… using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could…’s 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, Kangaroo…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log-at-trx-commit=1 innodb-flush-method=O_DIRECT innodb-ibuf-active-contract=1 innodb…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… were innodb_buffer_pool_size=16G innodb_log_file_size=1900M innodb_flush_log_at_trx_commit=2 innodb_doublewrite=1 innodb_flush_method=O_DIRECT innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file…
Comment: Percona Server 5.1.47-rel11.0
June 25, 2010 By 13 Comments
…€“with-plugins=partition,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,innodb_plugin,myisam,myisammrg –with-big-tables –without-debug…€“with-ssl my.ini add options default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict_mode=1 it work Percona server 10…
Comment: Percona Server 5.1.47-rel11.0
June 24, 2010 By 13 Comments
…€“with-plugins=partition,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,innodb_plugin,myisam,myisammrg –with-big-tables –without-debug…€“with-ssl my.ini add options default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda innodb_strict_mode=1 it work Percona server 10…
Comment: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 17, 2008 By 25 Comments
Does this build support Zlib compression, i.e. innodb_file_format=Barracuda
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…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… innodb_concurrency_tickets 500 innodb_data_file_path ibdata1:10M:autoextend innodb_data_home_dir /rdsdbdata/db/innodb innodb_doublewrite ON innodb_fast_shutdown 1 innodb_file_format Antelope innodb_file_format_check Barracuda innodb_file_per_table ON innodb…
Comment: Innodb Performance Optimization Basics
July 29, 2011 By 70 Comments
Nice post, but the basic MySQL tuning for innodb you need its to set the database ( innodb_file_format ) to barracuda and remember to “export / import” the database after mysql restart and remeber BACKUP before the changes, its will speed you perfome op 
