master

分支 (1)

管理

管理

master

leocook-private
/
mysql.html

<!doctype html>
<html class="no-js" lang="en">
  <head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>

  mysql -

  </title>
 <meta name="description" content="">
 <link href="atom.xml" rel="alternate" title="" type="application/atom+xml">
    <link rel="stylesheet" href="asset/css/foundation.min.css" />
    <link rel="stylesheet" href="asset/css/docs.css" />

    <script src="asset/js/vendor/modernizr.js"></script>
    <script src="asset/js/vendor/jquery.js"></script>
    <script src="asset/highlightjs/highlight.pack.js"></script>
    <link href="asset/highlightjs/styles/github.css" media="screen, projection" rel="stylesheet" type="text/css">
    <script>hljs.initHighlightingOnLoad();</script>

  </head>
  <body class="antialiased hide-extras">

    <div class="marketing off-canvas-wrap" data-offcanvas>
      <div class="inner-wrap">


<nav class="top-bar docs-bar hide-for-small" data-topbar>

<div id="header">
    <h1><a href="index.html"></a></h1>
</div>

</nav>
        <nav class="tab-bar show-for-small">
  <a href="javascript:void(0)" class="left-off-canvas-toggle menu-icon">
    <span> &nbsp; </span>
  </a>
</nav>

<aside class="left-off-canvas-menu">
      <ul class="off-canvas-list">
      <li><a href="index.html">Home</a></li>

        <li class="divider"></li>
        <li><label>1. Java 基础</label></li>


            <li><a title="1. Java 基础" href="16923474457318.html">1. Java 基础</a></li>


        <li class="divider"></li>
        <li><label>2. JCF（Java 集合）</label></li>


            <li><a title="2. JCF（Java 集合）" href="16923736135980.html">2. JCF（Java 集合）</a></li>

            <li><a title="2.4. Map - HashSet & HashMap 源码解析" href="16924335832240.html">2.4. Map - HashSet & HashMap 源码解析</a></li>

            <li><a title="2.5. Map - LinkedHashSet & LinkedHashMap源码解析" href="16924372183713.html">2.5. Map - LinkedHashSet & LinkedHashMap源码解析</a></li>

            <li><a title="2.6. Map - TreeSet & TreeMap 源码解析" href="16925007307182.html">2.6. Map - TreeSet & TreeMap 源码解析</a></li>


        <li class="divider"></li>
        <li><label>mysql</label></li>


            <li><a title="事务隔离" href="16925938083498.html">事务隔离</a></li>


        <li class="divider"></li>
        <li><label>常见文档</label></li>


            <li><a title="Paxos选举算法" href="16926055818559.html">Paxos选举算法</a></li>


      </ul>
    </aside>

<a class="exit-off-canvas" href="#"></a>

        <section id="main-content" role="main" class="scroll-container">

          <div class="row">
            <div class="large-3 medium-3 columns">
              <div class="hide-for-small">
                <div class="sidebar">
                <nav>
                  <ul id="side-nav" class="side-nav">


                      <li class="side-title"><span>1. Java 基础</span></li>

                          <li><a title="1. Java 基础" href="16923474457318.html">1. Java 基础</a></li>


                      <li class="side-title"><span>2. JCF（Java 集合）</span></li>

                          <li><a title="2. JCF（Java 集合）" href="16923736135980.html">2. JCF（Java 集合）</a></li>

                          <li><a title="2.4. Map - HashSet & HashMap 源码解析" href="16924335832240.html">2.4. Map - HashSet & HashMap 源码解析</a></li>

                          <li><a title="2.5. Map - LinkedHashSet & LinkedHashMap源码解析" href="16924372183713.html">2.5. Map - LinkedHashSet & LinkedHashMap源码解析</a></li>

                          <li><a title="2.6. Map - TreeSet & TreeMap 源码解析" href="16925007307182.html">2.6. Map - TreeSet & TreeMap 源码解析</a></li>


                      <li class="side-title"><span>mysql</span></li>

                          <li><a title="事务隔离" href="16925938083498.html">事务隔离</a></li>


                      <li class="side-title"><span>常见文档</span></li>

                          <li><a title="Paxos选举算法" href="16926055818559.html">Paxos选举算法</a></li>


                  </ul>
                </nav>
                </div>
              </div>
            </div>
            <div class="large-9 medium-9 columns">


		<div class="markdown-body">
		<h1>事务隔离</h1>

		<h2 id="toc_0">脏读</h2>

<p><img src="media/16925938083498/16925938601816.jpg" alt=""/></p>

<h2 id="toc_1">不可重复读</h2>

<p><img src="media/16925938083498/16925938213068.jpg" alt=""/></p>

<ul>
<li>幻读
<img src="media/16925938083498/16925940475023.jpg" alt=""/></li>
</ul>

<h2 id="toc_2">事务隔离级别</h2>

<p><img src="media/16925938%20083498/16925980982965.jpg" alt=""/></p>

<h2 id="toc_3">mysql MVCC的实现</h2>

<h3 id="toc_4">UNDO_LOG版本链</h3>

<p>UNDO_LOG版本链不是直接删除，MySQL确保版本链数据不再被“引用”后再进行删除。</p>

<ul>
<li>TRX_ID:事务ID</li>
<li>DB_ROLL_PTR:回滚指针</li>
</ul>

<p><img src="media/16925938083498/16925988962060.jpg" alt=""/></p>

<h2 id="toc_5">readView读视图</h2>

<p>视图类型：<br/>
- 快照读：select<br/>
- 当前读：Insert Update DELETE</p>

<p>readView的数据结构：</p>

<ul>
<li>m_ids：当前活跃的事务编号集合</li>
<li>min_trx_id：最小活跃事务编号</li>
<li>max_trx_id：预分配事务编号，当前最大事务编号</li>
<li>creator_trx_id：ReadView创建者的事务编号</li>
</ul>

<h3 id="toc_6">读已提交（RC）</h3>

<p><img src="media/16925938083498/16925995949372.jpg" alt=""/></p>

<p><img src="media/16925938083498/16925996162136.jpg" alt=""/></p>

<p><img src="media/16925938083498/16925997573856.jpg" alt=""/></p>

<p><img src="media/16925938083498/16926000893830.jpg" alt=""/></p>

<h3 id="toc_7">可重复度（RR）</h3>

<p><img src="media/16925938083498/16926005061683.jpg" alt=""/></p>

<p><img src="media/16925938083498/16926005244598.jpg" alt=""/></p>

<p><img src="media/16925938083498/16926006131960.jpg" alt=""/></p>

<p><img src="media/16925938083498/16926006744182.jpg" alt=""/></p>


		</div>


</div></div>


<div class="page-bottom">
  <div class="row">
  <hr />
  <div class="small-9 columns">
  <p class="copyright">Copyright &copy; 2015
Powered by <a target="_blank" href="http://www.mweb.im">MWeb</a>,&nbsp;
Theme used <a target="_blank" href="http://github.com">GitHub CSS</a>.</p>
  </div>
  <div class="small-3 columns">
  <p class="copyright text-right"><a href="#header">TOP</a></p>
  </div>

  </div>
</div>

        </section>
      </div>
    </div>


    <script src="asset/js/foundation.min.js"></script>
    <script src="asset/js/foundation/foundation.offcanvas.js"></script>
    <script>
      $(document).foundation();


    </script>


  </body>
</html>