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

moqada id:moqada

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

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

Linuxã‚«ãƒ¼ãƒãƒ«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒ¡ãƒ¢ - é›»åæ›¸ç±ã¨è¶£å‘³ã®éƒ¨å±‹
Post navigation â† Previous Home > Webé–¢é€£ > é–‹ç™º > Linux > Linuxã‚«ãƒ¼ãƒãƒ«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒ¡ãƒ¢ Linuxã‚«ãƒ¼ãƒãƒ«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒ¡ãƒ¢ ã‚µãƒ¼ãƒãƒ¼å‘ã‘ã«Linuxã‚«ãƒ¼ãƒãƒ«ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã£ãŸéš›ã®ãƒ¡ãƒ¢ã§ã™ã€‚ è¨å®šå†…å®¹ ä»Šå›žè¡Œã£ãŸ /etc/sysctl.conf ã®è¨å®šå†…å®¹ã¯æ›¸ãã®é€šã‚Šã§ã™ã€‚ å„ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®èª¬æ˜Žã¯ã‚³ãƒ¡ãƒ³ãƒˆã¨ã—ã¦æ®‹ã—ã¦ãŠãã¾ã™ã€‚ # å…±æœ‰ãƒ¡ãƒ¢ãƒªã®æœ€å¤§ã‚µã‚¤ã‚ºã€‚ã‚µãƒ¼ãƒãƒ¼ã®æè¼‰ãƒ¡ãƒ¢ãƒª(1GB)ã«åˆã‚ã›ã¦å¤‰æ›´ kernel.shmmax = 1073741824 # ã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã®å…±æœ‰ãƒ¡ãƒ¢ãƒªãƒ»ãƒšãƒ¼ã‚¸ã®æœ€å¤§æ•° kernel.shmall = 262144 # ã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã®ãƒ—ãƒã‚»ã‚¹æ•°ã®ä¸Šé™ kernel.threads-max = 1060863 # ã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã®ãƒ•ã‚¡ã‚¤ãƒ«ãƒ‡ã‚£ã‚¹ã‚¯ãƒªãƒ—ã‚¿ã®ä¸Šé™ fs.file-max = 5242880
moqada 2014/01/22
performance

tuning
ãƒªãƒ³ã‚¯
å…¨è‡ªå‹•ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã•ã‚“
2013/02/18 Yahoo! Open Hack Day å‚åŠ ä½œå“ KLabè³ž å—è³ž ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ã“ã¡ã‚‰: https://github.com/mirakui/tuningsan èª¬æ˜Ž: http://blog.mirakui.com/entry/2013/02/20/003401
moqada 2013/02/19
presentation

tuning

performance
ãƒªãƒ³ã‚¯
MySQLã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ« my.cnf ã‚’githubã«ã¦å…¬é–‹ã—ã¾ã—ãŸ & ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒã‚¤ãƒ³ãƒˆã®ç´¹ä»‹ - blog.nomadscafe.jp
YAPC::Asiaã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§äºˆå‘Šã—ã¦ã„ãŸé€šã‚Šã€å®Ÿéš›ã«å¼Šç¤¾ã®ã„ãã¤ã‹ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã£ã¦ã„ã‚‹ my.cnf ã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ github: https://github.com/kazeburo/mysetup/tree/master/mysql ä»Šå›žã€å…¬é–‹ã—ãŸç†ç”±ã¯MySQl Beginners Talksã®ç™ºè¡¨ã®ä¸ã§ã‚‚è§¦ã‚Œã¦ã„ã‚‹é€šã‚Šã§ã™ã€‚MySQLã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ä¸ã«å«ã¾ã‚Œã‚‹ã‚µãƒ³ãƒ—ãƒ«ã®my.cnfãŒæœ€è¿‘ã®ã‚µãƒ¼ãƒãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„é‹ç”¨ã«åˆã‚ãªããªã£ã¦æ¥ã¦ã„ã‚‹ã¨ã„ã†çŠ¶æ³ã§ã€è‡ªåˆ†ã®è¨å®šã«ã‚¤ãƒžã‚¤ãƒè‡ªä¿¡ãŒæŒã¦ã¦ã„ãªã„äººã¯å°‘ãªããªã„ã¯ãšã€‚ãã“ã§å„ç¤¾ç§˜ä¼ã®ã‚¿ãƒ¬çš„ãª my.cnf ã‚’Open & Shareã™ã‚‹ã“ã¨ã§ã€ãƒ¢ãƒ€ãƒ³ãªmy.cnfã‚’ä½œã‚Šä¸Šã’ã‚‹äº‹ãŒã§ãã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ã¨ã„ã†è€ƒãˆã®ä¸‹ã€ä»Šå›ž github ã«ã¦å…¬é–‹ã—ã¾ã—ãŸã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã¯4ã¤ã‚ã‚Šã€ãã‚Œãžã‚Œ MySQL 4.0ã€5.1ã€5.5ã€ãã—ã¦ãƒ†ã‚¹ãƒˆä¸
moqada 2012/10/17
mysql

tuning
ãƒªãƒ³ã‚¯
ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ãƒ¼MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœï¼ˆã‚¯ã‚¨ãƒªç·¨ï¼‰ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ãƒ¼MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœï¼ˆã‚¯ã‚¨ãƒªç·¨ï¼‰ ã“ã‚“ã«ã¡ã¯ã€ã‚¤ãƒ³ãƒ•ãƒ©æ‹…å½“æ–°äººã® nob ã§ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼ç›£è¦–ãƒ„ãƒ¼ãƒ«ã§ MySQL ã‚’ç›£è¦–ã—ã¦ã„ã‚‹ã®ã«ãƒ‡ãƒ¼ã‚¿ãŒå¤šã™ãŽã¦æ´»ç”¨ã—ã¦ã„ãªã„ã€‚ã¨ã„ã†æ–¹ã¯ã„ã¾ã›ã‚“ã‹ï¼Ÿãã®è±Šå¯Œãªãƒ‡ãƒ¼ã‚¿ã‚’ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ´»ç”¨ã—ãªã„æ‰‹ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ä»Šå›žã¯ã‚µãƒ¼ãƒãƒ¼ç›£è¦–ãƒ„ãƒ¼ãƒ«ã®ã‚°ãƒ©ãƒ•ã‚’èªã¿è§£ã„ãŸå®Ÿæˆ¦çµŒé¨“ã‚’å…ƒã«ã€ã€Œã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ã€ã¨ã„ã†ãƒ„ãƒœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ã€€ã‚¯ã‚¨ãƒªç·¨ã€€ï¼“ã¤ã®ã¤ã¼ã¨ï¼•ã¤ã®ã‚°ãƒ©ãƒ• ï¼ˆãã®ï¼‘ï¼‰ç›£è¦–ãƒ„ãƒ¼ãƒ«ãŒä½•ã‚’è¦‹ã¦ã„ã‚‹ã®ã‹çŸ¥ã‚‹ ï¼ˆãã®ï¼’ï¼‰ç›£è¦–ã®ã‚ãƒ¢ã€ã‚°ãƒ©ãƒ•ï¼“ç‚¹ã‚»ãƒƒãƒˆ (Questions, Lock Waits ã¨ Transaction Handler) ï¼ˆãã®ï¼“ï¼‰ã‚°ãƒ©ãƒ•ã§ãƒã‚§ãƒƒã‚¯ã™ã‚‹ SQL ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ( Select Type ã¨ Handler) ã‚·ãƒ³ãƒ—ãƒ«ã§ãŠå‹§ã‚ã€ã‚µãƒ¼ãƒãƒ¼ç›£è¦–ã‚°ãƒ©ãƒ•åŒ–ãƒ„ãƒ¼ãƒ«
moqada 2012/03/28
mysql

tuning
ãƒªãƒ³ã‚¯
[PDF]MySQL AB - MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚ˆãã‚ã‚‹è½ã¨ã—ç©´ æ¾ä¿¡ å˜‰ç¯„
1 Copyright 2009 Sun Microsystems inc The Worldâ€™s Most Popular Open Source Database MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ ã‚ˆãã‚ã‚‹è½ã¨ã—ç©´ æ¾ä¿¡ å˜‰ç¯„ (MATSUNOBU Yoshinori) Principal MySQL Consultant, Sun Microsystems yoshinori.matsunobu@gmail.com 2 Copyright 2009 Sun Microsystems inc The Worldâ€™s Most Popular Open Source Database ãƒ†ãƒ¼ãƒž â€¢ ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢é¸å®šã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³é¸å®š â€¢ ãƒãƒ¼ãƒ‰ãªã©ã®æ›´æ–°å‡¦ç†ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ”¹å–„ â€“ ä»Šæ—¥ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ãƒ¡ã‚¤ãƒ³ â€¢ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ â€¢ å…¨æ–‡æ¤œç´¢ â€¢ ãã®ä»– 3 Copyright 20
moqada 2011/12/27
mysql

tuning
ãƒªãƒ³ã‚¯
DSAS for Social ã§ã® MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ä»Šå¾Œã®æ–¹é‡ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
KLab Advent Calendar 2011 ã€ŒDSAS for Social ã‚’æ”¯ãˆã‚‹æŠ€è¡“ã€ã®5æ—¥ç›®ã§ã™ã€‚ @methane ã«ã‚ˆã‚‹ MySQL ã‚’éª¨ã¾ã§ã—ã‚ƒã¶ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚·ãƒªãƒ¼ã‚º (ã‚·ãƒªãƒ¼ã‚ºåã¯ä»Šè€ƒãˆã¾ã—ãŸ)ã®ã¾ã¨ã‚ã¨ã—ã¦ã€ç¾åœ¨ã® DSAS for Social ã® MySQL ã®ãƒªã‚¢ãƒ«ãªæ€§èƒ½å€¤ã‚„ç›´é¢ã—ã¦ã„ã‚‹ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’èµ¤è£¸ã€…ã«å…¬é–‹ ã—ã¦ã—ã¾ã„ã¾ã™ã€‚ innodb_io_capacity ã‚’å¢—ã‚„ãã† æœ¬é¡Œã«å…¥ã‚‹å‰ã«ã€ã¾ã ç´¹ä»‹ã—ã¦ãªã„ã‘ã©1è¨˜äº‹ã«ã™ã‚‹ã»ã©ã§ã¯ãªã‹ã£ãŸ ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ç´¹ä»‹ã—ã¦ãŠãã¾ã™ã€‚ innodb_io_capacity ã¯ã€ InnoDB ã«æ•™ãˆã‚‹ãƒ’ãƒ³ãƒˆã§ã€ Disk ã® IO/sec ã‚’æŒ‡å®šã—ã¾ã™ã€‚ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ã€é€šå¸¸ã®HDDã§ã‚‚ä½¿ãˆã‚‹ã‚ˆã†ã«ä¸é€”åŠç«¯ãªå€¤(ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã£ã¦100ã‹200) ã«ãªã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€BBUä»˜ããƒãƒƒãƒ•ã‚¡ãŒã‚ã‚‹RAIDã‚«ãƒ¼ãƒ‰ã‚’ä½¿ã†ãª
moqada 2011/12/16
mysql

tuning
ãƒªãƒ³ã‚¯
Apache ã®ä¸¦åˆ—æ•°ã‚’ CPU ã‚³ã‚¢æ•°ã«å¿œã˜ã¦æ±ºå®šã™ã‚‹ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
KLab Advent Calendar 2011 ã€ŒDSAS for Social ã‚’æ”¯ãˆã‚‹æŠ€è¡“ã€ã®10æ—¥ç›®ã§ã™ã€‚ æ˜¨æ—¥ã®è¨˜äº‹ ã§ã¯ä¸¦åˆ—æ•°ã‚’è¨å®šã™ã‚‹åŸºæœ¬çš„ãªæ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ä»Šæ—¥ã¯å®Ÿéš›ã« DSAS for Social ã§åˆ©ç”¨ã—ã¦ã„ã‚‹è¨å®šæ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ èƒŒæ™¯ å®Ÿéš›ã®ä¸¦åˆ—æ•°ã®è¨å®šã¯ãƒžã‚·ãƒ³ã®CPUã‚¹ãƒšãƒƒã‚¯ã‚„ã‚¢ãƒ—ãƒªã®ç‰¹æ€§(ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚¿ã‚¤ãƒ ã® ä½•å‰²ã‚’Webã‚µãƒ¼ãƒãƒ¼ã®CPUã‚’ä½¿ã†å‡¦ç†ãŒå ã‚ã¦ã„ã‚‹ã‹)ã«å¿œã˜ã¦è¨å®šã™ã‚‹ã®ã§ã™ãŒã€ DSAS for Social ã§ã¯ã‚¢ãƒ—ãƒªã®è² è·ã«å¿œã˜ã¦æŸ”è»Ÿã«Webã‚µãƒ¼ãƒãƒ¼ã‚’ è¿½åŠ ãƒ»å‰Šé™¤ã™ã‚‹ã®ã§ã€CPUã‚¹ãƒšãƒƒã‚¯ãŒä¸€å®šã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ å…·ä½“çš„ã«è¨€ãˆã°ã€ Core2 ä¸–ä»£ã®4ã‚³ã‚¢ã‚µãƒ¼ãƒãƒ¼ã¨ã€Core i7ä¸–ä»£ã®4ã‚³ã‚¢8ã‚¹ãƒ¬ãƒƒãƒ‰ ã‚µãƒ¼ãƒãƒ¼ãŒ Web ã‚µãƒ¼ãƒãƒ¼ã¨ã—ã¦åˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã§ã‚‚ã€Webã‚µãƒ¼ãƒãƒ¼ã”ã¨ã«é•ã†è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”¨æ„ã—ãŸãã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ãªã‚“ã¨ã‹ã§ããªã„
moqada 2011/12/16
apache

tuning
ãƒªãƒ³ã‚¯
MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - ãƒ¢ãƒŽãƒŽãƒ•æ—¥è¨˜
ã¨ã‚ã‚‹å‹‰å¼·ä¼šã§Sunã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®äººã®ãƒ—ãƒ¬ã‚¼ãƒ³ã‚’ç›´æŽ¥èžãæ©Ÿä¼šãŒã‚ã£ãŸã®ã§ãƒ¡ãƒ¢ã£ãŸã“ã¨ã‚’å…¬é–‹ã—ã¾ã™ã€‚åŸºæœ¬çš„ãªäº‹ãŒå¤šã„ã‚“ã ã‚ã†ã‘ã©ã€éžå¸¸ã«å‚è€ƒã«ãªã‚Šã¾ã—ãŸã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã¯ ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆ ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚¿ã‚¤ãƒ /ãƒ¬ã‚¤ãƒ†ãƒ³ã‚· ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ ä¸Šè¨˜ã®ã‚³ãƒ³ãƒ“ãƒãƒ¼ã‚·ãƒ§ãƒ³ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨ã¯ Connection Thread Pool Query Cache Parser SQLã‚¯ã‚¨ãƒªã‚’ãƒ‘ãƒ¼ã‚¹ Optimizer Storage Engines ã‚¢ãƒ—ãƒªã«ã‚ˆã£ã¦æœ€é©ãªã‚¨ãƒ³ã‚¸ãƒ³ã‚’é¸æŠžã™ã¹ã ã‚µãƒ¼ãƒã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³&ã‚¹ãƒ¬ãƒƒãƒ‰ my.cnf max_connection (100) å¤šã™ãŽã‚‹ã¨ãƒ¡ãƒ¢ãƒªã‚’æ¶ˆè²»ã—ãã‚‹å¯èƒ½æ€§ã‚ã‚Š thread_cache_size (8) ã‚¹ãƒ¬ãƒƒãƒ‰ã‚’ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã®åˆ‡æ–å¾Œã«ã‚‚ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ãŠãæ•° ä¸€èˆ¬çš„ã«ã¯ max_connections / 3 sort_buffer_size(2M)
moqada 2011/12/15
mysql

tuning

performance
ãƒªãƒ³ã‚¯
Apacheã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã‚’èª¿ã¹ã‚‹ - With-No-Parachute D-side
ã“ã®è¨˜äº‹ã¯å¼•ã£è¶Šã—ã—ã¾ã—ãŸã€‚ http://blog.satooshi.jp/blog/2009/12/09/monitoring-memory-usage-of-apache/
moqada 2011/12/15
apache

tuning
ãƒªãƒ³ã‚¯
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã§å„ªå‹ã—ã¦ãã¾ã—ãŸ : 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ã¨é•ã£ã¦çµæ§‹æ–°ã—ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç”¨
moqada 2011/12/15
apache

mysql

tuning
ãƒªãƒ³ã‚¯
å®ŸéŒ²MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° æ˜¥ã®é™£ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
long_query_time = 0.5 ã¨ã‹é–¾å€¤ã‚’å°ã•ã‚ã«ã—ã¦ã‚‚ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãŒå‡ºãªããªã£ãŸã‘ã©ã€CPU(user)ä½¿ç”¨çŽ‡é«˜ã„ã¨ã‹ã€ãªã‚“ã‹è¶³å¼•ã£å¼µã£ã¦ã‚‹ã‚¯ã‚¨ãƒªãŒã‚ã‚‹ã£ã½ã„ãªãã¨ã„ã†å ´åˆã®ãŠè©±ã§ã™ã€‚ ã€Œå®ŸéŒ²ã€ã®é€šã‚Šã€ç¾åœ¨çµ¶è³›é€²è¡Œä¸ã§ã™ã®ã§ã€é€æ¬¡å‹•ããŒã‚ã£ãŸã‚‰æ›¸ãè¶³ã—ã¦ã„ãã¤ã‚‚ã‚Šã§ã™ã€‚ ã€Œã‚ã‚Œã‚’è¦‹ãŸæ–¹ãŒã„ã„ã€ã¨ã‹ã€Œã“ã‚Œã‚’ã‚ãƒ¼ã—ãŸæ–¹ãŒã„ã„ã€ã¨ã‹ã‚ã‚Œã°ã€ã‚³ãƒ¡ãƒ³ãƒˆã‹Twitterã§ @hirose31 ã¾ã§ãŠçŸ¥ã‚‰ã›ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ï¼ ä½¿ç”¨ã—ã¦ã„ã‚‹ã®ã¯ã€MySQL 5.1.41 ã§ã™ã€‚ å‰æ: ã‚µãƒ¼ãƒãƒ¼ãƒªã‚½ãƒ¼ã‚¹ã®ã‚°ãƒ©ãƒ• Gangliaã§ã‚‚Cactiã§ã‚‚Muninã§ã‚‚ãªã‚“ã§ã‚‚ã„ã„ã‚“ã§ã™ãŒã€ã‚µãƒ¼ãƒãƒªã‚½ãƒ¼ã‚¹ã®ã‚°ãƒ©ãƒ•åŒ–ã¯å¿…é ˆã§ã™ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ãŸéš›ã®åŠ¹æžœæ¸¬å®šã‚„ã€ãã‚ãã‚ãƒªã‚½ãƒ¼ã‚¹é£Ÿã„æ½°ã—ã¦ã‚„ã°ã„ã¨ã‹ã®äºˆæ¸¬ã«ã‚‚ä½¿ãˆã¾ã™ã€‚ è‡ªåˆ†ã¯DBã‚µãƒ¼ãƒã®å ´åˆã“ã®ã‚ãŸã‚Šã‚’ã‚°ãƒ©ãƒ•åŒ–ã—ã¦ã¾ã™ã€‚ CPUä½¿ç”¨çŽ‡ (user,
moqada 2011/12/15
mysql

tuning
ãƒªãƒ³ã‚¯
MySQL åˆã‚ã¦ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
2. è‡ªå·±ç´¹ä»‹ â€¢ id:Craftworks â€¢ Twitter: @Craftworks â€¢ github: https://github.com/Craftworks â€¢ Blog: http://d.hatena.ne.jp/Craftworks â€¢ æœ€è¿‘ã¯ EC2 ã§ Perl æ›¸ã„ã¦ã¾ã™ â€¢ ãšã£ã¨ PostgreSQL ã‚’ä½¿ã£ã¦ã„ãŸ MySQL åˆå¿ƒè€…ã§ã™
moqada 2011/12/15
mysql

presentation

tuning
ãƒªãƒ³ã‚¯
1