Amazon RDS ã§è‚¥å¤§åŒ–ã—ãŸslow_logテーブルをクリアã™ã‚‹æ–¹æ³•ä»¥å‰AmazonRDSã§slow queryを出力ã™ã‚‹ã‚ˆã†ã«ã™ã‚‹æ–¹æ³•ã«ã¦RDSã§slow_logを出力ã™ã‚‹ã‚ˆã†ã«è¨å®šã™ã‚‹ã¨ã€mysqlデータベースã®slow_logテーブルã«ãƒã‚°ãŒä¿å˜ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã®ã§ã™ãŒã€ã“ã®ãƒ†ãƒ¼ãƒ–ルã«ä¿å˜ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã¯ã€RDSã§ä½œæˆã§ãるユーザーã®æ¨©é™ã§ã¯å‰Šé™¤ã™ã‚‹ã“ã¨ãŒã§ãã¾ã›ã‚“。 mysql> delete from slow_log; ERROR 1556 (HY000): You can't use locks with log tables. mysql> truncate table slow_log; ERROR 1044 (42000): Access denied for user 'xxxx'@'%' to database 'mysql' ã“ã®ã“ã¨ã¯general_logã«ã‚‚言ãˆã‚‹ã®ã§ã™ãŒã€ ã“ã‚Œã«å¯¾ã—ã¦ã€Amazonã‹ã‚‰ä»¥ä¸‹ã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸
{{#tags}}- {{label}}
{{/tags}}