InnoDB Development History

Some twists and turns in InnoDB and MySQL history:

• The InnoDB engine was developed by Innobaseoy Corporation.
• In 2001, Innobase started working with MySQL AB and open source InnoDB storage engine code.
• Oracle acquired Innobase Company in 2005 with a lightning-swift momentum.
• 2008 Sun Company acquired MySQL AB company.
• Oracle acquired Sun in 2009, and the MySQL database finally reached Oracle's hands, and InnoDB storage engine and MySQL were finally together again.

Released in 2008 InnoDB Plugin, for MySQL version 5.1, is the next generation InnoDB engine created by Oracle and is owned by InnoDB rather than MySQL.

Google,percona,sun Microsystems and other companies provide patch packages for InnoDB plugin to achieve maximum performance.

In the previous version of MySQL 5.1.38, when you need to install InnoDB plugin, you must download the plugin file, unzip it, and then perform a series of installation.

Starting with MySQL 5.1.38, MySQL contains 2 different versions of the InnoDB storage Engine-an older version of the engine, called Build-in InnoDB, and the other 1.0.4 version of the InnoDB storage engine. If you want to use the new INNDB plugin engine, simply make the following settings in the configuration file:

[mysqld]  ignore-builtin-innodb  plugin-load=innodb=ha_innodb_plugin.so;  innodb_trx=ha_innodb_plugin.so; innodb_locks=ha_innodb_plugin.so;  innodb_cmp=ha_innodb_plugin.so;  innodb_cmp_reset=ha_innodb_plugin.so;   innodb_cmpmem=ha_innodb_plugin.so;  innodb_cmpmem_reset=ha_innodb_plugin.so;  

MySQL5.5 uses InnoDB as the default engine and you no longer need to do any installation. This engine is InnoDB Plugin, which has become the default engine distributed along with MySQL. To better utilize the engine's features, the following configuration is recommended:

innodb_file_per_table=1innodb_file_format=barracudainnodb_strict_mode=1

Innodb_strict_mode=1 is used to open InnoDB strict mode, in strict mode innodb in some conditions will be directly error, rather than warn or conservative processing some syntax.
INNODB_FILE_FORMAT Specifies the file format, InnoDB currently supports both types of files, antelope and barracuda. Antelope in the old file format, it is the MySQL5.5 default format to maximize compatibility with previous versions, supporting compact and redundant line formats. Barracuda is a new file format that supports both the dynamic and compressed row formats, while TRUNCATE TABLE is faster.
innodb_file_per_table=1 says that each table uses a separate tablespace, and there are many benefits to be addressed later.

InnoDB Development History