mysql中查看innodb版本的方法

SELECT * FROM information_schema.plugins\G

mysql 5.6.3-m6 的innodb版本为 1.2.3

查看版本方法,可以看到大版本

SELECT * FROM information_schema.plugins;

SELECT @@innodb_version;

MySQL 5.5:

MySQL Plugin Status Date

5.5.18 1.1.8 GA 11/16/2011

5.5.17 1.1.8 GA 10/19/2011

5.5.16 1.1.8 GA 09/15/2011

5.5.15 1.1.8 GA 07/28/2011

5.5.14 1.1.8 GA 07/05/2011

5.5.13 1.1.7 GA 05/31/2011

5.5.12 1.1.6 GA 05/05/2011

5.5.11 1.1.6 GA 04/07/2011

5.5.10 1.1.5 GA 03/15/2011

5.5.9 1.1.5 GA 02/07/2011

5.5.8 1.1.4 GA 12/03/2010

5.5.7 1.1.3 GA 10/14/2010

5.5.6 1.1.2 GA 09/13/2010

5.5.5 1.1.1 Early Adopter 06/06/2010 *3

5.5.4 1.1.0 Beta 04/09/2010 *2

5.5.3 1.0.6 RC 03/24/2010

5.5.2 1.0.6 RC 02/12/2010

5.5.1 1.0.6 RC 01/04/2010

5.5.0 1.0.5 RC 12/07/2009 *1

*1: The InnoDB Plugin is included in MySQL 5.5 releases as the built-in version of InnoDB.

*2: InnoDB has been upgraded to version 1.1. This version is considered of Beta quality.

*3: InnoDB has been upgraded to version 1.1.1. This version is considered of “early adopter” quality.

MySQL 5.1:

MySQL Plugin Status Date

5.1.60 1.0.17 GA 11/16/2011

5.1.59 1.0.17 GA 09/15/2011

5.1.58 1.0.17 GA 07/05/2011

5.1.57 1.0.16 GA 05/05/2011

5.1.56 1.0.15 GA 03/01/2011

5.1.55 1.0.15 GA 02/07/2011

5.1.54 1.0.14 GA 11/26/2010

5.1.53 1.0.13 GA 11/03/2010

5.1.52 1.0.13 GA 10/11/2010

5.1.51 1.0.12 GA 09/10/2010

5.1.50 1.0.11 GA 08/03/2010

5.1.49 1.0.10 GA 07/09/2010

5.1.48 1.0.9 GA 06/02/2010

5.1.47 1.0.8 GA 05/06/2010

5.1.46 1.0.7 GA 04/06/2010

5.1.45 1.0.6 RC 03/01/2010

5.1.44 1.0.6 RC 02/04/2010

5.1.43 1.0.6 RC 01/15/2010

5.1.42 1.0.6 RC 12/15/2009

5.1.41 1.0.5 RC 11/05/2009 *4

5.1.40 1.0.4 Beta 10/06/2009

5.1.39 1.0.4 Beta 09/04/2009

5.1.38 1.0.4 Beta 09/01/2009 *3

x.x.xx 1.0.3 Alpha 03/11/2009

x.x.xx 1.0.2 Alpha 12/01/2008

x.x.xx 1.0.1 Alpha 05/08/2008 *2

x.x.xx 1.0.0 Alpha 04/15/2008 *1

本文出自 “郑鸿健的BLOG” 博客，请务必保留此出处http://tenry.blog.51cto.com/9937729/1615081