… client thread: Fixed-row format (FRF, Percona Server without this patch applied): Insertions in 900 seconds: 25962452. VmPeak: 6267692 kB Dynamic-row format (DRF): Insertions… of rows inserted). In the second test we check if the dynamic row format delivers the memory savings for VARCHAR fields agains the fixed row format…
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…/O load. This was related to the fact that with DYNAMIC row format InnoDB was able to keep an entire PRIMARY index in… and I’ve tried to convert this table using COMPRESSED row format. This time conversion took 1,5 hours and results were…
Post: How number of columns affects performance ?
September 28, 2009 By 12 Comments
… rows/sec ; 653MB/sec) t99v1 – 12.36 sec (1M rows/sec ; 93MB/sec) This shows there is surely the problem with dynamic row format table with many columns. But is it because of large number of columns or dynamic format on its own… very similarly to how indexes are stored. Summary: Beware of dynamic row format tables with many columns they might bite you with surprise…
Comment: Adventures in archiving
February 14, 2013 By 16 Comments
…). #drop table if exists $table_dynamic; create table $table_dynamic like $table; alter table $table_dynamic row_format=dynamic; insert into $table_dynamic select * from $table limit…; create table $table_16 like $table; alter table $table_16 row_format=compressed key_block_size=16; insert into $table_16 select…
Post: Percona Server 5.5.15-21.0
August 31, 2011 By 10 Comments
….5.15, a Fixed Row Format (FRF) is still being used in the MEMORY storage engine. The fixed row format imposes restrictions on the type of columns as it assigns on advance a limited amount of memory per row. This… tables. This implementation is based on the Dynamic Row Format (DFR) introduced by the mysql-heap-dynamic-rows patch. DFR is used to store column…
Comment: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 5, 2008 By 15 Comments
… to clarify that the Barracuda file format only ENABLES new features that require an on-disk format change. Unless you create tables that use compression, or unless your table takes advantage of the new DYNAMIC row format (where… difference in performance between enabling the default Antelope format and the new Barracuda format. I know you’re not using compression for…
Comment: Concatenating MyISAM files
November 19, 2012 By 5 Comments
Yves, It works in simple case I wonder how it works if tables have deleted rows (would not delete chain be all weird) and also how about dynamic row format (Varchar etc) would it also work or is it fixed row format feature only ?
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
… Application Developers. Sometimes a good workaround is not even possible; dynamic row format in memory engine is an example of such a feature…
Comment: Dynamic row format for MEMORY tables
September 24, 2012 By 5 Comments
Laurynas, Just checking whether MEMORY engine dynamic row format was already implemented for internal tables? I could not find this info anywhere. If not, is there a tentative release day? Gene
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
… ? This depends on 3 factors. Blob size; Full row size and Innodb row format. But before we look into how BLOBs are really…) 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… which are often stored outside the page. COMPRESSED row format is similar to DYNAMIC when it comes to handling blobs and will use…
