mysqldump --single-transaction ã« --flush-logs ã‚’ã¤ã‘ã¦ã¯ã„ã‘ãªã„ - tmtms ã®ãƒ¡ãƒ¢(ã„ã¾ã ã«æ™‚々ブクマã•ã‚Œã¦ã„ãŸã‚Šã—ã¾ã™ãŒã€ã“ã‚Œã¯ãƒã‚°ã§ MySQL 5.5.21 以é™ã§ã¯ä¿®æ£ã•ã‚Œã¦ã„ã¾ã™ã€‚) mysqldump 㯠MySQL ã®ãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–å¾—ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã§ã™ã€‚ mysqldump ã« --single-transaction を指定ã™ã‚‹ã¨ä¸€è²«æ€§ã‚’ä¿æŒã—ãŸãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™*1。 ã“ã®æ™‚ã« mysqldump ãŒç™ºè¡Œã—ã¦ã„るクエリã¯æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã§ã™ã€‚ [mysqldump --single-transaction DBå] SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ START TRANSACTION WITH CONSISTENT SNAPSHOT UNLOCK TABLES DBé¸æŠž テーブルã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã®èªã¿è¾¼ã¿ã€ŒSTART TRANSACTION WITH CON
{{#tags}}- {{label}}
{{/tags}}