ã€AWS】RDS for MySQLã§å…±æœ‰ãƒ†ãƒ¼ãƒ–ルスペースã«æ§‹æˆå¤‰æ›´ã™ã‚‹éš›ã®æ‰€è¦æ™‚間を実測ã—ã¦ã¿ãŸ | DevelopersIO今回ã®èª²é¡Œ ã“ã‚“ã«ã¡ã¯æ¤æœ¨å’Œæ¨¹ã§ã™ã€‚RDS for MySQLを使用ã—ã¦ã„ãŸã¨ã“ã‚以下ã®ã‚ˆã†ãªè¦‹æ…£ã‚Œãªã„メッセージãŒé€šçŸ¥ã•ã‚Œã¦ãã¾ã—ãŸã€‚ DB Instance XXXX-XXXX has a large number of tables and has the parameter innodb_file_per_table set to 1, which can increase database recovery time significantly. Consider setting this parameter to 0 in the parameter group associated with this DB instance to minimize database downtime during reboots and failovers. ã‚ã‚ã›ã¦ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã«ã¯ä¸‹è¨˜URL
AWSã‹ã‚‰ã€ãƒ†ãƒ¼ãƒ–ル多ã„ã‹ã‚‰innodb_file_per_tableã‚’0ã«ã—ã‚ã¨æ€’られ㟠- ã«ã‚ã‹ã‚µãƒ¼ãƒãƒ¼å±‹ã•ã‚“ã®è¦šæ›¸
PIOPSã«ã¤ã„㦠- 雑多ãªã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢æ—¥è¨˜
AWSã§ãƒžãƒ«ãƒAZãªã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†DBを構築ã™ã‚‹5ã¤ã®ãƒ—ラクティス | DevelopersIO
{{#tags}}- {{label}}
{{/tags}}