-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmysql
316 lines (316 loc) · 31.5 KB
/
mysql
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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
<mxfile host="app.diagrams.net" modified="2023-04-08T06:43:27.707Z" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36" etag="A9A1MFIwh1g56BtSX2Wy" version="21.1.5" type="github" pages="2">
<diagram id="9vEL_aTF37jJ-JzKRqVW" name="redolog">
<mxGraphModel dx="1434" dy="798" grid="1" 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="0" />
<mxCell id="1" parent="0" />
<mxCell id="4EWMEHIbi63ABoTpL-Ew-1" value="<font style="font-size: 20px;">Server层</font>" style="rounded=1;whiteSpace=wrap;html=1;verticalAlign=top;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="180" y="90" width="400" height="120" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-2" value="" style="shape=curlyBracket;whiteSpace=wrap;html=1;rounded=1;labelPosition=left;verticalLabelPosition=middle;align=right;verticalAlign=middle;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="141" y="85" width="20" height="510" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-4" value="binlog<br style="font-size: 20px;">归档日志" style="rounded=1;whiteSpace=wrap;html=1;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="320" y="130" width="120" height="60" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-5" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#97D077;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="270" y="220" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-6" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#97D077;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="330" y="220" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-7" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#97D077;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="390" y="220" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-8" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#97D077;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="460" y="220" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-10" value="存储引擎API" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="180" y="310" width="390" height="60" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-11" value="InnoDB存储引擎层" style="rounded=1;whiteSpace=wrap;html=1;verticalAlign=top;fillColor=#fff2cc;strokeColor=#d6b656;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="180" y="469" width="400" height="120" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-12" value="redolog<br style="font-size: 20px;">重做日志" style="rounded=1;whiteSpace=wrap;html=1;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="320" y="509" width="120" height="60" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-13" value="MySQL" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="60" y="325" width="60" height="30" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-14" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#97D077;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="270" y="380" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-15" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#97D077;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="330" y="380" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-16" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#97D077;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="390" y="380" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="4EWMEHIbi63ABoTpL-Ew-17" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#97D077;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="460" y="380" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-5" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=0.5;entryY=0;entryDx=0;entryDy=0;fontSize=20;fillColor=#f8cecc;strokeColor=#b85450;fontStyle=1" edge="1" parent="1" source="VZknAvyC0pC5Cmd-lRkQ-1" target="VZknAvyC0pC5Cmd-lRkQ-4">
<mxGeometry relative="1" as="geometry">
<Array as="points">
<mxPoint x="864" y="250" />
<mxPoint x="864" y="250" />
</Array>
</mxGeometry>
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-1" value="实例挂了或宕机" style="ellipse;whiteSpace=wrap;html=1;fillColor=#f8cecc;strokeColor=#b85450;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="778.75" y="140" width="170" height="83" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-4" value="MySQL" style="rounded=1;whiteSpace=wrap;html=1;verticalAlign=top;fillColor=#f8cecc;strokeColor=#b85450;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="760" y="300" width="207.5" height="130" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-6" value="InnoDB存储引擎层" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#f8cecc;strokeColor=#b85450;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="803.75" y="350" width="120" height="60" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-7" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;entryX=0.5;entryY=0;entryDx=0;entryDy=0;fontSize=20;fillColor=#d5e8d4;strokeColor=#82b366;fontStyle=1" edge="1" source="VZknAvyC0pC5Cmd-lRkQ-8" target="VZknAvyC0pC5Cmd-lRkQ-9" parent="1">
<mxGeometry relative="1" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-8" value="重启" style="ellipse;whiteSpace=wrap;html=1;fillColor=#d5e8d4;strokeColor=#82b366;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1113.75" y="140" width="182.5" height="80" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-18" style="edgeStyle=orthogonalEdgeStyle;rounded=0;orthogonalLoop=1;jettySize=auto;html=1;startArrow=classic;startFill=1;fontStyle=1" edge="1" parent="1" source="VZknAvyC0pC5Cmd-lRkQ-9" target="VZknAvyC0pC5Cmd-lRkQ-17">
<mxGeometry relative="1" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-20" value="数据恢复" style="edgeLabel;html=1;align=center;verticalAlign=middle;resizable=0;points=[];fontSize=20;fontStyle=1" vertex="1" connectable="0" parent="VZknAvyC0pC5Cmd-lRkQ-18">
<mxGeometry x="-0.0957" y="-5" relative="1" as="geometry">
<mxPoint as="offset" />
</mxGeometry>
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-9" value="MySQL" style="rounded=1;whiteSpace=wrap;html=1;verticalAlign=top;fillColor=#d5e8d4;strokeColor=#82b366;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1100" y="300" width="210" height="130" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-10" value="InnoDB存储引擎层" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#d5e8d4;strokeColor=#82b366;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1145" y="350" width="120" height="60" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-12" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=east;notch=0;fillColor=#97D077;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1000" y="325" width="80" height="50" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-17" value="redo.file" style="rounded=1;whiteSpace=wrap;html=1;fontSize=20;fontStyle=1;fillColor=#e1d5e7;strokeColor=#9673a6;" vertex="1" parent="1">
<mxGeometry x="1540" y="335" width="120" height="60" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-21" value="InnoDB存储引擎" style="rounded=1;whiteSpace=wrap;html=1;fontSize=20;verticalAlign=top;fillColor=#d5e8d4;strokeColor=#82b366;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="820" y="520" width="550" height="260" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-24" value="" style="group;fontStyle=1" vertex="1" connectable="0" parent="1">
<mxGeometry x="980" y="870" width="220" height="80" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-22" value="" style="ellipse;whiteSpace=wrap;html=1;fontStyle=1" vertex="1" parent="VZknAvyC0pC5Cmd-lRkQ-24">
<mxGeometry width="220" height="80" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-23" value="" style="ellipse;whiteSpace=wrap;html=1;fontStyle=1" vertex="1" parent="VZknAvyC0pC5Cmd-lRkQ-24">
<mxGeometry x="61.25" y="23.75" width="97.5" height="32.5" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-25" value="硬盘" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=20;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="995" y="950" width="60" height="40" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-26" value="redo.file" style="rounded=1;whiteSpace=wrap;html=1;fontSize=20;fontStyle=1;fillColor=#e1d5e7;strokeColor=#9673a6;" vertex="1" parent="1">
<mxGeometry x="1230" y="880" width="120" height="60" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-27" value="缓冲池<br style="font-size: 20px;">(Buffer Pool)" style="rounded=1;whiteSpace=wrap;html=1;fontSize=20;fillColor=#f8cecc;strokeColor=#b85450;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="850" y="649" width="260" height="101" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-28" value="重做日志缓存<br style="font-size: 20px;">(redo log buffer)" style="rounded=1;whiteSpace=wrap;html=1;fontSize=20;fillColor=#f8cecc;strokeColor=#b85450;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1140" y="660" width="210" height="71" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-29" value="1.磁盘加载数据放入到缓冲池" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=20;fontColor=#FF3333;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="740" y="780" width="280" height="40" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-30" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=north;notch=0;fillColor=#dae8fc;fontSize=20;strokeColor=#6c8ebf;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1015" y="760" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-31" value="2.直接更新缓存数据" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=20;fontColor=#FF3333;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="820" y="580" width="200" height="40" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-32" value="3.记录更新信息" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=20;fontColor=#FF3333;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1179" y="580" width="160" height="40" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-34" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#dae8fc;fontSize=20;strokeColor=#6c8ebf;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1140" y="750" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-35" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#f8cecc;fontSize=20;strokeColor=#b85450;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1015" y="565" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-39" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#f8cecc;fontSize=20;strokeColor=#b85450;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1139" y="565" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-40" value="4.清空redo log buffer<br>刷盘到redo日志中" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontSize=20;fontColor=#FF3333;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1190" y="780" width="220" height="60" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-55" value="" style="group;fontSize=20;fontStyle=1" vertex="1" connectable="0" parent="1">
<mxGeometry x="1370" y="940" width="310" height="160" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-41" value="<font style="font-size: 20px;">什么时候刷盘呢，<br>提交事物的时候吗</font>" style="ellipse;shape=cloud;whiteSpace=wrap;html=1;container=0;fontStyle=1;fillColor=#ffe6cc;strokeColor=#d79b00;" vertex="1" parent="VZknAvyC0pC5Cmd-lRkQ-55">
<mxGeometry x="40" y="45" width="270" height="115" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-42" value="" style="ellipse;whiteSpace=wrap;html=1;container=0;fontStyle=1;fillColor=#ffe6cc;strokeColor=#d79b00;" vertex="1" parent="VZknAvyC0pC5Cmd-lRkQ-55">
<mxGeometry x="20" y="15" width="26" height="10" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-43" value="" style="ellipse;whiteSpace=wrap;html=1;container=0;fontStyle=1;fillColor=#ffe6cc;strokeColor=#d79b00;" vertex="1" parent="VZknAvyC0pC5Cmd-lRkQ-55">
<mxGeometry x="40" y="30" width="40" height="20" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-45" value="" style="ellipse;whiteSpace=wrap;html=1;container=0;fontStyle=1;fillColor=#ffe6cc;strokeColor=#d79b00;" vertex="1" parent="VZknAvyC0pC5Cmd-lRkQ-55">
<mxGeometry width="20" height="10" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-56" value="redo记录" style="rounded=1;whiteSpace=wrap;html=1;verticalAlign=top;fillColor=#b1ddf0;strokeColor=#10739e;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1540" y="395" width="120" height="250" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-57" value="表空间号" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#d0cee2;strokeColor=#56517e;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1550" y="424" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-58" value="数据页号" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#d0cee2;strokeColor=#56517e;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1550" y="464" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-59" value="偏移量" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#d0cee2;strokeColor=#56517e;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1550" y="504" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-60" value="修改数据长度" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#d0cee2;strokeColor=#56517e;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1550" y="544" width="100" height="40" as="geometry" />
</mxCell>
<mxCell id="VZknAvyC0pC5Cmd-lRkQ-61" value="具体修改的数据" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#d0cee2;strokeColor=#56517e;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="1550" y="584" width="100" height="40" as="geometry" />
</mxCell>
</root>
</mxGraphModel>
</diagram>
<diagram id="5rndfH5mqZKDCLKyA4aS" name="binlog">
<mxGraphModel dx="2261" dy="798" grid="1" 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="0" />
<mxCell id="1" parent="0" />
<mxCell id="kygdl1loShtP7_gs9jyl-36" value="" style="rounded=0;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=20;fillColor=#d5e8d4;strokeColor=#82b366;" vertex="1" parent="1">
<mxGeometry x="-481" y="13.75" width="1431" height="520" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-1" value="根据binlog还原<br style="font-size: 20px;">mysql实例" style="ellipse;whiteSpace=wrap;html=1;fontStyle=1;fillColor=#bac8d3;strokeColor=#23445d;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="-201.5" y="30" width="195" height="80" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-2" value="MySQL" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#fad7ac;strokeColor=#b46504;fontStyle=1;fontSize=20;imageWidth=26;" vertex="1" parent="1">
<mxGeometry x="-400" y="230" width="150" height="70" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-3" value="MySQL" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#fad7ac;strokeColor=#b46504;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="73" y="241" width="150" height="70" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-7" value="binlog<br style="font-size: 20px;">归档日志" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=17;fontStyle=1;fillColor=#bac8d3;strokeColor=#23445d;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="-140" y="215" width="90" height="110" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-8" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=east;notch=0;fillColor=#fad9d5;fontSize=20;strokeColor=#ae4132;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="-230" y="245" width="80" height="50" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-9" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=east;notch=0;fontSize=20;fillColor=#bac8d3;strokeColor=#23445d;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="-27" y="246" width="80" height="50" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-10" value="写" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="-220" y="230" width="40" height="40" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-11" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=south;notch=0;fillColor=#bac8d3;fontSize=20;strokeColor=#23445d;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="-129" y="120" width="50" height="80" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-12" value="MySQL-主" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#fad7ac;strokeColor=#b46504;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="290" y="237.5" width="150" height="70" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-13" value="MySQL-备" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#fad7ac;strokeColor=#b46504;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="769" y="246.5" width="150" height="70" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-14" value="binlog<br style="font-size: 20px;">归档日志" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=17;fontStyle=1;fillColor=#bac8d3;strokeColor=#23445d;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="560" y="217.5" width="90" height="112.5" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-15" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=east;notch=0;fillColor=#fad9d5;fontSize=20;strokeColor=#ae4132;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="460" y="252.5" width="80" height="50" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-16" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=west;notch=0;fontSize=20;fillColor=#fad7ac;strokeColor=#b46504;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="669" y="251.5" width="80" height="50" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-17" value="写" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="470" y="237.5" width="40" height="40" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-18" value="MySQL-主" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#fad7ac;strokeColor=#b46504;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="-400" y="415" width="150" height="70" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-19" value="MySQL-主" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#fad7ac;strokeColor=#b46504;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="74" y="415" width="150" height="70" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-20" value="binlog<br style="font-size: 20px;">归档日志" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=17;fontStyle=1;fillColor=#bac8d3;strokeColor=#23445d;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="-140" y="390" width="90" height="110" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-23" value="读写" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="-220" y="400" width="60" height="40" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-24" value="MySQL-主" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#fad7ac;strokeColor=#b46504;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="290" y="410" width="150" height="70" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-25" value="MySQL-从" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#fad7ac;strokeColor=#b46504;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="771" y="405" width="150" height="70" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-26" value="binlog<br style="font-size: 20px;">归档日志" style="shape=note;whiteSpace=wrap;html=1;backgroundOutline=1;darkOpacity=0.05;size=17;fontStyle=1;fillColor=#bac8d3;strokeColor=#23445d;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="560" y="380" width="90" height="110" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-27" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=east;notch=0;fillColor=#fad9d5;fontSize=20;strokeColor=#ae4132;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="460" y="415" width="80" height="50" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-28" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.arrow;dy=0.72;dx=23;direction=west;notch=0;fontSize=20;fillColor=#fad7ac;strokeColor=#b46504;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="671" y="410" width="80" height="50" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-29" value="写" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="470" y="400" width="40" height="40" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-30" value="读" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="699" y="236.5" width="40" height="40" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-31" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.twoWayArrow;dy=0.73;dx=22;fillColor=#d0cee2;strokeColor=#56517e;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="-240" y="435" width="90" height="30" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-32" value="" style="html=1;shadow=0;dashed=0;align=center;verticalAlign=middle;shape=mxgraph.arrows2.twoWayArrow;dy=0.73;dx=22;fillColor=#d0cee2;strokeColor=#56517e;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="-36" y="435" width="90" height="30" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-33" value="读" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="701" y="395" width="40" height="40" as="geometry" />
</mxCell>
<mxCell id="kygdl1loShtP7_gs9jyl-34" value="读写" style="text;html=1;align=center;verticalAlign=middle;resizable=0;points=[];autosize=1;strokeColor=none;fillColor=none;fontStyle=1;fontSize=20;" vertex="1" parent="1">
<mxGeometry x="-16" y="400" width="60" height="40" as="geometry" />
</mxCell>
<mxCell id="xGZ0fxmZIUeej7BjvDqD-1" value="" style="rounded=0;whiteSpace=wrap;html=1;fontFamily=Helvetica;fontSize=20;fillColor=#d5e8d4;strokeColor=#82b366;" vertex="1" parent="1">
<mxGeometry x="-500" y="910" width="1431" height="520" as="geometry" />
</mxCell>
<mxCell id="xGZ0fxmZIUeej7BjvDqD-30" value="BEGIN" style="rounded=0;whiteSpace=wrap;html=1;strokeColor=#b46504;fontFamily=Helvetica;fontSize=20;fontColor=default;fillColor=#fad7ac;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="-350" y="660" width="210" height="40" as="geometry" />
</mxCell>
<mxCell id="xGZ0fxmZIUeej7BjvDqD-31" value="COMMIT xid=xx" style="rounded=0;whiteSpace=wrap;html=1;strokeColor=#b46504;fontFamily=Helvetica;fontSize=20;fontColor=default;fillColor=#fad7ac;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="-350" y="810" width="210" height="40" as="geometry" />
</mxCell>
<mxCell id="xGZ0fxmZIUeej7BjvDqD-32" value="use 库名;<br>update T set<br>updater_time = now()<br>where id = 1" style="rounded=0;whiteSpace=wrap;html=1;strokeColor=#d6b656;fontFamily=Helvetica;fontSize=20;fillColor=#fff2cc;verticalAlign=top;align=left;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="-350" y="700" width="210" height="110" as="geometry" />
</mxCell>
<mxCell id="xGZ0fxmZIUeej7BjvDqD-33" value="事务开始" style="rounded=1;whiteSpace=wrap;html=1;strokeColor=#9673a6;fontFamily=Helvetica;fontSize=20;fillColor=#e1d5e7;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="-34" y="660" width="140" height="40" as="geometry" />
</mxCell>
<mxCell id="xGZ0fxmZIUeej7BjvDqD-34" value="记录内容" style="rounded=1;whiteSpace=wrap;html=1;strokeColor=#9673a6;fontFamily=Helvetica;fontSize=20;fillColor=#e1d5e7;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="-34" y="740" width="140" height="40" as="geometry" />
</mxCell>
<mxCell id="xGZ0fxmZIUeej7BjvDqD-35" value="提交事务与事务id" style="rounded=1;whiteSpace=wrap;html=1;strokeColor=#9673a6;fontFamily=Helvetica;fontSize=20;fillColor=#e1d5e7;fontStyle=1" vertex="1" parent="1">
<mxGeometry x="-34" y="810" width="190" height="40" as="geometry" />
</mxCell>
<mxCell id="xGZ0fxmZIUeej7BjvDqD-36" value="" style="endArrow=block;startArrow=block;html=1;rounded=0;fontFamily=Helvetica;fontSize=20;fontColor=default;startFill=0;endFill=0;strokeWidth=2;fontStyle=1" edge="1" parent="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="-138" y="679.5" as="sourcePoint" />
<mxPoint x="-38" y="679.5" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="xGZ0fxmZIUeej7BjvDqD-37" value="" style="endArrow=block;startArrow=block;html=1;rounded=0;fontFamily=Helvetica;fontSize=20;fontColor=default;startFill=0;endFill=0;strokeWidth=2;fontStyle=1" edge="1" parent="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="-138" y="760" as="sourcePoint" />
<mxPoint x="-38" y="760" as="targetPoint" />
</mxGeometry>
</mxCell>
<mxCell id="xGZ0fxmZIUeej7BjvDqD-38" value="" style="endArrow=block;startArrow=block;html=1;rounded=0;fontFamily=Helvetica;fontSize=20;fontColor=default;startFill=0;endFill=0;strokeWidth=2;fontStyle=1" edge="1" parent="1">
<mxGeometry width="50" height="50" relative="1" as="geometry">
<mxPoint x="-138" y="829.5" as="sourcePoint" />
<mxPoint x="-38" y="829.5" as="targetPoint" />
</mxGeometry>
</mxCell>
</root>
</mxGraphModel>
</diagram>
</mxfile>