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

yadokari23 id:yadokari23

mysqlã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹yadokari23ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

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

WEBã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’å§‹ã‚ã‚‹ - Mandy Code
ã•ã¦ISUCON2ã‚‚è¿‘ã¥ã„ã¦ã„ã‚‹ã“ã¨ã§ã™ã—ã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’é¡Œæã«ä»Šå®Ÿéš›ã«WEBã‚¢ãƒ—ãƒªã‚’ä½œã‚‹ä¸ã§è¡Œãªã£ã¦ã„ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åˆæ©ã«ã¤ã„ã¦æ›¸ã„ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãšã€åƒ•ã¯ã‚‚ã®ã™ã”ãMySQLã«è©³ã—ã„ã‚ã‘ã§ã‚‚ã‚‚ã®ã™ã”ãPerlã‚„PHPã«ç²¾é€šã—ã¦ã„ã‚‹ã‚ã‘ã§ã‚‚ãªã„ã€ã¨ã„ã†å‰æãŒã‚ã‚Šã€è‡ªåˆ†ã§è€ƒãˆãŸã‚Šå°‘ãªã„ãªãŒã‚‰ã‚‚çµŒé¨“ã—ãŸã“ã¨ã‚’ã‚‚ã¨ã«ã—ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’é€²ã‚ã¦ãŠã‚Šã¾ã™ã€‚ ãã®ä¸ã§è¦šæ›¸çš„ã«ã€èª°ã§ã‚‚ã„ã¾ã™ãå‡ºæ¥ã‚‹æ¸¬å®šæ–¹æ³•ãªã©ã‚’æ›¸ã„ã¦ãŠã“ã†ã‹ãªãƒ¼ã¨æ€ã„ã¾ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¯ã‚‚ã®ã™ã”ãå¤§ããåˆ†ã‘ã¦2ç¨®é¡žã‚ã‚Šã¾ã™ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ã‚¤ãƒ³ãƒ•ãƒ©ãƒ¬ã‚¤ãƒ¤ãƒ¼ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ã¾ãšã¯ã“ã®2ã¤ãŒåŠ¹æžœçš„ãªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãªã‚Šã¾ã™ã€‚ ã“ã®ä¸ã§ã‚‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ã»ã†ãŒçµ¶å¤§ãªåŠ¹æžœã‚’ã‚ã’ã‚‹ã“ã¨ãŒå¤šã„ã€ã¨YAPCã§fujiwaraã•ã‚“ãŒãŠã£ã—ã‚ƒã£ã¦ã„ã¾ã—ãŸã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ã§ã¯WEBã‚¢ãƒ—ãƒªã‚±
yadokari23 2012/10/26
ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ»IT

MyInterest

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

mysql

tuning

ã‚µãƒ¼ãƒ

webapp
ãƒªãƒ³ã‚¯
è§£æžã¾ã§10åˆ†ï¼æœ€å¼·ã®MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã€ŒJet Profilerã€ - Lancersé–‹ç™ºãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€keiã§ã™ã€‚ ä»Šå›žã¯ã€MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«å¤§æ´»èºãªã€ŒJet Profilerã€ã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ Jet Profilerã¨ã¯ Jet Profilerã¯ã€MySQLå‘ã‘ã®ã‚¯ã‚¨ãƒªã‚¢ãƒŠãƒ©ã‚¤ã‚¶ã§ã™ã€‚ ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¯ã€DBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä¸ã§ã‚‚é‡è¦ãªä½œæ¥ã®1ã¤ã§ã™ãŒã€ Jet Profilerã‚’ä½¿ãˆã°ã€ãã®ä½œæ¥ã‚’GUIã§ç›´æ„Ÿçš„ã«è¡Œã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ•ãƒªãƒ¼ã‚¦ã‚§ã‚¢ã®å½¢æ…‹ã§æä¾›ã•ã‚Œã¦ãŠã‚Šã€æ©Ÿèƒ½é™å®šç‰ˆã§ã‚ã‚Œã°ç„¡æ–™ã§åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ è³¼å…¥ã™ã‚‹å ´åˆã¯ã€$499ã¨ãªã‚Šã¾ã™ã€‚ è©³ç´°æƒ…å ±ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯å…¬å¼ãƒšãƒ¼ã‚¸ã‹ã‚‰ã©ã†ãžã€‚ http://www.jetprofiler.com/ja/ Jet Profilerã®é…åŠ› ãã®1ã€€å°Žå…¥ã®ã—ã‚„ã™ã• é€šå¸¸ã®Windowãƒžã‚·ãƒ³ã«ã€æ™®é€šã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ„Ÿè¦šã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒå¯èƒ½ã§ã™ã€‚ ã‚¤ãƒ³
yadokari23 2012/08/25
ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ»IT

MyHotentry

mysql

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

DB

performance

database
ãƒªãƒ³ã‚¯
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ç¬¬3å¼¾ã§å„ªå‹ã—ã¾ã—ãŸ!
3/24æ—¥ã®ç¬¬ä¸‰å¼¾ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚¬ã‚½ãƒ³ã«å‚åŠ ã—ãŸã®ã§ã€ãã®è©³ç´°ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ ãƒ„ãƒƒã‚³ãƒŸå¤§æ“è¿Žã§ã™ï¼ï¼ï¼ ä»Šå›žç¦å²¡ã§ã‚‚ãƒªãƒ¢ãƒ¼ãƒˆã§å‚åŠ å¯èƒ½ã ã¨èžã„ã¦ã€ã“ã‚Œã¯å‚åŠ ã›ãã°ã¨æ€ã„ã‚¨ãƒ³ãƒˆãƒªã—ã¾ã—ãŸã€‚ åŸºæœ¬ã¼ã£ã¡ãªã‚“ã§ä¸€äººã§å‚åŠ ã€‚ ~å‰æ—¥ç¦å²¡ã®ã‚¤ãƒ³ãƒ•ãƒ©å‹‰å¼·ä¼šã§ä¸€åº¦ã€å‚¾å‘ã¨å¯¾ç–çš„ãªã“ã¨ã‚’ã—ã¦ã¾ã—ãŸã€‚ ã“ã“ã§ã¯ã€ä¸»ã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é …ç›®ã®æ´—ã„å‡ºã—ã¨ã€æ¬¡ã®ãŠé¡Œã®äºˆæƒ³ã—ã¦ã¾ã—ãŸã€‚ ç§ã®äºˆæƒ³ã§ã¯ã€webã‚µãƒ¼ãƒãƒ¼ã«nginxã€appã«redmineã˜ã‚ƒãªã„ã‹ã¨äºˆæƒ³ã—ã¦ã¾ã—ãŸã€‚ã€‚ã€‚ ã‚ã¨ã¯ã€å‰å›žã¾ã§ãŒphpãŒãŠé¡Œã ã£ãŸã®ã§ã€phpè§¦ã£ãŸäº‹ç„¡ã„ã®ã§apcã‚¤ãƒ³ã‚¹ã‚³ã™ã‚‹æ‰‹é †ã¨ã‹ã‚’ä¸€å¿œäºˆç¿’ã€‚ (çµå±€ã€å…¨ãå½¹ã«ç«‹ãŸãªã‹ã£ãŸã®ã§ã™ãŒãƒ»ãƒ»ãƒ»ãƒ») ãã®ä»–ã«ã‚‚ã€apacheã‚„mysqlã®è¨å®šã‚’å‹‰å¼·ã—ã¦ã¾ã—ãŸã€‚ msqlã®å‹‰å¼·ã§æœ€å¾Œã®ç ¦ã¨ã—ã¦èªã‚“ã ã®ãŒâ†“ã§ã™ã€‚ ã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã‚ˆãƒ¼ ã‚ã¨ã€ä»Šå›žå¿…ãšä½¿ãŠã†ã¨æ€ã£ã¦ã„ãŸã®ãŒã€dstatã§ã—ãŸã€‚ dst
yadokari23 2012/03/29
ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãƒ»IT

ByMyFav

performance

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

tuningathon

mysql

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

ByMyFav

MySQL

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

Index

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

ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹
ãƒªãƒ³ã‚¯
1