MySQL InnoDBã®è¡Œãƒãƒƒã‚¯ - There's an echo in my headãƒãƒƒã‚¯ãŒã‚ã‹ã‚‰ãªã„。MySQL InnoDBã®è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ã‚’èªã‚“ã ã‘ã©ã€ã‚¤ãƒžã‚¤ãƒã‚ã‹ã‚‰ãªã„。ã¨ã„ã†ã‚ã‘ã§ã€ç¤¾å†…ã®å‹‰å¼·ä¼šã§çŸ¥ã£ãŸã“ã¨ã‚’ã¾ã¨ã‚ã¦ã¿ã‚‹ã€‚ FOR UPDATEã‹LOCK IN SHARE MODEã«ã‚ˆã£ã¦ã€ãã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ä¸ã«èµ°ã‚‹åˆ¥ç”»é¢ã§ã®ã‚¯ã‚¨ãƒªã®å‡¦ç†ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ãŒç•°ãªã‚‹ã€‚ FOR UPDATEã«ã‚ˆã‚‹ãƒãƒƒã‚¯ ã¾ãšã¯ç”»é¢Aã§æŽ¥ç¶šãŒè¡Œã‚ã‚Œã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒé–‹å§‹ã•ã‚Œã€SELECTæ–‡ãŒç™ºè¡Œã•ã‚ŒãŸã¨ã™ã‚‹ã€‚ [ç”»é¢A] BEGIN; // トランザクションA開始 SELECT * FROM users WHERE id = 1 FOR UPDATE; COMMIT; // トランザクションA終了 ãã—ã¦ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³Aã®é–‹å§‹å¾Œã€œçµ‚了å‰ã«ç”»é¢B〜DãŒã‚¯ã‚¨ãƒªã‚’発行ã—ãŸã¨ã™ã‚‹ã€‚ ã¡ãªã¿ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’開始ã—ã¦ãŠã‹ãªã„ã¨FOR UPDATEを書ã„ã¦ã‚‚ç”»é¢Aã§ã®ãƒãƒƒã‚¯ãŒå§‹ã¾ã‚‰ãªã„ã®ã§è¦æ³¨
{{#tags}}- {{label}}
{{/tags}}