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

at_home id:at_home

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

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

InnoDBã®è¨è¨ˆã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æ„è˜ã—ãŸã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã¨è¤‡åˆãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã®æ¯”è¼ƒ - Y's note
å®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQL ç¬¬2ç‰ˆ ä½œè€…: Baron Schwartz,Peter Zaitsev,Vadim Tkachenko,Jeremy D. Zawodny,Arjen Lentz,Derek J. Balling,ä¼Šè—¤ç›´ä¹Ÿ(ç›£è¨³),ç”°ä¸æ…Žå¸(ç›£è¨³),å‰å·è‹±èˆˆ(ç›£è¨³),æ ªå¼ä¼šç¤¾ã‚¯ã‚¤ãƒ¼ãƒ—å‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: ã‚ªãƒ©ã‚¤ãƒªãƒ¼ã‚¸ãƒ£ãƒ‘ãƒ³ç™ºå£²æ—¥: 2009/12/14ãƒ¡ãƒ‡ã‚£ã‚¢: å¤§åž‹æœ¬è³¼å…¥: 17äºº ã‚¯ãƒªãƒƒã‚¯: 373å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (46ä»¶) ã‚’è¦‹ã‚‹ æ¦‚è¦ ã“ã®è¨˜äº‹ã§ã¯InnoDBã‚’ä½¿ç”¨ã™ã‚‹ä¸Šã§ã®ã‚¯ãƒ©ã‚¹ã‚¿ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æ„è˜ã—ãŸã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã¨è¤‡åˆä¸»ã‚ãƒ¼ã®æ¯”è¼ƒã‚’ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è¦³ç‚¹ã‹ã‚‰è¡Œã„ã¾ã™ã€‚ã‚µãƒã‚²ãƒ¼ãƒˆã‚ãƒ¼ã‹è¤‡åˆã‚ãƒ¼ã®ã©ã¡ã‚‰ã‚’ä½¿ã†ã¹ãã‹ã¯æ§˜ã€…ãªè°è«–ãŒãªã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«ã‚±ãƒ¼ã‚¹ãƒã‚¤ã‚±ãƒ¼ã‚¹ã¨ã„ã£ãŸã¨ã“ã‚ã§è‡ªåˆ†ã¯ç´å¾—ã—ã¦ã„ã¾ã™ã€‚ã“ã“ã§ã¯è‡ªåˆ†ã®å®Ÿç¾ã—ãŸã„ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã¨åˆ©ç”¨ç›®çš„ã‚’æ˜Žç¢ºã«ã—ã¦
at_home 2013/05/23
çµæ§‹èˆˆå‘³æ·±ã„æ¤œè¨¼

InnoDB

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

mysql

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹

tuning

index

tips
ãƒªãƒ³ã‚¯
MySQLã®è¤‡åˆINDEX - æ†‚é¬±ãªãƒ—ãƒã‚°ãƒ©ãƒžã®å½¢è€Œä¸Šå¦
MySQL MySQLã®è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã€‚MySQLã‚’ä½¿ã„ã“ãªã—ã¦ã„ã‚‹äººã«ã¯å¸¸è˜ã®ç¯„ç–‡ã«ã¯ã„ã‚‹çŸ¥è˜ã ã¨æ€ã†ã®ã§ã™ãŒã€ã‹ã¤ã¦ã®ç§ã®ã‚ˆã†ã«ã€çŸ¥ã‚‰ãªã„ã¨ãƒ‰ãƒ„ãƒœã«ã¯ã¾ã‚‹ã®ã§ã€ã“ã“ã«ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ã‚¿ã‚¤ãƒˆãƒ«ã§ã©ã†ã„ã†å†…å®¹ã‹ã€ã‚‚ã—ã‹ã—ãŸã‚‰å¤§ä½“ã€æƒ³åƒãŒã¤ãã‹ãªã¨æ€ã†ã®ã§ã™ãŒã€MySQLã¯1ã¤ã®ã‚¯ã‚¨ãƒªãƒ¼ã§1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã€1ã¤ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã—ã‹æ©Ÿèƒ½ã—ãªã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ˆã†ã™ã‚‹ã«ã€ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€æ™®é€šã«å¤§é‡ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã£ã¦ã‚‚ã‚ã¾ã‚Šæ„å‘³ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ãã“ã§ã€ä»Šå›žã¯ã€æœ€é©ãªè¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã¯ã‚‹ã“ã¨ãŒã§ãã‚‹ã‹è€ƒãˆã¦ã„ã“ã†ã˜ã‚ƒãªã„ã‹ã€ã¨ã„ã†è¶£æ—¨ã§æ›¸ã„ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ã¾ãšã¯åˆ†æžã€‚ãƒ†ã‚¹ãƒˆç’°å¢ƒã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ãªã„SQLã‚’é›†ã‚ã‚‹ã¾ãšã¯ã€/etc/my.cnfã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ä»¥ä¸‹ã®ã‚ˆã†ã«è¨å®šã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã¦ã„ãªã„SQLã‚’ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ã«åãå‡ºã—ã¾ã™ã€‚ slow
at_home 2013/05/21
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹

SQL

tips

mysql

db

database

performance

tuning

index
ãƒªãƒ³ã‚¯
Akamai CDN - Content Delivery Network Solutions | Akamai
Compute Build, release, and scale faster with VMs for every workload
at_home 2012/08/24
ãƒ¢ãƒã‚¤ãƒ«å‘ã‘webã‚µã‚¤ãƒˆã®é€Ÿåº¦è¨ˆæ¸¬ãŒå‡ºæ¥ã‚‹ã€ãŒã€ä»Šæ—¥è½ã¡ã¦ã‚‹ã€‚ã€‚

mobile

performance

tool

free

web

tuning

test

smartphone
ãƒªãƒ³ã‚¯
Tips:PHP APCã®å¤‰æ•°ã‚ãƒ£ãƒƒã‚·ãƒ¥ã§é«˜é€ŸåŒ– #advent201110 - managamiâ€™s diary
PHPã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‘ä¸Šã®ãŸã‚ã«APCã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ä½¿ã†ã“ã¨ã¯ã‚ˆãçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ APCã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’PHPã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ä¸é–“ã‚³ãƒ¼ãƒ‰ã¸ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã•ã‚ŒãŸçµæžœã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã™ã‚‹ä½¿ã„æ–¹ã ã‘ã§æº€è¶³ã•ã‚Œã¦ã„ã‚‹æ–¹ãŒå¤šã„æ°—ãŒã—ã¾ã™ãŒã€PHPãƒ—ãƒã‚°ãƒ©ãƒ ä¸ã§å¤‰æ•°ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥é ˜åŸŸã«å…¥ã‚Œã¦ä½¿ã†ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ APCã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« $ sudo pecl install apc ã“ã‚Œã ã‘ã§PHPã®å®Ÿè¡Œæ™‚ã«ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ä¸é–“ã‚³ãƒ¼ãƒ‰ã¸ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã•ã‚ŒãŸçµæžœã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ãã‚Œã‚‹ã‚ˆã†ãªã‚Šã¾ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã ã‘ã§ã‚‚åŠ¹æžœãŒã§ã¾ã™ãŒã€APCã‚ãƒ£ãƒƒã‚·ãƒ¥ã®æ©Ÿèƒ½ã¨ã—ã¦ã¯å¤‰æ•°ãƒ‡ãƒ¼ã‚¿ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã™ã‚‹é–¢æ•°ç¾¤ãŒæä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ PHPã®ãƒ•ãƒãƒ³ãƒˆãƒ¬ã‚¤ãƒ¤ãƒ¼ã‹ã‚‰DBã‚¢ã‚¯ã‚»ã‚¹ã€ã‚ã‚‹ã„ã¯APIã‚³ãƒ¼ãƒ«ã—ã¦å–å¾—ã—ã¦ããŸãƒ‡ãƒ¼ã‚¿ã‚’ã€ã“ã®APCé–¢æ•°ç¾¤ã‚’ä½¿ã£ã¦ä¿å˜ï¼å–å¾—ã™ã‚Œã°å¤–éƒ¨IOã‚’çœç•¥ã—ã¦é«˜é€Ÿã«å‡¦ç†ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ APCé–¢æ•° http://
at_home 2012/02/20
php

ãƒ‡ãƒ¼ã‚¿

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

Tuning

APC
ãƒªãƒ³ã‚¯
è»½é‡é«˜é€ŸWebã‚µãƒ¼ãƒã®nginxã§é™çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„é…ä¿¡ã¨ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«
nginxã¨ã¯ï¼Ÿ nginxã¯ãƒã‚·ã‚¢ã§é–‹ç™ºã•ã‚Œã¦ã„ã‚‹è»½é‡ã§é«˜é€ŸãªWebã‚µãƒ¼ãƒã§ã™ã€‚ ç¾åœ¨ã‚·ã‚§ã‚¢ã¯ 7% è¿‘ãã‚ã‚‹ã‚ˆã†ã§ã™ã€‚ã‚‚ã¡ã‚ã‚“Apacheã«æ¯”ã¹ã‚Œã°å°‘ãªã„ã§ã™ãŒã€Apache 55%ã€IIS 25%, nginx 7%ã§3ç•ªç›®ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹Webã‚µãƒ¼ãƒã«ãªã‚Šã¾ã™ã€‚ æ˜”ã¯ã€Pound+Lighttpd+Apacheã®çµ„ã¿åˆã‚ã›ã‚’ã‚ˆãä½¿ã£ã¦ã„ã¾ã—ãŸãŒã€ã“ã“æ•°å¹´ã¯nginx+Apacheã¨ã‹ã«ãªã‚Šã¾ã—ãŸã€‚ ä¸»ã«ã€é™çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’nginxãŒå—ã‘æŒã¡ã€PHPãªã©ã®å‹•çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¯Apacheã«æ¸¡ã™å½¢ã«ãªã‚Šã¾ã™ã€‚Railsã‚’ä½¿ã†å ´åˆã¯ã€nginx+Unicornã®çµ„ã¿åˆã‚ã›ãŒå¤šã„ã§ã™ã€‚ ã„ã¾ã•ã‚‰ãªæ„Ÿã˜ã‚‚ã‚ã‚Šã¾ã™ãŒã€ã‚¤ãƒ³ãƒ•ãƒ©å‘¨ã‚Šã®è¦‹ç›´ã—ã‚‚å«ã‚ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ é™çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’nginxã«ä»»ã›ã‚‹ nginx+Apacheã®å ´åˆã®è¨å®šã¯æ¬¡ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ï¼ˆnginxãŒport 80ã€Apac
at_home 2012/02/16
ã“ã‚Œä»¥å‰ä½¿ã£ã¦ãŸã€‚å°Žå…¥æ¤œè¨Žã™ã¹ã—ã€‚

proxy

apache

web

ã‚µãƒ¼ãƒ

nginx

webã‚µãƒ¼ãƒ

tuning
ãƒªãƒ³ã‚¯
1