[B! 5.1] k_37toã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

k_37to id:k_37to

5.1ã«é–¢ã™ã‚‹k_37toã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

MySQL 5.1.39ãƒªãƒªãƒ¼ã‚¹ - SH2ã®æ—¥è¨˜
å‡ºã¾ã—ãŸã€‚ä»Šå›žã¯ãƒã‚°ä¿®æ£ãŒ20ä»¶ã‚ã‚Šã€ãã®ã†ã¡ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°æ©Ÿèƒ½ã«é–¢ã™ã‚‹ã‚‚ã®ãŒ4ä»¶ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«é–¢ã™ã‚‹ã‚‚ã®ãŒ9ä»¶ã¨ãªã£ã¦ã„ã¾ã™ã€‚ ä»Šå›žã®ãƒã‚°ä¿®æ£ã®ã†ã¡Bug#28976ã€æ£ç¢ºã«ã¯Bug#28976ã‚’å–ã‚Šå·»ãçŠ¶æ³ã¯è¦šãˆã¦ãŠã„ãŸæ–¹ãŒè‰¯ã„ã¨æ€ã„ã¾ã™ã€‚è§£èª¬ã—ã¾ã™ã€‚ ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆãƒ™ãƒ¼ã‚¹ã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã€ä¸€ã¤ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å†…ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å¯¾å¿œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³éžå¯¾å¿œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä¸¡æ–¹æ›´æ–°ã™ã‚‹ã«ã¯ã€æ¬¡ã®ã‚ˆã†ã«ã—ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ã¾ãšæœ€åˆã«MyISAMãªã©ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³éžå¯¾å¿œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ›´æ–°ã—ã€æ¬¡ã«InnoDBãªã©ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å¯¾å¿œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ›´æ–°ã—ã¾ã™ã€‚ ãªãœã“ã†ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã®ã‹ã¨ã„ã†ã¨ã€InnoDB â†’ MyISAMã®é †ç•ªã§æ›´æ–°ã‚’è¡Œã£ãŸå ´åˆã€MyISAMãƒ†ãƒ¼ãƒ–ãƒ«ã®æ›´æ–°å†…å®¹ãŒä»–ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰å³åº§ã«è¦‹ãˆã‚‹ã‚ˆã†ã«ãªã‚‹ä¸€æ–¹ã§ã€ã“ã®æ›´æ–°å†…å®¹ã¯COMMI
k_37to 2009/12/31
MySQL

5.1

Tips
ãƒªãƒ³ã‚¯
mysql full-text parser plugin collection
MySQL (5.1 and later) full-text parser plugins collection. This collection provides bigram, mecab , space, snowball and suffix parser. If you want to use Chinese or Japanese, bigram plugin might be useful.
k_37to 2009/09/18
MySQL

5.1

full

text

search

plugin
ãƒªãƒ³ã‚¯
MySQL 5.1 on CentOS | Carpe Diem
CentOS 5.3 x86_64 ä¸Šã§ MySQL 5.1 ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã„ãŸã‚ã€è‡ªåˆ†ã§ RPM ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚ã„ã‚ã„ã‚ã¨æ¤œç´¢ã—ãŸçµæžœã€Fedora ã® CVS ã«ã‚ã‚‹ã‚‚ã®ãŒæœ€æ–°ã§ã‹ã¤ã€æ—¢å˜ã® MySQL 5.0 ç³»ã¨åŒã˜ã‚ˆã†ãª SPEC ãƒ•ã‚¡ã‚¤ãƒ«ã®ãŸã‚ã€ã“ã‚Œã‚’ä½¿ã†ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã¾ãšã€CVS ã§ checkout ã—ã¾ã™ã€‚ export CVSROOT=:pserver:anonymous@cvs.fedoraproject.org:/cvs/pkgs cvs co mysql ãã†ã™ã‚‹ã¨ã€mysql/devel ã« MySQL 5.1 ç³»(ä»Šæ—¥ç¾åœ¨ã§ã¯ã€5.1.34) ã® SPEC ã‚„ã‚‰ãƒ‘ãƒƒãƒãƒ•ã‚¡ã‚¤ãƒ«ãªã©ãŒã‚ã‚Šã¾ã™ã€‚SPEC ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ ~/rpm/SPEC ã«ã€ãƒ‘ãƒƒãƒãƒ•ã‚¡ã‚¤ãƒ«ã‚„ SPEC ãƒ•ã‚¡ã‚¤ãƒ«ã«æ›¸ã‹ã‚Œã¦ã„ã‚‹ãƒ‘ãƒƒãƒã‚„ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆãªã©ã‚’ ~/rpm/SOURCES ã«
k_37to 2009/06/15
MySQL

5.1

centos
ãƒªãƒ³ã‚¯
LINEAR HASHãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã£ã¦ãªã‚“ã ï¼Ÿ
MySQL 5.1ã‹ã‚‰åˆ©ç”¨å‡ºæ¥ã‚‹ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®ç¨®é¡žã«ã¯ã€æ¬¡ã®4ã¤ãŒã‚ã‚‹ã€‚ RANGEãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° LISTãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° [LINEAR] HASHãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° [LINEAR] KEYãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° RANGEãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¯å€¤ã®ç¯„å›²ã‚’æŒ‡å®šã™ã‚‹ã€‚æ¬¡ã®ã‚ˆã†ã«æ—¥ä»˜ã‚’ç”¨ã„ã¦ç¯„å›²ã‚’æŒ‡å®šã™ã‚‹ã®ãŒä»£è¡¨çš„ãªä½¿ã„æ–¹ã ã€‚è©³ç´°ã¯ã“ã¡ã‚‰ã®è¨˜äº‹ï¼ˆãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®ä½¿ç”¨ä¾‹ - http sessionæƒ…å ±ï¼‰ã‚’è¦‹ã¦æ¬²ã—ã„ã€‚ mysql> CREATE TABLE http_session ( -> session_id VARCHAR(32) NOT NULL, -> last_access TIMESTAMP NOT NULL, -> created TIMESTAMP NOT NULL, -> t_session_data VARCHAR(1024) -> ...(ä¸ç•¥)...
k_37to 2009/05/25
MySQL

5.1

partitioning
ãƒªãƒ³ã‚¯
ï¼»MySQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬40å›ž ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã§é«˜é€ŸåŒ–ã—å¤§é‡ãƒ‡ãƒ¼ã‚¿ã«å‚™ãˆã‚‹
å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«æ ¼ç´ã™ã‚‹ã¨ä½•ã‹ã¨ä¸ä¾¿ã¨ãªã‚‹ã€‚å‡¦ç†å¯¾è±¡ãŒå¤§é‡ã ã‘ã«æ¤œç´¢ã‚’ã¯ã˜ã‚ã¨ã—ã¦å‡¦ç†æ™‚é–“ãŒå¤§ãããªã‚‹ã€‚ç¾å®Ÿã®ç”Ÿæ´»ã¯ã€æ‰‹ã«ä½™ã‚‹å¤§é‡ã®ç‰©ã‚’å°åˆ†ã‘ã«ã™ã‚‹ã¨ã„ã†ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ã‚ˆãä½¿ã†ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚‚ã“ã®æ‰‹æ³•ã¯æœ‰åŠ¹ã§ã‚ã‚‹ã€‚å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’å°åˆ†ã‘ã«ã™ã‚‹ã“ã¨ã§ã€å‡¦ç†ã®é«˜é€ŸåŒ–ã¨æ ¼ç´åŠ¹çŽ‡ã‚’å‘ä¸Šã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã‚ã‚‹ã€‚ä»Šå›žã¯ã€MySQL 5.1ã®æ–°æ©Ÿèƒ½ã®ç†é ã«ä¸ŠãŒã£ã¦ã„ã‚‹ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã‚’è§£èª¬ã™ã‚‹ã€‚ MySQL 5.1ã®æ³¨ç›®æ©Ÿèƒ½ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã¯ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã¨ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ†å‰²ã—ã¦æ€§èƒ½ã‚’å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®æŠ€è¡“ã ã€‚MySQL 5.0ã§ã‚‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®åˆ†å‰²æ©Ÿèƒ½ã¯ã‚ã£ãŸã€‚è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’é€£çµã—ã¦ï¼‘ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«è¦‹ã›ã‹ã‘ã‚‹MARGEã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³(ãƒ†ãƒ¼ãƒ–ãƒ«)ã€SELECTã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’çµåˆã™ã‚‹UNIONãªã©ãŒã‚ã‚‹ã€‚ã“ã‚Œã‚‰ã®æ©Ÿèƒ½ã¯ã€ã‚‚ã¨ã‚‚ã¨åˆ¥ã€…ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’çµåˆã—ã¦å‡¦ç†ã™ã‚‹å¾Œå‡¦ç†çš„ãªä½ç½®ã¥ã‘ã«ãªã‚‹
k_37to 2009/05/02
MySQL

performance

tuning

5.1

partitioning
ãƒªãƒ³ã‚¯
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
k_37to 2009/04/29
MySQL

5.1

tuning
ãƒªãƒ³ã‚¯
ã“ã“ãŒæ–°ã—ã„ï¼MySQL 5.1
MySQL 5.1ã¨MySQL Clusterã®åˆ†é›¢ MySQLã‚’é–‹ç™ºã—ã¦ã„ãŸMySQL ABãŒã€2008å¹´2æœˆã«ã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºã«è²·åŽã•ã‚Œã¾ã—ãŸã€‚è²·åŽä»¥å‰ã‚‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦äººæ°—ã‚’èª‡ã£ã¦ã„ãŸMySQLã§ã™ãŒã€è²·åŽå¾Œã¯ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰æ•°ãŒå¢—ãˆã€ã•ã‚‰ã«å‹¢ã„ã¥ã„ã¦ãã¦ã„ã‚‹ã‚ˆã†ã«æ€ã„ã¾ã™ã€‚æœ€è¿‘ã¯å°‘ã—ãƒãƒ¼ãƒ‰ãƒžãƒƒãƒ—ã«å¤‰åŒ–ã‚‚ã‚ã‚Šã€ã¾ãŸæœ€æ–°ç‰ˆã§ã‚ã‚‹MySQL 5.1ã‚‚ãƒªãƒªãƒ¼ã‚¹ãŒè¿‘ã¥ã„ã¦ã„ã¾ã™ã®ã§ã€ä»Šå›žã¯MySQLã®æœ€æ–°æƒ…å ±ã‚’ä¸å¿ƒã«ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¾ãšæœ€æ–°ç‰ˆã§ã‚ã‚‹MySQL 5.1ã§ã™ãŒã€åŽŸç¨¿åŸ·ç†æ™‚ç‚¹ï¼ˆ2008å¹´6æœˆä¸æ—¬ï¼‰ã§ã¯5.1.25-rcã¨ã„ã†ãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ã‚‚ã®ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ã¾ã™ã€‚GAãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ãƒªãƒªãƒ¼ã‚¹ãŒè¿«ã£ã¦ãã¦ã„ã‚‹ã®ã§ã€ã“ã®è¨˜äº‹ãŒæŽ²è¼‰ã•ã‚Œã‚‹ã“ã‚ã«ã¯ã¡ã‚‡ã†ã©GAãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ã‚‹ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ã€‚ å®Ÿã¯5.1.25-rcã§ã¯å¤§ããªå¤‰æ›´ãŒã‚ã‚Šã¾
k_37to 2008/07/09
MySQL

5.1
ãƒªãƒ³ã‚¯
1