[B! tuningathon] toritori0318ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

toritori0318 id:toritori0318

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

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³5ã®å¾©ç¿’ MySQL 5.5 ãƒãƒ¼ãƒˆç·¨ï¼†å‹‰å¼·ä¼šã®ãŠçŸ¥ã‚‰ã› - SH2ã®æ—¥è¨˜
ã‚¼ãƒã‚¹ã‚¿ãƒ¼ãƒˆã®@zakiã•ã‚“ã‚’ä¸å¿ƒã«ä¼ç”»ã€é‹å–¶ã•ã‚Œã¦ã„ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆãŒã‚ã‚Šã¾ã™ã€‚æŒ‡å®šã•ã‚ŒãŸç’°å¢ƒã‚’ç”¨ã„ã¦OSã‚„ã‚µãƒ¼ãƒå‘¨ã‚Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã„ã€æ€§èƒ½ã‚’ç«¶ã†ã¨ã„ã†ã‚‚ã®ã§ã™ã€‚2013å¹´1æœˆã«è¡Œã‚ã‚ŒãŸç¬¬5å›žã§ã¯MySQLãŒãƒ†ãƒ¼ãƒžã ã£ãŸã¨ã„ã†ã“ã¨ã§ã€æœ¬æ—¥ã¯ã“ã‚Œã®å¾©ç¿’ã‚’ã—ã¦ã„ã“ã†ã¨æ€ã„ã¾ã™ã€‚ ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘ã„ã‚ã„ã‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ç«¶ã†ãƒãƒˆãƒ«ã‚¤ãƒ™ãƒ³ãƒˆï¼ã€ŒTuningathonã€ç¬¬5å¼¾ï¼ #tuningathon : ã‚¼ãƒã‚¹ã‚¿ãƒ¼ãƒˆã®åºƒå ±ãƒ–ãƒã‚° 2013å¹´æœ€åˆã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã¯MySQLï¼â€•â€•ç¬¬5å¼¾ï¼ ã„ã‚ã„ã‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ç«¶ã†ãƒãƒˆãƒ«ã‚¤ãƒ™ãƒ³ãƒˆã€Œãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã€ãƒ¬ãƒãƒ¼ãƒˆï¼šãƒ¬ãƒãƒ¼ãƒˆï½œgihyo.jp â€¦ æŠ€è¡“è©•è«–ç¤¾ Tuningathon#5 - Togetter ã—ã°ã‚‰ãçœŸé¢ç›®ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ã„ãŸã®ã§ã™ãŒæ€ã„ã®ã»ã‹é›£ã—ã‹ã£ãŸã®ã§ã€ä»Šå›žã¯ã¡ã‚‡ã£ã¨ã‚ºãƒ«ã‚’ã—ã¦å„ª
toritori0318 2013/03/04
MySQL

tuningathon
ãƒªãƒ³ã‚¯
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ç¬¬3å¼¾ã§å„ªå‹ã—ã¾ã—ãŸ!
3/24æ—¥ã®ç¬¬ä¸‰å¼¾ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã«å‚åŠ ã—ãŸã®ã§ã€ãã®è©³ç´°ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ ãƒ„ãƒƒã‚³ãƒŸå¤§æ“è¿Žã§ã™ï¼ï¼ï¼ ä»Šå›žç¦å²¡ã§ã‚‚ãƒªãƒ¢ãƒ¼ãƒˆã§å‚åŠ å¯èƒ½ã ã¨èžã„ã¦ã€ã“ã‚Œã¯å‚åŠ ã›ãã°ã¨æ€ã„ã‚¨ãƒ³ãƒˆãƒªã—ã¾ã—ãŸã€‚ åŸºæœ¬ã¼ã£ã¡ãªã‚“ã§ä¸€äººã§å‚åŠ ã€‚ ~å‰æ—¥ç¦å²¡ã®ã‚¤ãƒ³ãƒ•ãƒ©å‹‰å¼·ä¼šã§ä¸€åº¦ã€å‚¾å‘ã¨å¯¾ç–çš„ãªã“ã¨ã‚’ã—ã¦ã¾ã—ãŸã€‚ ã“ã“ã§ã¯ã€ä¸»ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é …ç›®ã®æ´—ã„å‡ºã—ã¨ã€æ¬¡ã®ãŠé¡Œã®äºˆæƒ³ã—ã¦ã¾ã—ãŸã€‚ ç§ã®äºˆæƒ³ã§ã¯ã€webã‚µãƒ¼ãƒãƒ¼ã«nginxã€appã«redmineã˜ã‚ƒãªã„ã‹ã¨äºˆæƒ³ã—ã¦ã¾ã—ãŸã€‚ã€‚ã€‚ ã‚ã¨ã¯ã€å‰å›žã¾ã§ãŒphpãŒãŠé¡Œã ã£ãŸã®ã§ã€phpè§¦ã£ãŸäº‹ç„¡ã„ã®ã§apcã‚¤ãƒ³ã‚¹ã‚³ã™ã‚‹æ‰‹é †ã¨ã‹ã‚’ä¸€å¿œäºˆç¿’ã€‚ (çµå±€ã€å…¨ãå½¹ã«ç«‹ãŸãªã‹ã£ãŸã®ã§ã™ãŒãƒ»ãƒ»ãƒ»ãƒ») ãã®ä»–ã«ã‚‚ã€apacheã‚„mysqlã®è¨å®šã‚’å‹‰å¼·ã—ã¦ã¾ã—ãŸã€‚ msqlã®å‹‰å¼·ã§æœ€å¾Œã®ç ¦ã¨ã—ã¦èªã‚“ã ã®ãŒâ†“ã§ã™ã€‚ ã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã‚ˆãƒ¼ ã‚ã¨ã€ä»Šå›žå¿…ãšä½¿ãŠã†ã¨æ€ã£ã¦ã„ãŸã®ãŒã€dstatã§ã—ãŸã€‚ dst
toritori0318 2012/03/26
tuningathon
ãƒªãƒ³ã‚¯
ã„ã‚ã„ã‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ç«¶ã†ãƒãƒˆãƒ«ã‚¤ãƒ™ãƒ³ãƒˆã«å‚åŠ ã—ã¦ããŸ - ã™ãŽã‚ƒãƒ¼ã‚“ãƒ¡ãƒ¢
å…¨ç„¶ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®çµŒé¨“ã‚„èƒ½åŠ›ãŒç„¡ã„ã‘ã‚Œã©ã€ã¨ã«ã‹ãé¢ç™½ãã†ã ã—ã‚¹ã‚´ã„ãƒ’ãƒˆãŸã¡ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°æ–¹æ³•ã‚’çŸ¥ã‚‹ã®ã¯å‹‰å¼·ã«ãªã‚Šãã†ã ã€ã¨æ€ã£ãŸã®ã§ã€å‚åŠ ã—ã¦ãã¾ã—ãŸã€‚ ã„ã‚ã„ã‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ç«¶ã†ãƒãƒˆãƒ«ã‚¤ãƒ™ãƒ³ãƒˆé–‹å‚¬ï¼ã€ŒTuningathonã€ #tuningathon on Zusaar å‡ºã•ã‚ŒãŸãŠé¡Œã¯ã€ŒAmazon EC2ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ä¸Šã§å‹•ãwordpressã¸ã®ã‚³ãƒ¡ãƒ³ãƒˆæ›¸ãè¾¼ã¿ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚‹ã€ã¨ã„ã†ã‚‚ã®ã€‚wordpressè‡ªä½“ã«æ‰‹ã‚’åŠ ãˆã‚‹ã®ã¯NGã€‚ ã¨ã„ã†ã“ã¨ã§è‡ªåˆ†ãŒæ‰‹ã‚’å‡ºã›ãã†ãªã®ã¯Apache, MySQLã®ã‚ãŸã‚Šã ã¨æ€ã£ã¦httpd.confã‚„my.cnfã‚’ã¡ã‚‡ã„ã¡ã‚‡ã„è¨å®šå€¤ã„ã˜ã£ã¦ã¿ãŸã‚Šã—ãŸã‚‚ã®ã®ã€å…¨ç„¶æ—©ããªã‚‰ãªã„â€¦ é€”æ–¹ã«æš®ã‚Œã¦ã„ãŸã¨ã“ã‚APCã£ã¦ã®ã‚’å…¥ã‚Œã‚‹ã¨ä¸€æ°—ã«æ—©ããªã‚‹ã€ã¨ã„ã†ã“ã¨ã‚’ãã„ã¦ã€ãã‚Œã‚’ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚ãã‚Œä»¥å¤–ã«ã¯ã»ã¨ã‚“ã©ä½•ã‚‚ã§ã
toritori0318 2011/07/12
tuningathon
ãƒªãƒ³ã‚¯
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã§å„ªå‹ã—ã¦ãã¾ã—ãŸ : 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ã¨é•ã£ã¦çµæ§‹æ–°ã—ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç”¨
toritori0318 2011/07/11
tuningathon

php

apache
ãƒªãƒ³ã‚¯
tuningathon #1ã«å‚åŠ ã—ã¦ãã¾ã—ãŸ
ã©ã†ã‚‚ã‚³ãƒ³ãƒ‹ãƒãƒ¯ã€‚ åŽ»ã‚‹2011.7.9ã«é–‹å‚¬ã•ã‚ŒãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°å¤§ä¼š tuningathon ã«å‚åŠ ã—ã¦ãã¾ã—ãŸã€‚ çµæžœã¯2ä½ã€‚æƒœã—ã‹ã£ãŸï¼ã™ã”ãã™ã”ãæ¥½ã—ã‹ã£ãŸã§ã™ã€‚ ã‚ˆãã‚ˆãè€ƒãˆãŸã‚‰ã†ã¡ã®ä¼šç¤¾ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆä¼æ¥ã®æ–¹ã€…ã‚‚ã„ã‚‰ã£ã—ã‚ƒã£ã¦ã„ãŸã‚Šã—ã¦ã€ã“ã‚Šã‚ƒè² ã‘ã‚‰ã‚Œãªã„ãžã€ã¨æ°—ã¥ã„ãŸã®ã¯çµæžœç™ºè¡¨ãŒåŠåˆ†ã™ãã‚‰ã„æ¸ˆã‚“ã§ã‹ã‚‰ã§ã—ãŸã€‚ ã¾ãã‚ã¾ã‚Šç´°ã‹ã„ã“ã¨ã¯æ°—ã«ã›ãšã¿ã‚“ãªå‚åŠ ã—ãŸã‚‰ã„ã„ã¨æ€ã†ã‚ˆï¼ä¿ºãŒè¨±ã™ï¼ ä¸»å‚¬ã®ã‚¼ãƒã‚¹ã‚¿ãƒ¼ãƒˆã•ã‚“ã¨æŠ€è©•ã•ã‚“ã€ä¼šå ´æä¾›ã—ã¦ã„ãŸã ã„ãŸECãƒŠãƒ“ã•ã‚“ã€ã‚µãƒ¼ãƒæä¾›ã—ã¦ã„ãŸã ã„ãŸAmazonã•ã‚“ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸï¼ ã•ã¦ã€ä»Šå›žã¯çµæžœãŒå‡ºã¦ã»ã£ã¨ã—ãŸã‚ã‘ã§ã™ãŒã€å…·ä½“çš„ã«ä½•ã‚’ã‚„ã£ãŸã®ã‹ãƒ¡ãƒ¢ã£ã¦ãŠãã¾ã™ã®ã§ã”å‚è€ƒã¾ã§ã€‚ å•é¡Œè§£æ±ºã®ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’æ™’ã™æ„å‘³ã§ã€ã‚„ã£ãŸã“ã¨ã‚’é †ç•ªã«æ›¸ã„ã¦ã¿ã¾ã™ã€‚ ã¡ãªã¿ã«ç’°å¢ƒã¯MacBook Airã§ã™ã€‚ä¼šå ´ã®ã»ã¨ã‚“ã©ã®äººãŒMacã§ã—ãŸãã€‚ ã¾ãštop,vmst
toritori0318 2011/07/10
tuningathon

apache

php

mysql
ãƒªãƒ³ã‚¯
1