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

wyukawa id:wyukawa

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

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

ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç–ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç– ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã®æ¾æµ¦éš¼äººã•ã‚“ã«ã€8ã¤ã®ã€ŒSQLãŒé‡ãŸããªã‚‹åŽŸå› ã¨ãã®å¯¾ç–ã€ã‚’èžãã¾ã—ãŸã€‚ã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚‹ã‚ˆã†ãªã€Œå•é¡Œã®ã‚ã‚‹SQLã€ã‚’å›žé¿ã™ã‚‹ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã³ã¾ã—ã‚‡ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æ“ä½œã‚„å®šç¾©ã‚’ã™ã‚‹è¨€èªžã€ŒSQLã€ã¯ã€ã©ã®ã‚ˆã†ãªé ˜åŸŸã‚’æ‹…ã†ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã‚‚å¿…ä¿®ç§‘ç›®ã§ã™ã€‚ã—ã‹ã—ã€ãã®ä»•æ§˜ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å„ªã‚ŒãŸSQLã‚’æ›¸ã‘ã‚‹æ–¹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚å•é¡Œã®ã‚ã‚‹SQLã‚’æ›¸ã„ã¦ã—ã¾ã„ã€çŸ¥ã‚‰ã¬é–“ã«ãã‚ŒãŒã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã†äº‹æ…‹ã¯ã‚ˆãç™ºç”Ÿã—ã¾ã™ã€‚ ã§ã¯ã€ã©ã†ã™ã‚Œã°ãã†ã—ãŸäº‹æ…‹ã‚’å›žé¿ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã®ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã¶ãŸã‚ã€ä»Šå›žã¯ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã§ã‚ã‚Šã€è‡ªèº«ã‚‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã‚ã‚‹æ¾æµ¦éš¼äººï¼ˆã¾ã¤ã†ã‚‰ãƒ»ã¯ã‚„ã¨ï¼@dblmktï¼‰ã•ã‚“ã«8ã¤
wyukawa 2017/06/27
sql

database
ãƒªãƒ³ã‚¯
http://www.vldb.org/pvldb/vol8/p1816-teller.pdf
wyukawa 2016/04/08
memory

database

facebook
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã§å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚¤ãƒ³ãƒ•ãƒ©ã‚’å¦ã‚“ã - ã‚†ã†ã†ããƒ–ãƒã‚°
ä¸ã€œå¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚¤ãƒ³ãƒ•ãƒ©ã®æ§˜åã‚’çŸ¥ã‚ŠãŸã„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã«ã€ã‚‚ã¨ã‚‚ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ãŸè¦–ç‚¹ã‹ã‚‰ã€å€‹äººçš„ãªä½“é¨“ã‚’ãƒ™ãƒ¼ã‚¹ã«ã¯ã¦ãªã§å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚¤ãƒ³ãƒ•ãƒ©ã‚’å¦ã‚“ã éŽç¨‹ã‚„å¦ã‚“ã å†…å®¹ã®ä¸€éƒ¨ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®å‘ã“ã†å´ ãªãœè¤‡æ•°ã®ã‚µãƒ¼ãƒãŒå¿…è¦ãªã®ã‹ çªç„¶ã®Webã‚µãƒ¼ãƒ“ã‚¹3å±¤æ§‹æˆ ãƒªãƒãƒ¼ã‚¹ãƒ—ãƒã‚ã‚· ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãã®ä»–ã®ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆ ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯éº»è–¬ é£›ã³é“å…·ã¨ã—ã¦ã®KVS/NoSQL éžåŒæœŸå‡¦ç† ãƒãƒƒãƒå‡¦ç† Mackerelã®å ´åˆ å‚è€ƒ ã¾ã¨ã‚ Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ ä»Šå¹´ã‚‚ã¯ã¦ãªã‚¤ãƒ³ã‚¿ãƒ¼ãƒ³ã®æ™‚æœŸãŒè¿‘ã¥ã„ã¦ããŸã€‚ æ¯Žå¹´ã§ã¯ãªã„ã‘ã©ã€ã¯ã¦ãªã‚¤ãƒ³ã‚¿ãƒ¼ãƒ³ã§ã¯ã€Œã‚¤ãƒ³ãƒ•ãƒ©è¬›ç¾©ã€ã¨ã„ã†ã®ã‚’ã‚„ã£ã¦ã„ã‚‹ã€‚ ä»Šå¹´ã¯ã‚¤ãƒ³ãƒ•ãƒ©è¬›ç¾©ã®è¬›å¸«ã¨ã—ã¦ã‚¢ã‚µã‚¤ãƒ³ã•ã‚ŒãŸã®ã§ã¡ã‚‡ã†ã©ä½•ã‚’è©±ã
wyukawa 2015/07/30
ã‚¤ãƒ³ãƒ•ãƒ©

webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

ã¯ã¦ãª

Web

database
ãƒªãƒ³ã‚¯
YappoLogs: ãªãœ SQL_CALC_FOUND_ROWS ã‚„ LIMIT OFFSET ã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ãŒè‰¯ãç„¡ã„ã®ã‹
ãªãœ SQL_CALC_FOUND_ROWS ã‚„ LIMIT OFFSET ã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ãŒè‰¯ãç„¡ã„ã®ã‹ ã“ã“æœ€è¿‘ã®å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹é–¢é€£ã—ãŸãƒ‡ãƒ¼ã‚¿ãƒšãƒ¼ã‚¸ãƒ³ã‚°è€ƒã§ã™ã€‚ mysql 5.5.34 ã§è©¦ã—ã¦è¨˜äº‹æ›¸ã„ã¦ã¾ã™ã€‚ bigdata ãƒ†ãƒ¼ãƒ–ãƒ«ã¯ id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ãªã‚«ãƒ©ãƒ ãŒã‚ã‚‹å‰æã§ã™ã€‚ã‚‚ã¡ã‚ã‚“ InnoDB ã§ã™ã€‚ 2014å¹´ãªã‚“ã ã‹ã‚‰COUNT(*)ã¨ã‹SQL_CALC_FOUND_ROWSã¨ã‹LIMIT OFFSETã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°ã¯ã‚„ã‚ã‚ˆã†ãœ - Togetterã¾ã¨ã‚ãŒç™ºç«¯ã«ã¿ãˆã‚‹ã‘ã©ã€ã‚ã‚Šã¨æ˜”ã‹ã‚‰è©±ã•ã‚Œã¦ã‚‹äº‹ãªã‚“ã ã‘ã©ã€ã€Œnippondanji SQL_CALC_FOUND_ROWSã€ã§ã‚°ã‚°ã£ã¦ã‚‚æœ‰ç”¨ãªæƒ…å ±ãªã„ã—æ–‡æ›¸åŒ–ã•ã‚Œã¦ãªã„ã‹ã‚‰ã—ã¨ãã€‚ ãƒšãƒ¼ã‚¸ãƒ³ã‚°å‡¦ç†ã§ä½¿ã‚ã‚ŒãŒã¡ãªæ©Ÿèƒ½ã§ã™ã€‚ S
wyukawa 2014/03/12
database
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ã¯æ‰‹ã‚’å–ã‚Šåˆã†ã¹ãã ã¨ã€ãƒžãƒ¼ãƒãƒ³ãƒ»ãƒ•ã‚¡ã‚¦ãƒ©ãƒ¼æ°
ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã¯å®˜åƒšçš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ã‚’å«Œã£ã¦ã€ç®¡ç†ä¸è¦ã®NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¸Œæœ›ã™ã‚‹ã“ã¨ãŒã‚ã‚‹ã‘ã‚Œã©ã€ä¸¡è€…ãŒæ‰‹ã‚’å–ã‚Šåˆã†ã“ã¨ã®æ–¹ãŒé‡è¦ã ã€‚ãƒžãƒ¼ãƒãƒ³ãƒ»ãƒ•ã‚¡ã‚¦ãƒ©ãƒ¼æ°ã¯å…ˆé€±ã€ã€ŒNoDBAã€ã¨ã„ã†è¨˜äº‹ã‚’è‡ªèº«ã®Webã‚µã‚¤ãƒˆã«ãƒã‚¹ãƒˆã—ã¾ã—ãŸã€‚ ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã«ã‚ˆã‚‹æœ€æ–°ã®é–‹ç™ºæ‰‹æ³•ã®æŽ¡ç”¨ã¨ãã®å£ã€NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€DevOpsã¨ã„ã£ãŸITã®ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‚’å«ã‚€ã“ã®è¨˜äº‹ã¯ç¿»è¨³ãŒè¨±å¯ã•ã‚Œã¦ã„ã‚‹ãŸã‚ã€æ—¥æœ¬èªžè¨³ã—ã¦ã¿ã¾ã—ãŸã€‚ NoDBA å¤šãã®çµ„ç¹”ã«ãŠã„ã¦ã€ä¿å˜ãŒå¿…è¦ãªãƒ‡ãƒ¼ã‚¿ã¯æƒ…å ±éƒ¨é–€ãŒé›†ä¸ç®¡ç†ã™ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«åŽã¾ã‚‹ã“ã¨ã ã‚ã†ã€‚æƒ…å ±éƒ¨é–€ãŒé›†ä¸ç®¡ç†ã™ã‚‹ç†ç”±ã¯ãã‚Œãžã‚Œã ãŒã€çµ±åˆçš„ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é‹ç”¨ãŒä¸€èˆ¬çš„ãªç†ç”±ã ã‚ã†ã€‚ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã—ã¦ã„ã‚‹éƒ¨é–€ã¯ã€å¤‰ãªãƒ‡ãƒ¼ã‚¿ãŒç´›ã‚Œè¾¼ã¾ãªã„ã‹ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’é…ãã™ã‚‹ã‚ˆã†ãªã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•ã‚ŒãŸã‚Šã—ãªã„ã‹ã€ä¼æ¥å…¨ä½“ã§ä¸€è²«æ€§ã®ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ãŒå®Ÿç¾ã•ã‚Œã¦ã„ã‚‹ã‹ã€ã¨ã„ã£ãŸ
wyukawa 2013/03/05
ãµã†ã‚€ã€‚

nosql

devops

database
ãƒªãƒ³ã‚¯
1