… large Blob (and potentially compress it) If all columns do not fit to the page completely Innodb will automatically chose some of…) 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…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… example how compression in InnoDB plugin could be useful for large warehousing tasks. One of our clients had really many problems with one of… to try to convert customer’s data to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I’ve…
Comment: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 5, 2008 By 15 Comments
…’re not using compression for this test. (And it wouldn’t make sense anyway with an in-memory database, since compression is a… created and indexed using the InnoDB Plugin with its new Fast Index Creation capability (which does not require Barracuda format), there should be no…
Comment: Should you move from MyISAM to Innodb ?
January 22, 2009 By 53 Comments
… if we changed from Barracuda back to Antelope file format. We do not have compression then, but InnoDB plugin performs with around 13000 samples/second on inserts compared to 2000-3000 with Barracuda and compression. cheers
Comment: Innodb row size limitation
April 9, 2011 By 11 Comments
Starting with the InnoDB plugin InnoDB checks this and won’t let you even create the ….1.47 plugin and now InnoDB checks that you can’t possibly exceed the size if: 1. You’re using innodb_strict_mode = 1. 2. or you are using the Barracuda format and the table is dynamic or compressed. The relaxation…
Comment: Innodb row size limitation
April 7, 2011 By 11 Comments
Starting with the InnoDB plugin InnoDB checks this and won’t let you even create the ….1.47 plugin and now InnoDB checks that you can’t possibly exceed the size if: 1. You’re using innodb_strict_mode = 1. 2. or you are using the Barracuda format and the table is dynamic or compressed. The relaxation…
Post: xtrabackup-1.1
March 24, 2010 By 5 Comments
… is built on a base of MySQL 5.1.44 with InnoDB plugin 1.0.6 Added –host option tar4ibd can treat over… method for stream, even tar is specified the binary supports compressed tables and Baraccuda format Fixed bugs: Bug #529874: innobackupex cannot… exit code of xtrabackup executable Bug #498660: xtrabackup not handling barracuda compressed table format Bug #498660: innobackupex doesn’t pass –defaults-files…
Post: xtrabackup-0.9.5rc
October 24, 2009 By 13 Comments
… are InnoDB and you DO NOT CARE about binary log position of backup XtraBackup is ported for InnoDB Plugin 1.0.4. Barracuda file format as well as compressed tables are supported. We thank a… directory” Bug #417178 in Percona-XtraBackup: “can’t backup tables with $ in name” The binary packages for RHEL4,5, Debian, FreeBSD…
Comment: Modeling InnoDB Scalability on Multi-Core Servers
January 31, 2012 By 11 Comments
…InnoDB: Compressed tables use zlib 1.2.3 120131 16:00:43 InnoDB: Using Linux native AIO 120131 16:00:43 InnoDB…InnoDB: Completed initialization of buffer pool 120131 16:00:43 InnoDB: highest supported file format is Barracuda. 120131 16:00:43 InnoDB…
