【TiDB GAME DAY 2025】Shadowverse: Worlds Beyond にみる TiDB 活用術

by Cygames

Slide 1

Slide 1 text

1/72 にみる活用術株式会社サーバーサイド宮脇剛史

Slide 2

Slide 2 text

2/72

Slide 3

Slide 3 text

3/72

Slide 4

Slide 4 text

4/72

Slide 5

Slide 5 text

5/72

Slide 6

Slide 6 text

Slide 7

Slide 7 text

7/72 – – – –

Slide 8

Slide 8 text

8/72 – – – –

Slide 9

Slide 9 text

9/72 – – –

Slide 10

Slide 10 text

10/72

Slide 11

Slide 11 text

11/72

Slide 12

Slide 12 text

12/72

Slide 13

Slide 13 text

13/72

Slide 14

Slide 14 text

14/72

Slide 15

Slide 15 text

15/72

Slide 16

Slide 16 text

16/72

Slide 17

Slide 17 text

17/72

Slide 18

Slide 18 text

18/72

Slide 19

Slide 19 text

19/72

Slide 20

Slide 20 text

20/72

Slide 21

Slide 21 text

21/72

Slide 22

Slide 22 text

22/72

Slide 23

Slide 23 text

23/72

Slide 24

Slide 24 text

24/72

Slide 25

Slide 25 text

25/72 • •

Slide 26

Slide 26 text

26/72

Slide 27

Slide 27 text

27/72

Slide 28

Slide 28 text

28/72

Slide 29

Slide 29 text

29/72 BEGIN; SELECT value FROM user_items WHERE user_id=1 AND item_id=1; UPDATE user_items SET value=10 WHERE user_id=1; UPDATE user_items SET value=1+1 WHERE user_id=1 AND item_id=1; COMMIT;

Slide 30

Slide 30 text

30/72 BEGIN; SELECT * FROM users WHERE id=1 FOR UPDATE; SELECT value FROM user_items WHERE user_id=1 AND item_id=1; BEGIN; SELECT * FROM users WHERE id=1 FOR UPDATE; UPDATE user_items SET value=1+1 WHERE user_id=1 AND item_id=1; COMMIT;

Slide 31

Slide 31 text

31/72

Slide 32

Slide 32 text

32/72 BEGIN; UPDATE user_items SET value=10 WHERE user_id=1; SELECT * FROM users WHERE id=1; UPDATE user_items SET value=20 WHERE user_id=1; SELECT value FROM user_items WHERE user_id=1 AND item_id=1; COMMIT;

Slide 33

Slide 33 text

33/72

Slide 34

Slide 34 text

34/72 BEGIN; BEGIN; SELECT * FROM users WHERE id=1 FOR UPDATE; UPDATE user_items SET value=10 WHERE user_id=1; COMMIT; SELECT * FROM users WHERE id=1 FOR UPDATE; SELECT value FROM user_items WHERE user_id=1 AND item_id=1; UPDATE user_items SET value=1+1 WHERE user_id=1 AND item_id=1; COMMIT;

Slide 35

Slide 35 text

35/72

Slide 36

Slide 36 text

36/72

Slide 37

Slide 37 text

37/72 SELECT GET_LOCK('users:1', 60); BEGIN; SELECT GET_LOCK('users:1', 60); SELECT * FROM users WHERE id=1 FOR UPDATE; SELECT value FROM user_items WHERE user_id=1 AND item_id=1; UPDATE user_items SET value=1+1 WHERE user_id=1 AND item_id=1; COMMIT; SELECT RELEASE_LOCK('users:1');

Slide 38

Slide 38 text

38/72

Slide 39

Slide 39 text

39/72 BEGIN; BEGIN; SELECT * FROM users WHERE id=1 FOR UPDATE; UPDATE user_items SET value=10 WHERE user_id=1; COMMIT; SELECT * FROM users WHERE id=1 FOR UPDATE; SELECT value FROM user_items WHERE user_id=1 AND item_id=1 FOR UPDATE; UPDATE user_items SET value=10+1 WHERE user_id=1 AND item_id=1; COMMIT;

Slide 40

Slide 40 text

40/72 – – –

Slide 41

Slide 41 text

41/72 BEGIN; BEGIN; SELECT * FROM users WHERE id=1 FOR UPDATE; UPDATE user_items SET value=10 WHERE user_id=1; COMMIT; SELECT * FROM users WHERE id=1 FOR UPDATE; SELECT value FROM user_items WHERE user_id=1 AND item_id=1; UPDATE user_items SET value=10+1 WHERE user_id=1 AND item_id=1; COMMIT;

Slide 42

Slide 42 text

42/72

Slide 43

Slide 43 text

43/72

Slide 44

Slide 44 text

44/72 • •

Slide 45

Slide 45 text

45/72

Slide 46

Slide 46 text

46/72

Slide 47

Slide 47 text

47/72 • •

Slide 48

Slide 48 text

48/72

Slide 49

Slide 49 text

49/72

Slide 50

Slide 50 text

50/72

Slide 51

Slide 51 text

51/72

Slide 52

Slide 52 text

52/72 – UPDATE {table} SET value = 100; – DELETE FROM {table}; – INSERT INTO {table_new} SELECT * FROM {table_old};

Slide 53

Slide 53 text

53/72 BATCH ON id LIMIT 1000 DELETE FROM users; DELETE FROM users WHERE id BETWEEN 1 AND 1000; DELETE FROM users WHERE id BETWEEN 1001 AND 2000; ︙