… it. The only table customer has on this server is one huge innodb table with a set … format using new InnoDB plugin recently released by Oracle. First thing I’ve tried was DYNAMIC row format. … compress 16kb pages down to 8kb) new innodb plugin performs TEXT/BLOB/VARCHAR fields compression off-page …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…InnoDB plugin is that it only works when indexes are explicitly created using ALTER TABLE…table. To illustrate this, I have performed a number of simple benchmarks. Let’s start with a table…
Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
May 24, 2008 By Leave a Comment
… compressed row format, and how that affects performance. One of the nice things they added in this InnoDB release is INFORMATION_SCHEMA tables that… on InnoDB locks even in the older versions of InnoDB, but it’s not really easy.) These tables are fully documented in the InnoDB plugin…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB… Adaptive Flushing for the InnoDB Plugin. The engine being ‘swamped’… done by REPAIR TABLE. The table data page size… stored in RAM. The format is quite compact (especially …
Comment: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 5, 2008 By 15 Comments
… not expect a significance difference in performance between enabling the default Antelope format and the new Barracuda format. I know you’re not… tests used tables created and indexed using the InnoDB Plugin with its new Fast Index Creation capability (which does not require Barracuda format), there…
Comment: Innodb row size limitation
April 9, 2011 By 11 Comments
… InnoDB plugin InnoDB checks this and won’t let you even create the table if it’s possible for…You’re using innodb_strict_mode = 1. 2. or you are using the Barracuda format and the table is dynamic…query and could probably improve performance by moving some of it to another table. A classic example is…
Comment: Innodb row size limitation
April 7, 2011 By 11 Comments
… InnoDB plugin InnoDB checks this and won’t let you even create the table if it’s possible for…You’re using innodb_strict_mode = 1. 2. or you are using the Barracuda format and the table is dynamic…query and could probably improve performance by moving some of it to another table. A classic example is…
Comment: Should you move from MyISAM to Innodb ?
January 22, 2009 By 53 Comments
… facilitate pruning, we chose the maximum amount of partitions per table, which currently corresponds to 3,5 days per partition (partition… a good performance increase if we changed from Barracuda back to Antelope file format. We do not have compression then, but InnoDB plugin performs with…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…table_instances_lostblogpercona.commanual Performance_schema_thread_classes_lostblogpercona.commanual Performance_schema_thread_instances_lostblogpercona.commanual pid_fileblogpercona.commanual pluginblogpercona.commanual plugin_dirblogpercona.commanual plugin…
