MySQL ibdata1ãŒè‚¥å¤§åŒ–ã™ã‚‹ç†ç”±(記事ã®æ„訳) | Ore no homepage毎日暑ã„…。ã¨ã„ã†ã‹è’¸ã—æš‘ã„。何年ã‹å‰ã«ãƒ™ãƒˆãƒŠãƒ ã¨ã‚«ãƒ³ãƒœã‚¸ã‚¢ã‚’ãƒãƒƒã‚¯ãƒ‘ッカー旅行ã—ãŸã¨ãã‚’æ€ã„出ã™ã€‚日本ã®æ°—候ãŒäºœç†±å¸¯ã£ã¦ã‹æ±å—アジアã£ã½ããªã£ã¦ããŸã‚ˆã†ãªâ€¦æ˜”ã¯ã“ã‚“ãªé »ç¹ã«ã‚²ãƒ©ãƒªè±ªé›¨ã¨ã‹é™ã‚‰ãªã‹ã£ãŸã‚ˆãー？温暖化ã£ã¦ã‚„ã¤ï¼Ÿæ—¥æœ¬ã®æ¤ç”Ÿã¨ã‹å¤‰ã‚ã‚‹ã‚“ã˜ã‚ƒãーã®ã‹ãªâ€¦ã€‚ ãˆãƒ¼ã¨ã€ãŠã‚ŒãŒã‚ˆã見ã¦ã„る技術ブãƒã‚°ã®ä¸€ã¤ã«Percona社ã®MySQL Performance BlogãŒã‚る。ãã®ãƒ–ãƒã‚°ã«å…ˆæ—¥ã€ã€ŒWhy is the ibdata1 file continuously growing in MySQL?ã€ã¨ã„ã†è¨˜äº‹ãŒæŠ•ç¨¿ã•ã‚ŒãŸã€‚内容ã¯InnoDBã®ibdata1ã®è‚¥å¤§åŒ–ã¨ãã®è§£æ¶ˆæ–¹æ³•ã«é–¢ã™ã‚‹ã‚‚ã®ã€‚ibdata1ã®è‚¥å¤§åŒ–を解消ã™ã‚‹æ‰‹æ®µã¯ã€ãƒ€ãƒ³ãƒ—ã‚’ã¨ã£ã¦DBを作り直ã—ã¦ã‚ã’ãªã„ã¨æ²»ã‚‰ãªã„ã¨ã„ã†ã“ã¨ã¯å¤šãã®InnoDBユーザãŒçŸ¥ã£ã¦ã„ã‚‹ã“ã¨ã ã¨æ€ã†ã‘ã©ã€ãŠã‚Œã‚‚InnoDBを触り始ã‚ãŸã“ã‚ã¯ã€ã€Œæ°—
{{#tags}}- {{label}}
{{/tags}}