[B! mysql] C_Lã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

C_L id:C_L

mysqlã«é–¢ã™ã‚‹C_Lã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

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

[Q&A]MySQLé–‹ç™ºã§ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãªè‡´å‘½çš„ãƒŸã‚¹ | Yakst
Percona MySQL Webinarsã®ç™ºè¡¨(MYSQLé–‹ç™ºã§ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãªè‡´å‘½çš„ãªãƒŸã‚¹ã«ã¤ã„ã¦)ã®QAã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ æœ¬ç™ºè¡¨ã¯SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³è‘—è€…ã®Bill Karwinã•ã‚“ã®ç™ºè¡¨ã§ã™ã€‚ ã‚ªãƒªã‚¸ãƒŠãƒ«: http://www.percona.com/resources/mysql-webinars/how-avoid-even-more-common-deadly-mysql-development-mistakes July 17, 2014 by Bill Karwin æ°´æ›œæ—¥ã«ã€ŒMySQLã‚’é–‹ç™ºã™ã‚‹ä¸Šã§ã‚ˆãèµ·ã“ã‚‹(ãã—ã¦è‡´å‘½çš„ãª)ãƒŸã‚¹ã‚’ã©ã®ã‚ˆã†ã«å›žé¿ã™ã‚‹ã‹ã€ã‚’Percona MySQL webinarsã§ç™ºè¡¨ã—ãŸã€‚ãŠè¦‹é€ƒã®éš›ã¯ã€ãƒ“ãƒ‡ã‚ªã¨ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’è¦‹ã‚‹ç‚ºã«ç™»éŒ²ã™ã‚Œã°ã¾ã ã”è¦§ã«ã„ãŸã ã‘ã‚‹ã€‚ å‚åŠ ã„ãŸã ã„ãŸçš†æ§˜ã€ãã—ã¦ã¨ã‚Šã‚ã‘ã™ã°ã‚‰ã—ã„è³ªå•ã‚’ã—ã¦ã„ãŸã ãã‚ã‚ŠãŒãŸãæ€ã£ã¦ã„ã‚‹
C_L 2016/04/29
mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒ¡ãƒ¢ãƒªè¨å®šã®å‹˜æ‰€ â€“ sawara.me
MySQLã‚µãƒ¼ãƒãƒ¼ã‚’ãƒ€ã‚¦ãƒ³ã•ã›ãŸå¤œã¯æ•°çŸ¥ã‚Œãšã€‚ ãã®åº¦ã«my.cnfã®è¨å®šã‚’è¦‹ãªãŠã—ã¦ã¿ã¦ã¯ãƒˆãƒ©ã‚¤ã—ã€æ²»ã£ãŸã¨æ€ã„ãã‚„çªç„¶ã®ãƒ€ã‚¦ãƒ³ã€‚ ã‚µãƒ¼ãƒãƒ¼ãŒãƒ€ã‚¦ãƒ³ã—ã¦ã—ã¾ã†åŽŸå› ã¯ä½•ã‹ã¨èžã‹ã‚Œã‚Œã°ã€ã€Œãƒ¡ãƒ¢ãƒªã§ã™ã€ã¨æ–è¨€ã—ã¾ã—ã‚‡ã†ã€‚ ãƒ¡ãƒ¢ãƒªè¨å®šã¯è«¸åˆƒã®å‰£ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æœ€å¤§ã«å¼•ãå‡ºã™ã“ã¨ã‚‚ã§ãã‚Œã°ãã‚Œã¨å¼•ãæ›ãˆã«ã‚µãƒ¼ãƒãƒ¼ã‚’ãƒ€ã‚¦ãƒ³ã•ã›ã¦ã—ã¾ã†ã“ã¨ã‚‚ã§ãã‚‹ã‚“ã§ã™ã€‚ ä»Šå›žã¯MySQLã®ãƒ¡ãƒ¢ãƒªã®è¨å®šã®å‹˜æ‰€ã¨ã„ã†ã‹ãŸã¡ã§ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¨ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ãƒ¡ãƒ¢ãƒªã®è¨å®šã«ã¤ã„ã¦ã¾ãšã€Œã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã€ã¨ã€Œã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã€ã«ã¤ã„ã¦ç†è§£ã—ã¦ãŠãã“ã¨ãŒå¤§äº‹ã§ã™ã€‚ãƒãƒƒãƒ•ã‚¡ã¨ã¯ä¸€æ™‚çš„ãªè¨˜æ†¶é ˜åŸŸãƒ»ã¤ã¾ã‚Šã¯ãƒ¡ãƒ¢ãƒªã®é ˜åŸŸã®ã“ã¨ãªã®ã§ã™ãŒã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ MySQLã§ä½¿ç”¨ã™ã‚‹å…¨ä½“çš„ãªãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã‚’è¨ˆç®—ã™ã‚‹ã«ã¯ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ + (ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ Ã— ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³æ•°) = ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ ã¨
C_L 2016/02/29
mysql
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQL/MariaDBã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨ãƒãƒƒã‚¯ã®é–¢ä¿‚ï¼‹ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã‚»ãƒ¼ãƒ•ã«ã¤ã„ã¦ - interdbâ€™s diary
ã‚ˆã„æ©Ÿä¼šãªã®ã§ã¾ã¨ã‚ã¦ãŠãã€‚å¯¾è±¡ã¯MySQL5.6ä»¥ä¸‹ã¨MariaDB10.0ä»¥ä¸‹ã€‚ (2014.12.3è¿½è¨˜ï¼šä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚è¨˜è¿°ã—ãŸã€‚) è¦æ—¨ MySQL/MariaDBã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã«ã¤ã„ã¦ã€ç›¸å¤‰ã‚ã‚‰ãšã€ŒInnoDBã•ãˆä½¿ã£ã¦ã„ã‚Œã°ã€FLUSH TABLES WITH READ LOCKã¯ä¸è¦ã€‚ã‚ˆã£ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ä¸ã«æ›´æ–°ä¸å¯ã«ãªã‚‹ã“ã¨ã¯ãªã„ï¼ã€ã¨ã®ä¸»å¼µãŒç¹°ã‚Šè¿”ã•ã‚Œã¦ã„ã‚‹ãŒã€å°‘ãªãã¨ã‚‚5.6/10.0ã¾ã§ã¯ãã‚“ãªã“ã¨ã¯ãªã„ã€‚ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã«é–¢ã™ã‚‹ãƒãƒƒã‚¯ã®æ£ç¢ºãªè¨˜è¿° ã‚ˆã‚Šæ£ç¢ºã«è¨€ãˆã°ã€Œå…¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é ˜åŸŸã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹å ´åˆã«ã¯ã€FLUSH TABLES WITH READ LOCKã¯å¿…é ˆã€‚ç‰¹å®šã®InnoDBã ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹éš›ã¯ã€ã“ã®é™ã‚Šã§ã¯ãªã„ã€ã€‚ ãªã®ã ãŒã€å…¨é ˜åŸŸã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã—ãŸã„äººã«å¯¾ã—ã¦ãƒãƒƒã‚¯ä¸è¦èª¬ã‚’å¹ãè¾¼ã‚€äººãŒæœªã ã«ã„ã‚‹ã€‚ ãƒãƒƒã‚¯ã®å¿…è¦
C_L 2014/09/23
mysql

mariadb
ãƒªãƒ³ã‚¯
ã¨ã‚ã‚‹è¨ºæ–å“¡ã¨SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³
7. é€šå¸¸ã®Webã‚µãƒ¼ãƒã¨ã®é€šä¿¡ <html> <body> <form action=â€œregisterâ€ method=â€œPOSTâ€> æ°å:vultest<BR> ãƒ¡ãƒ¼ãƒ«ã‚¢ãƒ‰ãƒ¬ã‚¹:vulte [email protected]<BR> æ€§åˆ¥:ç”·<BR> ï¼ˆä»¥ä¸‹ç•¥ï¼‰ </html> POST /confirm.php HTTP/1.1 Host: example.jp ï¼ˆä»¥ä¸‹ç•¥ï¼‰ Cookie: PHP SESSID=xxxxxxxxxx name=vultest&mail=vultest%40example.jp&gender=1 HTTP Response HTTP Request 8. è‰²ã€…ã„ã˜ã£ã¦ã¿ã¦ã©ã†ã„ã†å¿œç”ãŒã‚ã‚‹ã‹ç¢ºèª POST /confirm.php HTTP/1.1 Host: example.jp ï¼ˆä»¥ä¸‹ç•¥ï¼‰ Cookie: PHP SESSID=xxxxxxxxxx name
C_L 2014/05/26
ã‚¤ãƒ³ãªã‚“ã¨ã‹ã•ã‚“

sql

mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã«é–¢ã™ã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°Tips | Yakst
MySQLãŒç¢ºä¿ã™ã‚‹å„ç¨®ãƒ¡ãƒ¢ãƒªã«é–¢ã™ã‚‹ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®æ¦‚è¦ã‹ã‚‰ã€ãã‚Œã‚‰ãŒã©ã®ã‚ˆã†ã«å‰²ã‚Šå½“ã¦ã‚‰ã‚Œã‚‹ã®ã‹ã‚’çŸ¥ã‚‹ãŸã‚ã®æ§˜ã€…ãªæ‰‹æ³•ã¾ã§ã€Perconaã®ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒè©³ã—ãè§£èª¬ã™ã‚‹ã€‚ January 24, 2014 By Nilnandan Joshi ã€ŒMySQLã‚µãƒ¼ãƒã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã€ã«é–¢é€£ã™ã‚‹ãƒˆãƒ”ãƒƒã‚¯ã‚¹ã‚’æ›¸ã„ãŸãƒ–ãƒã‚°è¨˜äº‹ã¯æ—¢ã«ãŸãã•ã‚“ã‚ã‚‹ã«ã‚‚é–¢ã‚ã‚‰ãšã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢é€£ã®å•é¡Œã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã§æ··ä¹±ã—ãªã‹ã£ãŸäººã¯ã„ãªã„ã ã‚ã†ã€‚Perconaã‚µãƒãƒ¼ãƒˆã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ã€é«˜è² è·ã®ã‚µãƒ¼ãƒã«é–¢ã™ã‚‹ã“ã¨ã‚„ã€ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡é«˜é¨°ã§OOM killerãŒç™ºå‹•ã—ã¦MySQLã‚µãƒ¼ãƒãŒåœæ¢ã—ãŸã“ã¨ã€ã‚ã‚‹ã„ã¯ã€ŒMySQLãŒã©ã†ã—ã¦ã“ã‚“ãªã«ãƒ¡ãƒ¢ãƒªã‚’é£Ÿã†ã®ã‹åˆ†ã‹ã‚‰ãªã„ã€‚ã©ã†ã‚„ã£ãŸã‚‰ä½•ã«ãƒ¡ãƒ¢ãƒªãŒä½¿ã‚ã‚Œã¦ã‚‹ã‹åˆ†ã‹ã‚‹ã‚“ã ï¼ŸåŠ©ã‘ã¦ãã‚Œï¼ã€ã¨è¨€ã£ãŸå•é¡Œã‚’æ•°å¤šãè¦‹ã¦ã„ã‚‹ã€‚ MySQLã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚‹æ–¹æ³•ã¯ãŸã
C_L 2014/01/29
mysql
ãƒªãƒ³ã‚¯
é•·å¹´ã®è°è«–ã«çµ‚æ¢ç¬¦ -- MySQLã¨MariaDBã®é•ã„ä¸€è¦§ - æŠ€è¡“ãƒ¡ãƒ¢ç½®ãå ´
(2014.12.3è¿½è¨˜ï¼šã“ã®blogã®å†…å®¹ã¯ã€ä»¥ä¸‹ã®æ›¸ç±ã«ã‚‚åæ˜ ã•ã›ãŸã€‚) SQLãƒ¬ãƒ™ãƒ«ã®å·®ç•° MariaDB5.5ã¨MySQL5.5ã§ã¯SQLãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã»ã¨ã‚“ã©ãªã‹ã£ãŸã€‚autoincrementã®æœ€å¤§å€¤ã®æ‰±ã„ãã‚‰ã„ã€‚ ãŸã ã—ã€MariaDB10.0ã§REGEXPãŒãƒžãƒ«ãƒãƒã‚¤ãƒˆå¯¾å¿œã«ãªã£ãŸã®ã§ã€ã‚¢ãƒ—ãƒªå´ã¯æ³¨æ„ã€‚ é …ç›® MySQL MariaDB Autoincrement æœ€å¤§å€¤ã«é”ã™ã‚‹ã¨ã€ä»¥é™ã¯æœ€å¤§å€¤ã‚’ç¹°ã‚Šè¿”ã™ã€‚Warningã®ã¿ã€‚ã‚¨ãƒ©ãƒ¼ã«ãªã‚‰ãªã„ã€‚tinyintãªã‚‰â€¦,125,126,127,127,127â€¦ æœ€å¤§å€¤-1ã¾ã§ã€‚ä»¥é™ã¯ã‚¨ãƒ©ãƒ¼ã‚’è¿”ã™ã€‚tinyintãªã‚‰â€¦,125,126,ERROR,ERROR,â€¦ EXPLAINæ–‡ JSONå½¢å¼ ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œ Optimizer Trace ãƒãƒ¼ã‚¸ãƒ§ãƒ³5.6ã‹ã‚‰ æœªå¯¾å¿œï¼ˆãŸã ã—ã€MariaDBã®ã»ã†ãŒã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶
C_L 2013/09/20
ãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³æä¾›ã®DBä½¿ã†æ–¹é‡ã ã¨ä»Šå¾Œã•ã‘ã¦é€šã‚Œãªã„ã‚ˆã

mysql

mariadb
ãƒªãƒ³ã‚¯
Devsã®å¸¸è˜ã€DBAã¯éžå¸¸è˜
1. MySQL Admin ãŒè¦‹ãŸ Devs ã®å¸¸è˜ã€ DBA ã¯éžå¸¸è˜ 2013/09/14 yoku0825@MyNA PHP Conference 2013 2. ï¼¼ã“ã‚“ã«ã¡ã¯ï¼ï¼ â— yoku0825 â— ã¨ã‚ã‚‹ä¼æ¥ã® DBA â— MySQL æ´ 5 å¹´ãã‚‰ã„ â— ã‚ªãƒ©ã‚¯ã‚Œãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ â— æ—¥æœ¬ MySQL ãƒ¦ãƒ¼ã‚¶ä¼š (MyNA) ã®ã‚¹ãƒ™ã‚Šæ‹…å½“ 3. ï¼¼ã—ã‚ƒã¹ã‚‹ã“ã¨ï¼ï¼ â— æ—¥å¸¸çš„ã« MySQL ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã«è§¦ã‚Œã‚‹å¤‰æ…‹ DBA ãŒãƒ•ãƒ„ãƒ¼ã® Devs ã«æŠ•ã’ãŸæ„›ã®ãƒžã‚µã‚«ãƒªé›† ( ã®ã¤ã‚‚ã‚Š ) â— ã‚¦ãƒã®é–‹ç™ºè¨€èªžã¯ PHP > Java >> Ruby ã‚‰ã—ã„ã§ã™ â— ã‚¦ãƒã§ã¯ DBA ãŒã‚µãƒ¼ãƒãƒ¼ã®æ§‹ç¯‰ã€ Devs ãŒè¨è¨ˆãƒ» ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹ç¯‰ãƒ»é‹å–¶ã€ DBA ã¯ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒˆã‚„æ”¹ å–„ææ¡ˆ ( é‹ç”¨ ) ã€ã¨ã„ã†ã‚µã‚¤ã‚¯ãƒ«ã§å›žã—ã¦ã„ã¾ã™ã€‚
C_L 2013/09/14
mysql
ãƒªãƒ³ã‚¯
MySQL 5.1â†’5.6ã®my.cnfã®å·®åˆ†ã¨ã‹ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQL 5.1ã§ä½¿ã£ã¦ãŸmy.cnfã‚’è©¦ã—ã«5.6ã§å‹•ãã‚ˆã†ã«ã—ãŸã¨ãã®å·®åˆ†ã™ã€‚ç¶²ç¾…çš„ã«ã¯èª¿ã¹ã¦ãªã„ã‚“ã§ä»–ã«ã‚‚å»ƒæ¢ã«ãªã£ãŸãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ã‚ã‚‹ã‹ã‚‚ã§ã™ã€‚ã‚ãã¾ã§å‚è€ƒã¾ã§ã«ã€‚ # log-binã«ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿æŒ‡å®šã—ãªã„ã¨æ€’ã‚‰ã‚Œã¾ã™ -log-bin +log-bin = mysqld-bin # old-passwordsã¯ã‚ªãƒ³ã€ã‚ªãƒ•ã ã‘ã˜ã‚ƒãªãã¦å¼•æ•°(0, 1, 2)ãŒå¿…é ˆã«ãªã£ã¦ã€å¼•æ•°ã®å€¤ã«ã‚ˆã£ã¦æŒ™å‹•ãŒã‹ã‚ã‚Šã¾ã™ã€‚ -old-passwords +old-passwords = 1 # ã“ã‚ŒæŒ‡å®šã—ãªã„ã¨ã€ãƒªãƒ¢ãƒ¼ãƒˆã‹ã‚‰ã®pre-4.1ãªèªè¨¼æ–¹æ³•ã§æŽ¥ç¶šã§ããªã„ã§ã™ +skip-secure-auth # ã“ã‚ŒæŒ‡å®šã—ãªã„ã¨ã€pre-4.1ãªèªè¨¼æ–¹æ³•ã§æŽ¥ç¶šã§ããªã„ã§ã™â˜…ä¸‹ã«è¿½è¨˜ã‚ã‚Š +default-authentication-plugin = mysql_old_password # ãƒ‘ãƒ©ãƒ¡ãƒ¼
C_L 2012/10/03
MySQL
ãƒªãƒ³ã‚¯
ãƒ•ãƒ„ãƒ¼ãªæ—¥å¸¸ - MySQLã®Tips
http://forge.mysql.com/wiki/Top10SQLPerformanceTipsã¨ã„ã†ã®ãŒã‚ã£ãŸã®ã§ã€å’Œè¨³ã—ã¦ã¿ã‚‹ã€‚ (11/23 è¿½è¨˜)id:pekeqã•ã‚“ã¨sodaã•ã‚“ã®ã‚³ãƒ¡ãƒ³ãƒˆã‚’å—ã‘ä¸€éƒ¨æ›´æ–° (4/27 è¿½è¨˜ã¨ä¿®æ£)id:hirose31ã•ã‚“ã®æŒ‡æ‘˜ã‚’å—ã‘ä¿®æ£ã€‚ã‚ã¨å…ƒã®ã‚µã‚¤ãƒˆãŒæ§‹æˆå¤‰æ›´ã—ã¦ã„ãŸã®ã§è¿½å¾“ ã‚¯ã‚¨ãƒªã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹Tips(ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ã‚¶ã‚¤ãƒ³ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã‚‚) EXPLAINã‚’ä½¿ã£ã¦ã‚¯ã‚¨ãƒªã®å®Ÿè¡Œãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ã‚’å–ã‚Œ ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚’ä½¿ãˆ(å¸¸ã«æœ‰åŠ¹ã«ã—ã¦ãŠã‘ï¼) GROUP BYã‚’ä½¿ã£ã¦ã„ã‚‹ã‹ä½¿ãˆã‚‹ãªã‚‰ã€DISTINCTã‚’ä½¿ã†ãª Insertã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ ãƒãƒƒãƒå‡¦ç†ã«ã‚ˆã‚‹INSERTã¨REPLACE INSERTã®ä»£ã‚Šã«LOAD DATAã‚’ä½¿ã† LIMIT m,nã¯æ¡ˆå¤–é€Ÿããªã„ 2000ä»¶ä»¥ä¸Šã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã«å¯¾ã—ã¦ORDER BY RA
C_L 2006/11/24
mysql
ãƒªãƒ³ã‚¯
http://www.wikiroom.com/asakura/index.php?MySQL%2FUTF8
C_L 2006/09/07
$dbh->do("set names utf8");

utf8

mysql
ãƒªãƒ³ã‚¯
http://oss.timedia.co.jp/index.fcgi/kahua-web/show/MySQL%C6%FC%CB%DC%B8%EC%A4%CE%CE%B9
C_L 2006/09/07
mysql

code
ãƒªãƒ³ã‚¯
1