[B! database] tomityã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tomity id:tomity

databaseã«é–¢ã™ã‚‹tomityã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

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

mixi Engineersâ€™ Blog Â» Tokyo Tyrantã«ã‚ˆã‚‹è€é«˜è² è·DBã®æ§‹ç¯‰
é€£ä¼‘ä¸ã¯Wiiã®ãƒžãƒªã‚ªã‚«ãƒ¼ãƒˆã‚’ã‚„ã‚Šã¾ãã£ã¦ã‚„ã£ã¨VR7000è¶ŠãˆãŸmikioã§ã™ã€‚æ„›è»Šã¯ãƒžãƒƒãƒãƒ»ãƒã‚¤ã‚¯ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ã‚»ãƒ—ã‚¿ãƒ¼ã§ã™ã€‚ã•ã¦ä»Šå›žã¯ã€åˆ†æ•£ãƒãƒƒã‚·ãƒ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒTokyo Tyrantã§mixiã®æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã‚’ç®¡ç†ã™ã‚‹ã‚ˆã†ã«ã—ãŸæ™‚ã®è‹¦åŠ´è©±ã‚’æ›¸ãã¾ã™ã€‚ ãƒã‚°ã‚¤ãƒ³å‡¦ç†ã¯è² è·åœ°ç„ mixiã§ã¯ã€å…¨ã¦ã®ãƒ¦ãƒ¼ã‚¶ã«ã¤ã„ã¦ã€å„ã€…ã®æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã‚’ç®¡ç†ã—ã¦ã„ã¾ã™ã€‚ã€Œãƒžã‚¤ãƒŸã‚¯ã‚·ã‚£ä¸€è¦§ã€ã‚„ã€ŒãŠæ°—ã«å…¥ã‚Šã€ãªã©ã®ç”»é¢ã§ã€å‹äººãŒè¿‘ã„æ™‚é–“ã«ãƒã‚°ã‚¤ãƒ³ã—ã¦ã„ã¦ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã¨ã‚Šã‚„ã™ã„çŠ¶æ…‹ã«ã‚ã‚‹ã‹ã©ã†ã‹ç¢ºèªã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã§ã™ã€‚ mixiã®ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã¯ãƒã‚°ã‚¤ãƒ³ã—ãªã„ã¨è¦‹ã‚‰ã‚Œãªã„ãƒšãƒ¼ã‚¸ãªã®ã§ã€ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹ãŸã³ã«ãƒã‚°ã‚¤ãƒ³ç¢ºèªãŒè¡Œã‚ã‚Œã¾ã™ã€‚ã—ãŸãŒã£ã¦ã€æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã¯ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹åº¦ã«æ›´æ–°ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚mixiã®ä¸ã§æœ€ã‚‚é‡ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã²ã¨ã¤ã¨ã—ã¦ã€Œ
tomity 2010/07/23
[for:@twitter]

mixi

database

memcached

db

mysql

web

programming

tips
ãƒªãƒ³ã‚¯
Lux IO - Yet Another Fast Database Manager
Lux IO is a yet another fast database manager. It supports B+-tree and Array index in either cluster or non-cluster index. It's originally designed for storing large expanding data as a value in Lux Search Engine, but it's also pretty fast for small and a large number of data. Fast key lookup (B+-tree, Array) Support both clustered and non-clustered index mmap(2) the whole index structure in clust
tomity 2010/07/23
[for:ã‚ã¨ã§ã‚½ãƒ¼ã‚¹èªã‚“ã§ã¿ã‚‹][for:@twitter]

database

library

c++

software

programming

db
ãƒªãƒ³ã‚¯
ã‚¢ã‚¤ãƒ•ãƒ« ç”³è¾¼ã¿å…¥ãƒ
è³ƒè²¸ä½å®…ä½ã¾ã„ã€ç‹¬èº«ã®æ–¹ã€æ‰€å¾—ã‚‚ä½Žé¡ã¨ã„ã†çŠ¶æ…‹ã§ã‚‚å¹´åŽã®ï¼“åˆ†ã®ï¼‘ã‚ˆã‚Šå°‘ãªã„é‡‘é¡ã‚’å¸Œæœ›ã™ã‚‹ãªã‚‰ã°ã€å¯©æŸ»ã§OKã¨ãªã‚‹ã“ã¨ã‚‚æœŸå¾…ã•ã‚Œã‚‹ã¨è¨€ã£ã¦ã‚ˆã„ã¨æ€ã„ã¾ã™ã€‚ é•·ã„äººç”Ÿã®ä¸ã«ãŠã„ã¦ã¯ã€ã©ã‚“ãªäººã§ã‚‚æ€ã„ãŒã‘ãšã€å¾…ã£ãŸãªã—ã§ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒå…¥ç”¨ã«ãªã‚‹ã“ã¨ãŒã‚ã‚‹ã§ã—ã‚‡ã†ã€‚ã“ã†ã„ã£ãŸæ™‚ã«ã¯ã€å³æ—¥èžè³‡ã«å¯¾å¿œã—ã¦ã„ã‚‹ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒéžå¸¸ã«å½¹ã«ç«‹ã¤ã¨æ€ã„ã¾ã™ã€‚ ã€ŒéŠ€è¡Œã§ç”³è«‹ã™ã‚‹ã‚«ãƒ¼ãƒ‰ãƒãƒ¼ãƒ³ã€ã¯ãŸã¾ãŸä¿¡è²©ç³»ã®è²¸ä»˜ã‚µãƒ¼ãƒ“ã‚¹ã¨ã„ã†ã®ã¯ã€å®Ÿéš›ã®ã¨ã“ã‚å¯©æŸ»ã«æ™‚é–“ã‚’ã‹ã‘ã‚‹ã®ã§ã¯ãªã„ã‹ï¼Ÿï¼½ã¨å¿ƒé…ã—ã¦ã„ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ã“ã“æœ€è¿‘ã§ã¯å³æ—¥èžè³‡ã‚’å®Ÿæ–½ã—ã¦ã„ã‚‹é‡‘èžæ¥è€…ã‚‚æ¬¡ç¬¬ã«å¤šããªã£ã¦ã„ã‚‹ã¨ã®ã“ã¨ã§ã™ã€‚ ã©ã‚“ãªå†…å®¹ã®ãƒãƒ¼ãƒ³ã‚’çµ„ã‚€ã¨ã—ã¾ã—ã¦ã‚‚ã€ä¸‡ãŒä¸€ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã«ã‚ˆã£ã¦ãŠé‡‘ã‚’å€Ÿã‚Šã¦ã„ã‚‹çŠ¶æ³ãªã‚‰ã€ãƒãƒ¼ãƒ³åˆ©ç”¨ã«ã‚ˆã‚‹å€Ÿå…¥é‡‘ã¯ç¸®æ¸›ã•ã‚Œã‚‹ã“ã¨ã¯è€ƒãˆã‚‰ã‚Œã‚‹ã§ã—ã‚‡ã†ã€‚ çµ¦æ–™æ—¥ãŒæ¥ã‚‹ã¾ã§ã€æ•°æ—¥é–“åŠ©ã‘ã¦è²°ãˆã‚‹ã®ãŒã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿç·Šæ€¥ã®æ™‚ã
tomity 2010/06/17
database

programming

db

source

oss
ãƒªãƒ³ã‚¯
RDBMSã‚’Key-Value Storageã¨ã—ã¦ä½¿ã†å ´åˆã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¨ˆæ¸¬ï¼ˆH2, MySQLç·¨ï¼‰ - kaisehã®ãƒ–ãƒã‚°
Tokyo Cabinet, QDBM, Lux IOãªã©ã€DBMåŒå£«ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒã¯Webã§è‰¯ãè¦‹ã‹ã‘ã‚‹ã®ã§ã™ãŒã€MySQLã®ã‚ˆã†ãªæ™®é€šã®RDBMSã‚’Key-Value Storageçš„ã«ä½¿ç”¨ã—ãŸå ´åˆã€DBMã¨æ¯”ã¹ã¦ã©ã‚Œãã‚‰ã„å·®ãŒä»˜ãã‚‚ã®ãªã®ã‹ã‚¤ãƒ¡ãƒ¼ã‚¸ãŒæ¹§ã‹ãªã‹ã£ãŸã®ã§ã€å®Ÿéš›ã«è¨ˆæ¸¬ã—ã¦ã¿ã¾ã—ãŸã€‚ Javaãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ã€Berkeley DBã€H2ã€MySQLã®3ç¨®é¡žã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’ä½¿ç”¨ã—ã¾ã—ãŸã€‚æ¡ä»¶ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ Berkeley DB Java Edition 3.3.75 ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®š H2 1.1.106 jdbc:h2:file:~/dbmbench Embeddedãƒ¢ãƒ¼ãƒ‰ã§ä½¿ç”¨ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®š DDLã¯ä»¥ä¸‹ã‚’ä½¿ç”¨ create table casket ( id integer auto_increment primary key, key_ varchar(255
tomity 2010/05/07
database

mysql

db
ãƒªãƒ³ã‚¯
Netflix - Watch TV Shows Online, Watch Movies Online
'); doc.close(); } if (!doc) throw Error('base not supported'); var baseTag = doc.createElement('base'); baseTag.href = base; doc.getElementsByTagName('head')[0].appendChild(baseTag); var anchor = doc.createElement('a'); anchor.href = url; return anchor.href; } finally { if (iframe) iframe.parentNode.removeChild(iframe); } }()); } // An inner object implementing URLUtils (either a native URL // ob
tomity 2009/04/21
programming

statistics

movie

database

business

dataset

community
ãƒªãƒ³ã‚¯
Internet Archive
tomity 2009/02/20
database

library

web

tools

music

media

video

history
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
tomity 2009/02/19
database

web

tools

DB

tips

mysql

sql
ãƒªãƒ³ã‚¯
Tokyo Cabinet
Tokyo Cabinet is the successor of QDBM, a high performance database library similar to the DBM family. It also supports hash and B-tree databases and does not require any server process. The overall speed is improved compared to QDBM.
tomity 2009/01/13
database

programming

library

java

perl

ruby
ãƒªãƒ³ã‚¯
Leo's Chronicle: ãœã²æŠ¼ã•ãˆã¦ãŠããŸã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ•™ç§‘æ›¸
å…ˆæ—¥ã®ã‚¨ãƒ³ãƒˆãƒªã§å°‘ã—è©±ã—ãŸã®ã§ã™ãŒã€åƒ•ãŒåœ¨å¦ã—ã¦ã„ãŸã¨ãã®æ±å¤§ã«ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¦ã¶ãŸã‚ã®ã‚³ãƒ¼ã‚¹ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸï¼ˆDBé–¢ä¿‚ã®æŽˆæ¥ã¯å¹´ã«ï¼‘ã¤ã‹ï¼’ã¤ã‚ã‚‹ç¨‹åº¦ã€‚ç¾åœ¨ã¯ã©ã†ãªã‚“ã ã‚ã†ï¼Ÿï¼‰ã€‚ãã‚“ãªã¨ãã«å½¹ã ã£ãŸã®ã¯ã€ã‚„ã¯ã‚Šæ•™ç§‘æ›¸ã€‚èªã¿ã‚„ã™ã„ã‚‚ã®ã‹ã‚‰é †ã«ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ï¼ˆã¨ã¯ã„ã£ã¦ã‚‚ã™ã¹ã¦è‹±èªžã®æœ¬ã§ã™ã€‚ã‚ã—ã‹ã‚‰ãšï¼‰ ä¸€ç•ªã®ãŠè–¦ã‚ã¯ã€Raghu Ramakrishnanå…ˆç”Ÿ (ç¾åœ¨ã¯ã€Yahoo! Research) ã®ã€ŒDatabase Management Systems (3rd Edition)ã€ã€‚åˆå¦è€…ã‹ã‚‰ç ”ç©¶è€…ã¾ã§å¹…åºƒãä½¿ãˆã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã®åŸºæœ¬æ¦‚å¿µã‹ã‚‰ã€å•ã„åˆã‚ã›æœ€é©åŒ–ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ç®¡ç†ãªã©ã€ã“ã‚Œã‚‰ã‚’å®Ÿè£…ãƒ»è©•ä¾¡ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã€ã€ŒDBã®ä¸–ç•Œã§ã®å¸¸è˜ã€ãŒã€ä¸å¯§ãªèªžã‚Šå£ã§ãµã‚“ã ã‚“ã«ç››ã‚Šè¾¼ã¾ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®1å†Šã‚’èªã‚“ã§ãŠã‘ã°ã€DBã®ä¸–ç•Œã§è°è«–ã™ã‚‹ãŸã‚ã®
tomity 2009/01/08
database

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
Googleã€MySQLã‚’å¼·åŒ–ã™ã‚‹ãƒ‘ãƒƒãƒã‚’ç„¡å„Ÿãƒªãƒªãƒ¼ã‚¹ï¼šCodeZine
Googleã¯ã€åŒç¤¾ã®è£½å“é–‹ç™ºã®ä¸ã‹ã‚‰ç”Ÿã¾ã‚ŒãŸMySQLã‚’å¼·åŒ–ã™ã‚‹ãƒ‘ãƒƒãƒã‚’å…¬é–‹ã—ãŸã€‚Googleã®Webã‚µã‚¤ãƒˆã‹ã‚‰ç„¡å„Ÿã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ ã“ã®ãƒ‘ãƒƒãƒã¯MySQLã®æ‰±ã„ã‚„ã™ã•ã¨ä¿¡é ¼æ€§ã‚’å‘ä¸Šã•ã›ã‚‹ç›®çš„ã§ä½œã‚‰ã‚Œã¦ãŠã‚Šã€ä¸»ã«ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒï¼ˆãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ãªã‚‹ã‚µãƒ¼ãƒï¼‰ã®æ©Ÿèƒ½ã‚’å¼·åŒ–ã•ã›ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ä¾‹ã¨ã—ã¦ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒãŒæ›´æ–°é€šçŸ¥ã‚’å—ã‘å–ã‚‰ãªã„é™ã‚Šãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒã‚’æ›´æ–°ã•ã›ãªã„æ©Ÿèƒ½ã‚„ã€å†èµ·å‹•ãªã—ã§ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã‚’ãƒžã‚¹ã‚¿ã‚µãƒ¼ãƒã«ç½®ãæ›ãˆã‚‹æ©Ÿèƒ½ãªã©ãŒå‚™ã‚ã£ã¦ã„ã‚‹ã€‚ ä»–ã«ã‚‚ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã«ãªã£ã¦ã„ã‚‹ã‚¢ã‚«ã‚¦ãƒ³ãƒˆãƒ»ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ã™ã‚‹ã‚‚ã®ã‚„ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ/MySQLé€šä¿¡ã®ãŸã‚ã®é«˜é€Ÿãªåœ§ç¸®æ©Ÿèƒ½ãªã©ã‚‚ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã€‚ ã¡ãªã¿ã«ã€ã“ã®ãƒ‘ãƒƒãƒã¯Linuxä¸Šã§å‹•ä½œã™ã‚‹InnoDBç”¨ã«æœ€é©åŒ–ã•ã‚ŒãŸã‚‚ã®ã¨ãªã£ã¦ã„ã‚‹ã€‚ãã®ç†ç”±ã¨ã—ã¦Googleã¯ã€Œæˆ‘ã€…ãŒInnoDBã‚’ä½¿ã£ã¦ã„ã‚‹ãŸã‚ã€ã¨èª¬æ˜Žã—ã¦ã„ã‚‹ã€‚ã¾ãŸã€ç¾åœ¨ãƒ‘
tomity 2008/06/24
google

mysql

database
ãƒªãƒ³ã‚¯
1