[B! performance] nao-tã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nao-t id:nao-t

performanceã«é–¢ã™ã‚‹nao-tã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

PostgreSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã«ã€€ï½žé‡ã„SQLã®è¦‹ã¤ã‘æ–¹ï½ž : ã‚¢ã‚·ã‚¢ãƒ«ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ç‰§é‡Žã§ã™ã€‚ å…ˆæ—¥ã€ã‚ã‚‹ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã§ä½¿ç”¨ã—ã¦ã„ã‚‹PostgreSQLã‚’è¦‹ç›´ã™æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ PostgreSQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ‰‹è»½ã«ä¸Šã’ã‚‹ã«ã¯ã€ ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’å¤‰æ›´ã™ã‚‹ ãƒ»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ–¹ã§é‡ã„SQLã‚’ç™ºè¡Œã—ã¦ã„ã‚‹å ´æ‰€ã‚’è¦‹ã¤ã‘ã¦ã€ãã®éƒ¨åˆ†ã‚’ç›´ã—ã¦ã„ã ãƒ»vaccumã‚’å®Ÿè¡Œã™ã‚‹ ãªã©ã€ã„ãã¤ã‹æ–¹æ³•ãŒè€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ ä»Šå›žã¯ã€PostgreSQLã§å®Ÿè¡Œæ™‚é–“ãŒé•·ã„SQLã‚’è¦‹ã¤ã‘ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ æœ¬é¡Œã«å…¥ã‚‹å‰ã«ã€ã¾ãšã¯ãƒ†ã‚¹ãƒˆç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã£ã¦ãŠãã¾ã™ã€‚ <?php $dbÂ =Â pg_connect('dbname=test'); $sqlÂ =Â " CREATEÂ TABLEÂ artistÂ ( artist_idÂ serialÂ primaryÂ key, nameÂ textÂ notÂ null ) "; pg_query($sql); $sq
nao-t 2013/07/10
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

postgresql

PHP

Webé–‹ç™º

performance

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

database
ãƒªãƒ³ã‚¯
httpã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ãƒã‚§ãƒƒã‚¯ã—ãŸã„ã€œApacheBenchç·¨ã€œ
httpã‚µãƒ¼ãƒã®Apacheã§ã¯ã€ã€ŒApacheBenchã€ã¨å‘¼ã°ã‚Œã‚‹ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ«ãŒä»˜å±žã•ã‚Œã¦ã„ã‚‹ã€‚åŽéŒ²å…ˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã¯æ¬¡ã®é€šã‚Šã ã€‚ ãƒ»ã‚½ãƒ¼ã‚¹ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã‹ã‚‰ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã®å ´åˆ /usr/local/apache/bin/ab ãƒ»RPMãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã®å ´åˆ /usr/sbin/ab å®Ÿè¡Œæ–¹æ³•ã¯æ¬¡ã®é€šã‚Šã§ã‚ã‚‹ã€‚è¡¨ç¤ºçµæžœã‚µãƒ³ãƒ—ãƒ«ã¨å…±ã«ç€ç›®ã—ãŸã„ãƒã‚¤ãƒ³ãƒˆã‚‚æŒ™ã’ã¦ã¿ã‚ˆã†ã€‚ æ¬¡ã®ä¾‹ã¯ã€100ä»¶ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã€10ã®åŒæ™‚æŽ¥ç¶šã§10å›žè¡Œã†ã¨ã„ã†æŒ‡å®šã«ãªã‚‹ï¼ˆä¾‹ãˆã°ã€-n 100000 -c 500ã§ã¯ã€100000å›žã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’500å€‹åŒæ™‚ã«200å›žã¨ã„ã†æ„å‘³ã ï¼‰ã€‚é€šå¸¸ã¯ã“ã®æ–¹æ³•ã§æ•°å€¤ã‚’èª¿æ•´ã™ã‚Œã°ã‚ˆã„ãŒã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒ¼ã‚’GETã§ã¯ãªãPOSTã§é€ä¿¡ã—ãŸã„å ´åˆã«ã¯ã€ã€Œ-nã€ã§ãªãã€Œ-pã€ã¨ã—ã¦ç½®ãæ›ãˆã‚Œã°ã‚ˆã„ã€‚ # ab -n 100 -c 10 http://www.zdnet.co.jp/
nao-t 2012/09/18
apache

performance

ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯

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

performance

Webåˆ¶ä½œ

é–‹ç™º

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

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

performance

apache
ãƒªãƒ³ã‚¯
é–“é•ã„ã ã‚‰ã‘ã®WEBã‚µãƒ¼ãƒ Keep-Alive - æ–°ãƒ»æµ…ãåºƒãã‚’ãƒ¢ãƒƒãƒˆãƒ¼ã« - WEBãƒ—ãƒã‚°ãƒ©ãƒž ãƒ¡ãƒ¢
14:30 | Keep-Alive on / off ã«é–¢ã™ã‚‹æ–‡çŒ®ã®å¤šããŒæ›–æ˜§ã§ã‚ã‚‹ã“ã¨ãŒæ°—ã«ãªã£ã¦ã„ãŸã®ã§ã€ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚Apacheã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‹ã‚‰ã€Keep-Aliveã®èª¬æ˜Žã‚’æ‹å€Ÿã—ã¾ã™ã¨ã€HTTP/1.0 ã® Keep-Alive æ‹¡å¼µã¨ HTTP/1.1 ã®æŒç¶šçš„æŽ¥ç¶šã®æ©Ÿèƒ½ã¯ã€è¤‡æ•°ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆãŒåŒã˜TCPã®æŽ¥ç¶šã§é€ã‚‰ã‚Œã‚‹ã€é•·æ™‚é–“æŒç¶šã™ã‚‹ HTTP ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’æä¾›ã—ã¾ã™ã€‚ã¤ã¾ã‚Šã€Keep-Aliveã¯ã€ã€ŽTCP 3ã‚¦ã‚§ã‚¤ãƒãƒ³ãƒ‰ã‚·ã‚§ã‚¤ã‚¯ã®ç¯€ç´„ã€ã§ã‚ã‚‹ã¨ã„ã†ç‚¹ã‚’ç†è§£ã—ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ãŸã„ã¦ã„ã®æ–‡çŒ®ã¯ã€Žç”»åƒã‚„CSSãŒå¤šã„ã‚µã‚¤ãƒˆã§ã¯ã€æŽ¥ç¶šã‚’ä½¿ã„å›žã™ã“ã¨ã«ã‚ˆã‚Šç„¡é§„é£ã„ã‚’ãªãã™ã€ã¨ã„ã†èª¬æ˜Žã‚’ã—ã¦ã„ã¾ã™ãŒã€ã“ã®æŽ¥ç¶šã‚’ä½¿ã„å›žã™ã¨ã„ã†è¡¨ç¾ã‚‚æ›–æ˜§ãªæ°—ãŒã—ã¾ã™ã€‚ä½•ã¨ãªãåˆ†ã‹ã£ãŸæ°—ã«ãªã£ã¦ã—ã¾ã†äººã‚‚å¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãã‚Œã§ã¯ã€ã¾ãšã¯ä»¥ä¸‹ã®ã‚ˆã†ãªhttpd.confã§ã€Apacheã®å‹•
nao-t 2012/07/14
apache

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

performance

keepalive
ãƒªãƒ³ã‚¯
Apache2 - worker MPM ã®ãƒ—ãƒã‚»ã‚¹ï¼†ã‚¹ãƒ¬ãƒƒãƒ‰æ•°ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
å‰ã‚¨ãƒ³ãƒˆãƒªã€€pound ã¨ apache ã‚’ãƒãƒ©ãƒ³ã‚¹ã‚ˆããƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹å¿…è¦æ€§ã«ã¤ã„ã¦ã€€ã®ç¶šãã§ã™ã€‚Apache2 ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã‚ˆã‚‹é«˜è² è·ï¼ˆå¤§é‡ã‚¢ã‚¯ã‚»ã‚¹ï¼‰å¯¾ç–ã‚’è€ƒãˆã¦ã¿ã¾ã™ã€‚ ã“ã“ã¾ã§ãã¦ã‚„ã£ã¨ã€ãã‚‚ãã‚‚é«˜è² è·æ™‚ã« apache2 ã®ãƒ—ãƒã‚»ã‚¹æ•°ãŒè¶³ã‚Šã¦ã„ãªãã€é™çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã®å¿œç”æ™‚é–“ãŒé…å»¶ã—ã¦ã„ã‚‹ã®ã‹ã‚‚ï¼Ÿã¨ã„ã†ä»®èª¬ã‚’ç«‹ã¦ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚å›³è§£ã™ã‚‹ã¨ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ Apache2 ã¯ã‚‚ã¡ã‚ã‚“ worker MPM ã§å‹•ä½œã•ã›ã¦ã„ã¾ã™ã€‚worker MPM ã£ã¦ãªã‚“ãžï¼Ÿã¨ã„ã†æ–¹ã¯ã€ã“ã®ãƒ–ãƒã‚°ã‚’èªã‚“ã§é ‚ã‘ã¦ã„ã‚‹æ–¹ã«ã¯ã„ã‚‰ã£ã—ã‚ƒã‚‰ãªã„ã‹ã¨æ€ã„ã¾ã™ãŒã€€http://httpd.apache.org/docs/2.0/mod/worker.htmlã€€ã‚ãŸã‚Šã‚’èªã‚€ã¨è‰¯ã„ã§ã—ã‚‡ã†ã€‚ ã“ã®ãƒžãƒ«ãƒãƒ—ãƒã‚»ãƒƒã‚·ãƒ³ã‚°ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« (MPM) ã¯ã€ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ã¨ãƒžãƒ«ãƒãƒ—ãƒã‚»ã‚¹ã®ãƒã‚¤ãƒ–ãƒªãƒƒãƒ‰åž‹ã‚µãƒ¼ãƒã‚’ å®Ÿè£…ã—ã¦
nao-t 2012/06/26
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

apache

performance
ãƒªãƒ³ã‚¯
1