-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmysql-example1.txt
92 lines (90 loc) · 1.18 KB
/
mysql-example1.txt
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
❯ npm run mysql-black-white-demo
> [email protected] mysql-black-white-demo
> ./run-mysql.sh black-white-demo
testing with READ COMMITTED
inital state
black
white
black
white
black
white
black
white
black
white
transaction successfully committed! changed black to white
transaction successfully committed! changed white to black
result of 1 transaction
fulfilled
result of 2 transaction
fulfilled
final values
black
black
black
black
black
black
black
black
black
black
testing with REPEATABLE READ
inital state
black
white
black
white
black
white
black
white
black
white
transaction successfully committed! changed black to white
transaction successfully committed! changed white to black
result of 1 transaction
fulfilled
result of 2 transaction
fulfilled
final values
black
black
black
black
black
black
black
black
black
black
testing with SERIALIZABLE
inital state
black
white
black
white
black
white
black
white
black
white
transaction successfully committed! changed white to black
transaction successfully committed! changed black to white
result of 1 transaction
fulfilled
result of 2 transaction
fulfilled
final values
white
white
white
white
white
white
white
white
white
white