[B! performance] yuhei_kagayaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yuhei_kagaya id:yuhei_kagaya

performanceã«é–¢ã™ã‚‹yuhei_kagayaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (22)

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

Rails ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¤ã„ã¦ RubyKaigi 2013 ã§ç™ºè¡¨ã—ã¾ã—ãŸ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã‚¤ãƒ³ãƒ•ãƒ©ã‚¹ãƒˆãƒ©ã‚¯ãƒãƒ£ãƒ¼éƒ¨ã®æˆç”°ã§ã™ã€‚ å…ˆæ—¥é–‹å‚¬ã•ã‚ŒãŸ RubyKaigi 2013 ã§ã€ "High Performance Rails" ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã®ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚ ã‚¹ãƒ©ã‚¤ãƒ‰ã¨å‹•ç”» ç™ºè¡¨ã®æ§˜åã¯ ustream ã®éŒ²ç”»ã‚’ã”è¦§ãã ã•ã„ã€‚ [ustream id=33559705 hwaccel=1 version=3 width=480 height=302] ã‚¹ãƒ©ã‚¤ãƒ‰ã¯ä»¥ä¸‹ã«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ã‚ã‚Šã¾ã™ã€‚ High Performance Rails (long edition) // Speaker Deck ãªãŠã€ç™ºè¡¨æ™‚é–“ã®éƒ½åˆä¸Šã€å½“æ—¥ã¯ã“ã“ã‹ã‚‰ 40 æžšã»ã©ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’å‰Šé™¤ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ç™ºè¡¨ã«ä½¿ã£ãŸçŸã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã¯ã“ã¡ã‚‰ã§ã™ã€‚ ç™ºè¡¨ã®æ¦‚è¦ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã¯ 2008 å¹´ã‹ã‚‰ Ruby on Rails ã‚’æŽ¡ç”¨ã—ã€ãšã£ã¨ä½¿ã„ç¶šã‘ã¦ãã¾ã—ãŸã€‚ã‚µãƒ¼ãƒ“ã‚¹ãŒæˆé•·ã™ã‚‹ã¨ã¨ã‚‚ã«
yuhei_kagaya 2013/06/07
rails

performance
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
yuhei_kagaya 2012/09/11
mysql

performance
ãƒªãƒ³ã‚¯
IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
yuhei_kagaya 2012/07/11
performance
ãƒªãƒ³ã‚¯
ç°¡å˜ï¼ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ç”»åƒå¤‰æ›ã‚’Nginxã ã‘ã§è¡Œã†æ–¹æ³•
å…ˆé€±é‡‘æ›œæ—¥ï¼ˆ12/2ï¼‰ã«ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã‚¤ãƒ³ãƒ•ãƒ©å‹‰å¼·ä¼šã«å‚åŠ ã—ã¾ã—ã¦ã€ãã“ã§åŒç¤¾ã®æˆç”°ã•ã‚“ã‹ã‚‰ã€Œä»Šæ—¥ã‹ã‚‰ã§ãã‚‹Apacheãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«é–‹ç™ºã¨é‹ç”¨ã€ã¨ã„ã†ç™ºè¡¨ãŒã‚ã‚Šã¾ã—ãŸã€‚ ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ç”»åƒå¤‰æ›ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ã€ŒTOFUã€ã‚’é–‹ç™ºã™ã‚‹ã«è‡³ã£ãŸçµŒç·¯ã¨ã€Apacheãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«é–‹ç™ºã«ã¤ã„ã¦ã®ãŠè©±ã§ã—ãŸã€‚ TOFUã¯ã€S3ã«ç½®ã‹ã‚ŒãŸãƒžã‚¹ã‚¿ãƒ¼ã¨ãªã‚‹ç”»åƒãƒ•ã‚¡ã‚¤ãƒ«ã‚’å–å¾—ã—ã€ä¸Žãˆã‚‰ã‚ŒãŸãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã§ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ï¼ˆã‚ªãƒ³ã‚¶ãƒ•ãƒ©ã‚¤ï¼‰ã«ãƒªã‚µã‚¤ã‚ºãƒ»ãƒˆãƒªãƒŸãƒ³ã‚°ã‚’è¡Œã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ï¼ˆmod_tofuï¼‰ã§ã™ã€‚ æ–™ç†ã‚’æ¥½ã—ãã™ã‚‹ç”»åƒé…ä¿¡ã‚·ã‚¹ãƒ†ãƒ å®Ÿéš›ã¯ã€ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«ã‚ˆã‚‹ç”»åƒå–å¾—ãƒ»å¤‰æ›ã‚’ãƒ™ãƒ¼ã‚¹ã«ã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚„é…ä¿¡ã¾ã§ã‚‚å«ã‚ãŸä¸€é€£ã®ç”»åƒé…ä¿¡ã‚·ã‚¹ãƒ†ãƒ ã¨è¨€ãˆãã†ã§ã™ã€‚ ã“ã®ä»•çµ„ã¿ã‚’Nginxã‚’ä½¿ã£ã¦å®Ÿè£…ã§ããªã„ã‹ã¨è€ƒãˆã¦ã€ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ å¤‰æ›ã®ä»•çµ„ã¿ã‚’Nginxã ã‘ã§å®Ÿç¾ã™ã‚‹æ–¹æ³•ã‚’å®Ÿé¨“ã—ã¦ã¿ã¾ã—ãŸã€‚ æº–å‚™ã™ã‚‹ã‚‚ã® HttpImageFilterModul
yuhei_kagaya 2012/07/11
nginx

performance
ãƒªãƒ³ã‚¯
ãƒã‚°ã‹ã‚‰ã¯è¦‹ãˆã¦ã“ãªã„é«˜è² è·ã‚µã‚¤ãƒˆã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
ã¡ã‚‡ã†ã©ï¼‘å¹´å‰ã«ã€Œé«˜è² è·ã‚µã‚¤ãƒˆã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’è¦‹ã¤ã‘ã‚‹ã«ã¯ã€ã¨ã„ã†è¨˜äº‹ã‚’æŽ²è¼‰ã—ã¦ã„ã¾ã™ãŒã€ã“ã®æ‰‹ã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã£ã¦çµæ§‹å¤§å¤‰ã§æ‚©ã¾ã—ã„ã§ã™ã‚ˆãã€‚ã¯ã˜ã‚ã¾ã—ã¦ã€æ–°å…¥ã‚Šã®@pandax381ã§ã™ã€‚ ãƒã‚°ã‹ã‚‰ã¯è¦‹ãˆã¦ã“ãªã„ã‚‚ã® ã€Œã‚µã‚¤ãƒˆã®å¿œç”ãŒé…ã„ã€ã¨ã„ã†å•é¡ŒãŒç™ºç”Ÿã—ãŸå ´åˆã€ãã®åŽŸå› ã¯ã©ã“ã«ã‚ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å‡¦ç†ã«æ™‚é–“ãŒæŽ›ã‹ã£ã¦ã„ã‚‹ DBã‚µãƒ¼ãƒã«æŠ•ã’ãŸã‚¯ã‚¨ãƒªãƒ¼ã®å¿œç”ãŒé…ã„ ã‚µãƒ¼ãƒã®å‡¦ç†èƒ½åŠ›ã‚’è¶…ãˆã¦ã„ã‚‹ ãªã©ãªã©ã€ã„ãã¤ã‚‚ã®å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚é€šå¸¸ã€ä¸Šã«æŒ™ã’ã¦ã„ã‚‹ã‚ˆã†ãªå•é¡Œã¯ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ã‚µãƒ¼ãƒã®ãƒã‚°ã‚’èª¿æŸ»ã™ã‚‹ã“ã¨ã§ã€åŽŸå› ã‚’çªãæ¢ã‚ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ä¸€æ–¹ã§ã€ã“ã†ã„ã£ãŸãƒã‚°ã®èª¿æŸ»ã ã‘ã§ã¯ã€ãã®åŽŸå› ã«ãŸã©ã‚Šç€ãã“ã¨ãŒã§ããªã‹ã£ãŸã‚Šã€ç›¸å½“ãªè‹¦åŠ´ãŒä¼´ã†ã‚±ãƒ¼ã‚¹ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã‚ã‚‹ã‚µã‚¤ãƒˆã®ã‚ã‚‹æ—¥ã®å‡ºæ¥äº‹ ã¤ã„å…ˆæ—¥ã®ã“ã¨ã§ã™ãŒã€KLabã®é‹å–¶ã—ã¦ã„ã‚‹æŸã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã«ã¦ã€ã‚µ
yuhei_kagaya 2012/07/07
performance

network
ãƒªãƒ³ã‚¯
TwitterãŒãƒšãƒ¼ã‚¸è¡¨ç¤ºæ™‚é–“ã‚’5åˆ†ã®1ã«é«˜é€ŸåŒ–ã€‚ã©ã®ã‚ˆã†ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ä½¿ã£ãŸã®ã‹ï¼Ÿ
TwitterãŒãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’è¦‹ç›´ã—ã€Webãƒšãƒ¼ã‚¸ã®èªã¿è¾¼ã¿é€Ÿåº¦ã‚’æ”¹å–„ã—ãŸã“ã¨ã‚’ãƒ–ãƒã‚°ã§æ˜Žã‚‰ã‹ã«ã—ã¦ã„ã¾ã™ã€‚ æ–°ã—ã„ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã§ã¯ã€ã“ã‚Œã¾ã§Webãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã§JavaScriptã®å‡¦ç†ã«ã‚ˆã£ã¦è¡Œã£ã¦ããŸWebãƒšãƒ¼ã‚¸ã®ãƒ¬ãƒ³ãƒ€ãƒªãƒ³ã‚°ã‚’è¦‹ç›´ã—ã€ã‚µãƒ¼ãƒå´ã§ãƒ¬ãƒ³ãƒ€ãƒªãƒ³ã‚°æ¸ˆã¿ã®HTMLãƒšãƒ¼ã‚¸ã‚’é€ä¿¡ã—è¡¨ç¤ºã™ã‚‹ã“ã¨ã«ã—ã¦ã„ã¾ã™ã€‚ã“ã‚Œã«ã‚ˆã£ã¦Webãƒšãƒ¼ã‚¸ã®èªã¿è¾¼ã¿ã‹ã‚‰æœ€åˆã®ãƒ„ã‚¤ãƒ¼ãƒˆã®è¡¨ç¤ºã¾ã§ã®æ™‚é–“ãŒå¤§å¹…ã«çŸç¸®ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ When we shipped #NewTwitter in September 2010, we built it around a web application architecture that pushed all of the UI rendering and logic to JavaScript running on our usersâ€™
yuhei_kagaya 2012/06/01
performance
ãƒªãƒ³ã‚¯
è‰²ã€…ãªPHPãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ¯”è¼ƒ - cakephperã®æ—¥è¨˜(CakePHP, Laravel, PHP)
PHPãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®é€Ÿåº¦æ¯”è¼ƒã§ã¯ã€HelloWorldã‚’è¡¨ç¤ºã™ã‚‹ã®ã¿ã®å˜ç´”ãªã‚¢ãƒ—ãƒªã‚’ç”¨ã„ãŸè¨ˆæ¸¬ã‚’å…ƒã«æ¯”è¼ƒè¡¨ãŒä½œã‚‰ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ç‰¹ã«å¾Œç™ºã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã¯åˆ†ã‹ã‚Šã‚„ã™ã„ç‰¹å¾´ä»˜ã‘ã¨ã—ã¦é€Ÿåº¦ã‚’ã‚¢ãƒ”ãƒ¼ãƒ«ã™ã‚‹å‚¾å‘ã«ã‚ã‚‹ãŸã‚ã€ãã®æ¯”è¼ƒè¡¨ã‚’å…ƒã« Nå€é€Ÿã„ã¨ã„ã†ã‚¢ãƒ”ãƒ¼ãƒ«ã‚’ã—ã¦ã„ã¾ã™ã€‚ PHPãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’ä½¿ã†ã¨ã„ã†ã“ã¨ã¯ã€DBã¾ã§çµ¡ã‚ãŸWebã‚¢ãƒ—ãƒªã‚’ä½œã‚‹ã“ã¨ãŒã»ã¨ã‚“ã©ãªãŸã‚ã€HelloWorldã‚¢ãƒ—ãƒªã®æ¯”è¼ƒã‚ˆã‚Šã¯ã€DBã‹ã‚‰ãƒ¬ã‚³ãƒ¼ãƒ‰å–å¾—ã—ã¦è¡¨ç¤ºã™ã‚‹ã¾ã§ã®å‡¦ç†é€Ÿåº¦ã‚’æ¯”è¼ƒã—ãŸã»ã†ãŒã‚ˆã‚Šç¾å®Ÿã«è¿‘ã„æŒ‡æ¨™ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ç‰¹ã«CakePHP1ç³»ã§ã¯DBã®ãƒ‡ãƒ¼ã‚¿å–å¾—ã‚‚ç‹¬è‡ªãƒ‰ãƒ©ã‚¤ãƒã«ãªã£ã¦ã„ã¾ã™ã—ã€ãƒ¢ãƒ‡ãƒ«ã®å‡¦ç†ã‚‚é‡ã„ã®ã§ãã“ã¾ã§å«ã‚ã¦ä»–ã¨æ¯”è¼ƒã—ãŸã»ã†ãŒè‰¯ã„ã¨æ€ã£ã¦ã¾ã™ã€‚ ä»Šå›žã¯DBã‹ã‚‰1ãƒ¬ã‚³ãƒ¼ãƒ‰å–å¾—ã—ã¦è¡¨ç¤ºã™ã‚‹ã¨ã„ã†ç°¡å˜ãªã‚¢ãƒ—ãƒªã§å„ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®é€Ÿåº¦ã‚’è©•ä¾¡ã—ã¾ã—ãŸã€‚ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã«å‚™ã‚ã£ã¦ã„ã‚‹Viewã‚ãƒ£ãƒƒã‚·ãƒ¥
yuhei_kagaya 2012/02/21
cakephp

codeigniter

performance
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®æ´å²
Convert to study guideBETATransf orm any presentation into a summarized study guide, highlighting the most important points and key insights. Convert
yuhei_kagaya 2012/02/20
performance

è² è·åˆ†æ•£
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜
â– ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹(ç´¢å¼•)ã¨ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ é«˜é€Ÿã«å–ã‚Šå‡ºã™ç‚ºã®ä»•çµ„ã¿ã‚’æ„å‘³ã—ã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é©åˆ‡ã«ä½¿ç”¨ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦SQLæ–‡ã®å¿œç”æ™‚é–“ãŒåŠ‡çš„ã«æ”¹å–„ ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¯B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¯ã˜ã‚ã€ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€ é–¢æ•°ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãªã©ã®ç¨®é¡žãŒã‚ã‚Šã¾ã™ãŒã€ã“ã“ã§ã¯æœ€ã‚‚ä¸€èˆ¬çš„ã«ä½¿ã‚ã‚Œã€ã‹ã¤ ã»ã¨ã‚“ã©ã®DBMSã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ â€» CREATE INDEXæ–‡ã§ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’æŒ‡å®šã—ãªã„å ´åˆã¯é€šå¸¸B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒ ä½œæˆã•ã‚Œã¾ã™ã€‚ â– B-Treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ã—ãã¿ B-Tree(Balanced Tree)ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æ¬¡ã®ã‚ˆã†ãªãƒ„ãƒªãƒ¼çŠ¶ã®æ§‹é€ ã«ãªã£ã¦ã„ã¾ã™ã€‚ ãƒ„ãƒªãƒ¼ã®å…ˆé ã¯ãƒ˜ãƒƒãƒ€ãƒ–ãƒãƒƒã‚¯ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã™ã€‚ãƒ˜ãƒƒãƒ€ãƒ–ãƒãƒƒã‚¯ã§ã¯ã€ã‚ãƒ¼å€¤ã® ç¯„å›²
yuhei_kagaya 2012/02/14
sql

index

performance
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ - ä¹…ä¿æ¸…éš†ã®ãƒ–ãƒã‚°
ä»•äº‹ã§MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ã„ã¦ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ã¦ã„ãªã„ã“ã¨ãŒå¤šã‹ã£ãŸã®ã§èª¿ã¹ãŸã“ã¨ã‚’ãƒ¡ãƒ¢ã€‚åŸºæœ¬çš„ãªã¨ã“ã‚ã‹ã‚‰å¦ç¿’ã—ãªãŠã—ãŸã€‚ MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã€ã‚«ãƒ©ãƒ ãŒç‰¹å®šã®å€¤ã‚’ã‚‚ã¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã®è¿…é€Ÿãªæ¤œç´¢ã«ä½¿ç”¨ã•ã‚Œã‚‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã™ã‚Œã°ã€æ•°ç™¾ã¨ã‹æ•°å„„ã‚‚ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå…¥ã£ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ã€ä¸€çµ„ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿…é€Ÿã«è¦‹ã¤ã‘ã¦å–ã‚Šå‡ºã™ã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ã€‚ ã—ã‹ã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é€Ÿåº¦ã‚’æ”¹å–„ã™ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ãŒã€æŒ¿å…¥ã®é‚ªé”ã«ãªã£ã¦é…ããªã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é©åˆ‡ã«ä½¿ã†ãŸã‚ã«ã€ã¾ãšã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºæœ¬æ¦‚å¿µã‚’ãŠã•ãˆã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ¦‚å¿µ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä»•çµ„ã¿ã‚’ç†è§£ã™ã‚‹ã«ã¯ã€ã¾ãšMySQLãŒã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªã«å¿œç”ã™ã‚‹ã‹ã‚’çŸ¥ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ä¾‹ãˆã°ã€ SELECT * FROM phone_book WHERE last_name = 'Hoge'
yuhei_kagaya 2012/02/14
mysql

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

performance

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

performance

etag
ãƒªãƒ³ã‚¯
ETagã‚’ã©ã†ç”Ÿæˆã™ã‚‹ã‹ - å²©æœ¬éš†å²ã®æ—¥è¨˜å¸³ï¼ˆã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ï¼‰
ETagã¨ã¯ä½•ã‹ ETagã¯HTTPãƒ¬ã‚¹ãƒãƒ³ã‚¹ãƒ˜ãƒƒãƒ€ã®ã²ã¨ã¤ã§ã€RFC 2616ã®14.19ï¼ˆæ—¥æœ¬èªžè¨³ï¼‰ã§è¦å®šã•ã‚Œã¦ã„ã¾ã™ã€‚If-None-Matchãƒªã‚¯ã‚¨ã‚¹ãƒˆãƒ˜ãƒƒãƒ€ã‚’ä½¿ã£ãŸæ¡ä»¶ä»˜ãGETã§ã®è»¢é€é‡è»½æ¸›ã‚„ã€If-Matchã‚’ä½¿ã£ãŸæ¡ä»¶ä»˜ãPUTã§ã®ç«¶åˆæ¤œå‡ºãªã©ã«ä½¿ã‚ã‚Œã‚‹å€¤ã§ã™ã€‚ å¼·ã„ETagã€å¼±ã„ETag ETagï¼ˆã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚¿ã‚°ï¼‰ã«ã¯å¼·å¼±ãŒã‚ã‚Šã¾ã™ã€‚ç°¡å˜ã«ã„ãˆã°ã€HTMLå†…ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚«ã‚¦ãƒ³ã‚¿ãŒ1ä¸ŠãŒã£ãŸã ã‘ã§å¤‰ã‚ã‚‹ã®ãŒå¼·ã„ETagã€å¤‰ã‚ã‚‰ãªã„ã®ãŒå¼±ã„ETagã§ã™ã€‚å¼±ã„ETagã¯ã€ãƒªã‚½ãƒ¼ã‚¹ã®æ„å‘³ãŒå¤‰ã‚ã‚‰ãªã‘ã‚Œã°å¤‰ã‚ã‚Šã¾ã›ã‚“ã€‚ åŒ13.3.4ã§ã¯ã€ŒHTTP/1.1 ã‚ªãƒªã‚¸ãƒ³ã‚µãƒ¼ãƒã«ã¨ã£ã¦ã‚ˆã‚Šæœ›ã¾ã‚Œã‚‹å‹•ä½œã¨ã¯å¼·ã„ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã‚¿ã‚°ã¨ Last-Modified å€¤ã®ä¸¡æ–¹ã‚’é€ã‚‹äº‹ã§ã‚ã‚‹ã€ã¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ãªã‚‹ã¹ãå¼·ã„ETagã‚’ä½¿ã„ã¾ã—ã‚‡ã†ã€ã¨ã„ã†ã“ã¨ã§ã™ã€‚ Rails2.0ã®ç”Ÿæˆæ‰‹æ³• ã€Œhttp:
yuhei_kagaya 2012/02/11
apache

performance

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

performance

etag
ãƒªãƒ³ã‚¯
Page Speedã§ãƒã‚§ãƒƒã‚¯ã¤ã„ã§ã«æœ€é©åŒ– | gaspanik weblog
å‰ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã€ŒYSlow!ã€ä½¿ã£ã¦ã‚ã‹ã‚‹ã‚ã‚“ãªã“ã¨ã“ã‚“ãªã“ã¨ã€ã§Firefoxã®ã‚¢ãƒ‰ã‚ªãƒ³ã€ŒYSlow!ã€ã®ä½¿ã„æ–¹ã¨ã‹è¦‹æ–¹ã‚’ç´¹ä»‹ã—ãŸã®ã§ã€ä»Šå›žã¯Googleã•ã‚“è¬¹è£½ã®ã‚¢ãƒ‰ã‚ªãƒ³ã€ŒPage Speedã€ã®è©±ã‚’ã—ã¦ã¿ã‚ˆã†ã‹ã¨æ€ã„ã¾ã™ã€‚ å‰å›žåŒæ§˜ã€ã€Œãã†ã ã€äº¬éƒ½ã€ã„ã£ã¦ããŸã€çš„ãªãƒšãƒ¼ã‚¸ã‚’å‚è€ƒãƒšãƒ¼ã‚¸ã¨ã—ã¾ã—ã¦ã€ä»Šå›žã¯ç”»åƒã«é–¢ã™ã‚‹ã¡ã‚‡ã£ã¨ã—ãŸè©±ãªã‚“ã‹ã‚‚å…¥ã‚Œã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ã§ã¯ã€Page Speedç·¨ã‚‚ã„ã£ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ å§‹ã‚ã‚‹å‰ã«ã€Page Speedã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‹ã‚‰ã€ŒPage Speedã€ã¯ã€Firefoxã®ã‚¢ãƒ‰ã‚ªãƒ³ã‚µã‚¤ãƒˆã«ã¯ç™»éŒ²ã•ã‚Œã¦ã„ã¾ã›ã‚“ã®ã§ã€Googleã•ã‚“ã®Page Speedã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãƒšãƒ¼ã‚¸ã‹ã‚‰ç›´æŽ¥ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ç¾åœ¨ã€æ£å¼ç‰ˆãŒã€ŒVersion 1.4ã€ã€Î²ç‰ˆã¨ã—ã¦ã€ŒVersion 1.5ã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã®ã§ã€ã©ã¡ã‚‰ã‹ãŠå¥½ããªæ–¹ã‚’ã€‚å¤ã„ã‚‚ã®ã‚ˆã‚Šã¯æ–°ã—ã„ã‚‚ã®ã®æ–¹ãŒè‰¯ã„ã¨æ€
yuhei_kagaya 2011/10/25
performance
ãƒªãƒ³ã‚¯
æ–™ç†ã‚’æ¥½ã—ãã™ã‚‹ç”»åƒé…ä¿¡ã‚·ã‚¹ãƒ†ãƒ
May 30, 2011Download as KEY, PDF101 likes22,672 views The document describes TOFU (Tofu on the Fly), a system for dynamically generating and caching image thumbnails on Amazon S3. It works by installing an Apache module that generates thumbnails using ImageMagick when images are requested, then caches them on S3 for future requests. This avoids hitting application servers for every image and provi
yuhei_kagaya 2011/09/06
performance

mod_tofu
ãƒªãƒ³ã‚¯
varnish | Hatak::Techlog
ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã•ã‚“ã®ã‚ªãƒ•ã‚£ã‚¹ã§é–‹å‚¬ã•ã‚ŒãŸã€Œã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆÃ—ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰åˆåŒå‹‰å¼·ä¼šã€ã«å‚åŠ ã—ã¦ãã¾ã—ãŸã€‚ ä¸¡ç¤¾ã§æ¤œè¨¼ã‚„æœ¬ç•ªå°Žå…¥ã—ã¦ã„ã‚‹ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ãªè©±é¡ŒãŒãƒ¡ã‚¤ãƒ³ã§ã€ã¨ã¦ã‚‚èˆˆå‘³æ·±ã„ã‚‚ã®ã§ã—ãŸã€‚ OpenStackã‚’æ¤œè¨¼ã—ã¦ã¿ãŸ â€“ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ä»®æƒ³åŒ–æŠ€è¡“ open stack ã®æ¤œè¨¼çµæžœã®å ±å‘Š ã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆã®å‚æœ¬ä½³ä¹… (@ton_katsu) ã•ã‚“ã®ç™ºè¡¨ã€‚ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆã‚¯ãƒ©ã‚¦ãƒ‰ã‚’æ§‹ç¯‰ã™ã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ã²ã¨ã¤ã€OpenStack ã‚’æ¤œè¨¼ã—ãŸçµæžœã®ã¾ã¨ã‚ã€‚ OpenStack Nova ã¨ Swift ã‚’çµ„ã¿åˆã‚ã›ãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã€‚ OpenStack ã‚’æ¤œè¨¼å¯¾è±¡ã¨ã—ã¦é¸ã‚“ã ç†ç”±ã¯æ¬¡ã®ã¨ãŠã‚Šã€‚ Eucalypusã ã¨ã‚¹ã‚±ãƒ¼ãƒ«ã—ãªã„ (ã‚‰ã—ã„) ubuntu ãŒã‚µãƒãƒ¼ãƒˆã™ã‚‹ (ã‚‰ã—ã„) 200 äººä½“åˆ¶ã§é–‹ç™ºãŒè¡Œã‚ã‚Œã¦ã„ã‚‹ å‚åŠ ä¼æ¥ã¨ã—ã¦ 60 ç¤¾ KVM, QEmu, Xen ãª
yuhei_kagaya 2011/09/06
performance
ãƒªãƒ³ã‚¯
GT Nitro: ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ãƒ»ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚·ãƒ³ã‚°ã‚²ãƒ¼ãƒ - Google Play ã®ã‚¢ãƒ—ãƒª
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
yuhei_kagaya 2011/09/06
varnish

performance
ãƒªãƒ³ã‚¯
ã¯ã˜ã‚ã¦ã® MySQL ã§100ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹æ™‚ã«è¡Œã£ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚
MySQL ã®å‹‰å¼·ã‚’ã›ãšã«ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ç‰ã§ SQL ã‚’æ›¸ã‹ãšã« Web ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰ã—ã¦ã„ã¾ã—ãŸã€‚ãƒ‡ãƒ¼ã‚¿æ•°ã‚‚2ä¸‡ä»¶ç¨‹åº¦ã§ã—ãŸã®ã§ã€ãã“ã¾ã§å›°ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸãŒã€ä»Šå›ž100ä¸‡å¼±ã®å•†å“ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†æ©Ÿä¼šãŒã§ããŸã®ã§ã€MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„ç™ºè¡Œã™ã‚‹ SQL ã«ã¤ã„ã¦è¦‹ç›´ã™æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ MySQL ã‚’é«˜é€ŸåŒ–ã™ã‚‹ã®ã«è¡Œã£ãŸå¯¾ç–ãªã©å‹‰å¼·ã—ãŸã‚‚ã®ã‚’è‡ªåˆ†ç”¨ã«ãƒ¡ãƒ¢ã—ã¦ãŠãã¾ã—ãŸã€‚ æ¡ä»¶å¼ã§æ¯”è¼ƒã™ã‚‹ã‚«ãƒ©ãƒ ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã—ã¦é«˜é€ŸåŒ– å•†å“ã‚³ãƒ¼ãƒ‰ã§å˜åœ¨ã—ãªã„å•†å“ã‚’è¦‹ã¤ã‘ã¦ã€å•†å“ã‚’DBã«ç™»éŒ²ã™ã‚‹ã¨ã„ã†å‡¦ç†ã‚’è¡Œã£ã¦ã„ã‚‹å ´åˆã€4ä¸‡ä»¶è¶…ãˆãŸã“ã‚ã‹ã‚‰å‡¦ç†ã«2ç§’ä»¥ä¸Šã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ãã¾ã™ã€‚12ä¸‡ä»¶è¶…ãˆãŸé ƒã«ã¯10ç§’ç¨‹åº¦ã‹ã‹ã‚‹ã‚ˆã†ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€å•†å“ã‚³ãƒ¼ãƒ‰ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«å¯¾ã—ã¦ã‚«ãƒ©ãƒ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è²¼ã‚‹ã“ã¨ã§0.2ç§’ã«çŸç¸®ã™ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã€‚ MySQL ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«ã‚‚ä»¥ä¸‹ã®ã‚ˆ
yuhei_kagaya 2011/07/22
mysql

performance
ãƒªãƒ³ã‚¯
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã§å„ªå‹ã—ã¦ãã¾ã—ãŸ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
7/9(åœŸ)ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã«å‚åŠ ã—ã¦å„ªå‹ã—ã¦ããŸã®ã§ã€ãã®å ±å‘Šã¨ã€ä½•ã‚’è€ƒãˆã¦ã©ã‚“ãªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ãŸã®ã‹ã‚’ è¨˜æ†¶ã®ç¯„å›²ã§å…¬é–‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã®ãŠé¡Œã¯ã€WordPress(ja) + php + Apache + MySQL ã§ã€ ab ã‚’ä½¿ã£ã¦ wp-comment.php çµŒç”±ã§ã‚³ãƒ¡ãƒ³ãƒˆã®ãƒã‚¹ãƒˆã‚’ã™ã‚‹ã“ã¨ã§è¨ˆæ¸¬ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ MySQLã¨Apacheã‚’ç«‹ã¡ä¸Šã’ãŸã‚‰WordPressãŒå‹•ãç’°å¢ƒãŒæ¸¡ã•ã‚Œã€ãã®WordPressè‡ªä½“ã¯è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã‚’å«ã‚ã¦ æ”¹é€ ãŒä¸€åˆ‡ç¦æ¢ã€WordPressã®å®Ÿè¡Œã‚’ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã™ã‚‹ãƒãƒ¼ãƒˆã‚‚ç¦æ¢ã§ã™ã€‚ 0. è©¦åˆå‰æ—¥ ç’°å¢ƒãŒAWSã¨AMI Linuxã¨ã„ã†ã“ã¨ã¯äº‹å‰ã«å…¬é–‹ã•ã‚Œã¦ã„ãŸãŸã‚ã€å‰æ—¥ã«AWSã«ç™»éŒ²ã—ã¦å°‘ã—ã ã‘AMI Linuxã‚’ è§¦ã£ã¦ã¿ã¾ã—ãŸã€‚yumãƒ™ãƒ¼ã‚¹ã ã‘ã©CentOSã¨é•ã£ã¦çµæ§‹æ–°ã—ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç”¨
yuhei_kagaya 2011/07/12
tuning

mysql

apache

php

wordpress

performance
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸