注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

老狗的博客

尽管每一步都很微小,但我确认我在进步

 
 
 

日志

 
 
关于我
sky

认真生活,努力工作 热爱技术,关注DB,存储,分布式,中间层,java,c++,php

网易考拉推荐

innodb存储引擎版本介绍  

2012-05-23 22:02:21|  分类: 默认分类 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

innodb的历史

In 1995 Heikki Tuuri founded Innobase Oy to develop InnoDB. In September 2000 Innobase Oy started collaboration with MySQL AB, which resulted in the release of MySQL that incorporated InnoDB in March 2001.

1995年,heikki Tuuri创建了innobase oy公司开发Innodb,在2000年9月innobase oy开始和mysql AB合作,2001年3月,包含innodb的mysql版本发布

InnoDB was originally closed source, but was released to open source after Innobase failed to find a buyer for InnoDB and started collaboration with MySQL. MySQL tried to close a deal with Innobase in the following years, but eventually Oracle acquired Innobase in October, 2005. Oracle eventually also acquired Sun Microsystems, owner of MySQL AB, in January 2010.

innodb原始是不开源的,但是在innodb找不到买家的情况下,innobase选择了开源开始和mysql合作,在接下来几年里,mysql一致想完成和innobase的交易,但是在2005年十月oracle把innobase买了下来,而且在2010年一月,oracle又买了sun,mysqlAB的拥有者,原来有钱真的是万能的。。。。


版本介绍

Starting with version 5.1, MySQL AB has promoted the idea of a “pluggable” storage engine architecture , which permits
multiple storage engines to be added to MySQL. Beginning with MySQL version 5.1, it is possible for users to swap out
one version of InnoDB and use another. The pluggable storage engine architecture also permits Innobase Oy to release
new versions of InnoDB containing bug fixes and new features independently of the release cycle for MySQL

翻译:从版本5.1开始,mysql AB 已经支持了pluggable storage engine架构,开始允许多个存储引擎添加到mysql中,也就是说从mysql5.1版本开始,用于可以废掉mysql自带的innodb版本,使用其他的版本,可插拔的存储架构也允许innobase oy独立于mysql 发布自己的innodb版本,当然这些版本会包含一些bug的修复和新的特性

结论:从这段话可以看出,innodb build-in version和innodb plugin的关系,innodb build-in为mysql团队维护,从属于mysql代码之中,随同mysql一块升级发布,而innodb plugin为innobase团队维护,独立于mysql,有自己的版本体系,所以innodb plugin的功能和特性会相对更多,更新一些

At the 2008 MySQL User Conference, Innobase announced availability of an InnoDB Plugin for MySQL. This plugin for
MySQL exploits the “pluggable storage engine” architecture of MySQL, to permit users to replace the “built-in” version of
InnoDB in MySQL 5.1.
从2008年mysql用户大会开始,innobase发布了innodb plugin,plugin充分利用了mysql可插拨的架构,允许用户替换掉mysql5.1中内置的版本

Percona XtraDB is an enhanced version of the InnoDB storage engine, designed to better scale on modern hardware, and including a variety of other features useful in high performance environments. It is fully backwards compatible, and so can be used as a drop-in replacement for standard InnoDB.


percona xtraDB是innodb 存储引擎的提高版本,设计用于提供更好的扩展性,包含了一些在高性能环境中非常有用的特性,它完全向后兼容,可以作为标准innodb存储引擎的一个替换

Percona XtraDB includes all of InnoDB ‘s robust, reliable ACID-compliant design and advanced MVCC architecture, and builds on that solid foundation with more features, more tunability, more metrics, and more scalability. In particular, it is designed to scale better on many cores, to use memory more efficiently, and to be more convenient and useful. The new features are especially designed to alleviate some of InnoDB ‘s limitations. We choose features and fixes based on customer requests and on our best judgment of real-world needs as a high-performance consulting company



具体版本情况

As of MySQL 5.1.38, the InnoDB Plugin is included in MySQL 5.1 releases, in addition to the built-in version of InnoDB
that has been included in previous releases. MySQL 5.1.42 through 5.1.45 include InnoDB Plugin 1.0.6, which is considered
of Release Candidate (RC) quality. MySQL 5.1.46 and up include InnoDB Plugin 1.0.7 or higher, which is considered
of General Availability (GA) quality.

从mysql 5.1.38开始,除了内建版本之外,innodb plugin也被包含于mysql 5.1版本之中,mysql 5.1.42到5.1.45,包含了innodb plugin 1.0.6, mysql 5.1.46包含了innodb plugin 1.0.7,等等,从mysql5.5开始,innodb plugin已经开始作为mysql的内建版本

GA = generally available
rc = release candidate(发行候选版本)

innodb存储引擎版本介绍 - sky - 老狗的博客
 
innodb存储引擎版本介绍 - sky - 老狗的博客
 
innodb plugin功能


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

innodb plugin提供了一些新的特性,提高了性能,可扩展性,可靠性和灵活性,易用性等,比较重要的有:快速索引创建,表和索引的压缩,文件格式管理,新的information_schema表,能力优化,多个后台i/o线程等,以及group commit功能

多个后台I/o线程
在5.1的内建版本中,innodb的io线程只有四个,分别为insert buffer thread,log thread,read thread,write thread, 限制了系统的io读写能力
innodb存储引擎版本介绍 - sky - 老狗的博客
 
innodb plugin自从1.0.4开始,read thread的数目和write thread的数目开始变的可配置

group commit
对于事务性存储引擎在安全事务要求下,每个事务在提交之前,必须刷新redo log到磁盘上去,group commit就是将flush requests进行合并然后再写redo log,梦寐以求的功能,大大的提高性能,其实mysql以前有,在mysql4.0版本中去掉了,原因是引入了分布式事务,为了保证写log的顺序

以后有空再写
  评论这张
 
阅读(754)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018