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

2025/05/30 TiDB Game Day 2025

Transcript

1. 1/72 にみる 活用術 株式会社 サーバーサイド 宮脇 剛史
2. 2/72
3. 3/72
4. 4/72
5. 5/72
6. 6/
7. 7/72 – – – –
8. 8/72 – – – –
9. 9/72 – – –
10. 10/72
11. 11/72
12. 12/72
13. 13/72
14. 14/72
15. 15/72
16. 16/72
17. 17/72
18. 18/72
19. 19/72
20. 20/72
21. 21/72
22. 22/72
23. 23/72
24. 24/72
25. 25/72 • •
26. 26/72
27. 27/72
28. 28/72
29. 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;
30. 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;
31. 31/72
32. 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;
33. 33/72
34. 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;
35. 35/72
36. 36/72
37. 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');
38. 38/72
39. 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;
40. 40/72 – – –
41. 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;
42. 42/72
43. 43/72
44. 44/72 • •
45. 45/72
46. 46/72
47. 47/72 • •
48. 48/72
49. 49/72
50. 50/72
51. 51/72
52. 52/72 – UPDATE {table} SET value = 100; – DELETE FROM {table}; – INSERT INTO {table_new} SELECT * FROM {table_old};
53. 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; ︙
54. 54/72
55. 55/72
56. 56/72
57. 57/72 – – –
58. 58/72 – –
59. 59/72 – – –
60. 60/72 •
61. 61/72 • • •
62. 62/72 • •
63. 63/72 • •
64. 64/72
65. 65/72
66. 66/72
67. 67/72
68. 68/72
69. 69/72
70. 70/72
71. 71/72 • – – •
72. 72/72