[B! log] harigelã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

harigel id:harigel

logã«é–¢ã™ã‚‹harigelã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

MySQLã®ã‚¹ãƒãƒ¼ãƒã‚°é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ãŒè©•ä¾¡ã•ã‚Œã‚‹é †ç•ª
åˆ¥ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼æ›¸ã„ã¦ãŸã‚‰ã€å‰ã«èª°ã‹ã«èžã‹ã‚ŒãŸãªã¨æ€ã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ ã‚¹ãƒãƒ¼ãƒã‚°ãŒå‡ºåŠ›ã•ã‚Œã‚‹ã‹ã©ã†ã‹ã®åˆ¤å®šã¯ã€ 1. ã‚¹ãƒãƒ¼ãƒã‚°ãŒæœ‰åŠ¹åŒ–ã•ã‚Œã¦ã„ã‚‹ã“ã¨ 2. log_slow_admin_statements = 0 ã§é™¤å¤–ã•ã‚Œã‚‹ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã§ã¯ãªã„ã“ã¨ 3. (long_query_timeä»¥ä¸Šã®æ™‚é–“ãŒã‹ã‹ã£ã¦ã„ã‚‹) OR (log_queries_not_using_indexes ã«ãƒžãƒƒãƒã™ã‚‹) ã‚¯ã‚¨ãƒªãƒ¼ã§ã‚ã‚‹ã“ã¨ 4. ã‚¯ã‚¨ãƒªãƒ¼ã®ExaminedãŒÂ min_examined_row_limit ä»¥ä¸Šã§ã‚ã‚‹ã“ã¨ 5. log_queries_not_using_indexesã«ãƒžãƒƒãƒã—ã¦ã„ã‚‹ã“ã¨ãŒæ±ºã¾ã£ã¦ã„ã‚‹å ´åˆã€log_throttle_queries_not_using_indexesÂ ã§è¨å®šã•ã‚ŒãŸä»¥ä¸Šã®æ™‚é–“ãŒçµŒã£ã¦ã„ã‚‹ã‹ã©ã†ã‹ æ„å¤–ã¨4. ãŒçŸ¥ã‚‰ã‚Œã¦ãªãã¦ã€ã©ã‚“ãªã«æ™‚é–“ãŒã‹ã‹ã£ã¦
harigel 2016/04/28
â€œã©ã‚“ãªã«æ™‚é–“ãŒã‹ã‹ã£ã¦ã‚‚min_examined_row_limitã‚ˆã‚Šä¸‹ã®ã‚„ã¤ã¯ãƒã‚°ã•ã‚Œãªã„â€

*programming

MySQL

log
ãƒªãƒ³ã‚¯
æŸ”è»Ÿãªãƒã‚°åŽé›†ã‚’å¯èƒ½ã«ã™ã‚‹ã€Œfluentdã€å…¥é–€ | ã•ãã‚‰ã®ãƒŠãƒ¬ãƒƒã‚¸
è¤‡æ•°å°ã®ã‚µãƒ¼ãƒãƒ¼ã‚„ã‚¯ãƒ©ã‚¦ãƒ‰ç’°å¢ƒã‚’çµ„ã¿åˆã‚ã›ã¦ã®ã‚µãƒ¼ãƒ“ã‚¹é‹ç”¨ã«ãŠã„ã¦ã¯ã€ãƒã‚°ã®åŽé›†æ–¹æ³•ã«å·¥å¤«ãŒå¿…è¦ã¨ãªã‚‹ã€‚ã“ã†ã„ã£ãŸå ´åˆã«æœ‰ç”¨ãªã®ãŒã€ã•ã¾ã–ã¾ãªãƒã‚°ã®åŽé›†æ‰‹æ®µã‚’æä¾›ã™ã‚‹fluentdã ã€‚ä»Šå›žã¯fluentdã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚„ãã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«/è¨å®šæ–¹æ³•ã€åŸºç¤Žçš„ãªè¨å®šä¾‹ãªã©ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ ã•ã¾ã–ã¾ãªæ–¹æ³•ã§ãƒã‚°ã‚’åŽé›†ã§ãã‚‹fluentd ä»Šå›žç´¹ä»‹ã™ã‚‹fluentdã¯ã€Treasure DataãŒé–‹ç™ºã™ã‚‹ãƒã‚°åŽé›†ç®¡ç†ãƒ„ãƒ¼ãƒ«ã ï¼ˆå›³1ï¼‰ã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã•ã‚Œã¦ãŠã‚Šã€Linuxã‚„å„ç¨®UNIXã§å‹•ä½œã™ã‚‹ã€‚ å›³1 fluentdã®Webã‚µã‚¤ãƒˆ ãƒã‚°åŽé›†ã®ãŸã‚ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¨ã—ã¦ã¯syslogdã‚„syslog-ngãªã©ãŒæœ‰åã ãŒã€fluentdãŒã“ã‚Œã‚‰ã¨ç•°ãªã‚‹ç‚¹ã¨ã—ã¦ã¯ã€ä»¥ä¸‹ãŒæŒ™ã’ã‚‰ã‚Œã‚‹ã€‚ ã•ã¾ã–ã¾ãªã‚½ãƒ¼ã‚¹ã‹ã‚‰ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’ã•ã¾ã–ã¾ãªåª’ä½“ã«å‡ºåŠ›ã§ãã‚‹ fluentdã®å¤§ããªç‰¹å¾´ã¨ã—ã¦ã¯ã€ãƒã‚°ã®åŽé›†æ–¹æ³•ã‚„ãƒã‚°ã®è¨˜
harigel 2014/10/27
ç›£è¦–

fluentd

log
ãƒªãƒ³ã‚¯
gitã§treeè¡¨ç¤ºã™ã‚‹alias - ã™ãŽã‚ƒãƒ¼ã‚“ãƒ¡ãƒ¢
TLã§è¦‹ã‹ã‘ãŸã®ã§è‡ªåˆ†ã‚‚é©å½“ã«è¨å®šã—ã¦ã¿ã¾ã—ãŸã€‚ ~/.gitconfigã«ã¦ [alias] tr = log --graph --pretty='format:%C(yellow)%h%Creset %s %Cgreen(%an)%Creset %Cred%d%Creset' è¦‹ã‚„ã™ãã¦ã‚¤ã‚¤ã‚«ãƒ³ã‚¸ã§ã™ãã€‚
harigel 2013/08/29
*programming

git

log
ãƒªãƒ³ã‚¯
Linuxç‰ã§ã®ãƒã‚°ã®ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã§ç°¡å˜ã«ã‚¢ãƒ©ãƒ¼ãƒˆã‚’ã‚ãƒ£ãƒƒãƒã™ã‚‹ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€…
æ˜”ã€ã€Žã€Œping -aã€ã§éŸ³ãŒé³´ã‚‹ï¼ã€ãªã‚¨ãƒ³ãƒˆãƒªã§ã‚‚æ›¸ã„ãŸã®ã§ã™ãŒã€ä½•ã‚‰ã‹ã‚’ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«ãƒã‚§ãƒƒã‚¯/ç›£è¦–ã—ãŸã„æ™‚ã«ã€è¦–è¦šã ã‘ã§ã¯ãªãã‚¢ãƒ©ãƒ¼ãƒˆéŸ³ãŒä¸€ç·’ã«å‡ºã‚‹ã¨ã€ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã—ã‚„ã™ã„ã‚‚ã®ã§ã™ã€‚ ã¨ã„ã†ã‚ã‘ã§ã€Linuxãªã‚“ã‹ã§ã€ã¨ã‚ã‚‹ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®å‡ºåŠ›ã‹ã‚‰ã€ã‚ã‚‹æ–‡å—åˆ—ãŒæ¤œå‡ºã•ã‚ŒãŸéš›ã«ã€ãƒ“ãƒ¼ãƒ—éŸ³ã‚’é³´ã‚‰ã™ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ã¯ä»¥ä¸‹ã€‚ $ tail -f ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ« | sed -e 's/$å¯¾è±¡æ–‡å—åˆ—$/\1^G/'ä¸Šè¨˜ã‚’å®Ÿè¡Œä¸ã«ã€æŒ‡å®šãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«å¯¾è±¡æ–‡å—åˆ—ãŒå‡ºåŠ›ã•ã‚Œã‚‹ã¨ãƒ“ãƒ¼ãƒ—(Beep)éŸ³ãŒé³´ã‚‹ã¯ãšã€‚ ã€Œ^Gã€(0x07)ã®éƒ¨åˆ†ãŒã€ASCIIã®BELã‚ãƒ£ãƒ©ã‚¯ã‚¿ã®ãƒªãƒ†ãƒ©ãƒ«ã§ã™ã€‚ $ echo -n "^G"ãªã©ã¨ã—ã¦ã‚„ã‚Œã°ã€ãƒ™ãƒ«(ãƒ“ãƒ¼ãƒ—éŸ³)ãŒé³´ã‚Šã¾ã™ã‚ˆãã€‚ ã¡ãªã¿ã«ã€ã€Œ^Gã€ã¯ã€[Ctrl-V] â‡’ [Ctrl-G] ã®é †ã«å…¥åŠ›ã—ã¦ã‚„ã‚Œã°OKã€‚emacsã ã¨[Ctrl-Q] â‡’ [Ctrl-G]ã‹
harigel 2010/08/27
linux

shell

log
ãƒªãƒ³ã‚¯
1