[B! mysql] nikkoroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

nikkoro id:nikkoro

mysqlã«é–¢ã™ã‚‹nikkoroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (17)

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

Facebookã‚„Googleã€ã€ŒWebScaleSQLã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹
ç±³Facebookã¯3æœˆ27æ—¥ï¼ˆç¾åœ°æ™‚é–“ï¼‰ã€ç±³Googleã€ç±³Twitterã€ç±³LinkedInã¨å”åŠ›ã—ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMySQLã€ã®ãƒ–ãƒ©ãƒ³ãƒã€ŒWebScaleSQLã€ã‚’GitHubã§å…¬é–‹ã—ãŸã¨ç™ºè¡¨ã—ãŸã€‚ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã¯GNU General Public License Ver.2ã€‚ WebScaleSQLã¯ã€MySQLã‚’å¤§è¦æ¨¡ãªã‚·ã‚¹ãƒ†ãƒ ã§ä½¿ã†4ç¤¾ãŒç›´é¢ã™ã‚‹å…±é€šã®å•é¡Œã‚’è§£æ±ºã™ã‚‹ç›®çš„ã§å…±åŒé–‹ç™ºã—ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€MySQLã«å¤§è¦æ¨¡ãªç’°å¢ƒã¸ã®å°Žå…¥ã«ç‰¹åŒ–ã—ãŸæ©Ÿèƒ½ã‚’è¿½åŠ ã—ãŸã‚‚ã®ã¨ã„ã†ã€‚ é–¢é€£è¨˜äº‹ Facebookã€æ–°ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã€ŒHackã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ FacebookãŒç¤¾å†…ã§ä½¿ã£ã¦ã„ã‚‹PHPãƒ™ãƒ¼ã‚¹ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã€ŒHackã€ã‚’BSDãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã§å…¬é–‹ã—ãŸã€‚ Twitterã€MySQLã®ç‹¬è‡ªãƒ„ãƒ¼ãƒ«ã‚’GitHubã§å…¬é–‹ TwitterãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹My
nikkoro 2014/03/28
mysql
ãƒªãƒ³ã‚¯
Facebookã«ãŠã‘ã‚‹MySQLã‚’ç”¨ã„ãŸå¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®ç¾å®Ÿï½žMySQL Connect 2013
ç±³ã‚ªãƒ©ã‚¯ãƒ«ãŒä¸»å‚¬ã™ã‚‹MySQLã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒMySQL Connectã€ãŒ9æœˆ21æ—¥ã‹ã‚‰23æ—¥ã¾ã§ã€ã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã§é–‹å‚¬ã•ã‚Œã¾ã—ãŸã€‚Oracle OpenWorldã€JavaOneã¨ã®åŒæ™‚é–‹å‚¬ã§ã—ãŸã€‚ åŸºèª¿è¬›æ¼”ã®1ã¤ã«ã¯ã€MySQLã®ãƒ˜ãƒ“ãƒ¼ãƒ¦ãƒ¼ã‚¶ãƒ¼ã§ã‚ã‚‹Facebookã®Harrison Fiskæ°ãŒç™»å£‡ã€‚Facebookã«ãŠã‘ã‚‹MySQLã®å½¹å‰²ã€å¤§è¦æ¨¡é‹ç”¨ã®èƒŒæ™¯ãªã©ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ãã®å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã§ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ MySQL@Facebook Lots and lots of small data Harrison Fiskæ°ã€‚ Facebookã§ãƒ‡ãƒ¼ã‚¿ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¼ãƒ ã®ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚’ã—ã¦ã„ã‚‹ã€‚ç¤¾å†…ã§ã¯MySQLã¯ã‚‚ã¡ã‚ã‚“ã€HBase Hadoopãªã©ã«ã‚‚é–¢ã‚ã£ã¦ã„ã‚‹ã€‚ ã¾ãšã¯ã€ã©ã‚“ãªç¨®é¡žã®ãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã£ã¦ã„ã‚‹ã®ã‹ã«ã¤ã„ã¦ã€‚ Facebookã¨ã¯åŸºæœ¬çš„ã«ã‚°ãƒ©ãƒ•ã ã€‚ã‚°
nikkoro 2013/09/27
mysql
ãƒªãƒ³ã‚¯
ã‚¢ã‚·ã‚¹ãƒˆãŒã‚«ãƒ©ãƒ æŒ‡å‘ä¸¦åˆ—DBã®æ–°ç‰ˆã€ŒInfiniDB 3ã€ã€ã‚·ã‚§ã‚¢ãƒ¼ãƒ‰ãƒŠãƒƒã‚·ãƒ³ã‚°ã§å‹•ä½œ
ã‚¢ã‚·ã‚¹ãƒˆã¯2012å¹´8æœˆ8æ—¥ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸I/Oã®å‰Šæ¸›ã«æ³¨åŠ›ã—ãŸDWHï¼ˆãƒ‡ãƒ¼ã‚¿ã‚¦ã‚¨ã‚¢ãƒã‚¦ã‚¹ï¼‰ç”¨é€”ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆRDBMSï¼‰æ–°ç‰ˆã€ŒInfiniDB 3ã€ã‚’ç™ºè¡¨ã€åŒæ—¥æä¾›ã‚’é–‹å§‹ã—ãŸã€‚æ–°ç‰ˆã§ã¯ã€ã‚·ã‚§ã‚¢ãƒ¼ãƒ‰ãƒŠãƒƒã‚·ãƒ³ã‚°æ§‹æˆã§å‹•ä½œã™ã‚‹ã‚ˆã†ã«ã—ãŸã€‚ä¾¡æ ¼ï¼ˆç¨Žåˆ¥ï¼‰ã¯ã€1ã‚³ã‚¢å½“ãŸã‚Š90ä¸‡å††ã§ã€ä¿å®ˆæ–™é‡‘ã¯å¹´é¡18ä¸‡å††ã€‚é–‹ç™ºä¼šç¤¾ã¯ã€ç±³Calpontã€‚ InfiniDBã¯ã€MySQLã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ãŸDWHå°‚ç”¨ã®RDBMSã§ã‚ã‚‹ã€‚ã‚«ãƒ©ãƒ ï¼ˆåˆ—ï¼‰æŒ‡å‘ã®ãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹ã€ç‹¬è‡ªã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«ã‚ˆã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸I/Oã®å‰Šæ¸›ã€ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã«ã‚ˆã‚‹æ‹¡å¼µæ€§ã€ã¨ã„ã£ãŸç‰¹å¾´ã‚’å‚™ãˆã‚‹ã€‚ã“ã‚Œã‚‰ã®å·¥å¤«ã«ã‚ˆã£ã¦ãƒ‡ãƒ¼ã‚¿è»¢é€é‡ã‚’æ¸›ã‚‰ã—ã€æ¤œç´¢ã‚’é«˜é€ŸåŒ–ã—ã¦ã„ã‚‹ã€‚ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨ã—ã¦ã¯ã€ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã§SQLã‚¯ã‚¨ãƒªãƒ¼ã‚’å—ã‘ä»˜ã‘ã‚‹ã€ŒUser Moduleã€ï¼ˆMySQLã§è¨€ã†SQLã‚¨ãƒ³ã‚¸ãƒ³ã«è©²å½“ï¼‰ã¨ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã§ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¢ã‚¯ã‚»ã‚¹ã‚’æ‹…å½“ã™ã‚‹ã€ŒPer
nikkoro 2012/09/04
mysql
ãƒªãƒ³ã‚¯
ã†ã‚‹ã†ç§’ã®ã‚ã¨ã«MySQLãªã©ã®CPUä½¿ç”¨çŽ‡ãŒé«˜é¨°ã™ã‚‹ä»¶ã«ã¤ã„ã¦ - SH2ã®æ—¥è¨˜
2012å¹´7æœˆ1æ—¥ã®ã†ã‚‹ã†ç§’ã®ã‚ã¨ã«ã€MySQLã‚„Javaãªã©ã®CPUä½¿ç”¨çŽ‡ãŒé«˜é¨°ã™ã‚‹äº‹è±¡ãŒå ±å‘Šã•ã‚Œã¦ã„ã¾ã™ã€‚ CPU %user %nice %system %iowait %steal %idle 08æ™‚30åˆ†01ç§’ all 0.02 0.00 0.02 0.04 0.00 99.91 08æ™‚40åˆ†01ç§’ all 0.02 0.00 0.02 0.08 0.00 99.88 08æ™‚50åˆ†01ç§’ all 0.02 0.00 0.02 0.03 0.00 99.92 09æ™‚00åˆ†01ç§’ all 0.11 0.00 0.13 0.04 0.00 99.72 09æ™‚10åˆ†01ç§’ all 23.02 0.00 29.09 0.11 0.00 47.78 09æ™‚20åˆ†01ç§’ all 23.11 0.00 29.08 0.06 0.00 47.75 09æ™‚30åˆ†01ç§’ all 22.85 0.00
nikkoro 2012/07/02
mysql

ã†ã‚‹ã†ç§’
ãƒªãƒ³ã‚¯
MySQL 5.6ç™»å ´ï¼ï¼æ–°æ©Ÿèƒ½é€Ÿæ”»ãƒ¬ãƒ“ãƒ¥ãƒ¼
ç¾åœ¨ã€ç±³å›½ã§è¡Œã‚ã‚Œã¦ã„ã‚‹MySQL Conference & Expoã«ã‚ã‚ã›ã¦ã€æ–°ã—ã„é–‹ç™ºç‰ˆã§ã‚ã‚‹MySQL 5.6ãŒç™ºè¡¨ã•ã‚ŒãŸã€‚MySQL 5.5ã«ãŠã‘ã‚‹æ–°æ©Ÿèƒ½ã‚‚ã‹ãªã‚Šã®ã‚‚ã®ã ã£ãŸãŒã€MySQL 5.6ã®é€²åŒ–ã¯è³ªãƒ»é‡ã¨ã‚‚ã«å‹ã¨ã‚‚åŠ£ã‚‰ãªã„å†…å®¹ã¨ãªã£ã¦ã„ã‚‹ã€‚ãã“ã§ã€ä»Šæ—¥ã¯ç°¡å˜ã«ã€MySQL 5.6ã§è¿½åŠ ã•ã‚ŒãŸæ–°æ©Ÿèƒ½ã®æ¦‚è¦ã«ã¤ã„ã¦è¦‹ã¦ã¿ã‚ˆã†ã€‚é–‹ç™ºç‰ˆãªã®ã§åˆ©ç”¨ã«ã‚ãŸã£ã¦ã¯ååˆ†ãªæ³¨æ„ãŒå¿…è¦ï¼ˆäºˆæœŸãªãäºˆå®šãŒå¤‰æ›´ã•ã‚Œã‚‹å¯èƒ½æ€§ã‚ã‚Šï¼‰ã ãŒã€æ¬¡æœŸæ£å¼ç‰ˆã®ãƒªãƒªãƒ¼ã‚¹ã«å‘ã‘ã¦æ˜¯éžè©¦ã—ã¦ã¿ã¦æ¬²ã—ã„ã€‚ InnoDBé–¢é€£MySQL 5.5ã§å¤§å¹…ãªé€²åŒ–ã‚’é‚ã’ãŸInnoDBã ãŒã€ãã®å‹¢ã„ã¯ã¾ã£ãŸãè¡°ãˆã‚‹ã“ã¨ã‚’çŸ¥ã‚‰ãªã„ã€‚æ€§èƒ½ã®å¼·åŒ–ã ã‘ã§ãªãã€ç—’ã„ã¨ã“ã‚ã«æ‰‹ãŒå±Šãä¾¿åˆ©ãªæ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã¦ã„ã‚‹ã€‚ ãƒ€ãƒ¼ãƒ†ã‚£ãƒšãƒ¼ã‚¸ã®ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã™ã‚‹ã‚¹ãƒ¬ãƒƒãƒ‰ãŒç‹¬ç«‹ã—ãŸã€‚ä»¥å‰ã¯ãƒžã‚¹ã‚¿ãƒ¼ã‚¹ãƒ¬ãƒƒãƒ‰å†…ã§ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãŒè¡Œã‚ã‚Œã¦ã„ãŸãŒã€ã‚¹ãƒ¬ãƒƒãƒ‰ãŒç‹¬ç«‹ã—ãŸã“ã¨ã«ã‚ˆã£
nikkoro 2012/04/12
mysql
ãƒªãƒ³ã‚¯
ã‚¸ãƒ§ã‚¤ãƒ³ãŒ70å€é«˜é€Ÿã§ã€Memcached APIæè¼‰ã®ã€ŒMySQL Cluster 7.2ã€æ£å¼ç‰ˆãŒç™»å ´
ç±³ã‚ªãƒ©ã‚¯ãƒ«ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦æ™®åŠã—ã¦ã„ã‚‹MySQLã‚’ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã—ã¦åˆ©ç”¨ã™ã‚‹ãŸã‚ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€ŒMySQL Cluster 7.2ã€ã®æ£å¼ç‰ˆã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ GPLã«æº–æ‹ ã—ãŸã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ç‰ˆã¨åŒæ™‚ã«ã€ç®¡ç†ãƒ„ãƒ¼ãƒ«ã‚’åŒæ¢±ã—ã€24æ™‚é–“365æ—¥ã®ã‚µãƒãƒ¼ãƒˆã‚‚è¡Œã†å•†ç”¨ç‰ˆã®ã€ŒMySQL Cluster Carrier Grade Editionã€ã‚‚åŒæ™‚ã«å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ ã‚¸ãƒ§ã‚¤ãƒ³ãŒ70å€é«˜é€Ÿã« MySQL Cluster 7.2ã®æœ€å¤§ã®ãƒã‚¤ãƒ³ãƒˆã¯ã€ã‚¸ãƒ§ã‚¤ãƒ³ãŒé«˜é€Ÿã«ãªã£ãŸã“ã¨ã§ã™ã€‚ã“ã‚Œã¾ã§ã‚¯ãƒ©ã‚¹ã‚¿ã§ã®ã‚¸ãƒ§ã‚¤ãƒ³ã¯ã€ã‚¸ãƒ§ã‚¤ãƒ³ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ãŒã‚¯ãƒ©ã‚¹ã‚¿å†…ã®ãƒŽãƒ¼ãƒ‰é–“ã‚’ã„ã¡ã„ã¡é£›ã³äº¤ã£ã¦ã„ãŸãŸã‚ã€è¤‡é›‘ãªã‚¸ãƒ§ã‚¤ãƒ³ã«ãªã‚‹ã»ã©é…ã„ã‚‚ã®ã«ãªã£ã¦ã„ã¾ã—ãŸã€‚ MySQL Cluster 7.2ã§æŽ¡ç”¨ã•ã‚ŒãŸAdaptive Query Localizationï¼ˆã‚ã‚‹ã„ã¯Push Down Joinsï¼‰ã¨å‘¼ã°
nikkoro 2012/04/11
mysql

memcached
ãƒªãƒ³ã‚¯
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ãŸé«˜é€ŸåŒ–ã«ã¤ã„ã¦(ORDERD BYã«ã‚¤ãƒ³ãƒ‡ã‚¯ã‚¹ãŒä½¿ã‚ã‚Œãªã„ä¾‹) - LukeSilviaâ€™s diary
ä»Šå›žã¯ã€MySQLã®é«˜é€ŸåŒ–ã®ãƒ¡ãƒ¢ - @luke_silvia.diaryã®æ–¹æ³•ã«å¾“ã£ã¦ã‚¯ã‚¨ãƒªã®é«˜é€ŸåŒ–ã‚’ã—ãŸéš›ã«ã€MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ãŸã“ã¨ã‚’æ›¸ã„ã¦ãŠãã¾ã™ã€‚ é«˜é€ŸåŒ–å¯¾è±¡ã®ã‚¯ã‚¨ãƒª ä»Šå›žé«˜é€ŸåŒ–ã—ãŸã„ã‚¯ã‚¨ãƒªã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã€‚ SELECT users.*, students.school, workers.school FROM users LEFT JOIN students ON users.id = students.user_id LEFT JOIN workers ON users.id = workers.user_id WHERE (users.status= 1 AND ((kind = 0 AND students.school = 'test') OR (kind = 1 AND workers.school = 'test'))) ORDER BY
nikkoro 2012/03/31
mysql
ãƒªãƒ³ã‚¯
layer8.sh
This domain may be for sale!
nikkoro 2012/03/24
mysql
ãƒªãƒ³ã‚¯
MySQLã«ãŠã‘ã‚‹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é…å»¶ã®å‚¾å‘ã¨å¯¾ç–
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯MySQLã§æœ€ã‚‚ã‚ˆãä½¿ã‚ã‚Œã‚‹æ©Ÿèƒ½ã®ã²ã¨ã¤ã ã€‚ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯åŸºæœ¬çš„ã«éžåŒæœŸã§ãƒ‡ãƒ¼ã‚¿ã®è¤‡è£½ã‚’è¡Œã†ä»•çµ„ã¿ã«ãªã£ã¦ã„ã‚‹ã®ã ãŒã€éžåŒæœŸæ•…ã«ã©ã†ã—ã¦ã‚‚é€ƒã‚Œã‚‰ã‚Œãªã„å•é¡ŒãŒã‚ã‚‹ã€‚ãã®ã²ã¨ã¤ãŒä»Šå›žã®ãƒ†ãƒ¼ãƒžã€é…å»¶ã§ã‚ã‚‹ã€‚ã¨ã„ã†ã¨ã€MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ã™ãã«é…å»¶ãŒç”Ÿã˜ã¦ã—ã¾ã†ã‚ˆã†ã«æ„Ÿã˜ã¦ã—ã¾ã†ã‹ã‚‚çŸ¥ã‚Œãªã„ãŒã€ãã®ã‚ˆã†ãªã“ã¨ã¯ãªã„ã€‚ã»ã¨ã‚“ã©ã®å ´åˆã¯å³åº§ã«ã‚¹ãƒ¬ãƒ¼ãƒ–ã®æ›´æ–°ãŒè¡Œã‚ã‚Œã‚‹ã€‚ ãªãœé…å»¶ã¯ç™ºç”Ÿã™ã‚‹ã®ã‹ã€ã©ã®ã‚ˆã†ã«é…å»¶ãŒèµ·ãã¦ã„ã‚‹ã“ã¨ã‚’èª¿ã¹ã‚‹ã®ã‹ã€ã©ã®ã‚ˆã†ã«å›žé¿ã™ã‚‹ã®ã‹ã¨ã„ã†ã“ã¨ã‚’æœ¬ã‚¨ãƒ³ãƒˆãƒªã§ã¯è§£èª¬ã—ãŸã„ã€‚ã†ã¾ãé…å»¶ã¨ä»˜ãåˆã£ã¦ã€MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚ˆã‚Šå¿«é©ã«é‹ç”¨ã—ã¦ã‚‚ã‚‰ãˆã‚Œã°ã¨æ€ã†ã€‚ ãã‚‚ãã‚‚é…å»¶ã¨ã¯ä½•ã‹MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯éžåŒæœŸã§è¡Œã‚ã‚Œã‚‹ã€‚ã“ã‚Œã¯æº–åŒæœŸã§ã‚‚åŒã˜ã§ã‚ã‚Šã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ãŠã„ã¦æ›´æ–°ãŒèµ·ãã‚‹ã®ã¯ãƒžã‚¹ã‚¿ãƒ¼ã‚ˆã‚Šã‚‚ä¸€çž¬é…ã‚Œã¦ã—ã¾ã†ã€‚ã“ã‚Œã¯éžåŒæœŸã§ã‚ã‚‹ãŒæ•…ã«é€ƒã‚Œ
nikkoro 2011/12/14
MySQL
ãƒªãƒ³ã‚¯
MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Memcached APIã‚’å‚™ãˆã‚‹ï¼ MySQL Conference & Expo 2011åŸºèª¿è¬›æ¼”
MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Memcached APIã‚’å‚™ãˆã‚‹ï¼ MySQL Conference & Expo 2011åŸºèª¿è¬›æ¼” ä»Šå¹´ã‚‚ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§4æœˆ11æ—¥ã‹ã‚‰13æ—¥ã«ã‹ã‘ã¦MySQLã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒMySQL Conference & Expo 2011ã€ãŒé–‹å‚¬ã•ã‚Œã¾ã—ãŸã€‚ MySQLã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦æœ€ã‚‚äººæ°—ã®ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ãŒã€ã‚ªãƒ©ã‚¯ãƒ«ãŒè²·åŽã—ãŸã“ã¨ã«ã‚ˆã£ã¦å…ˆè¡ŒããŒå¿ƒé…ã•ã‚Œã€ã¾ãŸMariaDBã‚„Drizzleã¨ã„ã£ãŸãƒ•ã‚©ãƒ¼ã‚¯ã‚‚é è§’ã‚’ç¾ã—ã¦ãã¦ã„ã¾ã™ã€‚ã—ã‹ã—ã€ã“ã®åŸºèª¿è¬›æ¼”ã§æ˜Žã‚‰ã‹ã«ã•ã‚ŒãŸæ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³MySQL 5.6ã¨MySQL Cluster 7.2ã¯ã€ãã†ã—ãŸæ‡¸å¿µã‚’å¹ãé£›ã°ã™ã»ã©å¼·åŠ›ãªæ€§èƒ½å‘ä¸Šã¨æ–°æ©Ÿèƒ½ãŒäºˆå®šã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ç¾åœ°æ™‚é–“4æœˆ12æ—¥ã«è¡Œã‚ã‚ŒãŸåŸºèª¿è¬›æ¼”ã€ŒState of the Dolphinã€ã®å†…å®¹ã‚’ã€å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ãƒ“ãƒ‡ã‚ªã‹ã‚‰ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ã‚ª
nikkoro 2011/11/02
mysql

nosql
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨PostgreSQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã©ã®ã‚ˆã†ãªæ–°æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã‚‹ã®ã‹ã€æ˜¨æ—¥ã€ä¸€æ˜¨æ—¥ã®2æœ¬ã®è¨˜äº‹ã§ç´¹ä»‹ã—ã¾ã—ãŸã€‚ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Memcached APIã‚’å‚™ãˆã‚‹ï¼ MySQL Conference & Expo 2011åŸºèª¿è¬›æ¼” PostgreSQLã®ç¾çŠ¶ã¨æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³9.1ã®æ–°æ©Ÿèƒ½ã€‚MySQL Conference & Expo 2011 ã“ã®2ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«å…±é€šã—ã¦ã„ã‚‹ã®ãŒã€NoSQLã®æ©Ÿèƒ½ã‚’å–ã‚Šè¾¼ã‚“ã§ã„ã‚‹ã“ã¨ã§ã™ã€‚NoSQLã«å¯¾ã™ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã‚‹åæ’ƒãŒå§‹ã¾ã£ã¦ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒNoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹MySQL 5.6ã«æè¼‰äºˆå®šã®æ–°æ©Ÿèƒ½ã®1
nikkoro 2011/11/01
mysql

NoSQL
ãƒªãƒ³ã‚¯
MySQL :: Developer Zone
"The Documents contained within this site may include statements about Oracle's product development plans. Many factors can materially affect Oracle's product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be reli
nikkoro 2011/10/07
mysql

cloud computing
ãƒªãƒ³ã‚¯
ï¼ IT Special PRï¼š600å„„PVã‚‚MySQLã§ï¼ ãƒ¢ãƒã‚²ãƒ¼ã®ã‚¤ãƒ³ãƒ•ãƒ©åº•åŠ›
æºå¸¯å‘ã‘ã‚µã‚¤ãƒˆã€Œãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ã€ã®å‹¢ã„ãŒæ¢ã¾ã‚‰ãªã„ã€‚2010å¹´3æœˆã®ä¼šå“¡æ•°ã¯ç´„1800ä¸‡äººã€æœˆé–“ãƒšãƒ¼ã‚¸ãƒ“ãƒ¥ãƒ¼ï¼ˆPVï¼‰600å„„ã¨ã„ã†"ãƒ¢ãƒ³ã‚¹ã‚¿ãƒ¼SNS"ã«æˆé•·ã—ã¦ã„ã‚‹ã€‚æ„å¤–ãªã“ã¨ã«ã€ã“ã‚Œã ã‘ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã•ã°ãã®ã«ã€memcachedã‚’ã¯ã˜ã‚ã¨ã™ã‚‹KVSï¼ˆKey-Value Storeï¼‰ç³»ã®ã‚¤ãƒ³ãƒ•ãƒ©ãƒ»ã‚½ãƒ•ãƒˆã¯ã‚ã¾ã‚Šä½¿ã£ã¦ãŠã‚‰ãšã€MySQLã§ååˆ†ã ã¨ã„ã†ã€‚ãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ã®ã‚¤ãƒ³ãƒ•ãƒ©æ‹…å½“è€…ã«è©±ã‚’èžã„ãŸã€‚ ãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ã‚’é‹å–¶ã™ã‚‹DeNAï¼ˆãƒ‡ã‚£ãƒ¼ãƒ»ã‚¨ãƒŒãƒ»ã‚¨ãƒ¼ï¼‰ã¯ã€ã‚‚ã¨ã‚‚ã¨1999å¹´ã«é–‹å§‹ã—ãŸã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã‚µã‚¤ãƒˆã€Œãƒ“ãƒƒãƒ€ãƒ¼ã‚ºã€ã§çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ãã®å¾Œã€ã‚ªãƒ¼ã‚¯ã‚·ãƒ§ãƒ³ã«åŠ ãˆã¦ECã‚µã‚¤ãƒˆã‚’é–‹å§‹ã—ã€auã¨ã®ææºã«ã‚ˆã‚Šã€Œauã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ãƒ¢ãƒ¼ãƒ«ã€ãªã©ã§æ€¥é€Ÿã«æˆé•·ã—ãŸã€‚ ãƒ“ãƒƒãƒ€ãƒ¼ã‚ºã ã‘ã§ã‚‚ã€æ•°åƒä¸‡PVè¦æ¨¡ã®å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹ã ãŒã€æœ€è¿‘ã¯ãƒ¢ãƒã‚²ãƒ¼ã‚¿ã‚¦ãƒ³ã®æˆé•·ãŒè‘—ã—ã„ã€‚ ã€Œç‰¹ã«2009å¹´9æœˆã‹ã‚‰é †æ¬¡ãƒªãƒªãƒ¼ã‚¹ã—ãŸè‡ªç¤¾è£½ã®ã‚½ãƒ¼ã‚·ãƒ£ãƒ«
nikkoro 2011/09/22
DeNA

MySql
ãƒªãƒ³ã‚¯
Twitterã«ãŠã‘ã‚‹å¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã€3ã¤ã®åŽŸå‰‡
4æœˆã«ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§è¡Œã‚ã‚ŒãŸMySQL Confernce & Expo 211ã§ã¯ã€Twitterã®Jeremy Coleæ°ãŒã€ŒBig and Small Data at @Twitterã€ã¨é¡Œã—ã¦ã€åŒç¤¾ã®ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹åŽŸå‰‡ã¨ã‚·ã‚¹ãƒ†ãƒ æ§‹æˆã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ 1æ—¥ã«1å„„5000ä¸‡ä»¥ä¸Šã®ãƒ„ã‚¤ãƒ¼ãƒˆãŒè¡Œã‚ã‚Œã¦ã„ã‚‹Twitterã®ã‚·ã‚¹ãƒ†ãƒ ã¯ã©ã®ã‚ˆã†ã«æ§‹ç¯‰ã•ã‚Œã¦ã„ã‚‹ã®ã‹ã€ãã®å†…å®¹ã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ Twitterã«ãŠã‘ã‚‹åŽŸå‰‡ Twitterã®Jeremy Coleæ°ã€‚
nikkoro 2011/05/24
twitter

mysql
ãƒªãƒ³ã‚¯
Leaving Oracle, Joining DeNA
9æœˆ1æ—¥ä»˜ã‘ã§ã‚ªãƒ©ã‚¯ãƒ«ã‚’é€€è·ã—ã€9æœˆ2æ—¥ä»˜ã‘ã§ãƒ‡ã‚£ãƒ¼ãƒ»ã‚¨ãƒŒãƒ»ã‚¨ãƒ¼ã«è»¢è·ã—ã¾ã—ãŸã€‚æ–°ä¼šç¤¾ã¸ã®å…¥ç¤¾ã®å ±å‘Šã‚ˆã‚Šã‚‚(ã ã„ã¶)å‰ã«é€€è·ã®å ±å‘Šã‚’ã™ã‚‹æ–¹ãŒå¤šã„ã‚ˆã†ã§ã™ãŒã€ç§ãŒå¤–å‘ã‘ã«ã‚ªãƒ©ã‚¯ãƒ«é€€è·ã®å ±å‘Šã‚’ã™ã‚‹ã®ã¯ã“ã‚ŒãŒåˆã‚ã¦ã§ã™ã€‚é€€è·ã¨è»¢è·ã®å ±å‘Šã¨åŒæ™‚ã«è¡Œãªã†ã®ã¯ã€å¤šãã®æ–¹ãŒãƒŠãƒ¼ãƒã‚¹ã«ãªã£ã¦ã„ã‚‹ã‚ªãƒ©ã‚¯ãƒ«ã¨MySQLã®è¡Œãæœ«ã«ã¤ã„ã¦ã€ã§ãã‚‹ã ã‘æ‚ªã„å°è±¡ã‚’ä¸ŽãˆãŸããªã„ã¨è€ƒãˆãŸãŸã‚ã§ã™ã€‚ãƒ‡ã‚£ãƒ¼ãƒ»ã‚¨ãƒŒãƒ»ã‚¨ãƒ¼ã¯ä¸–ç•Œã§ã‚‚æŒ‡æŠ˜ã‚Šã®MySQLã®è¶…ãƒ˜ãƒ“ãƒ¼ãƒ¦ãƒ¼ã‚¶ã¨ã—ã¦çŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ä¸–ç•Œã§ã¯ã€ãƒ™ãƒ³ãƒ€ãƒ¼ã‹ã‚‰ãƒ˜ãƒ“ãƒ¼ãƒ¦ãƒ¼ã‚¶ã®äº‹æ¥ä¼šç¤¾ã«è»¢è·ã—ã€ãã®å°‚é–€æ€§ã‚’ç”Ÿã‹ã—ãŸä»•äº‹ã‚’ç¶šã‘ã‚‹ã“ã¨ã¯çã—ãã‚ã‚Šã¾ã›ã‚“(ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ¡ãƒªãƒƒãƒˆã®1ã¤ã§ã™)ã€‚ã¨ã„ã†ã‚ã‘ã§ã€å¼•ãç¶šãMySQLã®ä»•äº‹ã‚’ç¶šã‘ã¾ã™ã€‚MySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®æ–¹ã¯ã©ã†ã‹å®‰å¿ƒã—ã¦ãã ã•ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ä»Šå¾Œã¨ã‚‚ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„è‡´ã—ã¾ã™ã€‚ ç§ã¯2006å¹´9æœˆã«MySQL
nikkoro 2010/09/04
mysql

DeNA
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¨è¨€ã£ãŸå ´åˆã«ã¯ã€ã‚µãƒ¼ãƒãƒ¼ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®èª¿æ•´ã‚„ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã—ãŸã‚¯ã‚¨ãƒªå®Ÿè¡Œè¨ˆç”»ã®æœ€é©åŒ–ãŒè©±é¡Œã«ä¸Šã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ã—ã‹ã—ã€ç™ºè¡Œã™ã‚‹å…¨ã¦ã® SQL ã«ã¤ã„ã¦ã€ã„ã¡ã„ã¡ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ã¦ç¢ºèªã—ã¦ã„ã¦ã¯ã€ã„ãã‚‰æ™‚é–“ãŒã‚ã£ã¦ã‚‚ãŸã‚Šã¾ã›ã‚“ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’åŠ¹çŽ‡çš„ã«é€²ã‚ã‚‹ã«ã¯ã€ã¾ãšã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã£ã¦ã„ã‚‹ SQL ã‚¯ã‚¨ãƒªã‚’ç‰¹å®šã—ã€æ¬¡ã«ãã®æœ€é©åŒ–ã‚’è¡Œã†ã¹ãã§ã™ã€‚ ã§ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ç‰¹å®šã™ã‚‹ã®ã‹ã€‚MySQL Conference & Expo 2009 ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ Mark Callaghan æ°ã¯ã€Google ã§ã¯ SHOW PROCESSLIST ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ãŸçµ±è¨ˆçš„ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’ä½¿ã£ã¦ã„ã‚‹ã¨è¿°ã¹ã¦ã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ (å‚ç…§: MySQLConf 09: Mark Callaghan, "This is Not a
nikkoro 2009/07/22
ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

mysql
ãƒªãƒ³ã‚¯
Registration: Machine learning & data conference | O'Reilly Strata
Weâ€™ve made the very difficult decision to cancel all future Oâ€™Reilly in-person conferences. Instead, weâ€™ll continue to invest in and grow Oâ€™Reilly online learning, supporting the 5,000 companies and 2.5 million people who count on our experts to help them stay ahead in all facets of business and techno logy. Come join them and learn what they already know. Become an Oâ€™Reilly online learning member
nikkoro 2006/03/12
Web++
ãƒªãƒ³ã‚¯
1