[B! ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°] xorphitusã®ãƒ

xorphitus id:xorphitus

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹xorphitusã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

nginxã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
@shibuya.pm#17
xorphitus 2015/09/22
ã‚¤ãƒ³ãƒ•ãƒ©

nginx

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Linuxã§ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã‚„ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚µãƒ¼ãƒã‚’ãƒžãƒ«ãƒã‚³ã‚¢ã‚¹ã‚±ãƒ¼ãƒ«ã•ã›ã‚‹ãŸã‚ã®ã‚«ãƒ¼ãƒãƒ«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - ã‚†ã†ã†ããƒ–ãƒã‚°
æœ¬è¨˜äº‹ã®å…¬é–‹å¾Œã®2016å¹´7æœˆã«ã¯ã¦ãªã«ãŠã‘ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°äº‹ä¾‹ã‚’ç´¹ä»‹ã—ãŸã€‚ ã¯ã¦ãªã«ãŠã‘ã‚‹Linuxãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚¹ã‚¿ãƒƒã‚¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ”¹å–„ / Linux network performance improvement at hatena - Speaker Deck HAProxy ã‚„ nginx ãªã©ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã‚„ãƒªãƒãƒ¼ã‚¹ãƒ—ãƒã‚ã‚·ã€memcached ãªã©ã® KVS ã®ã‚ˆã†ãªé«˜ãƒ‘ã‚±ãƒƒãƒˆãƒ¬ãƒ¼ãƒˆã«ãªã‚Šã‚„ã™ã„ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦ã€å˜ä¸€ã® CPU ã‚³ã‚¢ã«è² è·ãŒåã‚Šã€ãƒžãƒ«ãƒã‚³ã‚¢ã‚¹ã‚±ãƒ¼ãƒ«ã—ãªã„ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ ä»Šå›žã¯ã€ã“ã®ã‚ˆã†ãªãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦ CPU è² è·ãŒãƒžãƒ«ãƒã‚³ã‚¢ã‚¹ã‚±ãƒ¼ãƒ«ã—ãªã„ç†ç”±ã¨ã€ãƒžãƒ«ãƒã‚³ã‚¢ã‚¹ã‚±ãƒ¼ãƒ«ã•ã›ã‚‹ãŸã‚ã® Linux ã‚«ãƒ¼ãƒãƒ«ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚¹ã‚¿ãƒƒã‚¯ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ‰‹æ³•ã¨ã—ã¦ RFS (Receive Flow Steering) ã‚’
xorphitus 2015/03/31
Linux

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
å®ŸéŒ²MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° æ˜¥ã®é™£ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
long_query_time = 0.5 ã¨ã‹é–¾å€¤ã‚’å°ã•ã‚ã«ã—ã¦ã‚‚ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãŒå‡ºãªããªã£ãŸã‘ã©ã€CPU(user)ä½¿ç”¨çŽ‡é«˜ã„ã¨ã‹ã€ãªã‚“ã‹è¶³å¼•ã£å¼µã£ã¦ã‚‹ã‚¯ã‚¨ãƒªãŒã‚ã‚‹ã£ã½ã„ãªãã¨ã„ã†å ´åˆã®ãŠè©±ã§ã™ã€‚ ã€Œå®ŸéŒ²ã€ã®é€šã‚Šã€ç¾åœ¨çµ¶è³›é€²è¡Œä¸ã§ã™ã®ã§ã€é€æ¬¡å‹•ããŒã‚ã£ãŸã‚‰æ›¸ãè¶³ã—ã¦ã„ãã¤ã‚‚ã‚Šã§ã™ã€‚ ã€Œã‚ã‚Œã‚’è¦‹ãŸæ–¹ãŒã„ã„ã€ã¨ã‹ã€Œã“ã‚Œã‚’ã‚ãƒ¼ã—ãŸæ–¹ãŒã„ã„ã€ã¨ã‹ã‚ã‚Œã°ã€ã‚³ãƒ¡ãƒ³ãƒˆã‹Twitterã§ @hirose31 ã¾ã§ãŠçŸ¥ã‚‰ã›ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ï¼ ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ã¯ã€MySQL 5.1.41 ã§ã™ã€‚ å‰æ: ã‚µãƒ¼ãƒãƒ¼ãƒªã‚½ãƒ¼ã‚¹ã®ã‚°ãƒ©ãƒ• Gangliaã§ã‚‚Cactiã§ã‚‚Muninã§ã‚‚ãªã‚“ã§ã‚‚ã„ã„ã‚“ã§ã™ãŒã€ã‚µãƒ¼ãƒãƒªã‚½ãƒ¼ã‚¹ã®ã‚°ãƒ©ãƒ•åŒ–ã¯å¿…é ˆã§ã™ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ãŸéš›ã®åŠ¹æžœæ¸¬å®šã‚„ã€ãã‚ãã‚ãƒªã‚½ãƒ¼ã‚¹é£Ÿã„æ½°ã—ã¦ã‚„ã°ã„ã¨ã‹ã®äºˆæ¸¬ã«ã‚‚ä½¿ãˆã¾ã™ã€‚ è‡ªåˆ†ã¯DBã‚µãƒ¼ãƒã®å ´åˆã“ã®ã‚ãŸã‚Šã‚’ã‚°ãƒ©ãƒ•åŒ–ã—ã¦ã¾ã™ã€‚ CPUä½¿ç”¨çŽ‡ (user,
xorphitus 2014/02/28
MySQL

db

performance

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ã•ã‚‰ã«MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹7ã¤ã®æ–¹æ³•
MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†è¨˜äº‹ãŒã¨ã¦ã‚‚å¥½è©•ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚è¨˜äº‹ã‚’èªã‚“ã§é ‚ã„ãŸçš†ã•ã‚“ã€ã‚ã‚ŠãŒã¨ã†ã€‚ ã“ã®è¨˜äº‹ã«å¯¾ã™ã‚‹ä¾¿ä¹—ï¼ˆï¼Ÿï¼‰ã§Webå±‹ã®ãƒã‚¿å¸³: PostgreSQLã‚’é«˜é€ŸåŒ–ã™ã‚‹16ã®ãƒã‚¤ãƒ³ãƒˆã¨ã„ã†è¨˜äº‹ã‚’æ›¸ã„ã¦é ‚ã„ãŸã‚ˆã†ã ãŒã€ãã¡ã‚‰ã®æ–¹ã‚‚ã‹ãªã‚Šäººæ°—ã ã£ãŸã‚ˆã†ã§ã‚ã‚‹ã€‚ä»–äººãŒä½œã£ãŸã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã«æ”¹è‰¯ã‚’åŠ ãˆã‚‹ã¨ã„ã†ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚„ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®ç²¾ç¥žã‚‚åŸºæœ¬ã¯ä¾¿ä¹—ã§ã‚ã‚‹ã®ã§ã€ä¾¿ä¹—ã«ã¤ã„ã¦ã¯å¤§ã„ã«è³›æˆã—ãŸã„ã¨ã„ã†ã‹ã‚€ã—ã‚å–ã‚Šä¸Šã’ã¦ãã‚Œã¦ã‚ã‚ŠãŒã¨ã†ï¼ï¼ã¨æ€ã†ã‚ã‘ã§ã‚ã‚‹ãŒã€ã“ã“ã§ã•ã‚‰ã«ä¿ºã¯ã“ã†è€ƒãˆã‚‹ã€‚ ã¨ã€‚ Webå±‹ã®ãƒã‚¿å¸³ã•ã‚“ã®è¨˜äº‹ã§ã¯16ã®ãƒã‚¤ãƒ³ãƒˆãŒç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ãŒã€æ¼¢ï¼ˆã‚ªãƒˆã‚³ï¼‰ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“ã®è¨˜äº‹ã¯10ã®æ–¹æ³•ã ã£ãŸã®ã§ã‚ã¨6ã¤è¶³ã‚Šãªã„ã€‚ã‚ªãƒˆã‚³ã¯æ•°ã§å‹è² ï¼ï¼ã¨ã„ã†ã‚ã‘ã§ä»Šæ—¥ã¯ãƒã‚¿ã‚’æŒ¯ã‚Šçµžã£ã¦ã•ã‚‰ã«7ã¤ã®MySQLé«˜é€ŸåŒ–ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ 1. ã‚¤ãƒ³ãƒ†ãƒ«ã‚³ãƒ³ãƒ‘ã‚¤ãƒ©
xorphitus 2010/03/18
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
1