XtraDB 存储引擎升级到 1.0.2-3 春季版 - 开源中国社区
Float_left Icon_close
XtraDB 存储引擎升级到 1.0.2-3 春季版
红薯 2009年03月03日

XtraDB 存储引擎升级到 1.0.2-3 春季版

红薯 红薯 发布于2009年03月03日 收藏 0 评论 0

做APP,小程序就上开源众包。世界杯期间免费领2600元启动金。>>>  

XtraDB 是一个MySQL 的存储引擎,其设计的主要目的是用以替代现在的 InnoDB 。XtraDB 100%的兼容 InnoDB 。

该版本主要的改进包括:

  • Move to MySQL 5.1.31
  • Scalability fix — ability to use several rollback segments
  • Increasing the number of rseg may be helpful for CPU scale of write-intentional workloads. See benchmark results.

  • Scalability fix — replaced page_hash mutex to page_hash read-write lock. See benchmark results.
  • Fix broken group commit in InnoDB
  • As you know, the group commit of InnoDB doesn’t work after MySQL 5.0 with binlog.
    We pretend to fix this and added “innodb_enable_unsafe_group_commit=[0|1]” parameter. Note if you set this parameter to “1″ record order of binlog and InnoDB transaction log could be not same. But because InnoDB manages transactions in correct order most users may not have problem with this.

  • New parameters in the XtraDB io patches:
    • innodb_ibuf_max_size — Restrict innodb-insert-buffer size
    • innodb_ibuf_active_contract — Enabling it makes the each user threads positive to contract the insert buffer as possible in asynchronous
    • innodb_ibuf_accel_rate — This parameter is additional tuning the amount of insert buffer processing by background thread.
    • innodb_flush_neighbor_pages — When you use the storage which don’t have “head seek latency” (e.g. SSD or enough Write-Buffered), 0 may show better performance.
  • Changed parameter for control read ahead activity. Now it accepts string values:
    • innodb_read_ahead = [none|random|linear|both]
  • Deb builds for Ubuntu

下载地址:http://www.percona.com/docs/wiki/percona-xtradb:xtradb_downloads

本站文章除注明转载外,均为本站原创或编译。欢迎任何形式的转载,但请务必注明出处,尊重他人劳动共创开源社区。
转载请注明:文章转载自 开源中国社区 [http://www.oschina.net]
本文标题:XtraDB 存储引擎升级到 1.0.2-3 春季版
分享
评论(0)
最新评论
顶部