mk(pt)-query-digestã‚’ã‚‚ã£ã¨æ´»ç”¨ã—よã†ï¼ - ç‹ãƒˆãƒ¬ã¨ã¨ã‚‚ã«ç”Ÿãã‚‹DBAã®é›‘記もã¯ã‚„ã“ã‚ŒãŒç„¡ãã¦ã¯éšœå®³å¯¾å¿œãŒã§ããªã„ãらã„ä¸æ¯’ã«ãªã£ã¦ã„ã‚‹mk-query-digestã•ã‚“ã«ã¤ã„ã¦ã§ã™ã€‚ mk-query-digest - Analyze query execution logs and generate a query report, filter, replay, or transform queries for MySQL, PostgreSQL, memcached, and more. 例ãˆã°ã“ã‚“ãªã“ã¨ãŒèµ·ããŸã¨ãã¯ã€ä½•ã‚’å·®ã—ç½®ã„ã¦ã‚‚ã¾ãštcpdumpã‚’å–ã‚Šã«è¡Œãã¾ã™ã€‚ 状æ³ãŒãŠã•ã¾ã£ã¦ã—ã¾ã£ã¦ã‹ã‚‰ã§ã¯é…ã„ã®ã§ã™ã€‚ Load Averageã®é«˜é¨° Too Many Connections lock wait timeout tcpdump -i bond0 -s 65535 -x -n -q -tttt 'port 3306' > tcpdump.out
A tcpdump Tutorial with Examples
{{#tags}}- {{label}}
{{/tags}}