[B! tuning] penaltyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

penalty id:penalty

tuningã«é–¢ã™ã‚‹penaltyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

ãƒ¢ãƒã‚¤ãƒ«ã‚¦ã‚§ãƒ–ç’°å¢ƒã®HTTPSã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° Â« NAVER Engineers' Blog
ã“ã‚“ã«ã¡ã¯æ¤œç´¢ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºï¼”ãƒãƒ¼ãƒ ã®å´”ç‰ç§€ã¨ç”³ã—ã¾ã™ã€‚ ã‚¤ãƒ³ãƒ•ãƒ©ã‚„ã‚·ã‚¹ãƒ†ãƒ ã¨ã®é€£æºã‚„çµ±è¨ˆã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚’æ‹…å½“ã—ã¦ãŠã‚Šã¾ã™ã€‚ ãƒ¢ãƒã‚¤ãƒ«ã®ã‚¦ã‚§ãƒ–ç’°å¢ƒã¯PCã®ã‚¦ã‚§ãƒ–ä½¿ç”¨ç’°å¢ƒã¨ã¯è‰²ã€…ãªé•ã„ãŒæœ‰ã‚Šã¾ã™ã€‚ ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã®é€Ÿåº¦ã ã‘ã§ã¯ãªããƒãƒƒãƒ†ãƒªãƒ¼ã®åŠ¹çŽ‡ã‚’è€ƒãˆãŸä»•çµ„ã¿ãªã©ã€PCã«æ¯”ã¹ãƒªã‚½ãƒ¼ã‚¹ãŒååˆ†ã§ã¯ãªã„ãŸã‚ãƒ¢ãƒã‚¤ãƒ«ãƒ–ãƒ©ã‚¦ã‚¶ã®å‹•ä½œãŒç•°ãªã£ã¦ã„ã‚‹ã“ã¨ã‚‚æœ‰ã‚Šã¾ã™ã€‚ ä»Šå›žã¯ãƒ¢ãƒã‚¤ãƒ«ã®ã‚¦ã‚§ãƒ–Applicationã«ãŠã‘ã‚‹SSLé–¢ä¿‚ã®æ€§èƒ½ã«é–¢ã™ã‚‹å·¥å¤«ã®å†…å®¹ã‚’Q&Aå½¢å¼ã§è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚ Q. ä½•ãŒå•é¡Œã§ã—ãŸã‹ï¼Ÿ A. ãƒ¢ãƒã‚¤ãƒ«ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ(iPhone, Android)ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®HTTPãƒªã‚¯ã‚¨ã‚¹ãƒˆã®å¿œç”æ™‚é–“ã«é…å»¶ã®å•é¡ŒãŒæœ‰ã‚Šã¾ã™ã€‚ æœ€åˆã¯web access logã‹ã‚‰ã®slow response(ï¼‘ç§’ä»¥ä¸Š)ã®HTTPãƒªã‚¯ã‚¨ã‚¹ãƒˆãŒçµæ§‹ã‚ã‚Šã¾ã—ãŸã€‚ ãã®HTTPãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’protoc
penalty 2012/11/22
sslãŒé…ã„ã¨ã„ã†è©±ã—

server

tuning
ãƒªãƒ³ã‚¯
#isucon ã§ã¯ã©ã‚“ãªã“ã¨ã‚’è€ƒãˆãªãŒã‚‰ä½œæ¥ã—ã¦ã„ãŸã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
å‰ã®ã‚¨ãƒ³ãƒˆãƒª #isucon ã§å„ªå‹ã—ã¦ãã¾ã—ãŸ ã¯å½“æ—¥å¤œã«é…”ã£æ‰•ã£ãŸé ã§å‹¢ã„ã§æ›¸ãä¸Šã’ãŸã®ã§ã€å°‘ã—å†·é™ã«æŒ¯ã‚Šè¿”ã£ã¦ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ æœ€åˆã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ç™ºè¦‹ DB ãŒ CPU 4ã‚³ã‚¢ã‚’ãƒ•ãƒ«ã«ä½¿ã£ã¦å›žã£ã¦ã„ã‚‹ã®ã§ã™ãã« Query ãŒé‡ã„ã®ã¯åˆ†ã‹ã£ãŸ é‡ã„ã‚¯ã‚¨ãƒªã¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã™ã‚Œã°ã€ã¨ã„ã†ç™ºæƒ³ã¯è‡ªç„¶ (å®Ÿéš› MySQL ã®ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã ã‘ã§ã‚¹ã‚³ã‚¢ã¯ 1.5å€ç¨‹åº¦ä¸ŠãŒã‚‹)ã€ã¨ã¯ã„ãˆ ã“ã®ã‚¯ã‚¨ãƒªã¯å®Ÿè¡Œã« 300ã€œ400 ms ç¨‹åº¦ã‹ã‹ã‚‹ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¦ä»¶ä¸Šã€æ¯Žç§’æ›´æ–°ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ 1ç§’ã”ã¨ã«æ›´æ–°ã« 0.3ã€œ0.4ç§’ã‹ã‹ã‚‹å‡¦ç†ã‚’ã™ã‚‹ã®ã¯æ‚ªæ‰‹ã ã‚ã† cache ãŒæ¶ˆãˆã¦ã‹ã‚‰ç”Ÿæˆã€ã¨ã™ã‚‹ã¨ç”Ÿæˆå‡¦ç†ãŒè¤‡æ•°åŒæ™‚ã«èµ°ã£ã¦ç„¡é§„ãŒå¤§ãã„ (å®Ÿéš›ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ä¸ã® slow query ã‚’è¦‹ã‚‹ã¨ 600ã€œ700 ms ç¨‹åº¦ã®æ™‚é–“ãŒæŽ›ã‹ã£ã¦ã„ãŸ) ã¨ã„ã†ã“ã¨ã§ã€DB ã®ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹æˆã‚’å¤‰æ›´ã—ã¦é«˜é€ŸåŒ–ã§ããªã„ã‹ã€
penalty 2011/08/30
isucon

tuning
ãƒªãƒ³ã‚¯
isuconãŠéŠã³ãƒãƒ¼ãƒ ï¼ˆäº‹å‰ç¤¾å†…Î²çµ„ï¼‰ã®è¨å®šã‚ã‚Œã“ã‚Œ - hideden.hatenablog.com
ISUCONã«è¡Œã£ã¦ãã¾ã—ãŸã€‚ç¤¾å†…ã§ã®äº‹å‰Î²ãƒ†ã‚¹ãƒˆã«å‚åŠ ã—ã¦å•é¡Œã‚’çŸ¥ã£ã¦ã„ãŸã®ã§å‡ºå ´ã¯ã›ãšã€‚ç¤¾å†…Î²å‚åŠ ã‚’æŒã¡ã‹ã‘ã‚‰ã‚ŒãŸã¨ãã¯ã€æ£ç›´ã€Œã‚ã‚“ã©ãã›ãƒ¼ãªï½—ã€ãŒç´ ç›´ãªæ„Ÿæƒ³ã ã£ãŸã‚“ã§ã™ãŒã€å®Ÿéš›ã«ã‚„ã£ã¦ã¿ã‚‹ã¨ã‚¹ã‚³ã‚¢ãŒãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«ã‚ã‹ã‚‹ï¼†ã¡ã‚‡ã£ã¨ãšã¤è‡ªåˆ†ã®ã‚¹ã‚³ã‚¢ãŒä¸ŠãŒã£ã¦ã„ãã£ã¦ã®ã¯æ¥½ã—ãã¦ã€ã‚ã‚Šã¨æœ¬æ°—ã§ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ã•ã¦ã€æœ¬æˆ¦ã§ã‚‚14æ™‚é ƒã‹ã‚‰ãŠéŠã³ç”¨ã¨ã—ã¦ã‚µãƒ¼ãƒãƒ¼ä¸€å¼ãŒè§£æ”¾ã•ã‚ŒãŸã®ã§ã€å¤§äººã’ã‚‚ç„¡ããã“ã§112500req/minã‚’ãŸãŸãå‡ºã—ã¦å‚åŠ è€…ã®ã‚„ã‚‹æ°—ã‚’å‰Šã„ã ï¼ˆãƒ»ãƒ»ã¨æ‡‡è¦ªä¼šã§è¨€ã‚ã‚Œã¾ã—ãŸã€‚è‰²ã€…ã™ã„ã¾ã›ã‚“ï¼ï¼‰æ§‹æˆã«ã¤ã„ã¦ã€‚ reverse proxy nginx(1.0.5) ngx_http_memcached + ngx_http_ssi_filter + ngx_http_scgi + ngx_http_upstream_keepalive(3rd party plugin
penalty 2011/08/29
tuning

server

isucon
ãƒªãƒ³ã‚¯
Webã‚µã‚¤ãƒˆã‚’â€œé€Ÿãâ€è¡¨ç¤ºã•ã›ã‚‹7ã¤ã®è¨ˆæ¸¬ãƒã‚¤ãƒ³ãƒˆï¼ˆ1/2ï¼‰ - ï¼ IT
æ ªå¼ä¼šç¤¾ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ ãƒžãƒ¼ã‚¯ã‚¢ãƒƒãƒ—ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ æµœ ä¿Šå¤ªæœ— 2009/3/24 Firefoxã‚„YSlowã‚’ä½¿ã£ã¦Webã‚µã‚¤ãƒˆã®å•é¡Œç‚¹ã‚’æŽ¢ã‚‹ã«ã¯ï¼Ÿ ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ãƒ–ãƒã‚°ã‚’é€Ÿãã—ãŸè‘—è€…ãŒ7ã¤ã®ãƒã‚¤ãƒ³ãƒˆã‚’ä¼æŽˆã—ã¾ã™ï¼ˆç·¨é›†éƒ¨ï¼‰ Webã‚µã‚¤ãƒˆã¯â€œè¦‹ãŸç›®â€ãŒé‡è¦ãªã®ã¯å½“ãŸã‚Šå‰ã ãŒâ€¦â€¦ çš†ã•ã‚“ã¯Webã‚µã‚¤ãƒˆã‚’ä½œã‚‹ã¨ãã«ã€ã©ã®ã‚ˆã†ãªã“ã¨ã‚’æ„è˜ã—ã¦ã„ã¾ã™ã‹ï¼Ÿ ãƒ‡ã‚¶ã‚¤ãƒŠã‚„ä¸»ã«HTMLã®ã‚³ãƒ¼ãƒ€ãƒ¼ï¼ãƒžãƒ¼ã‚¯ã‚¢ãƒƒãƒ—ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨å‘¼ã°ã‚Œã‚‹è·ç¨®ã«å°±ã„ã¦ã„ã‚‹äººã¯ã€ã‚„ã¯ã‚Šâ€œè¦‹ãŸç›®â€ã‚’å¼·ãæ„è˜ã—ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ä¾‹ãˆã°ã€è¤‡æ•°ã®Webãƒ–ãƒ©ã‚¦ã‚¶ã§åŒã˜ã‹è¿‘ã„è¡¨ç¤ºã«ãªã‚‹ã‚ˆã†ã«ã¨ã‹ã€ãƒªãƒªãƒ¼ã‚¹å¾Œã®æ›´æ–°æ¥å‹™ã«ã‚ˆã£ã¦è¡¨ç¤ºå´©ã‚ŒãŒèµ·ããªã„ã‚ˆã†ã«ã€ãªã©ã§ã™ã€‚ã‚‚ã¡ã‚ã‚“ãã‚Œã¯è·ç¨®ã®é©æ€§ã¨ã—ã¦æ£ã—ã„ã‚‚ã®ã§ã™ãŒã€å®Ÿã¯ã»ã‹ã«ã‚‚æ„è˜ã—ãŸæ–¹ãŒã‚ˆã„é‡è¦ãªè¦ç´ ãŒã‚ã‚‹ã®ã§ã™ã€‚ è‰¯ã„å°è±¡ã‚’ä¸Žãˆã‚‹ã«ã¯ã€â€œé€Ÿåº¦â€ã‚‚é‡è¦ Webã‚µã‚¤ãƒˆã‚’è¦‹ãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã€è‰¯ã„å°è±¡ã‚’å—ã‘ã‚‹ã®ã‹
penalty 2009/12/08
html

firefox

tuning
ãƒªãƒ³ã‚¯
ã‚¬ãƒ™ãƒ¼ã‚¸ã‚³ãƒ¬ã‚¯ã‚¿ã®ä»•çµ„ã¿ã‚’ç†è§£ã™ã‚‹
GCã‚’é©åˆ‡ã«è¡Œã‚ã›ã‚‹ãŸã‚ã®ãƒ’ãƒ¼ãƒ—ã‚µã‚¤ã‚ºã®è¨å®š JVMã«GCã‚’é©åˆ‡ã«è¡Œã‚ã›ã‚‹ã«ã¯ãƒ’ãƒ¼ãƒ—ã‚µã‚¤ã‚ºã‚’é©åˆ‡ã«è¨å®šï¼ˆNewé ˜åŸŸã‚µã‚¤ã‚ºã€Oldé ˜åŸŸã‚µã‚¤ã‚ºã€é ˜åŸŸã‚µã‚¤ã‚ºã®ãƒãƒ©ãƒ³ã‚¹ãªã©ï¼‰ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚å½“ç„¶ã€é©åˆ‡ãªãƒ’ãƒ¼ãƒ—ã‚µã‚¤ã‚ºã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ä¾å˜ã—ã¾ã™ã€‚ä¸€èˆ¬ã«ãƒ’ãƒ¼ãƒ—ã‚µã‚¤ã‚ºãŒå°ã•ã„ã¨GCãŒé »ç™ºã—ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒä½Žä¸‹ã—ã¾ã™ã€‚ã•ã‚‰ã«ã€ãƒ’ãƒ¼ãƒ—ã‚µã‚¤ã‚ºãŒå¿…è¦é‡ã‚’ä¸‹å›žã‚‹å ´åˆã¯OutOfMemoryErrorãŒç™ºç”Ÿã—ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒåœæ¢ã—ã¦ã—ã¾ã„ã¾ã™ã€‚ä¸€æ–¹ã€ãƒ’ãƒ¼ãƒ—ã‚µã‚¤ã‚ºãŒå¤§ãã„ã¨ã€GCã®èµ·å‹•å›žæ•°ã¯æ¸›ã‚Šã¾ã™ãŒã€GC1å›žå½“ãŸã‚Šã®å‡¦ç†æ™‚é–“ã€ã™ãªã‚ã¡ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³åœæ¢çŠ¶æ…‹ãŒé•·ããªã‚Šã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¿œç”æ™‚é–“ã«å•é¡ŒãŒå‡ºã‚‹å ´åˆã‚‚ã‚ã‚Šã¾ã™ã€‚ã‚·ã‚¹ãƒ†ãƒ ã®ç‰©ç†ãƒ¡ãƒ¢ãƒªã®ãƒ•ãƒªãƒ¼é ˜åŸŸãŒä¸è¶³ã™ã‚‹ã¾ã§ãƒ’ãƒ¼ãƒ—ã‚µã‚¤ã‚ºã‚’å¤§ããã™ã‚‹ã¨ã€ç‰©ç†ãƒ¡ãƒ¢ãƒªã‹ã‚‰ã‚¹ãƒ¯ãƒƒãƒ—é ˜åŸŸã¸ã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ãŒèµ·ã“ã£ã¦ã—ã¾ã„ã€ã‹ãªã‚Šã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒåŠ£åŒ–ã™ã‚‹å¯
penalty 2007/09/02
JVMã®ãƒ¡ãƒ¢ãƒªè¨å®šã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

java

tuning

tips
ãƒªãƒ³ã‚¯
PostgreSQL ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚ - å¾’ç„¶ãªã‚‹ã¾ã¾ã«Blog
PostgreSQLã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ ãã®æ™‚ã«èª¿ã¹ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é …ç›®ã‚’å‚™å¿˜éŒ²ã¨ã—ã¦æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®é•ã„ã‚„ã‚µãƒ¼ãƒã®è¦æ¨¡ãªã©ã«ã‚ˆã£ã¦ã‚‚ åŠ¹æžœã¯å¤‰ã‚ã£ã¦ãã‚‹ã¨æ€ã†ã®ã§ã‚ãã¾ã§å‚è€ƒç¨‹åº¦ã®ã‚‚ã®ã§ã™ãŒã€‚ ãƒ»shared_buffers 7ç³»ã§ã¯8000ã€œ10000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ 8ç³»ã§ã¯150000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ã“ã¨ãŒå¯èƒ½ã€100000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ã“ã‚Œã«å¤šãå‰²ã‚Šå½“ã¦ã‚‹ã‚ˆã‚ŠOSã®ãƒãƒƒãƒ•ã‚¡é ˜åŸŸã¨ã—ã¦ä½¿ã†æ–¹ãŒæ€§èƒ½ãŒå‘ä¸Šã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã‚’å‰²ã‚Šå‡ºã—ã¦è¨å®šã™ã‚‹ã®ãŒãƒ™ã‚¹ãƒˆ ç°¡å˜ã«è¨å®šã™ã‚‹ãªã‚‰æè¼‰ãƒ¡ãƒ¢ãƒªé‡ã®1/4ã€æè¼‰ãƒ¡ãƒ¢ãƒªãŒå¤šã‘ã‚Œã°1/2ãã‚‰ã„ã§ã‚‚å¯ ãƒ»max_connections 7ç³»ã§ã¯256ç¨‹åº¦ã€8ç³»ã§ã¯1000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ãƒ»work_mem(sort_mem) é©åˆ‡ãªã‚µã‚¤ã‚ºã«èª¿æ•´ã™ã‚‹ã€2048ã€œ4096ç¨‹åº¦ ãƒ—ãƒã‚»ã‚¹æ¯Ž
penalty 2007/07/23
database

postgresql

tips

tuning
ãƒªãƒ³ã‚¯
1