Goal
u MySQL!RDBM
MySQLNS!CHM
@
?O
u 24%6=+,71=' 095:)7."='
MySQLNS
!CHD G JF! KP
u MySQLQ+0;*$=*= BAInnoDB >I
u TR L E03-&#=/-&+09=(&)8=<-&
U
Slide 3
Slide 3 text
u MySQL
u
u
u
Slide 4
Slide 4 text
MySQL! &
u +($* %( ) #0
u '+"1. = 1 ) #
u ) # 1./
Linuxps%+#
-,
u SHOW PROCESSLIST
%+# ,
u
PostgreSQL %( $* 0
u '+"11. = 1$*
Slide 5
Slide 5 text
MySQL
u
Slide 6
Slide 6 text
MySQL "
u !#$$
u MySQL%+2
&1()0,
u / !#$$.
-3'*.
u InnoDB
u MyISAM
u Memory
u MyRocks
Slide 7
Slide 7 text
u
u
u
Slide 8
Slide 8 text
-!"6 1&# !
u InnoDB%*/8 1&# ! 32 1&# !
-!"6 1&# !
u -!"6 1&# !B$..)('0 '7 -,&"
:=
u 0 '&":= 39 1&# !5 394<0!
+1!;
Slide 9
Slide 9 text
+ )+!
u ( 0+! +!
u + )+! )&$#( 0+! 6,
u + )+! 3
1:% "
.( 0
+! 1:
* '+ 5
u ( 0+! 1:4
79228-/
Slide 10
Slide 10 text
)-/! /(& "
u /(& ";<
-79:
u /(& ">?
u '*. #" 2=79:
u ,"$5 /(& "
6@10'*. ,+<3
)-/! /(& "=4
79:
u # /%- /(& "
6@10# /%- /(& "A ,
+< ,"$5 /(& " ,+<
8 )-/! /
(& "
Slide 11
Slide 11 text
u
u READ UNCOMMITTED
u READ COMMITTED
u REPEATABLE READ
u SERIALIZABLE
u MySQL
u MVCC
Slide 12
Slide 12 text
!% %&-# "
u !% % &-) % #
u .0
&- $(/
%,'
u %&-) # (/
4 &-# "
(SQL+*)
u READ UNCOMMITTED
u READ COMMITED
u REPEATABLE READ
u SERIALIZABLE
Slide 13
Slide 13 text
READ UNCOMMITED
u &#%
%)* (*035%)* (*,
u &#%
$!6 4
u -./1+2
"'!
Slide 14
Slide 14 text
READ COMMITTED
u ).1" #-1 7 ?E
!+&)
).1" #-1FN
u ).1" #-1<FN!+&) K).1" #-1
7
u 5J0*/ MG
u 8$'),1) 2=@3
L (% H GCA
u A).1" #-1 @32;B).1" #-1 !+&) 64A<
B> (% B!+&):9OIBD GCA
Slide 15
Slide 15 text
REPEATABLE READ
u MySQL$& *%%),"!#(,/D+'*
u READ UNCOMMITED FB
C
u %),"!#(, I: - 2%),"!#(, =
EI: 21 8@
u
;>G
u KH- 7J
4A%),"!#(, KH5
- L3
0.2KH 7J 5
- <
u InnoDB0.MVCC 9 ;> ?6
Slide 16
Slide 16 text
SERIALIZABLE
u 80*/5B>
u '-2#"$,2A467
'-2#"$,2 =<:CF
) 2'+.( @
u E; 31&" ?9
u
% + !'1&"A4G6 D
Slide 17
Slide 17 text
MySQLW7BAX: MVCC
u MultiVesion Concurrency Control[
u ;DTM,)(.*0&2*-"IC SF?I
u InnoDB98
u 7
\!R"JZ
u 7 IC!
&(+1/'26PY
u 7 VU!
&(+1/'26PY
u &(+1/'26PY-36%$&26 >K EL
u N-36%$&26>K;D&(+1/'26PY"HQ
u -36%$&26<$#47 ICVU&(+1/'26PY"
,)"@G]I
u -36%$&26&(+1/'26 =&(+1/'267":
"5*$O
Slide 18
Slide 18 text
MySQL7'.-8: MVCC
u "
u 2 %3,.96
1
!& &(5$ #+/
u )4 !& &(5$ #0*
u REPETABLE READ
u READ COMMITTED
Slide 19
Slide 19 text
u
u
u
u
u
u
u
u
Slide 20
Slide 20 text
!
u (# )
u $ #
u
u %"( )
u #
Slide 21
Slide 21 text
!.)
u !
u +*!
u "!
u -("!
u !
u "!
"!0'"& !
u id124
u UPDATE users SET age = 30 WHERE id BETWEEN 2 AND 4
,
$#'
id=3& /%!
Slide 22
Slide 22 text
0(&A8
u *&')$0(&
u 20(&%-(,0(&< 3"
u 20(
7%-(, 1@0(&
!
u 1,2,4? 43
u (negative infinity 1]
u (1 2]
u (2 3]
u (4 positive infinity]
u *&')$0(& :=2 positivie infinity0(& !
INSERT
).+/ 56 >;