[B! MySQL] rsyudouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

rsyudou id:rsyudou

MySQLã«é–¢ã™ã‚‹rsyudouã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

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

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨ã„ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã«ã¤ã„ã¦ - LukeSilviaâ€™s diary
Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Œãªã„ã‚»ãƒƒã‚·ãƒ§ãƒ³æ©Ÿæ§‹ã€‚DB ãƒ™ãƒ¼ã‚¹ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã‚’è¡Œãªã£ã¦å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã¨ã€ãã‚Œã‚’å…ƒã«è€ƒå¯Ÿã—ãŸçµæžœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã®ç‰¹æ€§ DB ã§ç®¡ç†ã•ã‚Œã‚‹ä»–ã®ãƒ‡ãƒ¼ã‚¿ã«æ¯”ã¹ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã¯ã‹ãªã‚Šç‰¹æ®Šã§ã™ã€‚ä¸»ãªç‰¹å¾´ã¯æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã€‚ ãƒ‡ãƒ¼ã‚¿ãŒå¢—åŠ ã™ã‚‹ã®ãŒé€Ÿã„ å®šæœŸçš„ãªå‰Šé™¤ãŒå¿…è¦ é »ç¹ã«æ›´æ–°ã•ã‚Œã‚‹ ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ¯Žã«èªã¿ã«è¡Œãå¿…è¦ãŒã‚ã‚‹ ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã‚ãªã„ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å…¨ä½“ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ ã‚¢ã‚¯ã‚»ã‚¹é »åº¦ãŒé«˜ã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ã¨ã€1ã¤ç›®ã®ç‰¹å¾´ã‹ã‚‰ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã¯æ„è˜çš„ã«ç®¡ç†ã—ã¦ã‚„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ç¾åœ¨ã®ç’°å¢ƒ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é ˜åŸŸãŒå°‘ã—ç‰¹æ®Šã§ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ãŒã‚„ãŸã‚‰ãŸã¾ã‚Šã¾ã™(ãƒ¦ãƒ¼ã‚¶æ•°ä½•ç™¾ä¸‡ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ãã†ã„ã†ã®ã§ã¯ãªã„ã§ã™)ã€‚ RDBMS MySQL 4.0.22 ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ InnoDB ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 6åƒä¸‡ ãƒ†ãƒ¼ã‚¿ã‚µ
rsyudou 2009/05/25
programming

MySQL
ãƒªãƒ³ã‚¯
MySQLç®¡ç†ãƒ„ãƒ¼ãƒ«ã¨é–‹ç™ºãƒ„ãƒ¼ãƒ«ã®ã¾ã¨ã‚ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
Smashing Magazine - WE SMASH YOU WITH THE INFORMATION THAT WILL MAKE YOUR LIFE EASIER, REALLY. Smashing Magazineã«ãŠã„ã¦MySQL Admin and Development Tools Round Upã®ã‚¿ã‚¤ãƒˆãƒ«ã®ã‚‚ã¨MySQLã®ç®¡ç†ãŠã‚ˆã³é–‹ç™ºã«æ´»ç”¨ã§ãã‚‹ãƒ„ãƒ¼ãƒ«ãŒã¾ã¨ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã€‚MySQLã‚’ä½¿ã£ãŸé–‹ç™ºã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚’è¡Œã£ã¦ã„ã‚‹å ´åˆã«ã¯ä¸€åº¦ãƒã‚§ãƒƒã‚¯ã—ã¦ãŠããŸã„å†…å®¹ã ã€‚ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ãƒ„ãƒ¼ãƒ«ã‚’æŠœç²‹ã™ã‚‹ã¨æ¬¡ã®ã¨ãŠã‚Šã€‚ phpMyAdmin - MySQLç®¡ç†Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ SQL Buddy - MySQLç®¡ç†Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ Aqua Data Studio - MySQLç®¡ç†ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³(é–‹ç™ºå‘ã‘æ©Ÿèƒ½å«ã‚€) (Win, OS X, Linux, Solari
rsyudou 2009/03/27
MySQL
ãƒªãƒ³ã‚¯
CodeZineï¼šDeNAã®äººæ°—ã‚µã‚¤ãƒˆã«å¦ã¶ LAMPã«ã‚ˆã‚‹Web-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/é‹ç”¨ã®æ¥µæ„ï¼ˆå‰ç·¨ï¼‰ï¼ˆãƒ¢ãƒã‚ªã‚¯, ãƒ¢ãƒã‚²ãƒ¼ï¼‰
ã‚·ãƒ³ã‚°ãƒ«ãƒžã‚¹ã‚¿ã®éžåŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã§ã¯ã€ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼ãŒ1å°ã«é™å®šã•ã‚Œã€ãƒžã‚¹ã‚¿ã‹ã‚‰ã‚¹ãƒ¬ãƒ¼ãƒ–ã¸ã®è¤‡è£½ã¯éžåŒæœŸã§è¡Œãªã‚ã‚Œã‚‹ãŸã‚é…å»¶ãŒç”Ÿã˜ã€çŸæ™‚é–“ã®ã‚¹ã‚±ãƒ¼ãƒ«ã§è¦‹ã‚‹ã¨å…¨ã‚¹ãƒ¬ãƒ¼ãƒ–ã¨ã®åŒæœŸãŒä¿è¨¼ã•ã‚Œãªã„ã€‚ã—ã‹ã—ã€ãã®åé¢ã‚¹ãƒ¬ãƒ¼ãƒ–ã®å°æ•°ã‚’å¢—åŠ ã•ã›ã¦ã„ã£ã¦ã‚‚ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼ã®æ›´æ–°è² è·ã¯å¤§ãããªã‚‰ãšã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’ç¶æŒã§ãã‚‹ã¨ã„ã†åˆ©ç‚¹ãŒã‚ã‚‹ã€‚DeNAã«ã‚ˆã‚‹é‹ç”¨å®Ÿç¸¾ã§ã‚‚ã€ãƒžã‚¹ã‚¿ã¨ã‚¹ãƒ¬ãƒ¼ãƒ–é–“ã®é…å»¶ã¯é€šå¸¸æ•°ç§’ç¨‹åº¦ä»¥å†…ã«åŽã¾ã‚‹ã€‚ã€€ã“ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã§ã¯ãƒ‡ãƒ¼ã‚¿æ›´æ–°æ™‚ã«ã¯ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼ã¸æŽ¥ç¶šã—ã€ãƒ‡ãƒ¼ã‚¿å‚ç…§ã®ã¿ã‚’è¡Œãªã†å ´åˆã¯ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒãƒ¼ã¸æŽ¥ç¶šã™ã‚‹ã‚ˆã†ã«ä½œæˆã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ã€€Webã‚„æºå¸¯é›»è©±å‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®å ´åˆã€å°ã•ãªè¦æ¨¡ã§å§‹ã‚ã¦ãƒ¦ãƒ¼ã‚¶ãƒ¼è¦æ¨¡ã€ãƒ‡ãƒ¼ã‚¿è¦æ¨¡ã€ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼æ•°ã‚’å¾ã€…ã«å¢—åŠ ã•ã›ã¦ã„ãã“ã¨ãŒå¤šã„ã€‚å°ã•ãªè¦æ¨¡ã®ãŸã‚DBã®è² è·åˆ†æ•£ãŒä¸è¦ãªå ´åˆã§ã‚‚ã€ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒãƒ¼1å°ã€ã‚¹ãƒ¬ãƒ¼
rsyudou 2007/08/02
MySQL
ãƒªãƒ³ã‚¯
MySQLã®çŠ¶æ…‹ãŒãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§ã‚ã‹ã‚‹MySQLç”¨topã‚³ãƒžãƒ³ãƒ‰ã€Œmytopã€ã¨ã€Œinnotopã€
ã‚µãƒ¼ãƒã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã™ã‚‹ä¸Šã§ã‹ãªã‚Šã‚„ã£ã‹ã„ãªã®ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç³»ã€‚ç‰¹ã«ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®é‡ãŒè†¨å¤§ã«ãªã‚‹ã¨å¾Œã‹ã‚‰ä¸èº«ã‚’è¦‹ã¦å•é¡Œã‚’åˆ†æžã™ã‚‹ã®ã‚‚ä¸€è‹¦åŠ´ã¨ã„ã†å ´åˆãŒã€‚ãã‚“ãªã¨ãã«ã“ã®MySQLç”¨topã‚³ãƒžãƒ³ãƒ‰ã€Œmytopã€ã‚’ä½¿ãˆã°ä¸€ä½“ä½•ãŒèµ·ãã¦ã„ã‚‹ã®ã‹ãŒã™ãã«ã‚ã‹ã‚‹ã®ã§å•é¡Œç‚¹ã®æŠŠæ¡ãŒå®¹æ˜“ã«ãªã‚Šã¾ã™ã€‚ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã™ã‚‹ã¨ãã«ä½µç”¨ã™ã‚Œã°ã‹ãªã‚ŠåŠ¹çŽ‡ãŒè‰¯ããªã‚‹ã®ã§ã¯ãªã„ã‹ã¨ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨ä½¿ã„æ–¹ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ ã¾ãšã¯ã€Œmytopã€ã‹ã‚‰ã€‚ä»¥ä¸‹ãŒå…¬å¼ã‚µã‚¤ãƒˆã€‚ mytop - a top clone for MySQL http://jeremy.zawodny.com/mysql/mytop/ ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã¯ä»¥ä¸‹ã«ã‚ã‚Šã¾ã™ã€‚ mytop - display MySQL server performance info like `top' ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã«ã¯SSHãªã©ã‚’ä½¿ã£ã¦rootã§ãƒã‚°ã‚¤ãƒ³å¾Œã€wgetã§ãƒ•ã‚¡ã‚¤ãƒ«
rsyudou 2007/08/01
MySQL
ãƒªãƒ³ã‚¯
æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚º
AWSã‚¢ãƒ‰ãƒãƒ³ã‚¹ãƒ‰ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã®ä¸€å“¡ã¨ã—ã¦æ´»å‹•ã™ã‚‹æ ªå¼ä¼šç¤¾ã‚¹ã‚¿ã‚¤ãƒ«ã‚ºãŒã€AWSå°Žå…¥ã€ç§»è¡Œã€é–‹ç™ºã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã€é‹ç”¨ä¿å®ˆãªã©ã€ã™ã¹ã¦ã®ã”ç›¸è«‡ã«ä¹—ã‚‰ã›ã¦ã„ãŸã ãã¾ã™ã€‚ AWSã‚’å°Žå…¥ã—ãŸã„ãŒä½•ã‹ã‚‰å§‹ã‚ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ æ—¢å˜ã®ãƒ™ãƒ³ãƒ€ãƒ¼ãŒæ–°æŠ€è¡“ã«å¼±ãã€è‰¯ã„ææ¡ˆãŒã‚‚ã‚‰ãˆãªã„ ã‚¯ãƒ©ã‚¦ãƒ‰ã®å°Žå…¥ã«ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ä¸å®‰ãŒã‚ã‚‹ AWSã‚’ã¨ã‚Šã‚ãˆãšå°Žå…¥ã—ãŸãŒã€ã•ã‚‰ã«æ´»ç”¨ã—ã¦ã„ããŸã„ ç¤¾å†…ã«AWSã®çŸ¥è¦‹ã‚’æŒã£ã¦ã„ã‚‹äººãŒã„ãªã„ AWSãªã‚‰ã§ã¯ã®ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã‚’è©³ã—ãçŸ¥ã‚ŠãŸã„
rsyudou 2007/07/15
MySQL
ãƒªãƒ³ã‚¯
MySQLãƒŽã‚¦ãƒã‚¦
ã„ã‚ã„ã‚ãªæœ¬ã‹ã‚‰ãƒ¡ãƒ¢ã£ã¦ããŸãƒ¡ãƒ¢ã®ãƒ¡ãƒ¢ã€‚å‡ºå…¸ã‚’æ›¸ã„ã¦ãŠãã®ã‚’å¿˜ã‚ŒãŸã€‚æ€ã„å‡ºã—æ¬¡ç¬¬è£œå®Œã™ã‚‹ã‹ã‚‚ã€‚ deleteã®ã‚³ã‚¹ãƒˆã¯é«˜ã„ã®ã§ã€ç„¡åŠ¹åŒ–ã‚’ç¤ºã™ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã‚’ä½œã£ã¦updateã™ã¹ã slow query logã«è¦æ³¨æ„ å¤šãã®ã‚¨ãƒ³ãƒˆãƒªã§ã»ã¨ã‚“ã©ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ãŒåŒã˜å€¤ã‚’æŒã¤å ´åˆã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå°ã•ã„ â†’è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒå¤§ãã„ è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æŒ‡å®šã®é †ç•ªãŒå¤§åˆ‡ã€‚Aã¨Bã¨ã„ã†æŒ‡å®šã®å ´åˆã€Aå˜ç‹¬ã§ã‚‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŠ¹æžœãŒã‚ã‚‹ã€‚é€†ã¯çœŸã§ãªã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ã‚ã‚Œã‚‹å ´é¢ã¯ ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã‚’å®šæ•°ã¨æ¯”è¼ƒã™ã‚‹ã¨ã (where name = 'hogehoge') ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã§JOINã™ã‚‹ã¨ã (where a.name = b.name) ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å€¤ã®ç¯„å›²ã‚’æ±‚ã‚ã‚‹ã¨ã (<,>,between) LIKEå¥ãŒæ–‡å—åˆ—ã‹ã‚‰å§‹ã¾ã‚‹ã¨ã (where name like 'hoge%') min(),
rsyudou 2007/07/14
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Open Tech Press | MySQLãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³•
This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.
rsyudou 2007/05/31
MySQL
ãƒªãƒ³ã‚¯
2007-04-13
ZENER WORKS æœ€çµ‚æ›´æ–°ãŒ2004å¹´7æœˆï¼¿|ï¿£|â—‹ Cross Gateã¨ã„ã†MMO RPGã®åˆ¶ä½œã«ã‚‚å‚åŠ ã—ã¦ã„ã‚‹æ¨¡æ§˜ã ãŒãã®æƒ…å ±ã¯ãªã—ã€‚ ãƒªãƒˆãƒžã‚¹ã‚·ãƒªãƒ¼ã‚ºã®è¨å®šè³‡æ–™ç”»åƒã¨ã‹ã†pãã¼ã‚“ã¬(ã‰ (1)testingã®ææ€– ã€Œtestingã«ã¯ã“ã‚Œã¾ã§ã²ã©ã„ç›®ã«ã‚ã£ãŸã“ã¨ã¯ãªã„ã€‚ä¸æ°—å‘³ã ï½—ã€ãªã©ã¨ä½™è£•ã¶ã£ã“ã„ã¦ãŸã‚‰mysql-server-5.0(ã»ã¨ã‚“ã©ä½¿ã£ã¦ãªã„ã‘ã©)ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã§ãªã«ã‚„ã‚‰å•é¡ŒãŒã€‚ mysqldãƒ—ãƒã‚»ã‚¹ãŒç«‹ã¡ä¸ŠãŒã£ã¦ã‚‹ã®ã«mysqld.sockã‚‚mysqld.pidã‚‚ä½œæˆã•ã‚Œãªã„ã¨ã„ã†æ„å‘³ä¸æ˜Žã®çŠ¶æ…‹ã«ã€‚ ãã®ãŸã‚mysqldã‚’kill -9ã§ã—ã‹æ¢ã‚ã‚‰ã‚Œãªããªã£ã¦ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã«å¤±æ•—â€¦ ã¡ãªã¿ã«ã‚«ãƒ¼ãƒãƒ«ãŒ2.4.33.3ã®ã¨ãã«ã“ã®ç¾è±¡ãŒç™ºç”Ÿã€‚2.6.20.6(è©³ç´°ã¯å¾Œè¿°)ã§ã¯ç™ºç”Ÿã—ã¾ã›ã‚“ã§ã—ãŸã€‚ â†“ãã®éš›æŒ™å‹•ã‚’èª¿ã¹ã‚ˆã†ã¨ã—ã¦mysqld_safeã‚’å®Ÿè¡Œã—ãŸã¨ã
rsyudou 2007/05/28
debian-testingã®mysqlã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚¨ãƒ©ãƒ¼

mysql
ãƒªãƒ³ã‚¯
Googleã€MySQLã‚’å¼·åŒ–ã™ã‚‹ãƒ‘ãƒƒãƒã‚’ç„¡å„Ÿãƒªãƒªãƒ¼ã‚¹ï¼šCodeZine
Googleã¯ã€åŒç¤¾ã®è£½å“é–‹ç™ºã®ä¸ã‹ã‚‰ç”Ÿã¾ã‚ŒãŸMySQLã‚’å¼·åŒ–ã™ã‚‹ãƒ‘ãƒƒãƒã‚’å…¬é–‹ã—ãŸã€‚Googleã®Webã‚µã‚¤ãƒˆã‹ã‚‰ç„¡å„Ÿã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ ã“ã®ãƒ‘ãƒƒãƒã¯MySQLã®æ‰±ã„ã‚„ã™ã•ã¨ä¿¡é ¼æ€§ã‚’å‘ä¸Šã•ã›ã‚‹ç›®çš„ã§ä½œã‚‰ã‚Œã¦ãŠã‚Šã€ä¸»ã«ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒï¼ˆãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ãªã‚‹ã‚µãƒ¼ãƒï¼‰ã®æ©Ÿèƒ½ã‚’å¼·åŒ–ã•ã›ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ä¾‹ã¨ã—ã¦ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒãŒæ›´æ–°é€šçŸ¥ã‚’å—ã‘å–ã‚‰ãªã„é™ã‚Šãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒã‚’æ›´æ–°ã•ã›ãªã„æ©Ÿèƒ½ã‚„ã€å†èµ·å‹•ãªã—ã§ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã‚’ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒã«ç½®ãæ›ãˆã‚‹æ©Ÿèƒ½ãªã©ãŒå‚™ã‚ã£ã¦ã„ã‚‹ã€‚ ä»–ã«ã‚‚ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã«ãªã£ã¦ã„ã‚‹ã‚¢ã‚«ã‚¦ãƒ³ãƒˆãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã™ã‚‹ã‚‚ã®ã‚„ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ/MySQLé€šä¿¡ã®ãŸã‚ã®é«˜é€Ÿãªåœ§ç¸®æ©Ÿèƒ½ãªã©ã‚‚ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã€‚ ã¡ãªã¿ã«ã€ã“ã®ãƒ‘ãƒƒãƒã¯Linuxä¸Šã§å‹•ä½œã™ã‚‹InnoDBç”¨ã«æœ€é©åŒ–ã•ã‚ŒãŸã‚‚ã®ã¨ãªã£ã¦ã„ã‚‹ã€‚ãã®ç†ç”±ã¨ã—ã¦Googleã¯ã€Œæˆ‘ã€…ãŒInnoDBã‚’ä½¿ã£ã¦ã„ã‚‹ãŸã‚ã€ã¨èª¬æ˜Žã—ã¦ã„ã‚‹ã€‚ã¾ãŸã€ç¾åœ¨ãƒ‘
rsyudou 2007/04/27
mysql
ãƒªãƒ³ã‚¯
ã€Œã¡ã‚‡ã£ã¨å¾…ã¦ã€ çœŸãƒ»MySQLã®ã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã™ã‚‹10ã®Tipsï¼šCodeZine
Jaslabs: High performance phpã§ç´¹ä»‹ã•ã‚ŒãŸã€ŒMySQLã®ã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã™ã‚‹10ã®Tipsã€ã«å¯¾ã—ã¦ã€åè«–ã—ã¦ã„ã‚‹äººãŒã„ã‚‹ã€‚ãƒ–ãƒã‚°ã€Œ20bitsã€ã®Jesseæ°ã ã€‚å½¼ã¯ã€Œ10 Tips for Optimizing MySQL Queries (That donâ€™t suck)ã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã€Jaslabsæ°ã®è¨˜äº‹ã¯é©åˆ‡ã§ãªã„ã¨ã—ã¦ã„ã‚‹ã€‚ Jesseæ°ã®çµŒé¨“ã«ã‚ˆã‚Œã°ã€SQLæœ€é©åŒ–ã§æœ€ã‚‚é‡è¦ãªã“ã¨ã¯SQLã‚„DBã®åŸºæœ¬ã‚’ã—ã£ã‹ã‚Šã¨ç†è§£ã™ã‚‹ã“ã¨ã§ã‚ã‚Šã€60ï¼…ãŒã“ã‚Œã§è§£æ±ºã™ã‚‹ã¨ã„ã†ã€‚æ®‹ã‚Š35ï¼…ã¯DBã‚„ã‚¯ã‚¨ãƒªã®ç‰¹æ®Šãªæ€§è³ªã«å¯¾ã™ã‚‹å¯¾å‡¦ã§ã‚ã‚Šã€æœ€å¾Œã®5ï¼…ã§ç™ºæƒ³ã®è»¢æ›ãªã©ã‚’æ±‚ã‚ã‚‰ã‚Œã‚‹ã€‚Jaslabsæ°ã¯ã“ã“ã«ã°ã‹ã‚ŠåŠ›ã‚’å…¥ã‚Œã¦ãŠã‚Šã€ãã‚Œã¯ã¾ã£ãŸãã‚‚ã£ã¦æ™‚é–“ã®ç„¡é§„ã ã¨è¿°ã¹ã¦ã„ã‚‹ï¼ˆJesseæ°ã¯ã€ŒSQL_SMALL_RESULTãªã‚“ã¦ã€ç”Ÿã¾ã‚Œã¦ã“ã®æ–¹ä½¿ã£ãŸã“ã¨ã™ã‚‰ãªã„ã€ã¨ã¾ã§è¨€
rsyudou 2007/04/11
mysql
ãƒªãƒ³ã‚¯
MySQLã®ã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã™ã‚‹10ã®Tips - PHPãƒ—ãƒï¼ãƒ‹ãƒ¥ãƒ¼ã‚¹
å¹³ç´ ã‚ˆã‚Šã€ŒPHPãƒ—ãƒï¼ã€ã‚’ã”æ„›é¡§ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ 2006å¹´ã‚ˆã‚Šé‹å–¶ã—ã¦ã¾ã„ã‚Šã¾ã—ãŸã€ŒPHPãƒ—ãƒï¼ã€ã§ã™ãŒã€ã‚µãƒ¼ãƒ“ã‚¹ã®åˆ©ç”¨çŠ¶æ³ã‚’é‘‘ã¿ã¾ã—ã¦ã€2018å¹´9æœˆ25æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã•ã›ã¦ã„ãŸã ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã¾ã—ã¦ã€2018å¹´8æœˆ28æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’æŒã¡ã¾ã—ã¦ã€æ–°è¦ä¼šå“¡ç™»éŒ²ãªã‚‰ã³ã«Q&AæŽ²ç¤ºæ¿ã¸ã®æ–°ãŸãªè³ªå•ã€å›žç”ã®æŠ•ç¨¿ã‚’åœæ¢ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ãªãŠã€ã”ç™»éŒ²ã„ãŸã ã„ãŸçš†æ§˜ã®å€‹äººæƒ…å ±ã«ã¤ãã¾ã—ã¦ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†å¾Œã€å¼Šç¤¾ãŒè²¬ä»»ã‚’ã‚‚ã£ã¦æ¶ˆåŽ»ã„ãŸã—ã¾ã™ã€‚ ã“ã‚Œã¾ã§å¤šãã®çš†æ§˜ã«ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ã¦ã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã€çš†æ§˜ã«ã¯ã”ä¸ä¾¿ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ã“ã¨ã€å¿ƒã‚ˆã‚ŠãŠè©«ã³ç”³ã—ä¸Šã’ã¾ã™ã€‚ æœ¬ä»¶ã«é–¢ã™ã‚‹ãŠå•ã„åˆã‚ã›ã¯ã“ã¡ã‚‰ã‚ˆã‚ŠãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
rsyudou 2007/04/11
mysql
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
rsyudou 2006/10/19
æ–‡å—åŒ–ã‘

MySQL
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬1å›žï¼šMySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®æ¦‚è¦ (1/3)
MySQLã®æ¦‚è¦ã«ã¤ã„ã¦ã¯ã”å˜çŸ¥ã®æ–¹ã‚‚å¤šã„ã¨æ€ã„ã¾ã™ãŒã€å¾©ç¿’ã®æ„å‘³ã‚‚è¾¼ã‚ã¦ç°¡å˜ã«ç´¹ä»‹ã—ã¾ã™ã€‚ MySQLã¯ã€MySQLç¤¾ã‚’ä¸å¿ƒã¨ã—ã¦é–‹ç™ºãŒé€²ã‚ã‚‰ã‚Œã¦ã„ã‚‹RDBMSã§ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®æ¨™æº–çš„ãªãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã‚’æ„å‘³ã™ã‚‹ã€ŒLAMPã€ã¨ã„ã†è¨€è‘‰ï¼ˆLinuxï¼Apacheï¼MySQLï¼PHPï¼‰ã«æŽ¡ç”¨ã•ã‚Œã‚‹ã»ã©æœ‰åãªã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ã™ã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¨ã—ã¦ã¯ã€GPLã¨å•†ç”¨ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®ãƒ‡ãƒ¥ã‚¢ãƒ«ãƒ©ã‚¤ã‚»ãƒ³ã‚¹å½¢æ…‹ã§æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.0ã‚ˆã‚Šã‚¹ãƒˆã‚¢ãƒ¼ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚„ãƒˆãƒªã‚¬ãªã©ã‚’ã‚µãƒãƒ¼ãƒˆã—ã€ä»–ã®RDBMSã¨æ¯”ã¹ã¦ã‚‚éœè‰²ã®ãªã„æ©Ÿèƒ½ã‚’å‚™ãˆãŸRDBMSã«ãªã‚Šã¾ã—ãŸã€‚ ç¹°ã‚Šè¿”ã—ã«ãªã‚Šã¾ã™ãŒã€MySQLã®æœ€å¤§ã®ç‰¹é•·ã¯ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã”ã¨ã«é¸æŠžã§ãã‚‹ç‚¹ã§ã™ã€‚ãã—ã¦ã€ãã®é¸æŠžã—ãŸã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã‚ˆã£ã¦ç‰¹é•·ãŒç•°ãªã‚‹ã“ã¨ã§ã™ã€‚ æ¬¡ã«ä»£è¡¨çš„ãª2ã¤ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ç¤ºã—ã¾ã™ãŒã€ã¾ã£ãŸãç•°ãªã‚‹ç‰¹é•·ã‚’æŒã£ã¦ã„
rsyudou 2006/10/17
MySQL
ãƒªãƒ³ã‚¯
1