Real Beat » Blog Archive » [MySQL] MyISAMã¨InnoDBKeep drinking, Keep listening to music, Go fuck yourself 今é‹ç”¨ã—ã¦ã„ã‚‹æŸã‚·ã‚¹ãƒ†ãƒ ã€MyISAMã®ã‚る難癖ã«ã‚ˆã£ã¦éžå¸¸ã«è¾›ã„ç›®ã«éã£ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œã¯ã‚‚ã¡ã‚んテーブルãƒãƒƒã‚¯ã€‚ã“ã‚Œã¯ã‚‚ã†MyISAMã‚’é¸æŠžã—ãŸæ™‚点ã§ã©ã†ã—ã¦ã‚‚é¿ã‘ã¦ã¯é€šã‚Œãªã„é“。ãã“ã‚“ã¨ã“ã‚仕組ã¿ã‚’ã¡ã‚ƒã‚“ã¨ç†è§£ã—ã¦ãªã„ã¨ã€MyISAMã®ã»ã†ãŒé€Ÿã„ã£ã¦è¨€ã†ã‹ã‚‰é¸ã‚“ã ã®ã«ã€ãªã‚“ã よ全然é…ã„ã˜ã‚ƒã‚“ï¼ã£ã¦ã„ã†ã‹ä½¿ã„物ã«ãªã‚‰ãªã„よウワァァァァンã¿ãŸã„ãªã“ã¨ã«ãªã‚ŠãŒã¡ã€‚今ã®ã‚·ã‚¹ãƒ†ãƒ ã§ã©ã†ã‚„ã£ã¦MyISAMã‹InnoDBã‹ã‚’分ã‘ãŸã®ã‹ã¨ã„ã†ã¨ã€å˜ç´”ã«æ›´æ–°é »åº¦ã ã£ãŸã€‚é »ç¹ã«æ›´æ–°ã•ã‚Œã‚‹ãƒ†ãƒ¼ãƒ–ルã¯InnoDBã€ãã†ã˜ã‚ƒãªã‘ã‚Œã°MyISAM。å‚ç…§ãŒæ®†ã©ãªã‚‰InnoDBã‚’é¸æŠžã™ã‚‹ãƒ¡ãƒªãƒƒãƒˆã¯ä½•ã‚‚ãªã„ã¨æ€ã£ã¦ã„ãŸã€‚ãŒã€å®Ÿã¯å…¨ç„¶ãã†ã˜ã‚ƒãªã‹ã£ãŸã€‚ MyISAMãŒè¾›ã„ã®ã¯ã€INSERT文実行時ã«ãƒ†ãƒ¼ãƒ–ル
オラクルã€é«˜é€Ÿå‡¦ç†ã‚¢ãƒ—リã®é–‹ç™ºã‚’容易ã«ã™ã‚‹ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªDB「TimesTen 7ã€ã‚’発表
{{#tags}}- {{label}}
{{/tags}}