http://wiki.eijux.com/index.php?action=history&feed=atom&title=InnoDB%EF%BC%9AInnoDB_%E4%BD%93%E7%B3%BB%E7%BB%93%E6%9E%84 2026-04-29T07:15:09Z 本wiki上该页面的版本历史 MediaWiki 1.38.2 http://wiki.eijux.com/index.php?title=InnoDB%EF%BC%9AInnoDB_%E4%BD%93%E7%B3%BB%E7%BB%93%E6%9E%84&diff=6546&oldid=prev 2023-03-31T15:14:30Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="zh-Hans-CN"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2023年3月31日 (五) 23:14的版本</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">第1行：</td> <td colspan="2" class="diff-lineno">第1行：</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[category:<del style="font-weight: bold; text-decoration: none;">MySQL</del>]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[category:<ins style="font-weight: bold; text-decoration: none;">MySQL文档</ins>]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== 关于 ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== 关于 ==</div></td></tr> </table>

Eijux http://wiki.eijux.com/index.php?title=InnoDB%EF%BC%9AInnoDB_%E4%BD%93%E7%B3%BB%E7%BB%93%E6%9E%84&diff=2442&oldid=prev 2021-04-19T17:45:29Z

<p><span dir="auto"><span class="autocomment">关于</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="zh-Hans-CN"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2021年4月20日 (二) 01:45的版本</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l11">第11行：</td> <td colspan="2" class="diff-lineno">第11行：</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>InnoDB <del style="font-weight: bold; text-decoration: none;">的三大特性：Buffer Pool（缓冲池）、Adaptive </del>Hash <del style="font-weight: bold; text-decoration: none;">Index（自适应Hash索引）、Doublewrite </del>Buffer（双写缓冲区）</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>InnoDB <ins style="font-weight: bold; text-decoration: none;">的三大特性：'''[http://wiki.eijux.com/InnoDB%EF%BC%9AInnoDB_%E5%86%85%E5%AD%98%E7%BB%93%E6%9E%84#Buffer_Pool.EF.BC.88.E7.BC.93.E5.86.B2.E6.B1.A0.EF.BC.89.E3.80.90.EF.BC.81.EF.BC.81.EF.BC.81.E3.80.91 Buffer Pool（缓冲池）]'''、'''[http://wiki.eijux.com/InnoDB%EF%BC%9AInnoDB_%E5%86%85%E5%AD%98%E7%BB%93%E6%9E%84#Adaptive_Hash_Index.EF.BC.88.E8.87.AA.E9.80.82.E5.BA.94.E5.93.88.E5.B8.8C.E7.B4.A2.E5.BC.95.EF.BC.89.E3.80.90.EF.BC.81.EF.BC.81.EF.BC.81.E3.80.91 Adaptive </ins>Hash <ins style="font-weight: bold; text-decoration: none;">Index（自适应Hash索引）]'''、'''[http://wiki.eijux.com/InnoDB%EF%BC%9AInnoDB_%E7%A3%81%E7%9B%98%E7%BB%93%E6%9E%84#Doublewrite_Buffer.EF.BC.88.E5.8F.8C.E5.86.99.E7.BC.93.E5.86.B2.E5.8C.BA.EF.BC.89.E3.80.90.EF.BC.81.EF.BC.81.EF.BC.81.E3.80.91 Doublewrite </ins>Buffer（双写缓冲区）<ins style="font-weight: bold; text-decoration: none;">]'''。</ins></div></td></tr> </table>

Eijux http://wiki.eijux.com/index.php?title=InnoDB%EF%BC%9AInnoDB_%E4%BD%93%E7%B3%BB%E7%BB%93%E6%9E%84&diff=2425&oldid=prev 2021-04-18T16:50:16Z

<p><span dir="auto"><span class="autocomment">关于</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="zh-Hans-CN"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2021年4月19日 (一) 00:50的版本</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l9">第9行：</td> <td colspan="2" class="diff-lineno">第9行：</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># [[InnoDB：InnoDB 内存结构]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># [[InnoDB：InnoDB 内存结构]]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># [[InnoDB：InnoDB 磁盘结构]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># [[InnoDB：InnoDB 磁盘结构]]</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">InnoDB 的三大特性：Buffer Pool（缓冲池）、Adaptive Hash Index（自适应Hash索引）、Doublewrite Buffer（双写缓冲区）</ins></div></td></tr> </table>

Eijux http://wiki.eijux.com/index.php?title=InnoDB%EF%BC%9AInnoDB_%E4%BD%93%E7%B3%BB%E7%BB%93%E6%9E%84&diff=2424&oldid=prev 2021-04-18T16:47:17Z

<p><span dir="auto"><span class="autocomment">关于</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="zh-Hans-CN"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←上一版本</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">2021年4月19日 (一) 00:47的版本</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l7">第7行：</td> <td colspan="2" class="diff-lineno">第7行：</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>InnoDB 架构分为两部分：</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>InnoDB 架构分为两部分：</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># [[InnoDB：InnoDB <del style="font-weight: bold; text-decoration: none;">内存结构 </del>内存结构]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># [[InnoDB：InnoDB 内存结构]]</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># [[InnoDB：InnoDB <del style="font-weight: bold; text-decoration: none;">磁盘结构 </del>磁盘结构]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># [[InnoDB：InnoDB 磁盘结构]]</div></td></tr> </table>

Eijux http://wiki.eijux.com/index.php?title=InnoDB%EF%BC%9AInnoDB_%E4%BD%93%E7%B3%BB%E7%BB%93%E6%9E%84&diff=2385&oldid=prev 2021-04-17T12:47:49Z

<p>建立内容为“<a href="/%E5%88%86%E7%B1%BB:MySQL" title="分类:MySQL">category:MySQL</a> == 关于 == 下图显示了组成 InnoDB 存储引擎体系结构的内存中和磁盘上的结构： : <a href="/%E6%96%87%E4%BB%B6:InnoDB_%E6%9E%B6%E6%9E%84.png" title="文件:InnoDB 架构.png">1000px</a> I…”的新页面</p> <p><b>新页面</b></p><div>[[category:MySQL]]<br /> <br /> == 关于 ==<br /> 下图显示了组成 InnoDB 存储引擎体系结构的内存中和磁盘上的结构：<br /> : [[File:InnoDB 架构.png|1000px]]<br /> <br /> <br /> InnoDB 架构分为两部分：<br /> # [[InnoDB：InnoDB 内存结构 内存结构]]<br /> # [[InnoDB：InnoDB 磁盘结构 磁盘结构]]</div>

Eijux