UPDATE1æ–‡ã ã‘ã§ã‚‚デッドãƒãƒƒã‚¯ã™ã‚‹ã¨ã„ã†è©±ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã¯è¤‡æ•°ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒè¤‡æ•°ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ãƒãƒƒã‚¯ã™ã‚‹å ´åˆã«ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã«ã‚ˆã£ã¦ç™ºç”Ÿã™ã‚‹ã€‚ トランザクションAãŒãƒ¬ã‚³ãƒ¼ãƒ‰1ã‚’ãƒãƒƒã‚¯â†’æˆåŠŸ トランザクションBãŒãƒ¬ã‚³ãƒ¼ãƒ‰2ã‚’ãƒãƒƒã‚¯â†’æˆåŠŸ トランザクションAãŒãƒ¬ã‚³ãƒ¼ãƒ‰2ã‚’ãƒãƒƒã‚¯â†’2ã®ãƒãƒƒã‚¯ã®è§£æ”¾å¾…㡠トランザクションBãŒãƒ¬ã‚³ãƒ¼ãƒ‰1ã‚’ãƒãƒƒã‚¯â†’1ã®ãƒãƒƒã‚¯ã®è§£æ”¾å¾…ã¡ Aã‚‚Bも互ã„ã®ãƒãƒƒã‚¯ã®è§£æ”¾ã‚’å¾…ã¤ã“ã¨ã«ãªã£ã¦ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã™ã‚‹ã€‚ MySQLã¯ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã‚’検出ã™ã‚‹ã¨ã€ç‰‡æ–¹ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã§ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã‚¨ãƒ©ãƒ¼ã‚’発生ã•ã›ã¦å¼·åˆ¶çš„ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’終了ã•ã›ã‚‹ã€‚ ãŸã¨ãˆã°ã€æ¬¡ã®ã‚ˆã†ãª2ã¤ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’åŒæ™‚ã«å‹•ã‹ã™ã¨ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ã€‚ CREATE TABLE t (a INT, val INT, INDEX(a)); INSERT INTO t VALUES (1,0),(2,0),(3,0),(4,0),(5,0),(6,0)
SQLアンãƒãƒ‘ターン勉強会
Introducton - C.2: Conventional Models - Fertile Forest Model - The Cusp of Helix
開発者ã®ãŸã‚ã®SQLパフォーマンスã®å…¨ã¦
SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ...
MySQL AB :: Managing Hierarchical Data in MySQL
mysql:12071　階層化ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†
SHIFT the Oracle - Oracle DBA, Oracle SQL and PL/SQL Tips
{{#tags}}- {{label}}
{{/tags}}