Innodb 和 XtraDB 结构和性能优化

所需积分/C币:47 2013-09-28 14:16:11 535KB PDF
收藏 收藏

Innodb 和 XtraDB 结构和性能优化 (出处: OSSEZ)
Aspects or Architecture General Architecture Storage and File layout Threads Memory Disk o Logging Indexes Mu|ti∨ versioNing Row Locking Latching PERc○NA Performance Consulting Experts Aspects of Architecture 2 Page flushing and Replacement Insert Buffering Adaptive Hash Index BLOB Storage Recovery Compression Features Foreign Keys PERc○NA Performance Consulting Experts innodb∨ ersions MySQL 5. 1 and below ots of limits. Poor Scalability Innodb Plugin for MySQL 5.1(1.0.X) Scales better, Fast index creation Compression MySQL 5.5(version 1.1.x Scalability further imroved XtraDB Based on Innodb plugin 5. 1 and version in 5.5 Has added features, performance improvements Available in percona server and mariadB PERc○NA Performance Consulting Experts General Architecture Traditional oltP engine “ Emulates oracle architecture” Implemented using My sQL Storage engine AP Row Based Storage. Row Locking. MVCC Data Stored in Tablespaces Log of changes stored in circular log files Data pages as pages in“ Buffer pool” PERc○NA Performance Consulting Experts Storage Files Layout Physical structure of Innodb Tabespaces and logs PERc○NA Performance Consulting Experts nnodb Tablespaces All data stored in Tablespaces Changes to these databases stored in circular logs Changes has to be reflected in tablespace before log record is overwritten Single tablespace or multiple tablespace innodb file per table=1 System information always in main tablespace lobata 1 Main tablespace can consist of many files They are concatenated PERc○NA Performance Consulting Experts ablespace Format Collection of Segments Segment is like a“fle Segment is number of extents Typically 64 of 16K page sizes Smaller extents for very small objects First Tablespace page contains header Tablespace size Tablespace id PERc○NA Performance Consulting Experts 10 ypes of Segments Each table is set of indexes Innodb has index organized tables Each index has Leaf node segment Non Leaf node segment Special Segments Rollback Segment(s) nsert buffer. etc PERc○NA Performance Consulting Experts

试读 95P Innodb 和 XtraDB 结构和性能优化
立即下载 低至0.43元/次 身份认证VIP会员低至7折
  • GitHub

  • 签到新秀

  • 分享王者

关注 私信 TA的资源
Innodb 和 XtraDB 结构和性能优化 47积分/C币 立即下载
Innodb 和 XtraDB 结构和性能优化第1页
Innodb 和 XtraDB 结构和性能优化第2页
Innodb 和 XtraDB 结构和性能优化第3页
Innodb 和 XtraDB 结构和性能优化第4页
Innodb 和 XtraDB 结构和性能优化第5页
Innodb 和 XtraDB 结构和性能优化第6页
Innodb 和 XtraDB 结构和性能优化第7页
Innodb 和 XtraDB 结构和性能优化第8页
Innodb 和 XtraDB 结构和性能优化第9页
Innodb 和 XtraDB 结构和性能优化第10页
Innodb 和 XtraDB 结构和性能优化第11页
Innodb 和 XtraDB 结构和性能优化第12页
Innodb 和 XtraDB 结构和性能优化第13页
Innodb 和 XtraDB 结构和性能优化第14页
Innodb 和 XtraDB 结构和性能优化第15页
Innodb 和 XtraDB 结构和性能优化第16页
Innodb 和 XtraDB 结构和性能优化第17页
Innodb 和 XtraDB 结构和性能优化第18页
Innodb 和 XtraDB 结构和性能优化第19页

试读结束, 可继续读1页

47积分/C币 立即下载 >