how to find innodb plugin version in mysql??

how do I find Innodb Plugin version number in MySQL.

here is a query that you can use to get detailed info

 SELECT * FROM Plugins WHERE PLUGIN_NAME LIKE '%innodb%' AND PLUGIN_TYPE LIKE 'STORAGE ENGINE';

you can also do the following to get full version no. (or look at the error log where Innodb stores full version no.)

SELECT @@innodb_version;

Edited 1 time(s). Last edit at 12/21/2011 03:27PM by sherry.