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 |
*1: The initial release of the InnoDB Plugin is based on the built-in InnoDB in MySQL version 5.1.
*2: These 4 versions (1.0.0 – 1.0.3) were only available as separate downloads.
3: 1st Release of Plugin (see 1* below for more details)
*4: InnoDB Plugin has been upgraded to version 1.0.5. This version is considered of Release Candidate (RC) quality.
MariaDB:
| MariaDB |
Plugin |
Status |
Date |
Comments |
| 5.1.55 |
1.0.15 |
GA |
03/01/11 |
If use InnoDB Plugin |
| 5.1.55 |
1.0.15-12.5 |
GA |
03/01/11 |
If use built-in InnoDB, which is XtraDB+ in MariaDB *1 |
| 5.2.9 |
1.0.15-12.7 |
GA |
09/22/11 |
|
| 5.3.2 |
1.0.15-12.7 |
GA |
10/14/11 |
|
*1: XtraDB+ differs some from XtraDB as it contains even further enhancements on top of XtraDB. Please see the following 2 links for more details on these differences:
http://kb.askmonty.org/en/mariadb-53-asynchronous-io-on-windows-with-innodb (work by Wlad)
http://www.facebook.com/note.php?note_id=10150211546215933 (work by KNielsen)
There are even some more optimizer additions, but no graphs yet to report.
Changelogs:
Note: The plugin versions had their own changelogs initially, but eventually the changes were just mixed into the general changelogs for the MySQL Server.
Note: Also, some plugin versions span multiple MySQL versions, so those have multiple links below.
Plugin 1.0:
1.0.0 http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-changes-100.html
1.0.1 http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-changes-101.html
1.0.2 http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-changes-102.html
1.0.3 http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-changes-103.html
1.0.4 http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-changes-104.html
1.0.5 http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-changes-105.html
1.0.6 http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-changes-106.html
1.0.7 http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-changes-107.html
1.0.8 http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-changes-108.html
1.0.9 http://dev.mysql.com/doc/refman/5.1/en/news-5-1-48.html
1.0.10 http://dev.mysql.com/doc/refman/5.1/en/news-5-1-49.html
1.0.11 http://dev.mysql.com/doc/refman/5.1/en/news-5-1-50.html
1.0.12 http://dev.mysql.com/doc/refman/5.1/en/news-5-1-51.html
1.0.13 http://dev.mysql.com/doc/refman/5.1/en/news-5-1-52.html
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-53.html
1.0.14 http://dev.mysql.com/doc/refman/5.1/en/news-5-1-54.html
1.0.15 http://dev.mysql.com/doc/refman/5.1/en/news-5-1-55.html
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-56.html
1.0.16 http://dev.mysql.com/doc/refman/5.1/en/news-5-1-57.html
1.0.17 http://dev.mysql.com/doc/refman/5.1/en/news-5-1-58.html
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-59.html
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-60.html
Plugin 1.1:
1.1.0 http://dev.mysql.com/doc/innodb/1.1/en/innodb-changes-11.html
1.1.1 http://dev.mysql.com/doc/refman/5.5/en/news-5-5-5.html
1.1.2 http://dev.mysql.com/doc/refman/5.5/en/news-5-5-6.html
1.1.3 http://dev.mysql.com/doc/refman/5.5/en/news-5-5-7.html
1.1.4 http://dev.mysql.com/doc/refman/5.5/en/news-5-5-8.html
1.1.5 http://dev.mysql.com/doc/refman/5.5/en/news-5-5-9.html
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-10.html
1.1.6 http://dev.mysql.com/doc/refman/5.5/en/news-5-5-11.html
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-12.html
1.1.7 http://dev.mysql.com/doc/refman/5.5/en/news-5-5-13.html
1.1.8 http://dev.mysql.com/doc/refman/5.5/en/news-5-5-14.html
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-15.html
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-16.html
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-17.html
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-18.html
Misc. Notes:
5.1.38 is first release of the plugin
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-38.html
And for reference, here is the text from that announcement regarding the InnoDB Plugin:
C.1.1. Changes in MySQL 5.1.38
As of MySQL 5.1.38, the InnoDB Plugin is included in MySQL
releases, in addition to the built-in version of InnoDB that
has been included in previous releases. This version of the
InnoDB Plugin is 1.0.4 and is considered of Beta quality.
The InnoDB Plugin offers new features, improved performance
and scalability, enhanced reliability and new capabilities
for flexibility and ease of use. Among the features of the
InnoDB Plugin are "Fast index creation," table and index
compression, file format management, new INFORMATION_SCHEMA
tables, capacity tuning, multiple background I/O threads, and
group commit.
For information about these features, see the InnoDB Plugin
Manual at
http://www.innodb.com/products/innodb_plugin/plugin-documentation
For general information about using InnoDB in MySQL,
see Section 13.6, "The InnoDB Storage Engine."
The InnoDB Plugin is included in source and binary
distributions, except RHEL3, RHEL4, SuSE 9 (x86, x86_64,
ia64), and generic Linux RPM packages.
To use the InnoDB Plugin, you must disable the built-in
version of InnoDB that is also included and instruct the
server to use InnoDB Plugin instead. To accomplish this, use
the following lines in your my.cnf file:
[mysqld]
ignore-builtin-innodb
plugin-load=innodb=ha_innodb_plugin.so
For the plugin-load option, innodb is the name to associate
with the plugin and ha_innodb_plugin.so is the name of the
shared object library that contains the plugin code. The
extension of .so applies for Unix (and similar) systems. For
HP-UX on HPPA (11.11) or Windows, the extension should be .sl
or .dll, respectively, rather than .so.
If the server has problems finding the plugin when it starts
up, specify the pathname to the plugin directory. For
example, if plugins are located in the lib/mysql/plugin
directory under the MySQL installation directory and you have
installed MySQL at /usr/local/mysql, use these lines in your
my.cnf file:
[mysqld]
ignore-builtin-innodb
plugin-load=innodb=ha_innodb_plugin.so
plugin_dir=/usr/local/mysql/lib/mysql/plugin
The previous examples show how to activate the storage engine
part of InnoDB Plugin, but the plugin also implements several
InnoDB-related INFORMATION_SCHEMA tables. (For information
about these tables, see
http://www.innodb.com/doc/innodb_plugin-1.0/innodb-information-schema.html)
To enable these tables, include additional name=library
pairs to the plugin-load option:
[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
The plugin-load option here is formatted on multiple lines
for display purposes but should be written in my.cnf using a
single line without spaces in the option value. On Windows,
substitute .dll for each instance of the .so extension.
After the server starts up, verify that InnoDB Plugin has
been loaded by using the SHOW PLUGINS statement. For example,
if you have loaded the storage engine and the
INFORMATION_SCHEMA tables, the output should include lines
similar to these:
mysql> SHOW PLUGINS;
+---------------------+--------+--------------------+---------------------...
| Name | Status | Type | Library ...
+---------------------+--------+--------------------+---------------------...
| InnoDB | ACTIVE | STORAGE ENGINE | ha_innodb_plugin.so ...
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so ...
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so ...
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so ...
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so ...
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so ...
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | ha_innodb_plugin.so ...
+---------------------+--------+--------------------+---------------------...
If you build MySQL from a source distribution, InnoDB Plugin
is one of the storage engines that is built by default. Build
MySQL the way you normally do; for example, by using the
instructions at Section 2.10, "MySQL Installation Using a
Source Distribution." After the build completes, you should
find the plugin shared object file under the
storage/innodb_plugin directory, and make install should
install it in the plugin directory. Configure MySQL to use
InnoDB Plugin as described earlier for binary distributions.
Misc Links:
http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-plugin-introduction.html
http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-changes.html
http://dev.mysql.com/doc/refman/5.5/en/innodb-5-5.html
http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-plugin-installation.html
转自:http://www.chriscalender.com/?p=479
近期评论