[B! ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°] n314ã®ãƒ

n314 id:n314

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹n314ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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ã®ãŠæ‰‹è»½ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - ã‚ãƒ¼ãã‚ã†ã¨ï¼
ã“ã¡ã‚‰ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§æ›¸ã„ã¦ã„ã‚‹ã®ã§ã™ãŒã€é–‹ç™ºç”¨ã®VPSé¯–ãŒãƒ¡ãƒ¢ãƒªä½¿ã„éŽãŽã§é‡ããªã£ã¦ã„ã¦ã€mysqlã«å•é¡ŒãŒã‚ã‚Šãã†ã ã£ãŸã®ã§ã‚µã‚¯ã£ã¨èª¿æ•´ã—ã¾ã—ãŸã€‚ ãã®æ‰‹é †ã‚’æ®‹ã—ã¦ãŠãã¾ã™ã€‚ MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é …ç›®ã«ã¤ã„ã¦èª¬æ˜Ž MySQLã®ãƒ¡ãƒ¢ãƒªã«é–¢ã™ã‚‹è¨å®šé …ç›®ã¯ãŸãã•ã‚“ã‚ã‚Šã¾ã™ã€‚ ãã‚Œãžã‚Œã®é …ç›®ã«é–¢ã—ã¦ã®è©³ã—ã„æƒ…å ±ã¯ä¸‹è¨˜ãŒå‚è€ƒã«ãªã‚Šã¾ã™ã€‚ http://trackback.blogsys.jp/livedoor/klab_gijutsu2/50860867 ãŸã ã€ã“ã‚Œã‚‰ã‚’å…¨ã¦æŠŠæ¡ã™ã‚‹ã®ã¯å¤§å¤‰ã ã¨æ€ã†ã®ã§ã€ç°¡å˜ã«åˆ†é¡žã™ã‚‹ã¨ä»¥ä¸‹ã®2ç¨®é¡žãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã§ã€MySQLãŒä½¿ã†ãƒ¡ãƒ¢ãƒªé‡ã¯ä¸‹è¨˜ã«ãªã‚‹ã‚ã‘ã§ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ + ( ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ * ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³æ•° ) ãã‚Œã‚‰ã‚’è¸ã¾ãˆãŸä¸Šã§å…·ä½“çš„ãªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«å…¥ã‚Šã¾ã™ã€‚ MySQLã§ä½¿ã£ã¦ã„ã‚‹ãƒ¡ãƒ¢ãƒªé‡ã‚’èª¿ã¹ã‚‹
n314 2015/03/31
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
ç¬¬5å›žã€€MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼ˆ4ï¼‰ã€€SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°åŸºç¤Ž | gihyo.jp
ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã®å‡ºåŠ›ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã•ã‚Œã¾ã™ã€‚log_outputã‚’TABLEã«è¨å®šã™ã‚‹ã¨ã€mysqlãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®slow_logãƒ†ãƒ¼ãƒ–ãƒ«ã«å‡ºåŠ›ã•ã‚Œã¾ã™ã€‚ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã§ã€ŒFILE,TABLEã€ã¨è¨å®šã™ã‚‹ã¨ã€slow_logãƒ†ãƒ¼ãƒ–ãƒ«ã¨ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®ä¸¡æ–¹ã«å‡ºåŠ›ã•ã‚Œã¾ã™ã€‚ãªãŠã€log_outputã¯ä¸€èˆ¬ãƒã‚°ï¼ˆGeneral Logï¼‰ã¨ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã®ä¸¡æ–¹ã«å½±éŸ¿ã—ã¾ã™ã®ã§æ³¨æ„ã—ã¦ãã ã•ã„ã€‚ slow_logãƒ†ãƒ¼ãƒ–ãƒ«ã¯CSVã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ãŸã‚ã€CSVå½¢å¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦å„ç¨®ã®ãƒ„ãƒ¼ãƒ«ã§é›†è¨ˆã‚‚å¯èƒ½ã§ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã«å‡ºåŠ›ã—ã¦ã„ã‚‹å ´åˆã®mysqldumpslowã«é¡žä¼¼ã—ãŸé›†è¨ˆã¯ä¸‹è¨˜ã®SQLæ–‡ã§å¯èƒ½ã§ã™ã€‚ å›³2ã€€mysql.slow_logãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰mysqldumpslowåŒç‰ã®é›†è¨ˆã‚’è¡Œã†SQLæ–‡ mysql> SELECT
n314 2015/03/31
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
è¶…ä¼šè°3ã®è¶…ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç¥ã®æ„Ÿæƒ³
ã•ã¦ã€è¶…ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç¥ãŒçµ‚ã‚ã£ãŸã®ã§ã€æ„Ÿæƒ³ã‚’æ›¸ã“ã†ã¨æ€ã†ã€‚ã™ã§ã«ã€å‚åŠ è€…ã®ä¸ã§ã€æ„Ÿæƒ³ã‚’æ›¸ã„ã¦ã„ã‚‹äººã‚‚ã„ã‚‹ã€‚ ãƒ¬ãƒãƒ¼ãƒˆ - è¶…ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç¥ã§åŠªåŠ›è³ž(æœ€é€Ÿè³ž)ã‚’ã¨ã‚‹ãŸã‚ã«ã‚„ã£ãŸã“ã¨ - Qiita ãƒ‹ã‚³å‹• è¶…ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç¥ã§æœ€å„ªç§€è³žã‚‚ã‚‰ã„ã¾ã—ãŸ è¶…ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç¥ã«å‚åŠ ã—ãŸ - masarakki's blog JavaScript - è¶…ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç¥ã«å‚åŠ ï¼†è¡¨å½°ã—ãŸ - Qiita kmizu/slide_cho_tuning ã¾ãŸã€ã„ã¤ã®é–“ã«è¡Œã£ãŸã®ã‹ã€å„ªå‹è€…ã«å–æã—ãŸã¨ã“ã‚ã‚‚ã‚ã‚‹ã‚‰ã—ã„ã€‚ ã€Žãƒ‹ã‚³è¶…3ã€ã®è¶…ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç¥ã§ã€â€œå‰µä¸–ç¥žâ€æˆ€å¡šæ˜å½¦æ°ã‚’ä¸Šå›žã£ãŸã‚«ãƒƒãƒ—ãƒ«ãŒè¦‹ã›ãŸãƒãƒ©ãƒ³ã‚¹æ„Ÿè¦š - ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢type ã•ã¦ã€ç†è€…ã®è¦–ç‚¹ã‹ã‚‰ã¿ãŸè¶…ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç¥ã¯ã©ã†ã ã£ãŸã‹ã€‚ ãã‚‚ãã‚‚ã€ç§ãŒã‚¹ã‚¿ãƒƒãƒ•ã¨ã—ã¦é…ç½®ã•ã‚Œã‚‹ãƒ–ãƒ¼ã‚¹ã¯ã€è¶…æ™‚ç©ºãƒ‹ã‚³ãƒ‹ã‚³ç ”ç©¶æ‰€ã§ã‚ã‚‹ã¯ãšã ã£ãŸã€‚ã—ã‹ã—ã€è¶…ä¼šè°ã«ã•ã‹ã®ã¼ã‚‹ã“ã¨ä¸‰é€±é–“å‰ã€
n314 2014/04/30
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

javascript

html
ãƒªãƒ³ã‚¯
MySQL 5.1ã®mysqldumpslowã§å¿«é€Ÿãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - SH2ã®æ—¥è¨˜
MySQL 5.1ã®mysqldumpslowã‚’ä½¿ã†ã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãŒæ¥½ã«ãªã‚‹ï¼ã¨ã„ã†è©±é¡Œã§ã™ã€‚ mysqldumpslowã¯ã‚‚ã¨ã‚‚ã¨MySQLã«ä»˜å±žã—ã¦ã„ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã€ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚’é›†è¨ˆã—ã¦ãã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ã“ã‚Œè‡ªä½“ã¯MySQL 5.1ã§ç‰¹ã«å¤‰ã‚ã£ãŸã¨ã“ã‚ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°æœ¬ä½“ã®æ–¹ãŒæ©Ÿèƒ½å¼·åŒ–ã•ã‚Œã¦ã„ã‚‹ãŸã‚ã€çµ„ã¿åˆã‚ã›ã‚‹ã¨ãªã‹ãªã‹ä¾¿åˆ©ã«ãªã£ã¦ã„ã¾ã™ã€‚MySQL 5.1ã«ãŠã‘ã‚‹ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã®ä¸»ãªæ©Ÿèƒ½å¼·åŒ–ã¯ä»¥ä¸‹ã®ä¸‰ç‚¹ã§ã™ã€‚ long_query_timeã«1ç§’æœªæº€ã®å€¤ã‚’è¨å®šã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ å‡ºåŠ›å…ˆã‚’è¨å®šã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ ã“ã‚Œã‚‰ã®è¨å®šã‚’ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§å¤‰æ›´ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ ã“ã‚Œã§ã©ã†ãªã‚‹ã‹ã¨ã„ã†ã¨ã€MySQLã®æ€§èƒ½åˆ†æžã‚’ã—ãŸã„ã¨æ€ã£ãŸã¨ãã«ã€ã‚µãƒ¼ãƒã‚’æ¢ã‚ãšã«ãã®å ´ã§ mysql> set global slow_query_log = 1; mysql> set glob
n314 2014/04/15
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Apacheã¨Nginxã®æ€§èƒ½æ¯”è¼ƒã§event_mpmã®æœ¬æ°—ã‚’è¦‹ãŸ
ã¯ã„ã€ã“ã‚Œã¯åƒ•ãŒã„ã¤ã‚‚è‰¯ãè¦‹ã‚‹Apacheã¨Nginxã®æ€§èƒ½å·®ã«è¦‹ãˆã¾ã™ã€‚å¤§ä½“ã€Apacheã¯Nginxã®75%ç¨‹åº¦ã®æ€§èƒ½ã«è½ã¡ç€ãã¾ã™ã€‚æ•°åãƒã‚¤ãƒˆã®é™çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã«å¯¾ã™ã‚‹ãƒªã‚¯ã‚¨ã‚¹ãƒˆå‡¦ç†ã¯Nginxã®å¾—æ„åˆ†é‡Žã ã¨æ€ã£ã¦ã„ãŸã®ã§ã€å¤§ä½“ã“ã‚“ãªã‚‚ã®ã§ã™ã€‚ ãã“ã§ã€çœŸé¢ç›®ã«event_mpmã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã£ã¦ã¿ã¾ã—ãŸã€‚ã§ã€å¹¾åº¦ã¨ãªããƒ™ãƒ³ãƒã‚’è©¦ã—ãŸçµæžœå°Žãå‡ºã—ãŸã€é™çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã«å¯¾ã™ã‚‹åŒæ™‚æŽ¥ç¶šæ•°100ç¨‹åº¦ã«å¯¾ã—ã¦æœ€é«˜ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ç¤ºã™event_mpmã®è¨å®šã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ [program lang=â€™apacheâ€™ escaped=â€™trueâ€™] StartServers 4 MinSpareThreads 4 MaxSpareThreads 4 ThreadsPerChild 2 MaxRequestWorkers 2 MaxConnectionsPerChild 0 [/p
n314 2013/04/23
apache

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

nginx
ãƒªãƒ³ã‚¯
1