InnoDB Plugin 1.0 for MySQL 5.1 User's Guide  /  Introduction to the InnoDB Plugin  /  Viewing the InnoDB Plugin Version Number

1.4. Viewing the InnoDB Plugin Version Number

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.

User Comments
Sign Up Login You must be logged in to post a comment.