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

lamich id:lamich

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

${{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}}

Sentryã‚’ã¡ã‚ƒã‚“ã¨ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã—ãŸã‚‰ã€æƒ³åƒä»¥ä¸Šã«ã§ãã‚‹ã‚„ã¤ã ã£ãŸè©±ï¼ˆãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã®ã‚¨ãƒ©ãƒ¼ç›£è¦–ï¼‰ | ã‚¨ã‚¹ãƒžãƒƒãƒˆ
2020-05-29Sentryã‚’ã¡ã‚ƒã‚“ã¨ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã—ãŸã‚‰ã€æƒ³åƒä»¥ä¸Šã«ã§ãã‚‹ã‚„ã¤ã ã£ãŸè©±ï¼ˆãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã®ã‚¨ãƒ©ãƒ¼ç›£è¦–ï¼‰ ã¯ã˜ã‚ã«ã“ã‚“ã«ã¡ã¯ã€‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°äº‹æ¥æœ¬éƒ¨ã®@1010realã§ã™ã€‚ ä»Šå¹´åˆã‚ã‹ã‚‰ã‚¹ãƒžãƒ¼ãƒˆã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã«å…¥ç¤¾ã—ã¦ã€æ—¢å˜ã‚µãƒ¼ãƒ“ã‚¹ã®ç®¡ç†ç”»é¢ã®ãƒªãƒ—ãƒ¬ãƒ¼ã‚¹ã‚„é‹ç”¨ãƒ»æ–°è¦æ©Ÿèƒ½é–‹ç™ºã«ãŠã‘ã‚‹ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰é–‹ç™ºã‚’å…¨èˆ¬çš„ã«è¡Œã£ã¦ãŠã‚Šã¾ã™ã€‚ ä»Šå›žã¯Webãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰é–‹ç™ºã«ãŠã‘ã‚‹æœ¬ç•ªç’°å¢ƒã®ã‚¨ãƒ©ãƒ¼ãƒˆãƒ©ãƒƒã‚ãƒ³ã‚°åŠã³ãã®ãƒã‚°ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã€Sentryã‚’ç”¨ã„ã¦åŠ¹çŽ‡çš„ã«è¡Œã†æ–¹æ³•ã‚’ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ å†…å®¹ã¨ã—ã¦ã¯ã€Webãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã«é™ã‚‰ãšã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚„ã‚¢ãƒ—ãƒªãªã©ã€SentryãŒå¯¾å¿œã—ã¦ã„ã‚‹Platformã§ã‚ã‚Œã°ã€å‚è€ƒã«ã§ãã‚‹å†…å®¹ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ç›®æ¬¡ã¯ã˜ã‚ã«ç›®æ¬¡Sentryã«ã¤ã„ã¦ãªãœã“ã®è¨˜äº‹ã‚’æ›¸ã“ã†ã¨æ€ã£ãŸã‹ã¡ã‚ƒã‚“ã¨ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã£ã¦ã©ã†ã„ã†ã“ã¨ï¼Ÿå°Žå…¥æ‰‹é † æœ€åˆã®ã‚¨ãƒ©ãƒ¼ã‚’ãƒˆãƒ©ãƒƒã‚ãƒ³
lamich 2021/04/13
sentry

erro

log

ç›£è¦–

vue.js

js
ãƒªãƒ³ã‚¯
Python ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®æ¨™æº–å‡ºåŠ›ã‚’ãƒ‘ã‚¤ãƒ—ã§ã¤ãªãæ™‚ã«æ°—ã‚’ã¤ã‘ãŸã„ã“ã¨ | iret.media
lamich 2020/02/21
python

tee

print

log
ãƒªãƒ³ã‚¯
https://www.elastic.co/jp/pdf/case-study-line-jp.pdf
lamich 2018/04/26
line

elastic

log

search
ãƒªãƒ³ã‚¯
Django logging on Heroku
lamich 2018/01/10
django

heroku

error

log
ãƒªãƒ³ã‚¯
CA.io #1 ã€Žãƒžãƒƒãƒãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã‚‹Elasticsearchã€å‹‰å¼·ä¼šãƒ¬ãƒãƒ¼ãƒˆ
ã¿ãªã•ã¾ã€ã“ã‚“ã«ã¡ã¯ã€‚ãƒžãƒƒãƒãƒ³ã‚°ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆã®æ²³é‡Žã§ã™ã€‚ ç†è€…ã¯æ¯Žå¹´ã‹ã‹ã•ãšå¤ãƒ•ã‚§ã‚¹ã«è¡Œãã®ã§ã™ãŒã€ä»Šå¹´ã¯éƒ½åˆãŒã¤ã‹ãšã§å‚æˆ¦ã§ããšã€â€ã¾ã å¤ãŒçµ‚ã‚ã£ã¦ã„ãªã„â€ã¨æ„Ÿã˜ã¦ã—ã¾ã†ä»Šæ—¥ã“ã®é ƒã§ã™ã€‚ ã•ã¦ã€ãã‚“ãªä¸(?)ã€9/11(æœˆ)ã«CA.ioã®ç¬¬ä¸€å›žã‚’å®Ÿæ–½ã„ãŸã—ã¾ã—ãŸã€‚å½“æ—¥ã¯100åã‚’è¶…ãˆã‚‹æ–¹ã«è¶³ã‚’é‹ã‚“ã§ã„ãŸã ãã€ã‚ã‚ŠãŒãŸã„ã“ã¨ã«æº€å“¡å¾¡ç¤¼ã¨ãªã‚Šã¾ã—ãŸã€‚ ä»Šå›žã¯ã“ã®å‹‰å¼·ä¼šã®é–‹å‚¬ãƒ¬ãƒãƒ¼ãƒˆã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ CA.ioã¨ã¯ CA.ioã¨ã¯ã€ã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆã®ãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒ¼ãƒ“ã‚¹ã‚’é‹å–¶ã—ã¦ã„ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã‚ˆã‚‹ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å‹‰å¼·ä¼šã§ã™ã€‚æ¯Žå›žç‰¹å®šã®é ˜åŸŸã«ãƒ†ãƒ¼ãƒžã‚’çµžã£ã¦å‹‰å¼·ä¼šã‚’å®Ÿæ–½ã™ã‚‹äºˆå®šã§ã™ã€‚ ç¬¬ä¸€å›žã®ãƒ†ãƒ¼ãƒžã¯â€ãƒžãƒƒãƒãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã‚‹Elasticsearchâ€ã€‚ CAãŒé‹å–¶ã—ã¦ã„ã‚‹ãƒžãƒƒãƒãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã§ã®Elasticsearchã®æ´»ç”¨ãƒŽã‚¦ãƒã‚¦ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ ã¾ãŸã€å½“æ—¥ã¯elasticç¤¾
lamich 2017/12/22
elastic

matching

cyberagent

search

log
ãƒªãƒ³ã‚¯
Oracleé‹ç”¨ã®åŸºæœ¬ã€Œãƒã‚°ã€ã‚’ç†è§£ã—ã‚ˆã†
ã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«åã§ä½œæˆã•ã‚Œã€åˆæœŸåŒ–ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿background_dump_destã§æŒ‡å®šã•ã‚ŒãŸãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«å‡ºåŠ›ã•ã‚Œã‚‹è¿½è¨˜åž‹ã®ãƒ•ã‚¡ã‚¤ãƒ«ã§ã™ã€‚ ä»¥ä¸‹ãŒã€ã‚¢ãƒ©ãƒ¼ãƒˆãƒ»ãƒã‚°ã«å‡ºåŠ›ã•ã‚Œã‚‹ä¸»ãªå†…å®¹ã§ã™ã€‚ -Oracleã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ -OS ã¨ãã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³æƒ…å ±ï¼ˆæ³¨ï¼‰ -ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®èµ·å‹•ãƒ»åœæ¢ã€ãã®ãƒ¢ãƒ¼ãƒ‰ -èµ·å‹•æ™‚ã«ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆä»¥å¤–ã®å€¤ãŒè¨å®šã•ã‚ŒãŸå ´åˆã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ -ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ãƒ—ãƒã‚»ã‚¹ã®PID -è¡¨é ˜åŸŸã®è¿½åŠ ãªã©ï¼ˆç‰©ç†æ§‹æˆã®å¤‰æ›´ï¼‰ -ãƒã‚°ã‚¹ã‚¤ãƒƒãƒã®ç™ºç”Ÿ -ã‚¨ãƒ©ãƒ¼ç•ªå·ã¨ãã®ã‚¨ãƒ©ãƒ¼åã€ãŠã‚ˆã³ãã®è©³ç´°ãŒè¨˜éŒ²ã•ã‚Œã¦ã„ã‚‹ãƒˆãƒ¬ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã®å‡ºåŠ›æƒ…å ± æ³¨ï¼‰ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ãŠã‚ˆã³ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã‚ŠOSå´ã®æƒ…å ±ã«ã¤ã„ã¦ã¯å‡ºåŠ›ã•ã‚Œãªã„å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ Thu Jun 12 14:47:07 2008 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 L
lamich 2017/12/15
oracle

log
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®å®Ÿè£…ã€€ç¬¬2å›žã€€ãƒã‚°ã®å–å¾—ã¨ç›£æŸ»è¨è¨ˆã®ãƒã‚¤ãƒ³ãƒˆ | Oracle æ—¥æœ¬
Pick Upãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®å®Ÿè£…ã€€ç¬¬2å›žã€€ãƒã‚°ã®å–å¾—ã¨ç›£æŸ»è¨è¨ˆã®ãƒã‚¤ãƒ³ãƒˆ é€£è¼‰ã®1å›žç›®ã§ã¯ã€ã‚¢ã‚¯ã‚»ã‚¹ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã¨æ¨©é™ç®¡ç†ã«ã¤ã„ã¦å–ã‚Šä¸Šã’ãŸã€‚ä»Šå›žã¯æƒ³å®šå¤–ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒãªãé©åˆ‡ãªæ¨©é™ç®¡ç†ãŒã§ãã¦ã„ã‚‹ã‹ã‚’ç¢ºèªã—ã€ã¾ãŸä¸‡ãŒä¸€ã®äº‹æ•…ç™ºç”Ÿæ™‚ã«ã¯äº‹æ•…åŽŸå› ã‚’ç©¶æ˜Žã™ã‚‹ãŸã‚ã«åˆ©ç”¨ã™ã‚‹ãƒã‚°ã¨ç›£æŸ»ã«ã¤ã„ã¦å–ã‚Šä¸Šã’ã‚‹ã€‚ â– ç›£æŸ»ã®æ„ç¾© ä¸€èˆ¬çš„ã«ç›£æŸ»ã¯ä»¥ä¸‹ã®ç›®çš„ã§å®Ÿæ–½ã•ã‚Œã‚‹ã€‚ æ¨©é™ç®¡ç†ã®å®Ÿè£…ã«é–¢ã™ã‚‹å•é¡Œã®æ¤œå‡º ä¸å¯©ãªã‚¢ã‚¯ãƒ†ã‚£ãƒ“ãƒ†ã‚£ã®èª¿æŸ»ãƒ»æ¤œå‡º ä¸æ£è¡Œç‚ºã‚’ãŠã“ãªã£ã¦ã„ãªã„è¨¼æ˜Ž ä¸æ£è¡Œç‚ºã®æœªç„¶äºˆé˜²(å¿ƒç†çš„éšœå£) ã‚³ãƒ³ãƒ—ãƒ©ã‚¤ã‚¢ãƒ³ã‚¹è¦ä»¶ã¸ã®å¯¾å¿œ(ç›£æŸ»ãƒ¬ãƒãƒ¼ãƒˆæå‡ºãªã©) ç›£æŸ»ã¨ã„ã†ã¨ä¸æ£ã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚‹ã‚‚ã®ã¨ã®èªè˜ãŒå¤šã„ã¨æ€ã†ãŒã€ãã®ä»–ã«ã‚‚ç®¡ç†è€…ã‚„ç¤¾å“¡ã®èº«ã®æ½”ç™½ã‚’è¨¼æ˜Žã™ã‚‹ãŸã‚ã«ã‚‚åˆ©ç”¨ã§ãã‚‹ã€‚ã¨ãã«å¤§ããªæ¨©é™ã‚’æŒã¤ç®¡ç†è€…ã¯ã€Database Vaultãªã©ã‚’åˆ©ç”¨ã—ãŸç®¡ç†è€…è‡ªèº«ã®æ¨©é™ã®åˆ¶é™(åŽ³æ ¼ãªè·å‹™åˆ†æŽŒ
lamich 2017/12/15
oracle

log
ãƒªãƒ³ã‚¯
goo
ãƒã‚µãƒ³ã‚¼ãƒ«ã‚¹ãƒ»ãƒ‰ã‚¸ãƒ£ãƒ¼ã‚¹ è©¦åˆãƒ•ã‚©ãƒãƒ¼ å¤§è°·ç¿”å¹³ è©¦åˆãƒ•ã‚©ãƒãƒ¼ ãƒˆãƒãƒ³ãƒˆãƒ»ãƒ–ãƒ«ãƒ¼ã‚¸ã‚§ã‚¤ã‚º è©¦åˆãƒ•ã‚©ãƒãƒ¼ ç±³å›½ãƒ•ã‚©ãƒãƒ¼ MLBãƒ•ã‚©ãƒãƒ¼
lamich 2017/12/12
sql

oracle

statspack

v$sql

session

log
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã®ãƒŽã‚¦ãƒã‚¦ã¡ã‚‡ã„è¦‹ã› ç§ãŒä½¿ã†SQLæ–‡ã®æ•ã¾ãˆæ–¹ï¼†å®Ÿè¡Œè¨ˆç”»å–å¾—æ–¹æ³•(å¾Œç·¨)
å„ç¨®ã‚¤ãƒ³ãƒ•ãƒ©æŠ€è¡“(OSã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯)ã‚„ã‚ªãƒ©ã‚¯ãƒ«è£½å“ã¨ã„ã£ãŸè©±é¡Œã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚è‘—è€…ã¯å°ç”°åœäºŒã€ã€Œé–€å¤–ä¸å‡ºã®Oracleç¾å ´ãƒ¯ã‚¶ã€ã€ã€Œçµµã§è¦‹ã¦ã‚ã‹ã‚‹Oracleã®ä»•çµ„ã¿ã€ã€ã€Œçµµã§è¦‹ã¦ã‚ã‹ã‚‹OS/ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸/ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ãªã©ã®è‘—ä½œã‚‚ã‚ã‚Šã¾ã™ å‰å›žã«å¼•ãç¶šã„ã¦SQLæ–‡ã®æ•ã¾ãˆæ–¹ï¼†å®Ÿè¡Œè¨ˆç”»å–å¾—æ–¹æ³•ã§ã™ã€‚ ãã®ï¼ã‹ã‚‰ï¼“ã¯ã€å‰ç·¨ã«è¼‰ã›ã¦ã„ã¾ã™ã€‚ â—ãã®ï¼”ã€€statspackã‹ã‚‰æ•ã¾ãˆã‚‹ æ³¨ï¼šsnapã®ãƒ¬ãƒ™ãƒ«ã¯6ä»¥ä¸ŠãŒãŠå‹§ã‚ã§ã™ã‹ã‚‰ãï¼ ä¾‹ï¼šexecute statspack.snap(i_snap_level=>6); ã“ã®æ–¹æ³•ã¯ã€éŽåŽ»ã®ã‚ã‚‹æ™‚ç‚¹ã®SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’ç¢ºèªã™ã‚‹ãŸã‚ã« ä¾¿åˆ©ãªæ–¹æ³•ã§ã™ã€‚ã€Œæ˜¨æ—¥é…ã‹ã£ãŸã€ã¨ã‹ã€ã€Œå‰åœŸæ›œæ—¥ã®ãƒãƒƒãƒãŒ é…ã‹ã£ãŸã€ã¨ã„ã£ãŸèª¿æŸ»ã«ãŠã„ã¦åŠ›ã‚’ç™ºæ®ã—ã¾ã™ã€‚ statspackã‚„AWR(æœ‰å„Ÿã‚ªãƒ—ã‚·ãƒ§ãƒ³)ã«ã‚ˆã£ã¦ã€éŽåŽ»ã®ã‚ã‚‹æ™‚æœŸã® DBå…¨ä½“ã®ç¨¼å‹•çŠ¶æ³ã‚’ç¢ºèªã§ã
lamich 2017/12/12
sql

oracle

statspack

v$sql

session

log
ãƒªãƒ³ã‚¯
Statspackã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã®å–å¾—ãƒ»å‰Šé™¤ã‚³ãƒžãƒ³ãƒ‰ ï½œ Oracleä½¿ã„ã®ãƒã‚¿å¸³
Statspackã¯è‡ªå‹•å–å¾—ã‚‚å¯èƒ½ Oracle ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã€å–å¾—æ¸ˆã¿ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã®ç¢ºèªã‚„ æ‰‹å‹•/è‡ªå‹•ã§ã®å–å¾—ã€å¯¾è±¡ãƒ¬ãƒ™ãƒ«ã®æŒ‡å®šã‚‚å¯èƒ½ã€‚ãã®æ–¹æ³•ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ Statspackã®æ‰‹å‹•å–å¾—ã‚³ãƒžãƒ³ãƒ‰ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆä»¥å¤–ã®ãƒ¬ãƒ™ãƒ«ã§ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’å–å¾—ã™ã‚‹ã«ã¯ã€ å¼•æ•°ã« i_snap_level ã‚’è¿½è¨˜ã™ã‚‹ã€‚ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ SQL> execute statspack.snap â€» ãƒ¬ãƒ™ãƒ«5ã§ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆãŒä½œæˆã•ã‚Œã‚‹ ãƒ¬ãƒ™ãƒ«6æŒ‡å®š SQL> execute statspack.snap(i_snap_level=> 6) â€» å®Ÿè¡Œæ™‚ã®ã¿ãƒ¬ãƒ™ãƒ«6ã§å–å¾—ã•ã‚Œã‚‹ Statspackã®è‡ªå‹•å–å¾—ã‚³ãƒžãƒ³ãƒ‰ æ—¥ä»˜ã®æ¼”ç®—ã§ä¸€å®šæ™‚é–“æ¯Žã«å–å¾—ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã€‚ 1æ™‚é–“æ¯Ž execute dbms_job.interval(ï¼œã‚¸ãƒ§ãƒ–ï¼ž, 'sysdate+(1/24)'); 10åˆ†æ¯Ž execute dbms_
lamich 2017/12/12
sql

oracle

statspack

v$sql

session

log

snap
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚³ãƒ³ã‚µãƒ«ã‚¿ãƒ³ãƒˆã®ãƒŽã‚¦ãƒã‚¦ã¡ã‚‡ã„è¦‹ã› ç§ãŒä½¿ã†SQLæ–‡ã®æ•ã¾ãˆæ–¹ï¼†å®Ÿè¡Œè¨ˆç”»å–å¾—æ–¹æ³•(å‰ç·¨)
å„ç¨®ã‚¤ãƒ³ãƒ•ãƒ©æŠ€è¡“(OSã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯)ã‚„ã‚ªãƒ©ã‚¯ãƒ«è£½å“ã¨ã„ã£ãŸè©±é¡Œã‚’å–ã‚Šä¸Šã’ã¾ã™ã€‚è‘—è€…ã¯å°ç”°åœäºŒã€ã€Œé–€å¤–ä¸å‡ºã®Oracleç¾å ´ãƒ¯ã‚¶ã€ã€ã€Œçµµã§è¦‹ã¦ã‚ã‹ã‚‹Oracleã®ä»•çµ„ã¿ã€ã€ã€Œçµµã§è¦‹ã¦ã‚ã‹ã‚‹OS/ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸/ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ãªã©ã®è‘—ä½œã‚‚ã‚ã‚Šã¾ã™ â€»ã„ãŸã ã„ãŸã‚³ãƒ¡ãƒ³ãƒˆã‚’æŽ¡ç”¨ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ã€Œ and a.sql_child_number = b.child_numberã€ã‚’è¿½åŠ ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€ç§ãŒã‚ˆãä½¿ã†ã€å®Ÿè¡Œã•ã‚ŒãŸSQLæ–‡ã®æ•ã¾ãˆæ–¹ã€ãŠã‚ˆã³SQLæ–‡ã®å®Ÿè¡Œè¨ˆç”»å–å¾—æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚é•·ã„ã®ã§å‰ç·¨ã¨å¾Œç·¨ã«åˆ†ã‘ã¾ã™ã€‚ä»Šå›žã¯å‰ç·¨ã§ã™ã€‚ ã¾ãšã€ã€Œv$sql_planã‹ã‚‰å®Ÿè¡Œè¨ˆç”»ã‚’è¡¨ç¤ºã™ã‚‹ã€æ–¹æ³•ã‚’ç°¡å˜ã«ç´¹ä»‹ã—ã€ãã®å¾Œã€ã€Œå®Ÿè¡Œã•ã‚ŒãŸSQLæ–‡ã®æ•ã¾ãˆæ–¹ã€ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ â—ãã®ï¼ã€€v$sql_planã‹ã‚‰å®Ÿè¡Œè¨ˆç”»ã‚’è¡¨ç¤ºã™ã‚‹ã€‚ ã©ã®æ–¹æ³•ã§ã‚‚å¤§ä½“ä½¿ãˆã‚‹ã€v$ãƒ“ãƒ¥ãƒ¼ã‹ã‚‰ã®å®Ÿè¡Œè¨ˆç”»ã®è¡¨ç¤ºæ–¹æ³•ã§ã™
lamich 2017/12/12
sql

oracle

statspack

v$sql

session

log
ãƒªãƒ³ã‚¯
ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ã‹ã‚‰æ™‚é–“ã”ã¨ã®ã‚¢ã‚¯ã‚»ã‚¹æ•°ã‚’é›†è¨ˆã™ã‚‹ - notebook
ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ã‹ã‚‰æ™‚é–“ã”ã¨ã®ã‚¢ã‚¯ã‚»ã‚¹æ•°ã‚’é›†è¨ˆã™ã‚‹ cat access_log | grep -P -o 'Dec 12 \d{2}:' | sort | uniq -c ç‰¹å®šã®ã‚¢ã‚¯ã‚»ã‚¹ã§ã‚«ã‚¦ãƒ³ãƒˆã—ãŸã„å ´åˆã¯catã‚’grepã«ã—ã¦ãƒ‘ã‚¤ãƒ—ã§æ¸¡ã™æ„Ÿã˜ã«ã™ã‚Œã°OK grep 'path' access_log | grep -P -o 'Dec 12 \d{2}:' | sort | uniq -c -P ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¯æ£è¦è¡¨ç¾ã§Perlã®æ£è¦è¡¨ç¾ã‚’ä½¿ã„ã¾ã™ã‚ˆã£ã¦ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³ linuxã®æ£è¦è¡¨ç¾ã ã¨ãŸã¾ã«æ„å›³ã—ã¦ãªã„æŒ™å‹•ã«ãªã‚‹ã®ã§æ€¥ã„ã§ãŸã‚Šã™ã‚‹ã¨ã¤ã„-Pã‚’ä½¿ã£ã¦ã—ã¾ã£ãŸã‚Šã€‚ã€‚ ãƒžãƒƒãƒã—ãŸã‚‚ã®ã ã‘å–ã‚Šå‡ºã™å ´åˆã¯ -o ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§å–ã£ã¦ã“ã‚Œã‚‹ã€‚å˜ç´”ãªé›†è¨ˆã ã£ãŸã‚‰ã“ã‚Œã§ååˆ†ã§ã™ãã€‚ uniq -c ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§ãã‚Œãžã‚Œã‚«ã‚¦ãƒ³ãƒˆã—ãŸå€¤ã‚‚å–å¾—ã§ãã¾ã™ã€‚ã“ã‚Œæœ€è¿‘ã¾ã§çŸ¥ã‚‰ãªã‹ã£ãŸï½— ç‰¹å®šãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®å€¤ã‚’å‡ºã—
lamich 2015/08/07
grep

text

access

log

analysis

server

bad
ãƒªãƒ³ã‚¯
ãƒã‚°è§£æžã®ã¨ãä¾¿åˆ©ãªã‚³ãƒžãƒ³ãƒ‰ã¾ã¨ã‚ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
lamich 2015/08/07
grep

text

access

log

analysis

server

bad
ãƒªãƒ³ã‚¯
grepã§ãƒã‚°è§£æžã‚’ã™ã‚‹ãªã‚“ã¦ã²ã©ã„è©±ã | POSTD
ä»Šã§ã‚‚ã€ systemdã®journal ã«ãŠã‘ã‚‹ãƒã‚¤ãƒŠãƒªã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã«é–¢ã—ã¦ã€ä¸æº€ã‚’æ¼ã‚‰ã™äººãŒå¤šãã„ã‚‹ã“ã¨ã«ç§ã¯é©šãã‚’éš ã›ã¾ã›ã‚“ã€‚ç§ã¯é•·å¹´ã€ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†è€…ã¨ã—ã¦åƒã„ã¦ãã¦ãŠã‚Šã€1å¹´ä»¥ä¸Šã‚‚ syslog-ng ã® ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚¨ãƒ‡ã‚£ã‚·ãƒ§ãƒ³ã®ãƒ¡ãƒ³ãƒ†ãƒŠ ã¨ã—ã¦æ´»å‹•ã—ã¦ãã¾ã—ãŸã€‚ã ã‹ã‚‰ã“ãã€ãƒ†ã‚ã‚¹ãƒˆã§ã¯ãªã„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã«å¯¾ã—ã¦ã€ãªãœå¤šãã®äººãŒæ‰¹åˆ¤çš„ãªã®ã‹ã€ç§ã¯ç†è§£ã«è‹¦ã—ã‚“ã§ã„ã¾ã™ã€‚æ›´ã«ã€åè«–ã‚’å”±ãˆã‚‹äººã¾ã§ã„ã‚‹ã“ã¨ãŒä¿¡ã˜ã‚‰ã‚Œã¾ã›ã‚“ã€‚ã‚‚ã—ã‹ã—ãŸã‚‰ã€ç§ã¯åˆ¥ä¸–ç•Œã®äººé–“ãªã®ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ã§ã™ãŒã€ã‚ˆã‚Šè‰¯ã„é¸æŠžè‚¢ãŒã‚ã‚‹ã®ã«ã€ãƒ†ã‚ã‚¹ãƒˆã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’ä½¿ã†ç†ç”±ã¯ã»ã¨ã‚“ã©ã‚ã‚Šã¾ã›ã‚“ã€‚ãƒã‚®ãƒ³ã‚°ã‚’ã™ã‚‹å¿…è¦æ€§ã€ãã—ã¦ãªãœã€ãƒ†ã‚ã‚¹ãƒˆã®ãƒã‚°ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã«å¯¾ã—ã¦ãã“ã¾ã§ç”¨å¿ƒæ·±ã„ã®ã‹ã«ã¤ã„ã¦ã€ç§ã¯ä½•åº¦ã‚‚å°‹ãã‚‰ã‚Œã¾ã—ãŸã€‚ã“ã“ã«ã€ç§ãŒå°Žãå‡ºã—ãŸç”ãˆã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã“ã‚Œã¯ã€journalã«ã¤ã„ã¦å¼æ˜Žã™ã‚‹
lamich 2015/08/07
grep

text

access

log

analysis

server

bad
ãƒªãƒ³ã‚¯
æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚º
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
lamich 2014/06/18
apache.log

apache

log

performance

tuning

SEO
ãƒªãƒ³ã‚¯
Logging - 2.x
This document is for a version of CakePHP that is no longer supported. Please upgrade to a newer release! LoggingÂ¶ While CakePHP core Configure Class settings can really help you see whatâ€™s happening under the hood, there are certain times that youâ€™ll need to log data to the disk in order to find out whatâ€™s going on. In a world that is becoming more dependent on techno logies like SOAP and AJAX, de
lamich 2014/05/26
cakephp

log
ãƒªãƒ³ã‚¯
CakePHPã§ä»»æ„ã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¸ãƒã‚°ã‚’å‡ºåŠ›ã™ã‚‹æ–¹æ³• | æ ªå¼ä¼šç¤¾LIG(ãƒªã‚°)ï½œDXæ”¯æ´ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãƒ»Webåˆ¶ä½œ
ã“ã‚“ã«ã¡ã¯ã€‚ãŠç›†ä¼‘ã¿ã¯åœ°å…ƒã«å¸°ã‚Šã€ã‚ã•ã‚ŠãŒé£Ÿã¹ãŸã„ãªãã¨æ€ã„ã€å†·è”µåº«ã‚’ã‚ã•ã‚Šç¶šã‘ã¾ã—ãŸãŒã€ã‚·ã‚¸ãƒŸã—ã‹ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ã‚·ã‚¸ãƒŸã®ç”³ã—åã€å‹åˆ©ã§ã™ã€‚ ãŠå¾ŒãŒå®œã—ã„ã‚ˆã†ã§ãƒ»ãƒ»ãƒ» ã•ãã€èŒ¶ç•ªã¯çµ‚ã‚ã‚Šã«ã—ã¦ã€ä»Šå›žã¯ä¹…ã—ã¶ã‚Šã®CakePHPãƒã‚¿ã§ã™ã€‚ CakePHPã§ä»»æ„ã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã¸ãƒã‚°ã‚’å‡ºåŠ›ã™ã‚‹æ–¹æ³•ã‚’ã”ç´¹ä»‹ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„è‡´ã—ã¾ã™ã€‚ çµŒç·¯ã‚„ç”¨é€” ç†ç”±ãªã‚“ã¦å¾Œã‹ã‚‰ã¤ã‘ã‚Œã°ã„ãƒ¼ã‚“ã§ã™ã€‚è‡ªåˆ†è‡ªèº«ãŒä½œã‚ŠãŸã„ã¨æ±ºã‚ãŸã‚‰ä½œã‚Œã°ã„ãƒ¼ã‚“ã§ã™ã€‚ ä½œæ¥ã—ã¦ã„ã‚‹éš›ã‚„ã€æœ¬ç•ªãƒªãƒªãƒ¼ã‚¹å¾Œç‰ã«è‡ªåˆ†ã ã‘ã®ãƒã‚°å‡ºåŠ›ãƒ•ã‚¡ã‚¤ãƒ«ã‚„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä»•æ§˜çš„ã«CakePHPã®ãƒã‚°ä»¥å¤–ã®ãƒã‚°ãŒå¿…è¦ã«ãªã£ãŸã‚Šæ¬²ã—ããªã£ãŸã‚Šã—ãŸã“ã¨ã¯ãªã„ã§ã™ã‹ï¼Ÿ ã‚‚ã¡ã‚ã‚“ãƒã‚°å‡ºåŠ›ã ã‘ã§ã‚ã‚Œã°CakePHPã«å‚™ã‚ã£ã¦ã„ã‚‹ã‚‚ã®ã‚’ä½¿ç”¨ã—ãŸã‚‰ã„ã„ã¨æ€ã†ã®ã§ã™ãŒã€CakePHPã§ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§åãå‡ºã•ã‚Œã‚‹ãƒã‚°ã«ã‚ˆã£ã¦æ±šã•ã‚ŒãŸã‚Šã™ã‚‹ã¨ã€è‡ªåˆ†ãŒåãå‡ºã—ãŸ
lamich 2014/05/14
cakephp

batch

log

tips
ãƒªãƒ³ã‚¯
CakePHP2ç³»ã§ãƒãƒƒãƒå‡¦ç†ã‚’å®Ÿè¡Œã™ã‚‹ãŸã‚ã«è¦šãˆã¦ãŠãã‚ã‹ã‚Šã‚„ã™ã„åŸºæœ¬æ–¹æ³• - ã€é‹åˆ©å›£ä½“ã€‘PK-Brothers
æˆ‘ã€…ã¯æ—¥ã€…æ»ã¬ãŸã‚ã«ç”Ÿãã¦ã„ã‚‹ã€‚ ç”Ÿãã‚‹ãŸã‚ã«æ»ãã‚‹ã€‚ æœ€è¿‘ãã‚“ãªè¨€è‘‰ãŒèƒ¸ã«ã•ã•ã£ãŸã€‚ ä»Šå›žã®Tipsã¯ã‚ˆãã‚ã‚‹CakePHPã§ã®ãƒãƒƒãƒå‡¦ç†ã‚’å®Ÿè¡Œã™ã‚‹ãŸã‚ã®åŸºæœ¬çš„æ–¹æ³•ã«ã¤ã„ã¦è¨˜è¿°ã™ã‚‹ã€‚ ã‚ˆãã‚·ã‚§ãƒ«ã¨ã‚‚è¨€ã†ã‚‰ã—ã„ãŒã€åƒ•ã¯ãƒãƒƒãƒã¨ã„ã£ãŸæ–¹ãŒã—ã£ãã‚Šãã‚‹ã‹ã‚‰ä»¥ä¸‹ãƒãƒƒãƒã¨ã„ã†ã€‚ åƒ•ã®é–‹ç™ºç’°å¢ƒã¯Windowsç’°å¢ƒãªã®ã§Windowsã«ç‰¹åŒ–ã—ã¦ã„ã‚‹è¨˜è¿°ã«ãªã‚‹ãŒã„ã„ã ã‚ã†ã€‚ çµæ§‹Windowsè¨˜äº‹ã‚’è¦‹ã¤ã‘ãªã„ã‹ã‚‰ã ã€‚ å‚è€ƒã«ãªã‚Œã°å¹¸ã„ã§ã”ã–ã‚‹ã€‚ ã¾ãšã€ã©ã®ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãã‹ï¼Ÿ app/Console/Command/ ã“ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’è¿½åŠ ã™ã‚‹ã€‚ ã§ãã‚Œã°CakePHPã®å‘½åè¦å‰‡ã«ã®ã£ã¨ã£ã¦æ›¸ãã®ãŒç„¡é›£ã ã‚ã†ã€‚ app/Console/Command/TestShell.php ã“ã‚“ãªæ„Ÿã˜ã«ã€ãã€‚ ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®æ§‹æˆã¯ï¼Ÿ åƒ•ã¯ã„ã¤ã‚‚ä»¥ä¸‹ã®ã‚ˆã†ãªå½¢ã§åŸºæœ¬å½¢æˆã‚’ä¿ã£ã¦ã„ã‚‹ã€‚ äººã¯ãƒ«ãƒ¼ãƒ«ã®ä¸Šã«ã„ã¦ã“ã
lamich 2014/05/14
cakephp

batch

log

tips
ãƒªãƒ³ã‚¯
[ãƒ…] [Linux]æ¨™æº–ã‚¨ãƒ©ãƒ¼å‡ºåŠ›ã¨æ¨™æº–å‡ºåŠ›ã‚’ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã—ã¦ãƒ•ã‚¡ã‚¤ãƒ«ã¸æ›¸ãå‡ºã™ (2011-03-26)
æ–°è¦ã¾ãŸã¯ä¸Šæ›¸ãã™ã‚‹å ´åˆ: $ ./mycommand >& mycommand.log è¿½è¨˜ã™ã‚‹å ´åˆ: $ ./mycommand >> mycommand.log 2>&1 â†“ã“ã“ã«ã™ã”ãã‚ˆãã¾ã¨ã¾ã£ã¦ãŸã€‚ ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆ Cã‚·ã‚§ãƒ«ã®å ´åˆ Command < file æ¨™æº–å…¥åŠ›ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰èªã¿è¾¼ã‚€ Command > file æ¨™æº–å‡ºåŠ›ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãå‡ºã™ Command >! file åŒä¸Šä¸Šæ›¸ã Command >& file æ¨™æº–å‡ºåŠ›ã¨æ¨™æº–ã‚¨ãƒ©ãƒ¼å‡ºåŠ›ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ãå‡ºã™ Command >&! file åŒä¸Šä¸Šæ›¸ã Command >> file æ¨™æº–å‡ºåŠ›ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã«è¿½è¨˜ Command >>& file æ¨™æº–å‡ºåŠ›ã¨æ¨™æº–ã‚¨ãƒ©ãƒ¼å‡ºåŠ›ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã«è¿½è¨˜ Command | cmd2 æ¨™æº–å‡ºåŠ›ã‚’ã‚³ãƒžãƒ³ãƒ‰cmd2ã®æ¨™æº–å…¥åŠ›ã«æŽ¥ç¶š Command |& cmd2 æ¨™æº–å‡ºåŠ›ã¨æ¨™æº–ã‚¨ãƒ©ãƒ¼å‡ºåŠ›ã‚’ã‚³
lamich 2013/08/02
error

redirect

linux

log

echo

tips
ãƒªãƒ³ã‚¯
multiburst.net
Selecting the right blog niche can make the difference between a thriving online presence and a forgotten website. With hundreds of potential niches available, understanding which topics resonate with audiences and offer sustainable content opportunities is crucial for long-term blogging success. Health and fitness blogs consistently rank among the most popular and engaging niches, offering endles
lamich 2012/12/22
php

error

log

php.ini
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸