[B! index] nobu666ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nobu666 id:nobu666

indexã«é–¢ã™ã‚‹nobu666ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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 INDEX + EXPLAINå…¥é–€ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ é–‹ç™ºè€…ãªã‚‰çŸ¥ã£ã¦ãŠããŸã„ MySQL INDEX + EXPLAINå…¥é–€ åºƒãæµ…ãã‚’æ‹…å½“ã—ã¦ã¾ã™ã€ota ã§ã™ã€‚ æŠ€è¡“ãƒ–ãƒã‚°ç¬¬ä¸€å›žã‹ã‚‰æ—©é€Ÿæµç”¨ã‚¹ãƒ©ã‚¤ãƒ‰ã§ç”³ã—è¨³ã‚ã‚Šã¾ã›ã‚“ãŒã€ç¤¾å†…å‹‰å¼·ä¼šè³‡æ–™ã¨ã—ã¦ä½œæˆã—ãŸã€ŒMySQL INDEX + EXPLAINå…¥é–€ã€ã§ã™ã€‚ å½“ç¤¾ã§ã‚‚ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®é–‹ç™ºã‚’è¡Œã£ã¦ã„ã¾ã™ãŒã€ã“ã®ã‚ˆã†ãªå¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ç”¨ã™ã‚‹ãƒ»ã‚¯ã‚¨ãƒªã®é€Ÿåº¦ãŒæ±‚ã‚ã‚‰ã‚Œã‚‹å ´åˆã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å¤§å¤‰é‡è¦ã§ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æœ‰åŠ¹ãªåˆ©ç”¨ã«ã¯DBè¨è¨ˆè€…ã ã‘ã§ã¯ãªããƒ—ãƒã‚°ãƒ©ãƒžã«ã‚‚ã‚ã‚‹ç¨‹åº¦ã®çŸ¥è˜ãŒæœ€ä½Žé™å¿…è¦ã¨ãªã‚Šã¾ã™ãŒã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã®åˆå¿ƒè€…å‘ã‘è³‡æ–™ãŒã‚ã¾ã‚Šãªã„ã‚ˆã†ã§ã™ã€‚ ã“ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ã¯ãƒ—ãƒã‚°ãƒ©ãƒžã«çŸ¥ã£ã¦ãŠã„ã¦æ¬²ã—ã„ä»¥ä¸‹ã®åŸºæœ¬çš„ãªç‚¹ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ INDEXã‚’ä½¿ç”¨ã™ã‚‹æ™‚ã«æ°—ã‚’ã¤ã‘ã‚‹ã“ã¨ WHEREå¥ !=ã€<>ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒä½¿ç”¨ã§ããªã„ WHEREå¥ã®å…¨ã¦ã®ANDã«ã‹ã‹ã£ã¦ã„ãªã„ã‚¤ãƒ³
nobu666 2011/03/29
mysql

index

performance
ãƒªãƒ³ã‚¯
é–‹ç™ºãƒ¡ãƒ¢: IndexDB: è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãŸã‚ã®DB
å¤§éœ‡ç½ã®æ™‚åˆ†ã«ä½•ã ãŒã€Kyoto Cabinetãƒ™ãƒ¼ã‚¹ã§æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã®æ ¸ã¨ãªã‚‹è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã‚‹ã®ã«é©ã—ãŸDBã‚’å®Ÿè£…ã—ãŸã¨ã„ã†è©±ã€‚ è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨appendæ“ä½œ å¤šãã®æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã®æ ¸ã¨ãªã‚‹è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ã€æ¤œç´¢èªžã«ä¸€è‡´ã™ã‚‹è¡¨ç¾ãŒã©ã“ã«å‡ºã¦ããŸã‹ã¨ã„ã†ä½ç½®æƒ…å ±ã®ãƒªã‚¹ãƒˆã‚’ä¿æŒã™ã‚‹ã‚‚ã®ã§ã‚ã‚Šã€æ¤œç´¢èªžã‚’ã‚ãƒ¼ã¨ã—ã¦ä½ç½®æƒ…å ±ãƒªã‚¹ãƒˆã‚’å€¤ã¨ã™ã‚‹é€£æƒ³é…åˆ—ã§ã‚ã‚‹ï¼ˆè»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã‚ãªã„æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã‚‚ã‚ã‚‹ãŒï¼‰ã€‚ã“ã®ä½ç½®æƒ…å ±ãƒªã‚¹ãƒˆã‚’posting listã¨ã‹å‘¼ã‚“ã ã‚Šã™ã‚‹ã‚‰ã—ã„ã€‚è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã‚‚ã„ãã¤ã‹æµå„€ãŒã‚ã‚Šã€æ¤œç´¢èªžã‚’ã©ã®ã‚ˆã†ã«åˆ‡ã‚Šåˆ†ã‘ã‚‹ã‹ã§å˜èªžï¼ˆåˆ†ã‹ã¡æ›¸ãï¼‰æ–¹å¼ã¨ã‹æ–‡å—N-gramæ–¹å¼ã¨ã‹å‘¼ã°ã‚Œã‚‹ã‚‚ã®ãŒã‚ã£ãŸã‚Šã™ã‚‹ãŒã€ã„ãšã‚Œã«ã›ã‚ˆã€å°ã•ã„ã‚ãƒ¼ã¨ã€éžå¸¸ã«ã§ã‹ã„å€¤ã‚’ä¿æŒã™ã‚‹é€£æƒ³é…åˆ—ã‚’ä½œã‚‹ã“ã¨ã«ã¯å¤‰ã‚ã‚Šãªã„ã€‚ ã§ã€ç´ æœ´ã«è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã‚ã†ã¨ã™ã‚‹ã¨ã€æ¤œç´¢å¯¾è±¡ã®æ–‡æ›¸ã‚’è§£æžã—ãªãŒã‚‰ã€å¾—ã‚‰ã‚Œ
nobu666 2011/03/16
database

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

index

performance
ãƒªãƒ³ã‚¯
MySQL ã® MEMORY(HEAP) ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ã†ã¨ãã¯ index_type ã«æ°—ã‚’ã¤ã‘ã‚ - @kyanny's blog
çµè«–: MEMORY ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã® index_type ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ HASH ãªã®ã§ = or <=>æ¼”ç®—åã‚’ä½¿ç”¨ã™ã‚‹ç‰ä¾¡æ¯”è¼ƒã«ã®ã¿ä½¿ç”¨ã•ã‚Œã‚‹ã€‚ >, >=, <, <=, BTWEEN ã‚’ä½¿ã†ã‚¯ã‚¨ãƒªã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã„ãŸã„ã¨ãã¯ USING BTREE ã‚’ã¤ã‘ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã‚‹ã“ã¨ã€‚ MySQL 5.0.75 (ã‚„ã‚„å¤ã‚ã‹ã—ã„ï¼Ÿï¼‰ã‚’ä½¿ã£ã¦ã„ã¦ã€ MEMORY ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€ SELECT * FROM tbl WHERE col1 = 'val1' AND col2 <= 'val2';ãªã‚“ã¦ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ãŸã‚‰å¦™ã«é…ã‹ã£ãŸã€‚ col1, col2 ã®é †ç•ªã§è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¯ã£ã¦ã„ã‚‹ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€‚ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«èªã‚“ã ã‚‰ã¡ã‚ƒã‚“ã¨æ›¸ã„ã¦ã‚ã‚Šã¾ã—ãŸã€‚ã‚ã‚“ã¾ã‚Šä½¿ã†æ©Ÿä¼šã‚‚ãªã„ã ã‚ã†ã‘ã©ï¼ˆã ã‹ã‚‰ã“ãï¼Ÿï¼‰ãƒ¡ãƒ¢ã€‚ ãã®åå‰ã‹ã‚‰ã‚‚ã‚ã‹ã‚‹ã‚ˆã†ã«ã€MEMORY ãƒ†ãƒ¼ãƒ–ãƒ«ã¯
nobu666 2010/01/12
mysql

database

index
ãƒªãƒ³ã‚¯
MySQLã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦é«˜é€ŸåŒ–ã™ã‚‹ãªã‚‰Covering IndexãŒä½¿ãˆãã† - (ï¾Ÿâˆ€ï¾Ÿ)oå½¡ sasata299's blog
2009å¹´10æœˆ28æ—¥09:33 MySQL MySQLã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦é«˜é€ŸåŒ–ã™ã‚‹ãªã‚‰Covering IndexãŒä½¿ãˆãã† Linux-DB ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/é‹ç”¨å…¥é–€ (DB Magazine SELECTION) è‘—è€…ï¼šæ¾ä¿¡ å˜‰ç¯„ è²©å£²å…ƒï¼šç¿”æ³³ç¤¾ ç™ºå£²æ—¥ï¼š2009-09-17 ãŠã™ã™ã‚åº¦ï¼š ã‚¯ãƒã‚³ãƒŸã‚’è¦‹ã‚‹ æœ€è¿‘ã€ã“ã®æœ¬ã‚’èªã‚“ã§ã„ã¾ã™ã€‚éžå¸¸ã«é¢ç™½ã„ã—ã€å‚è€ƒã«ãªã‚Šã¾ã™ã€œã€‚ä¸ã§ã‚‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã®è¨˜äº‹ãŒç‰¹ã«èˆˆå‘³æ·±ã‹ã£ãŸã®ã§ç°¡å˜ã«ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ å‰æ ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯æ¤œç´¢æ€§èƒ½ã«ã¯åŠ¹æžœãŒã‚ã‚‹ãŒã€æ›´æ–°æ€§èƒ½ã¯è½ã¡ã¦ã—ã¾ã† ãƒ»MyISAM ã¨ InnoDB ã§ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹é€ ãŒé•ã† ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ B+Tree ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨å‘¼ã°ã‚Œã€ãƒ«ãƒ¼ãƒˆã€ãƒ–ãƒ©ãƒ³ãƒã€ãƒªãƒ¼ãƒ•ã®éšŽå±¤æ§‹é€ ã«ãªã£ã¦ã„ã‚‹ ãƒ»ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã‚½ãƒ¼ãƒˆã•ã‚ŒãŸçŠ¶æ…‹ã§ä½œæˆã•ã‚Œã¦ã„ã‚‹ ã¾ãšã¯ MyISAM ã¨ InnoDB ã§ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹
nobu666 2009/10/28
mysql

database

index

performance
ãƒªãƒ³ã‚¯
Luke - Lucene Index Toolbox
Luke - Lucene Index Toolbox Important note: Luke is now hosted at Google Code: http://code.google.com/p/luke/ and you should go to that page to obtain the latest release of Luke. This page contains only information about past releases and is no longer up to date. Lucene is an Open Source, mature and high-performance Java search engine. It is highly flexible, and scala ble from hundreds to millions
nobu666 2009/10/05
lucene

java

tools

index
ãƒªãƒ³ã‚¯
LuSQL | é–¢å£å®å¸ã®Luceneãƒ–ãƒã‚°
ä¸€å®šæœŸé–“æ›´æ–°ãŒãªã„ãŸã‚åºƒå‘Šã‚’è¡¨ç¤ºã—ã¦ã„ã¾ã™
nobu666 2009/07/14
java

lucene

sql

index
ãƒªãƒ³ã‚¯
1