[B! mysql][å‹‰å¼·ä¼š] harumaki_netã®ãƒ

harumaki_net id:harumaki_net

mysqlã¨å‹‰å¼·ä¼šã«é–¢ã™ã‚‹harumaki_netã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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 Casual Talks vol.6ã€ã«å‚åŠ ã—ã¦ããŸï¼†è³‡æ–™ã¾ã¨ã‚ #mysqlcasual - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€…
ä¹…ã—ã¶ã‚Šã«MySQLã‚¬ãƒãƒ¥ã‚¢ãƒ«ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«å‚åŠ ã—ã¦ããŸã®ã§ã€ãã‚“ãªãƒã‚°ã¨è³‡æ–™ã‚’ã¾ã¨ã‚ã¦ãŠã“ã†ã¨æ€ã„ã¾ã™ã€‚ zusaar.comÂ -&nbspzusaar ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ± å°šã€ã“ã®ã‚¤ãƒ™ãƒ³ãƒˆã®éŽåŽ»ã®å‚åŠ è¨˜éŒ²ã¯ä»¥ä¸‹ã€‚ ã€ŒMySQL Casual Talks vol.1ã€ã«å‚åŠ ã—ã¦ããŸã‚ˆã€ã®ãƒ¡ãƒ¢ ã€ŒMySQL Casual Talks vol.2ã€ã«å‚åŠ ã—ã¦ããŸã‚ˆã€ã®ãƒ¡ãƒ¢ ã€ŒMySQL Casual Talks vol.3ã€ã«å‚åŠ ã—ã¦ããŸã‚ˆã€ã®ãƒ¡ãƒ¢ ã€ŒMySQL Casual Talks Vol.4ã€ã®ã‚¨ã‚¢å‚åŠ ãƒ¬ãƒãƒ¼ãƒˆ vol.4ãŒã‚¨ã‚¢å‚åŠ ã§ã€vol.5ãƒ»ãƒ»ãƒ»ã£ã¦ã„ã¤ã‚„ã£ãŸã®ã€‚ã€‚ã€‚ãªæ„Ÿã˜ã§ä¹…ã—ã¶ã‚Šã«å‚åŠ ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ TokuDBè©¦ã—ã¦ã¿ã‚‹ (@yoku0825) TokuDBè©¦ã—ã¦ã¿ã‚‹ from yoku0825 TokuDBã€InnoDBã®3å€ãã‚‰ã„åœ§ç¸®ãŒåŠ¹ãã¨ã®ã“ã¨ã§ã€ãƒ¬ã‚¤ãƒ†ãƒ³ã‚·
harumaki_net 2014/07/12
MySQL

å‹‰å¼·ä¼š

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
MySQLã®æœ€å…ˆç«¯ã‚’è¡Œãç¾å ´äººãŒé›†ã† MySQL Casual Talks #6ã«è¡Œã£ã¦ããŸï¼ - ã‚‚ãã‚ã½ã‚ã
TokuDBã¨ã¯TokutekãŒä½œã£ãŸFractalTree(R)Indexã‚’å®Ÿè£…ã—ãŸã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ ç‰¹å¾´ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ALTER TABLE(ADD INDEX, ADD COLUMN)ã«å¯¾å¿œ åœ§ç¸®ãŒã‚¤ã‚±ã¦ã‚‹ æ–ç‰‡åŒ–ã—ãªã„ ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’è¤‡æ•°ä½œã‚Œã‚‹ infromation_schema, show engine tokuDB ã§æƒ…å ±ã¿ã‚Œã‚‹ãŒãªã‚Œã‚‹ã®ã«æ™‚é–“ã‹ã‹ã‚‹ foreign keyã¯å¯¾å¿œã—ã¦ãªã„ How TokuDB Fractal TreeTM Indexes Work ãƒ©ãƒ³ãƒ€ãƒ ãƒ©ã‚¤ãƒˆãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹ç¯‰ãŒæ—©ã„ Insertã®TPSã¯ã„ã¤ã¾ã§ã‚‚ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆãŒå¤‰ã‚ã‚‰ãªã„ ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ twitterã¿ãŸã„ãªã“ã¨ã‚’ã‚„ã‚ã†ã¨ã—ãŸ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚¯ãƒã‚¹ã—ã¦timelineãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ timelineãƒ†ãƒ¼ãƒ–ãƒ«ã¯6å„„ä»¶ ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºå›³ã£ãŸã‚‰innodb compactã¯60Gå¼±ã€
harumaki_net 2014/07/12
MySQL

å‹‰å¼·ä¼š
ãƒªãƒ³ã‚¯
MySQL Indexå‹‰å¼·ä¼šå¤–éƒ¨å…¬é–‹ç”¨
12. Â© CROOZ,Inc. 12 ï¼‘ï¼ŽINDEXã¨ã¯ãªã«ã‹ ä½•æžšç›®ãŒãªã«ã‹ã‚’äº‹å‰ã«ãƒ¡ãƒ¢ã£ã¦ãŠã‘ã°è‰¯ã„ï¼ ã‚¹ãƒ¼ãƒˆ ãƒ©ãƒ³ã‚¯ ä½ç½® ãƒãƒ¼ãƒˆ Q 1 ã‚¹ãƒšãƒ¼ãƒ‰ 9 2 : : : ãƒ€ã‚¤ãƒ¤ 1 40 : : : ã‚¹ãƒšãƒ¼ãƒ‰ 6 45 ãªãœãªã‚‰ã€è¦æ±‚ã¯ã€Œã‚«ãƒ¼ãƒ‰ã‚’å¼•ãå›žæ•°ã‚’æœ€ã‚‚å°‘ãªã ã—ã¦ã‚¹ãƒšãƒ¼ãƒ‰6ã‚’æŽ¢ã™ã“ã¨ã€ ã‚»ã‚³ã„ã¨ã‹ãŠã‚‚ã†ãƒ’ãƒˆã¯ã„ã‚‹ã‹ ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒä½•ã‚‚ã‚»ã‚³ã„ã“ ã¯ã—ã¦ã„ãªã„ã§ã™ã€‚ å‰ææ¡ä»¶ãªã©ä¸€åˆ‡ãªã„ã‹ã‚‰ ã“ã®ãƒ¡ãƒ¢ã•ãˆã‚ã‚Œã°ä½ç½®ã‚’æŒ‡å®šã—ã¦1å›žå¼•ã‘ã°æ¸ˆã‚€
harumaki_net 2013/09/12
MySQL

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

å‹‰å¼·ä¼š
ãƒªãƒ³ã‚¯
qpstudyã§ç™ºè¡¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¾ã—ãŸã€‚
æœ¬æ—¥ã€qpstudyã§ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ã€ã¨ã„ã†å†…å®¹ã«ã¤ã„ã¦ã€ãã—ã¦ã€Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã¨ã¯ã€ã¨ã„ã†å†…å®¹ã«ã¤ã„ã¦è©±ã™æ©Ÿä¼šã‚’é ‚ã„ãŸã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã¨ã„ã†ç¡¬ã„å†…å®¹ã§ã‚ã£ãŸã«ã‚‚é–¢ã‚ã‚‰ãšã€å‡ºå¸è€…ã®çš†ã•ã‚“ã«ã¯æœ€å¾Œã¾ã§è‰¯ã„åå¿œã‚’ã—ã¦é ‚ã‘ãŸã‚ˆã†ã«æ€ã†ã€‚å®Ÿã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦èª¤è§£ã—ã¦ã„ã‚‹ã€ã‚ã‚‹ã„ã¯çŸ¥ã‚‰ãªã„äººãŒæœ¬å½“ã«å¤šã„ã€ãã—ã¦è‰¯ã„è§£èª¬æ›¸ãŒãªã„ã¨ã„ã†ã“ã¨ã‚’æ™®æ®µå•é¡Œã¨ã—ã¦æ„Ÿã˜ã¦ãŠã‚Šã€ãã†ã„ã£ãŸèƒŒæ™¯ã‹ã‚‰ä»Šå›žqpstudyã®è©±ã‚’å¼•ãå—ã‘ã•ã›ã¦è²°ã£ãŸã€‚ä»Šå›žç™ºè¡¨ã—ãŸå†…å®¹ãŒçš†ã•ã‚“ã®ãŠå½¹ã«ç«‹ã¦ã°å¹¸ã„ã§ã‚ã‚‹ã€‚ ç™ºè¡¨ã®å†…å®¹ã¯ã»ã¼ç¾åœ¨WEB+DB PRESSã§é€£è¼‰ã—ã¦ã„ã‚‹ã€Œç†è«–ã§å¦ã¶SQLå†å…¥é–€ã€ã®ã„ãã¤ã‹ã®å›žã®ã‚‚ã®ã‚’è¦ç´„ã—ãŸã‚‚ã®ã«ãªã£ã¦ã„ã‚‹ã€‚é€£è¼‰ã§ã¯ã•ã‚‰ã«è©³ã—ã„å†…å®¹ã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ã„ã‚‹ã®ã§ã€èˆˆå‘³ã®ã‚ã‚‹äººã¯ãœã²WEB+DB PRESSã®ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼ï¼ˆé€£è¼‰ã¯Vol.68ã€œï¼‰ã‚’è³¼å…¥ã—ã¦é ‚ããŸã„ã€‚ æœ¬æ—¥ç™ºè¡¨ã—ãŸã‚¹
harumaki_net 2013/07/29
ã†ãƒ¼ã‚“è¡ŒããŸã‹ã£ãŸã€æ®‹å¿µï½¥ï½¥ï½¥æ˜¼ä¼‘ã¿ã«ã‚¹ãƒ©ã‚¤ãƒ‰è¦‹ã‚ˆã†ã€‚

MySQL

å‹‰å¼·ä¼š

db
ãƒªãƒ³ã‚¯
1