InnoDB Plugin releases are numbered with version numbers independent of MySQL release numbers. The initial release of the InnoDB Plugin is version 1.0, and it is designed to work with MySQL 5.1.
The first component of the InnoDB Plugin version number designates a major release level.
The second component corresponds to the MySQL release. The digit 0 corresponds to MySQL 5.1.
The third component indicates the specific release of the InnoDB Plugin (at a given major release level and for a specific MySQL release); only bug fixes and minor functional changes are introduced at this level.
Once you have installed the InnoDB Plugin, you can check its version number in three ways:
In the error log, it is printed during startup
SELECT * FROM information_schema.plugins;
SELECT @@innodb_version;
The InnoDB Plugin writes its version number to the error log, which can be helpful in diagnosis of errors:
091105 12:28:06 InnoDB Plugin 1.0.5 started; log sequence number 46509
Note that the PLUGIN_VERSION
column
in the table INFORMATION_SCHEMA.PLUGINS
does not
display the third component of the version number, only
the first and second components, as in 1.0.
This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).