python-learning/MySQL at master · gitriver/python-learning · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
<mxfile host="app.diagrams.net" modified="2021-08-05T09:00:06.249Z" agent="5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36" etag="sxcYte8hrDgDgyLxrAQ9" version="14.9.4" type="github">
  <diagram id="C5RBs43oDa-KdzZeNtuy" name="Page-1">
    <mxGraphModel dx="1038" dy="581" grid="0" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
      <root>
        <mxCell id="WIyWlLk6GJQsqaUBKTNV-0" />
        <mxCell id="WIyWlLk6GJQsqaUBKTNV-1" parent="WIyWlLk6GJQsqaUBKTNV-0" />
        <mxCell id="-eipJY6fwbULrCsFKJTx-2" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;dashed=1;strokeColor=#3333FF;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="-eipJY6fwbULrCsFKJTx-3" target="-eipJY6fwbULrCsFKJTx-5">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-3" value="执行器更新记录A" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;fillColor=#cce5ff;strokeColor=#36393d;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="84" y="80" width="120" height="40" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-17" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;dashed=1;strokeColor=#3333FF;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="-eipJY6fwbULrCsFKJTx-5" target="-eipJY6fwbULrCsFKJTx-10">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-5" value="InnoDB将记录A&lt;br&gt;加载到Buffer Pool" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;fillColor=#d5e8d4;strokeColor=#82b366;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="84" y="155" width="120" height="40" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-18" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;dashed=1;strokeColor=#3333FF;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="-eipJY6fwbULrCsFKJTx-10" target="-eipJY6fwbULrCsFKJTx-11">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-10" value="将记录A旧值写入undo log,用于回滚" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;fillColor=#d5e8d4;strokeColor=#82b366;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="84" y="232" width="120" height="40" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-19" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;dashed=1;strokeColor=#3333FF;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="-eipJY6fwbULrCsFKJTx-11" target="-eipJY6fwbULrCsFKJTx-12">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-11" value="执行器更新&lt;br&gt;内存中的数据" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;fillColor=#d5e8d4;strokeColor=#82b366;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="84" y="316" width="120" height="40" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-20" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;dashed=1;strokeColor=#3333FF;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="-eipJY6fwbULrCsFKJTx-12" target="-eipJY6fwbULrCsFKJTx-13">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-12" value="执行器写redo log&amp;nbsp;&lt;br&gt;(prepare)" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;fillColor=#ffcc99;strokeColor=#36393d;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="84" y="392" width="120" height="40" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-21" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;dashed=1;strokeColor=#3333FF;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="-eipJY6fwbULrCsFKJTx-13" target="-eipJY6fwbULrCsFKJTx-14">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-13" value="执行器写binlog" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;fillColor=#ffcc99;strokeColor=#36393d;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="84" y="468" width="120" height="40" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-14" value="执行器写redo log&lt;br&gt;(状态是 commit)" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;fillColor=#fff2cc;strokeColor=#d6b656;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="84" y="544.5" width="120" height="40" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-22" value="执行器写redo log&amp;nbsp;&lt;br&gt;(状态是 prepare)" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;fillColor=#fff2cc;strokeColor=#d6b656;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="84" y="392" width="120" height="40" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-23" value="执行器写binlog" style="rounded=1;whiteSpace=wrap;html=1;fontSize=12;glass=0;strokeWidth=1;shadow=0;fillColor=#fff2cc;strokeColor=#d6b656;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="84" y="468" width="120" height="40" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-27" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;dashed=1;strokeColor=#999999;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="-eipJY6fwbULrCsFKJTx-24" target="-eipJY6fwbULrCsFKJTx-22">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-24" value="第一阶段提交&amp;nbsp;" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="223" y="402" width="84" height="20" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-28" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=0;exitY=0.5;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;dashed=1;strokeColor=#999999;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1" source="-eipJY6fwbULrCsFKJTx-25" target="-eipJY6fwbULrCsFKJTx-14">
          <mxGeometry relative="1" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-25" value="第二阶段提交&amp;nbsp;" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="230" y="554.5" width="84" height="20" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-31" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;exitX=1;exitY=0.5;exitDx=0;exitDy=0;dashed=1;strokeColor=#999999;" edge="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry relative="1" as="geometry">
            <mxPoint x="142.79998779296875" y="375" as="targetPoint" />
            <mxPoint x="93" y="375" as="sourcePoint" />
          </mxGeometry>
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-29" value="准备提交事务" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="9" y="366" width="84" height="20" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-34" value="时刻A Crash" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="153" y="440" width="102" height="20" as="geometry" />
        </mxCell>
        <mxCell id="-eipJY6fwbULrCsFKJTx-35" value="时刻B Crash" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;" vertex="1" parent="WIyWlLk6GJQsqaUBKTNV-1">
          <mxGeometry x="149" y="516" width="102" height="20" as="geometry" />
        </mxCell>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>