[B! è² è·åˆ†æ•£] puchibanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

puchiban id:puchiban

è² è·åˆ†æ•£ã«é–¢ã™ã‚‹puchibanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (14)

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

mod_rewrite ã‚’åˆ©ç”¨ã—ãŸãƒªãƒãƒ¼ã‚¹ãƒ—ãƒã‚ã‚·ç’°å¢ƒã®ä½œã‚Šæ–¹ - livedoor Blogï¼ˆãƒ–ãƒã‚°ï¼‰
ã“ã‚“ã«ã¡ã¯ã€ æœ€è¿‘æ„›ç”¨ã®MacbookãŒå¤–è¦³ã‚‚ä¸èº«ã‚‚ãƒœãƒãƒœãƒã«ãªã£ã¦ãã¦æ‚²ã—ã„kyannyã§ã™ã€‚ ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ã§ã¯ã€ç”»åƒã‚„CSSãƒ•ã‚¡ã‚¤ãƒ«ã‚„javascriptãƒ•ã‚¡ã‚¤ãƒ«ãªã©ã®é™çš„ãªã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’é…ä¿¡ã™ã‚‹ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒã¨ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æœ¬ä½“ãŒç¨¼åƒã™ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒã‚’åˆ¥ã€…ã®ãƒ›ã‚¹ãƒˆã§é‹ç”¨ã™ã‚‹ã€ã„ã‚ã‚†ã‚‹ãƒªãƒãƒ¼ã‚¹ãƒ—ãƒã‚ã‚·ç’°å¢ƒã‚’æ§‹ç¯‰ã—ã¦ã„ã¾ã™ã€‚ä»Šå›žã¯ã€ã“ã®ãƒªãƒãƒ¼ã‚¹ãƒ—ãƒã‚ã‚·ç’°å¢ƒã®ä½œã‚Šæ–¹ã‚’è§£èª¬ã—ã¾ã™ã€‚ ãƒªãƒãƒ¼ã‚¹ãƒ—ãƒã‚ã‚·ã¨ã¯ ãƒªãƒãƒ¼ã‚¹ãƒ—ãƒã‚ã‚·ã¨ã¯ãƒ—ãƒã‚ã‚·ã‚µãƒ¼ãƒã®ä¸€ç¨®ã§ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã«å¯¾ã—ã¦ãƒ•ã‚¡ã‚¤ã‚¢ã‚¦ã‚©ãƒ¼ãƒ«ã®ä¸ã«ã‚ã‚Šå¤–éƒ¨ã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‹ã‚‰ç›´æŽ¥ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ã‚µãƒ¼ãƒã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’æä¾›ã™ã‚‹æ©Ÿèƒ½ã§ã™ã€‚ã“ã‚Œä»¥å¤–ã«ã‚‚ã€è¤‡æ•°ã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚µãƒ¼ãƒã‚’ç”¨æ„ã—ã¦è² è·åˆ†æ•£ã‚’ã—ãŸã‚Šã€ãƒ—ãƒã‚ã‚·ã‚µãƒ¼ãƒã§ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ä½µç”¨ã™ã‚‹ã“ã¨ã§ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚µãƒ¼ãƒã¸ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’æ¸›ã‚‰ã—ãŸã‚Šã¨ã€æ§˜ã€…ãªã‚·ãƒ¼ãƒ³ã§æ´»ç”¨ã§ãã‚‹ãŸã‚ã€å¤§è¦æ¨¡ãªã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã‚’æ§‹ç¯‰
puchiban 2010/01/08
è² è·åˆ†æ•£

mod_rewrite
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¨è¨€ã£ãŸå ´åˆã«ã¯ã€ã‚µãƒ¼ãƒãƒ¼ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®èª¿æ•´ã‚„ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã—ãŸã‚¯ã‚¨ãƒªå®Ÿè¡Œè¨ˆç”»ã®æœ€é©åŒ–ãŒè©±é¡Œã«ä¸Šã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ã—ã‹ã—ã€ç™ºè¡Œã™ã‚‹å…¨ã¦ã® SQL ã«ã¤ã„ã¦ã€ã„ã¡ã„ã¡ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ã¦ç¢ºèªã—ã¦ã„ã¦ã¯ã€ã„ãã‚‰æ™‚é–“ãŒã‚ã£ã¦ã‚‚ãŸã‚Šã¾ã›ã‚“ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’åŠ¹çŽ‡çš„ã«é€²ã‚ã‚‹ã«ã¯ã€ã¾ãšã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã£ã¦ã„ã‚‹ SQL ã‚¯ã‚¨ãƒªã‚’ç‰¹å®šã—ã€æ¬¡ã«ãã®æœ€é©åŒ–ã‚’è¡Œã†ã¹ãã§ã™ã€‚ ã§ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ç‰¹å®šã™ã‚‹ã®ã‹ã€‚MySQL Conference & Expo 2009 ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ Mark Callaghan æ°ã¯ã€Google ã§ã¯ SHOW PROCESSLIST ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ãŸçµ±è¨ˆçš„ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’ä½¿ã£ã¦ã„ã‚‹ã¨è¿°ã¹ã¦ã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ (å‚ç…§: MySQLConf 09: Mark Callaghan, "This is Not a
puchiban 2009/09/29
MySQL

è² è·åˆ†æ•£
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: å›½ç”£MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒSpiderã€ã®ä½œè€…ã€æ–¯æ³¢å¥å¾³æ°ã«èžã
ã“ã‚“ã«ã¡ã¯ã€‚ä¸æ‘ã§ã™ã€‚ MySQLã«ã¯MyISAMã€InnoDBã€CSVãªã©ã®ã„ãã¤ã‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãŒã‚ã‚Šã¾ã™ãŒã€çš†ã•ã‚“ã¯Spiderã¨ã„ã†ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’èžã„ãŸã“ã¨ã¯ã‚ã‚Šã¾ã™ã§ã—ã‚‡ã†ã‹ã€‚Spider Storage Engineã¯æ–¯æ³¢å¥å¾³ã•ã‚“ã«ã‚ˆã‚Šä½œæˆã•ã‚ŒãŸDatabase Shardingã‚’å¯èƒ½ã«ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§MySQL 5.1ã§åˆ©ç”¨å¯èƒ½ã§ã™ã€‚ å…ˆæ—¥ã€æŸé›†ã¾ã‚Šã§æ–¯æ³¢ã•ã‚“ã¨ãŠä¼šã„ã—ãŸã¨ãã«Spiderã‚’ä½œã£ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã‚’æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã®ã§ã€æ—©é€Ÿè©³ã—ã„å†…å®¹ã‚’æ•™ãˆã¦ã‚‚ã‚‰ã†ã“ã¨ã«ã—ã¾ã—ãŸã€‚ â€»Spiderã«ã¤ã„ã¦ã®èª¬æ˜Žè³‡æ–™ã¯MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ 2009ã«ã¦æ–¯æ³¢ã•ã‚“ãŒç™ºè¡¨ã•ã‚ŒãŸã¨ãã®ã‚¹ãƒ©ã‚¤ãƒ‰ãŒã‚ã‚Šã¾ã™ã€‚ã‚¹ãƒ©ã‚¤ãƒ‰ã®ç›´ãƒªãƒ³ã‚¯ï¼ˆzipï¼‰ Spider Storage Engine ã«ã¤ã„ã¦ posted by (C)ãƒ•ã‚©ãƒˆè”µ Spider Storage Engineã¨ã¯ï¼Ÿ
puchiban 2009/07/17
ã“ã‚Œã™ã”ã„ã‚“ã˜ã‚ƒ?

MySQL

è² è·åˆ†æ•£
ãƒªãƒ³ã‚¯
ï¼»MySQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬40å›ž ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã§é«˜é€ŸåŒ–ã—å¤§é‡ãƒ‡ãƒ¼ã‚¿ã«å‚™ãˆã‚‹
å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ ¼ç´ã™ã‚‹ã¨ä½•ã‹ã¨ä¸ä¾¿ã¨ãªã‚‹ã€‚å‡¦ç†å¯¾è±¡ãŒå¤§é‡ã ã‘ã«æ¤œç´¢ã‚’ã¯ã˜ã‚ã¨ã—ã¦å‡¦ç†æ™‚é–“ãŒå¤§ãããªã‚‹ã€‚ç¾å®Ÿã®ç”Ÿæ´»ã¯ã€æ‰‹ã«ä½™ã‚‹å¤§é‡ã®ç‰©ã‚’å°åˆ†ã‘ã«ã™ã‚‹ã¨ã„ã†ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ã‚ˆãä½¿ã†ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚‚ã“ã®æ‰‹æ³•ã¯æœ‰åŠ¹ã§ã‚ã‚‹ã€‚å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’å°åˆ†ã‘ã«ã™ã‚‹ã“ã¨ã§ã€å‡¦ç†ã®é«˜é€ŸåŒ–ã¨æ ¼ç´åŠ¹çŽ‡ã‚’å‘ä¸Šã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã‚ã‚‹ã€‚ä»Šå›žã¯ã€MySQL 5.1ã®æ–°æ©Ÿèƒ½ã®ç†é ã«ä¸ŠãŒã£ã¦ã„ã‚‹ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã‚’è§£èª¬ã™ã‚‹ã€‚ MySQL 5.1ã®æ³¨ç›®æ©Ÿèƒ½ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã¯ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ†å‰²ã—ã¦æ€§èƒ½ã‚’å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®æŠ€è¡“ã ã€‚MySQL 5.0ã§ã‚‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®åˆ†å‰²æ©Ÿèƒ½ã¯ã‚ã£ãŸã€‚è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’é€£çµã—ã¦ï¼‘ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«è¦‹ã›ã‹ã‘ã‚‹MARGEã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³(ãƒ†ãƒ¼ãƒ–ãƒ«)ã€SELECTã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’çµåˆã™ã‚‹UNIONãªã©ãŒã‚ã‚‹ã€‚ã“ã‚Œã‚‰ã®æ©Ÿèƒ½ã¯ã€ã‚‚ã¨ã‚‚ã¨åˆ¥ã€…ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’çµåˆã—ã¦å‡¦ç†ã™ã‚‹å¾Œå‡¦ç†çš„ãªä½ç½®ã¥ã‘ã«ãªã‚‹
puchiban 2009/06/03
MySQL

ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°

performance

è² è·åˆ†æ•£
ãƒªãƒ³ã‚¯
æº€è¶³ã›ã‚‹è±šã€‚çœ ãŸã’ãªãƒãƒã€‚:å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹ã®é‹ç”¨äº‹ä¾‹ã¾ã¨ã‚
ã“ã“æ•°å¹´ã®å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚·ã‚¹ãƒ†ãƒ é‹ç”¨ã«ã¤ã„ã¦èª¿ã¹ã¦ã¿ãŸã®ã§å‚ç…§ã—ãŸãƒšãƒ¼ã‚¸ã‚„ãƒ•ã‚¡ã‚¤ãƒ«ã€æœ¬ã¸ã®ãƒªãƒ³ã‚¯ã‚’ã¾ã¨ã‚ã¦ãŠãã€‚PDF ã¸ã®ãƒªãƒ³ã‚¯ã‚‚å¤šæ•°å«ã¾ã‚Œã¦ã„ã‚‹ã®ã§ã”æ³¨æ„ã‚’ã€‚ æ™‚ä»£ãŒæ™‚ä»£ãªã‚‰ä¼æ¥ã®ãƒŽã‚¦ãƒã‚¦ã¨ã—ã¦éš ã•ã‚Œã¦ã„ãŸã‚ˆã†ãªæƒ…å ±ãŒã“ã‚Œã ã‘å…¬é–‹ã—ã¦ã‚‚ã‚‰ãˆã¦ã„ã‚‹ã¨ã„ã†ã®ãŒéžå¸¸ã«ã‚ã‚ŠãŒãŸã„ã€‚å…¬é–‹ã—ã¦ãã‚Œã¦ã„ã‚‹å„ä¼æ¥ã‚„å…¬é–‹ã—ã¦ãã‚Œã¦ã„ã‚‹äººã«æ„Ÿè¬ã€‚ ã‚ã¨ã§æ°—ä»˜ã„ãŸãŒã€Google ã‚„ Facebook ã®äº‹ä¾‹ã‚‚æŽ¢ã—ã¦ãŠã‘ã°ã‚ˆã‹ã£ãŸã€‚Thrift ã¨ã‹ã‚ã£ãŸã®ã«ã€‚ã€Œã“ã‚“ãªæƒ…å ±ã‚‚ã‚ã£ãŸã‚ˆã€ãªã©ã‚ã‚Œã°ãœã²æ•™ãˆã¦ãã ã•ã„ã€‚è¿½è¨˜ã—ã¦ã„ãã¾ã™ã€‚ youtube http://d.hatena.ne.jp/stanaka/20070427/1177651323 digg http://d.hatena.ne.jp/stanaka/20070427/1177651323 livedoor http://labs.cybo
puchiban 2009/06/03
performance

è² è·åˆ†æ•£

ã¾ã¨ã‚

web
ãƒªãƒ³ã‚¯
Hadoopã§ã€ã‹ã‚“ãŸã‚“åˆ†æ•£å‡¦ç† (Yahoo! JAPAN Tech Blog)
ãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10æœˆ1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ãƒ–ãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚LINEãƒ¤ãƒ•ãƒ¼ Tech Blog ã“ã‚“ã«ã¡ã¯ã€åœ°åŸŸã‚µãƒ¼ãƒ“ã‚¹äº‹æ¥éƒ¨ã®å‰ç”°ä¸€æ˜Ÿã§ã™ã€‚ ä»Šå›žã¯ã€Hadoopã«ã¤ã„ã¦ã€Yahoo! JAPANã§ã®å®Ÿéš›ã®ä½¿ç”¨ä¾‹ã‚’äº¤ãˆãªãŒã‚‰æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚Hadoopã¨ã¯ã€å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰‹è»½ã«è¤‡æ•°ã®ãƒžã‚·ãƒ³ã«åˆ†æ•£ã—ã¦å‡¦ç†ã§ãã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ã™ã€‚ è¤‡æ•°ã®ãƒžã‚·ãƒ³ã¸ã®åˆ†æ•£å‡¦ç†ã¯ã€ãƒ—ãƒã‚»ã‚¹é–“é€šä¿¡ã‚„ã€éšœå®³æ™‚ã¸ã®å¯¾å¿œãªã©ã‚’è€ƒãˆãªã‘ã‚Œã°ãªã‚‰ãšã€ãƒ—ãƒã‚°ãƒ©ãƒžã«ã¨ã£ã¦æ•·å±…ãŒé«˜ã„ã‚‚ã®ã§ã™ãŒã€ Hadoopã¯ãã†ã„ã£ãŸé¢å€’ãã•ã„åˆ†æ•£å‡¦ç†ã‚’ä¸€æ‰‹ã«å¼•ãå—ã‘ã¦ãã‚Œã¾ã™ã€‚ 1å°ã§ã¯å‡¦ç†ã«ã‹ãªã‚Šæ™‚é–“ãŒã‹ã‹ã‚‹ã‚ˆã†ãªå¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚‚ã€è¤‡æ•°ãƒžã‚·ãƒ³ã«åˆ†æ•£ã•ã›ã‚‹ã“ã¨ã§ã€é©šãã¹ãã‚¹ãƒ”ãƒ¼ãƒ‰ã§å‡¦ç†ã‚’è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ä¾‹ãˆã°ã€ä»Šã¾ã§1å°ã§ã‚„ã£ã¦ã„ãŸã€ã‚ã‚‹ãƒã‚°é›†è¨ˆå‡¦ç†
puchiban 2009/06/03
è² è·åˆ†æ•£

é–‹ç™º
ãƒªãƒ³ã‚¯
MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®‰å…¨ã«åˆ©ç”¨ã™ã‚‹ãŸã‚ã®10ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯éžå¸¸ã«ç°¡å˜ã«ä½¿ãˆã‚‹å‰²ã«ã¯å¿œç”¨ã®å¹…ãŒåºƒã„ã®ã§éžå¸¸ã«äººæ°—ã®ã‚ã‚‹æ©Ÿèƒ½ã®ä¸€ã¤ã§ã‚ã‚‹ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®å¿œç”¨åˆ†é‡Žã¯ä¾‹ãˆã°ã€ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— å‚ç…§ç³»ã®è² è·åˆ†æ•£ HAï¼ˆé«˜å¯ç”¨æ€§ï¼‰ ãƒ‡ã‚£ã‚¶ã‚¹ã‚¿ãƒªã‚«ãƒãƒªï¼ˆã‚µã‚¤ãƒˆé–“ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰ BIï¼ˆãƒ¬ãƒãƒ¼ãƒ†ã‚£ãƒ³ã‚°etcï¼‰ ã¨ã„ã†é¢¨ã«ã¨ã¦ã‚‚å¤šãã®ãƒãƒªã‚¨ãƒ¼ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ã€‚ã“ã®ãƒ–ãƒã‚°ã‚’èªã‚“ã§é ‚ã„ã¦ã„ã‚‹çš†ã•ã‚“ã®ä¸ã«ã‚‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã„ã‚‹æ–¹ã¯å¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ã”è¦§ã®é€šã‚ŠMySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«åˆ†é‡Žã§ã‚‚åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ãŒã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä½¿ã„æ–¹ãŒé©åˆ‡ã§ãªã„ã¨ã‚·ã‚¹ãƒ†ãƒ ã®å®‰å®šç¨¼åƒã«æ”¯éšœã‚’æ¥ã—ã¦ã—ã¾ã£ã¦DBAã‚„ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†è€…ã®è‚‰ä½“çš„ã€ç²¾ç¥žçš„è² æ‹…ãŒå¢—å¤§ã—ã¦ã—ã¾ã†ã€‚é€†ã«ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å …ç‰¢ã«é‹ç”¨ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚Œã°ãƒžã‚¯ãƒ©ã‚’é«˜ãã—ã¦çœ ã‚Œã‚‹ã¨ã„ã†ã‚‚ã®ã ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã®ä»£è¡¨çš„ãªæ©Ÿèƒ½ã§ã‚ã‚‹ã®ã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
puchiban 2009/06/02
è² è·åˆ†æ•£

ã¾ã¨ã‚

ãŠå½¹ç«‹ã¡

performance
ãƒªãƒ³ã‚¯
Yahoo!ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã®MySQL å†—é•·åŒ–æŠ€è¡“
ãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10æœˆ1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ãƒ–ãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚LINEãƒ¤ãƒ•ãƒ¼ Tech Blog ã“ã‚“ã«ã¡ã¯ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ãƒ—ãƒ©ãƒƒãƒˆãƒ›ãƒ¼ãƒ æŠ€è¡“ã®ãƒãƒ£ãƒƒã‚¯ã§ã™ã€‚ ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯ä¸€éƒ¨ã‚µãƒ¼ãƒ“ã‚¹ã« RDBMS ã® MySQL ã‚’ä½¿ã£ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æä¾›ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯å¤šãã®ãŠå®¢æ§˜ã‚ˆã‚Šã‚¢ã‚¯ã‚»ã‚¹ã‚’é ‚ã„ã¦ãŠã‚Šã¾ã™ã®ã§ã€å¤§é‡ã®æ›´æ–°ã€å‚ç…§ã®å‡¦ç†é€Ÿåº¦ã«å„ªã‚ŒãŸ MySQL ã‚’é¸æŠžã—ã€ãŠå®¢æ§˜ã«ã‚¹ãƒˆãƒ¬ã‚¹ãªãã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ã‘ã‚‹ã‚ˆã† æ—¥ã€…æ¥å‹™ã«å–ã‚Šçµ„ã¾ã•ã›ã¦ã„ãŸã ã„ã¦ãŠã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ç²¾å¯†æ©Ÿå™¨ã«ã¯æ•…éšœãŒã¤ãã‚‚ã®ã§ã€ã‚µãƒ¼ãƒ“ã‚¹é‹ç”¨ã®è¦³ç‚¹ã‹ã‚‰ã¯ ã€Œæ©Ÿå™¨ãŒæ•…éšœã™ã‚‹ã®ã¯ã—ã‹ãŸãªã„ã€ã—ã‹ã—ãã‚Œã‚’ã„ã‹ã«æ—©ãå¾©æ—§ã•ã›ã‚‹ã‹ã€ ã¨ã„ã£ãŸã“ã¨ã‚’å¿µé ã«å…¥ã‚Œã¦ãŠã‚Šã¾ã™ã€‚ å®Ÿéš›ã«ã¯ã€éšœå®³ãŒèµ·ã“ã£ã¦ã‹ã‚‰å¾©æ—§ã•ã›ã‚‹ã®ã§ã¯ãªãã€éšœå®³ãŒç™ºç”Ÿã—ãŸå ´åˆã«
puchiban 2009/06/02
è² è·åˆ†æ•£

performance

é–‹ç™º

web
ãƒªãƒ³ã‚¯
LVS+ldirectorã‚’ä½¿ã£ã¦MySQLã‚’ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚¹ã‚’ã—ã¦ã¿ã‚‹ - sanonosaã€€ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†ã‚³ãƒ©ãƒ é›†
ä»Šå›žã¯LVSã‚’ä½¿ã£ã¦MySQLã®slaveã‚µãƒ¼ãƒã‚’ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚·ãƒ³ã‚°ã™ã‚‹æ–¹æ³•ã‚’è¨˜ã—ã¦ã¿ã¾ã™ã€‚LVSã¯å˜ã«æŒ¯ã‚Šåˆ†ã‘ã—ã‹ã‚„ã£ã¦ãã‚Œã¾ã›ã‚“ã®ã§ã€ãƒªã‚¢ãƒ«ã‚µãƒ¼ãƒã®ç”Ÿå˜ç¢ºèªã‚„LVSã®ä½œå‹•ç®¡ç†ã®ãŸã‚ã«ldirectorã‚‚å°Žå…¥ã—ã¦ã„ã¾ã™ã€‚ LVSã ã‘ã ã¨LVSã®è¨å®šã‚’å…¥ã‚Œè¾¼ã¾ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ãŒã€ldirectorã‚’ä½¿ã†ã¨ldirectorã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ã„ã¦ãŠãã“ã¨ã§LVSã®è¨å®šã‚’ldirectorãŒè‡ªå‹•ç”Ÿæˆã—ã¦åæ˜ ã—ã¦ãã‚Œã‚‹ã®ã§æ¥½ã¡ã‚“ã§ã™ã€‚ â€»ä¸–ã®ä¸ã«ã¯LVS+keepalivedã®çµ„ã¿åˆã‚ã›ãŒå¤šã„ã‚ˆã†ã§ã™ãŒã€æ¤œè¨¼ã—ã¦ã¿ãŸã¨ã“ã‚ldirectorã®ã»ã†ãŒå°Žå…¥ã‚‚é‹ç”¨ã‚‚ç°¡å˜ãªã®ã§ã“ã¡ã‚‰ã‚’æŽ¡ç”¨ã—ã¾ã—ãŸã€‚ å‰ææ¡ä»¶ VIP: 10.0.2.10 DB1: 10.0.0.101 DB2: 10.0.0.102 ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãƒ¼ã¨ãªã‚‹ã‚µãƒ¼ãƒã¸ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³• ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‘ # yum install ip
puchiban 2009/06/02
è² è·åˆ†æ•£

lvs
ãƒªãƒ³ã‚¯
mixiã®ç”Ÿã¿ã®è¦ªâ€œãƒã‚¿ãƒ©æ°â€ãŒèªžã‚‹MySQLã®æ„å¤–ãªåˆ©ç”¨æ³• ï¼ TechTargetã‚¸ãƒ£ãƒ‘ãƒ³
æ—¥è¨˜ã ã‘ã§4å„„ä»¶ã®ãƒ‡ãƒ¼ã‚¿ ãƒŸã‚¯ã‚·ã‚£ãŒé‹å–¶ã™ã‚‹SNSã€Œmixiã€ã¯ã€2007å¹´7æœˆæœ«æ®µéšŽã§ãƒ¦ãƒ¼ã‚¶ãƒ¼æ•°ãŒ1110ä¸‡äººã€‚äººãŒ12äººé›†ã¾ã‚Œã°ã€1äººã¯mixiãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã„ã†ã‚ã‘ã ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–çŽ‡ï¼ˆãƒã‚°ã‚¤ãƒ³é–“éš”ãŒ3æ—¥ä»¥å†…ï¼‰ã¯ç´„62ï¼…ã¨é«˜ãã€2007å¹´4æœˆã‹ã‚‰6æœˆã®æœˆé–“å¹³å‡ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ã¯117.5å„„ã«é”ã—ãŸã€‚æ—¥è¨˜ã ã‘ã§ã‚‚4å„„ä»¶ä»¥ä¸Šã«ä¸Šã‚‹ãªã©ã€è“„ç©ã™ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã‚‚èŽ«å¤§ã€‚2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‹ã‚‰ã€ã‚ãšã‹3å¹´åŠã§ç¾åœ¨ã®å·¨å¤§ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã¸ã¨ç™ºå±•ã—ãŸã®ã ã€‚ ãƒŸã‚¯ã‚·ã‚£ã¯ã€ã€ŒLAMPï¼ˆOSã®Linuxã€Webã‚µãƒ¼ãƒã®Apacheã€DBMSã®MySQLã€é–‹ç™ºè¨€èªžã®Perlã€PHPã€Pythonï¼‰ã€ã¨å‘¼ã°ã‚Œã‚‹Webã‚·ã‚¹ãƒ†ãƒ å‘ã‘ã®æ¨™æº–çš„ãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ï¼ˆä»¥ä¸‹ã€OSSï¼‰ã§ã‚·ã‚¹ãƒ†ãƒ ã‚’è‡ªç¤¾é–‹ç™ºã—ã€å®‰ä¾¡ãªPCã‚µãƒ¼ãƒã‚’1000å°ä»¥ä¸Šé€£ãã‚‹è¶…åˆ†æ•£æ§‹æˆã§mixiã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ”¯ãˆã¦ã„ã‚‹ï¼ˆåºƒå‘Šé…ä¿¡ãªã©å‘¨è¾ºæ©Ÿèƒ½ã§ã¯
puchiban 2009/06/02
è² è·å¯¾ç–

è² è·åˆ†æ•£
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MySQL ã®è² è·åˆ†æ•£ã« LVS + keepalived ã‚’ä½¿ã†
ã‚ã¨ã§æ›¸ãã€ã¨è¨€ã£ãŸæ‰‹å‰ãªã®ã§æ›¸ãã¨ã—ã¾ã™ã€‚ DSASã®ä¸ã®äººãŒã™ã”ã„å‹¢ã„ã§ LVS ã®è©±ã‚’æ›¸ã„ã¦ãã‚Œã¦ã¾ã™ã€‚ã“ã®è¾ºã€‚LVS ã‚’ä½¿ã†ã¨ Linux ã¨ç®±ã§ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãŒä½œã‚Œã¡ã‚ƒã„ã¾ã™ã€‚æ™®é€šã«è²·ã£ãŸã‚‰æ•°ç™¾ä¸‡ã¨ã‹ã—ã¡ã‚ƒã†ã‚„ã¤ã€‚ DSAS ã®ä¸ã®ã²ã¨ã«æ„Ÿè¬ã—ã¤ã¤ã€ã„ã„æ©Ÿä¼šãªã®ã§ã‚„ã£ã¦ã¿ã‚ˆã†! ã¨æ€ã£ã¦ã„ã‚ã„ã‚è©¦ã—ã¦æ˜¨æ—¥ã‚ãŸã‚Šã‹ã‚‰ã¯ã¦ãªã®ä¸ã§ã‚‚ LVS + keepalived ã§å‹•ã‹ã—ã¯ã˜ã‚ã¦ã¾ã™ã€‚ã„ã¾ã®ã¨ã“ã‚å•é¡Œãªã—ã€‚ ãã®ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã‚’ã©ã“ã«ä½¿ã£ã¦ã‚‹ã‹ã§ã™ãŒã€æ™®é€šãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µã¨ã„ã†ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆã‹ã‚‰ã®å…¥ã‚Šå£ã®ã¨ã“ã‚ã«ç½®ã„ã¦ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒãƒ¼ã®è² è·åˆ†æ•£ã«ä½¿ã†ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒã‚ã‚Šã¾ã™ã€‚ãŒã€ä»Šå›žã¯ã¯ã¦ãªã§ã¯ MySQL ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã®æ‰‹å‰ã«ç½®ãã¨ã„ã†å½¹å‰²ã§ã¨ã‚Šã‚ãˆãšä½¿ã„ã¯ã˜ã‚ã¾ã—ãŸã€‚ +-----------+ +-----------+ | mod_perl | | mod_perl | +----
puchiban 2009/06/02
è² è·åˆ†æ•£

è² è·å¯¾ç–

performance
ãƒªãƒ³ã‚¯
ï¼‘äººã§ç¨¼ãæ—¥è¨˜ | MySQLï¼šï¼‘å°ã—ã‹ãªã„ç’°å¢ƒã§ã‚¨ã‚»è² è·åˆ†æ•£
MySQLã®ãƒã‚¿ã€‚ ï¼‘å°ã—ã‹ãªã„ç’°å¢ƒã§ã‚¨ã‚»è² è·åˆ†æ•£ã‚’è¡Œã†ã€‚ MySQLã§è² è·åˆ†æ•£ã‚’è€ƒãˆãŸã¨ãã€ ï¼‘å°ç›®ã«ãƒžã‚¹ã‚¿ãƒ¼ã®ï¼¤ï¼¢ã‚µãƒ¼ãƒãƒ¼ã€ ï¼’å°ç›®ä»¥é™ã‚’ã‚¹ãƒ¬ãƒ¼ãƒ–ã®ï¼¤ï¼¢ã‚µãƒ¼ãƒãƒ¼ã¨ã—ã¦ç”¨ã„ã‚‹ã€‚ ãƒžã‚¹ã‚¿ãƒ¼ã¯æ›´æ–°ç³»ã®ã¿ã®ï¼³ï¼±ï¼¬æ–‡ã‚’ã€ ã‚¹ãƒ¬ãƒ¼ãƒ–ã¯å‚ç…§ç³»ã®ã¿ã®ï¼³ï¼±ï¼¬æ–‡ã‚’æŠ•ã’ã‚‹ã€‚ ã“ã‚“ãªè² è·åˆ†æ•£ã‚’ï¼‘å°ã®ã‚µãƒ¼ãƒãƒ¼ã§è¡Œã†å¿…è¦ãŒå‡ºã¦ããŸã€‚ ç¾åœ¨ï¼‘å°ã§ã‚„ã£ã¦ã„ã¦ã€ãƒ‡ã‚£ã‚¹ã‚¯ï¼©ï¼¯ãŒè¿½ã„ã¤ã‹ãšã«æœã—æ±‚ã‚ãŸçµæžœã€ä¸‹ã®å½¢ã§è½ã¡ç€ã„ãŸã€‚ ï¼‘ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å«ã‚ãŸã‚µã‚¤ã‚ºãŒ 30MBã€œ100MBã»ã©ã§å®‰å®šã—ã¦ã„ã‚‹ã€ã¨ã„ã†æ¡ä»¶ãŒã‚ã‚‹ã®ã§ã™ãŒ ã‹ãªã‚Šè² è·ä¸‹ãŒã‚Šã¾ã™ã€‚ â€»ä¸Šè¨˜ã‚µã‚¤ã‚ºã¯æè¼‰ãƒ¡ãƒ¢ãƒªã‚µã‚¤ã‚ºã«ã‚ˆã£ã¦å¤‰ã‚ã‚Šã¾ã™ -------------------------- â– ã‚„ã‚Šã‹ãŸ è² è·ãŒé«˜ã„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ï¼¡ã¨ã™ã‚‹ ï¼‘ï¼šï¼¡ã¨åŒã˜ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹æˆã§ã€ã‚¨ãƒ³ã‚¸ãƒ³ã‚’MEMORY(he
puchiban 2009/06/02
performance

è² è·åˆ†æ•£

development

web
ãƒªãƒ³ã‚¯
MySQLè² è·åˆ†æ•£ã®ã¾ã¨ã‚ - Life on the net
ã¯ã¦ã¶ã§äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã«ãªã£ã¦ã„ãŸã€ http://kokoromo.jugem.cc/?eid=195 [MySQLï¼šï¼‘å°ã—ã‹ãªã„ç’°å¢ƒã§è² è·åˆ†æ•£] ã“ã‚Œã¯è² è·åˆ†æ•£ï¼ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã¨ã„ã†ã‚ˆã‚Šã¯ä¸€å°ã§ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ãƒƒãƒ—ã—ã¦ã—ã®ãæ‰‹æ®µã‚’æ›¸ã„ã¦ã„ã€‚ ã ã‹ã‚‰è² è·åˆ†æ•£ã¨ã„ã†è¨€è‘‰ã¯å¿…ãšã—ã‚‚æ£ã—ããªã„ã®ã ãŒã€ä¸€ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ä»˜åŠ é›†ä¸ã‚’åˆ†æ•£ã•ã›ã‚‹ã¨ã„ã†äº‹ãªã®ã ã‚ã†ã€‚ ãã“ã§ä½•ãƒ‘ã‚¿ãƒ¼ãƒ³ã‹ã‚ã‚‹MySQLã®è² è·åˆ†æ•£ã‚’ç°¡å˜ã«ã¾ã¨ã‚ã¦ã¿ã‚‹ã€‚ 1. å¯Œè±ªçš„åˆ†æ•£ å•†ç”¨ã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼è£½å“ã‚’ä½¿ã†ã€‚ æœ€è¿‘ã¯MySQLå°‚é–€ã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼è£½å“ãŒå‡ºã¦ãã¦ã„ã‚‹ã€‚ http://www.continuent.jp/pro.html ãªã‚“ã‹ã¯è‰¯ã„ã‹ãªã¨æ€ã†ã€‚ é•·æ‰€ï¼š ãƒ—ãƒã‚°ãƒ©ãƒ å´ã§ã¯ã‚¯ãƒ©ã‚¹ã‚¿çŠ¶æ…‹ã‚’ä½•ã®æ„è˜ã‚‚ã›ãšã€ä¸€ã¤ã®ã‚¿ãƒ¼ã‚²ãƒƒãƒˆã«å¯¾ã—ã¦ã‚¯ã‚¨ãƒªãƒ¼ã‚’ç™ºè¡Œã™ã‚Œã°è‰¯ã„ã€‚ ã‚¿ãƒ¼ã‚²ãƒƒãƒˆãŒè¤‡æ•°å°ã‚ã‚‹äº‹ã¯æ„è˜ã™ã‚‹äº‹ã¯ç„¡ã„ã€‚ ä¸å…·åˆãŒã‚ã‚‹ãƒŽãƒ¼ãƒ‰ã«ç”Ÿã˜ãŸå ´åˆã€ä»–
puchiban 2009/06/02
è² è·åˆ†æ•£

è² è·å¯¾ç–

performance

é–‹ç™º

development
ãƒªãƒ³ã‚¯
Milano::Monolog: mod_rewriteã§ã‚µãƒ¼ãƒãƒ¼ã®è² è·ãŒé«˜ã„ã¨ãã ã‘ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã™ã‚‹
mod_rewriteã§ã‚µãƒ¼ãƒãƒ¼ã®è² è·ãŒé«˜ã„ã¨ãã ã‘ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã™ã‚‹ ãƒ¯ã‚¿ã‚·ãŒåƒã„ã¦ã„ã‚‹ä¼šç¤¾ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã¯ã€ãŸã¾ãƒ¼ã«Yahooã®ãƒˆãƒ”ãƒƒã‚¯ã‚¹ã‹ã‚‰ãƒªãƒ³ã‚¯ã•ã‚Œã¾ã™ã€‚ ãƒˆãƒ”ãƒƒã‚¯ã‚¹ã«è¼‰ã‚‹ã¨ãã‚Œã¯ã‚‚ã†å¤§é‡ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒæ´¥æ³¢ã®ã‚ˆã†ã«æŠ¼ã—å¯„ã›ã¦ãã¦ã€ã‚ã£ã¨ã„ã†ã¾ã«ã‚µãƒ¼ãƒãƒ¼ã®ãƒªã‚½ãƒ¼ã‚¹ã‚’é£Ÿã„ã¤ã¶ã—ã¦ã‚¢ã‚¯ã‚»ã‚¹ä¸èƒ½ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ ã“ã†ã„ã†ã¨ãã®ãŸã‚ã«ã€Contents Delivery Networkã«ã‚ˆã‚‹ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã‚‚åˆ©ç”¨ã—ã¦ã¾ã™ã€‚ ä»Šã¾ã§ã¯ã€ãƒªãƒ³ã‚¯ã•ã‚Œãã†ã«ãªã£ãŸã‚‰mod_rewriteã§ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã£ã¦æ–¹æ³•ã‚’ä½¿ã£ã¦ã„ã¾ã—ãŸã€‚ ã§ã‚‚æ¯Žå›žã“ã‚Œã‚’ã‚„ã‚‹ã®ãŒé¢å€’ã«ãªã£ã¦ããŸã®ã§ã€ãªã‚“ã¨ã‹ãªã‚‰ã‚“ã‹ãªãƒ¼ã¨æ€ã£ã¦ã€Rewrit eMapã«åˆæŒ‘æˆ¦ã—ã¦ã¿ãŸã€‚ Rewrit eMapä½¿ãˆã°RewriteCondã¨ã‹RewriteRuleã«ãƒ—ãƒã‚°ãƒ©ãƒ ã®å‡ºåŠ›çµæžœã‚’ä½¿ã†ã“ã¨ãŒå‡ºæ¥ã‚‹ã‚ˆã†ã«ãªã‚‹ã®ã§ã€ã“ã‚Œã§Webã‚µãƒ¼ãƒãƒ¼ã®ãƒãƒ¼ãƒ‰ã‚¢ãƒ™ãƒ¬ãƒ¼
puchiban 2008/11/27
performance

mod_rewrite

è² è·åˆ†æ•£

è² è·å¯¾ç–

Apache

tips
ãƒªãƒ³ã‚¯
1