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

nagayama id:nagayama

mysqlã«é–¢ã™ã‚‹nagayamaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã„ã‚ã„ã‚è€ƒãˆã‚‹ã¨æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢ã‚‚MySQLãŒã„ã„ãï¼ - Kouhei Sutou - Rabbit Slide Show
Description MySQLã¯åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹RDBMSã§ã™ã€‚é€Ÿã„ã—ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒŽã‚¦ãƒã‚¦ã‚‚ã‚ã‚‹ã—ã€Webä¸Šã«ãŸãã•ã‚“ã®æƒ…å ±ã‚‚ã‚ã‚‹ã‹ã‚‰ã„ã–ã¨ã„ã†ã¨ãã‚‚å®‰å¿ƒã€ã¨ã„ã†ã®ãŒãã®ç†ç”±ã§ã—ã‚‡ã†ã€‚ ãã‚“ãªMySQLã®å¼±ç‚¹ã®1ã¤ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯æ—¥æœ¬èªžã§å…¨æ–‡æ¤œç´¢ã§ããªã„ã“ã¨ã§ã™ã€‚ã§ã‚‚ã€æ—¥æœ¬èªžã§å…¨æ–‡æ¤œç´¢ã—ãŸã„ã—ã€‚ã€‚ã€‚ã©ã†ã—ã‚ˆã†ã€‚ ãã‚“ãªã‚ãªãŸã«æœ€è¿‘ã®æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢äº‹æƒ…ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚Solrï¼ŸElasticsearchï¼ŸGroongaï¼ŸPostgreSQLã¯ã©ã†ã‚„ã£ã¦ã„ã‚‹ã®ï¼ŸMroongaï¼ŸSphinxï¼Ÿ ã„ã‚ã„ã‚è€ƒãˆã‚‹ã¨æ—¥æœ¬èªžã§å…¨æ–‡æ¤œç´¢ã™ã‚‹ã¨ãã‚‚MySQLã‚’ä½¿ã†ã®ãŒã„ã„ãï¼ã¨æ€ãˆã¦ãã‚‹ã‹ã‚‰ä¸æ€è°ã§ã™ã€‚æœ€è¿‘ã®æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢äº‹æƒ…ã‚’èžã„ã¦ä¸€ç·’ã«è€ƒãˆã¦ã¿ã¾ã›ã‚“ã‹ï¼Ÿ Page: 1 ã„ã‚ã„ã‚è€ƒãˆã‚‹ã¨ æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢ã‚‚ MySQLãŒã„ã„ãï¼ é ˆè—¤åŠŸå¹³ æ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼š OSC2014 Tokyo
nagayama 2017/01/14
mysql
ãƒªãƒ³ã‚¯
MySQL-Exploit-Remote-Root-Code-Execution-Privesc-CVE-2016-6662
__ __ __ __ __ / / ___ ____ _____ _/ / / / / /___ ______/ /_____ __________ / / / _ \/ __ `/ __ `/ / / /_/ / __ `/ ___/ //_/ _ \/ ___/ ___/ / /___/ __/ /_/ / /_/ / / / __ / /_/ / /__/ ,< / __/ / (__ ) /_____/\___/\__, /\__,_/_/ /_/ /_/\__,_/\___/_/|_|\___/_/ /____/ /____/ <-- BACK TO legalhackers.com Follow @dawid_golunski ~~~~~~~~~~~~~ ExploitBox.io ~~~~~~~~~~~~~~~~ Interested in security / vulns
nagayama 2016/09/13
mysql

security
ãƒªãƒ³ã‚¯
MySQLã«é‡å¤§ãªè„†å¼±æ€§è¦‹ã¤ã‹ã‚‹ã€ãƒ‘ãƒƒãƒå˜åœ¨ã›ãšãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§å½±éŸ¿
æ”»æ’ƒã«åˆ©ç”¨ã•ã‚ŒãŸå ´åˆã€rootæ¨©é™ã§ä»»æ„ã®ã‚³ãƒ¼ãƒ‰ã‚’å®Ÿè¡Œã•ã‚Œã€ã‚µãƒ¼ãƒã‚’åˆ¶å¾¡ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒæŒ‡æ‘˜ã•ã‚Œã¦ã„ã‚‹ã€‚ ç±³Oracleå‚˜ä¸‹ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMySQLã€ã«æœªè§£æ±ºã®è„†å¼±æ€§ãŒè¦‹ã¤ã‹ã£ãŸã¨ã—ã¦ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç ”ç©¶è€…ãŒ9æœˆ12æ—¥ã«æ¦‚ç•¥ã‚„ã‚³ãƒ³ã‚»ãƒ—ãƒˆå®Ÿè¨¼ã‚³ãƒ¼ãƒ‰ã‚’å…¬é–‹ã—ãŸã€‚ã‚µã‚¤ãƒãƒ¼æ”»æ’ƒã«åˆ©ç”¨ã•ã‚ŒãŸå ´åˆã€rootæ¨©é™ã§ä»»æ„ã®ã‚³ãƒ¼ãƒ‰ã‚’å®Ÿè¡Œã•ã‚Œã€ã‚µãƒ¼ãƒã‚’åˆ¶å¾¡ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒæŒ‡æ‘˜ã•ã‚Œã¦ã„ã‚‹ã€‚ ç ”ç©¶è€…ã®Dawid Golunskiæ°ãŒå…¬é–‹ã—ãŸæƒ…å ±ã«ã‚ˆã‚Œã°ã€MySQLã®è„†å¼±æ€§ã¯è¤‡æ•°ç™ºè¦‹ã•ã‚Œã€ã€ä¸ã§ã‚‚ç‰¹ã«æ·±åˆ»ãª1ä»¶ã«ã¤ã„ã¦ã¯ã€ãƒªãƒ¢ãƒ¼ãƒˆã®æ”»æ’ƒè€…ãŒMySQLã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã«ä¸æ£ãªå†…å®¹ã‚’ä»•è¾¼ã‚€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã«åˆ©ç”¨ã•ã‚Œã‚‹æã‚ŒãŒã‚ã‚‹ã€‚ ã“ã®è„†å¼±æ€§ã¯ã€MySQLã®æœ€æ–°ç‰ˆã‚’å«ã‚€5.7ç³»ã€5.6ç³»ã€5.5ç³»ã®å…¨ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®çŠ¶æ…‹ã§å˜åœ¨ã™ã‚‹ã€‚ç¾æ™‚ç‚¹ã§Oracle MySQLã‚µãƒ¼ãƒã®è„†å¼±æ€§ä¿®æ£ãƒ‘ãƒƒãƒã¯å˜åœ¨
nagayama 2016/09/13
security

mysql
ãƒªãƒ³ã‚¯
MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
MySQLã®masterã¨slave 1:1ã«ã—ã¦å‚ç…§ã‚’slaveå‘ã‘ã‚‹ã®ã£ã¦ã‚„ã‚ŠãŸãŒã‚‹äººå¤šã„ã¿ãŸã„ã ã‘ã©ã€æ€§èƒ½ãŸã„ã—ã¦ä¸ŠãŒã‚‰ãªã„å‰²ã«å¯ç”¨æ€§è½ã¡ã‚‹ã ã‘ã ã‹ã‚‰ã‚„ã‚ã‚ˆã†ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³ 2011-06-19 00:16:30 via YoruFukurou MySQL ã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç°¡å˜ã«æ§‹æˆã§ãã‚‹ã®ã§ã™ãŒã€æ™‚æŠ˜ master 1å° ã«å¯¾ã—ã¦ slave 1å°ã€æ›´æ–°å‡¦ç†ã¯ master ã«ã€å‚ç…§ã¯ slave ã«ã€ã¨ã„ã†æ§‹æˆã‚’ç›®ã«ã—ã¾ã™ã€‚ å€‹äººçš„ã«ã¯ã“ã®æ§‹æˆã¯ãŠå‹§ã‚ã§ãªã„ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã€ãã®ç†ç”±ã‚’è€ƒå¯Ÿã—ã¦ã¿ã¾ã™ã€‚ 1. å¯ç”¨æ€§ãŒè½ã¡ã‚‹ å½“ç„¶ã§ã™ãŒã€master, slave ã®ã©ã¡ã‚‰ãŒè½ã¡ã¦ã‚‚å½±éŸ¿ã‚’å—ã‘ã‚‹ãŸã‚ã«å¯ç”¨æ€§ãŒä½Žä¸‹ã—ã¾ã™ã€‚ 2. å…¨ä½“ã®æ€§èƒ½ãŒã»ã¨ã‚“ã©ä¸ŠãŒã‚‰ãªã„ master 1å°ã§ã™ã¹ã¦ã®ã‚¯ã‚¨ãƒªã‚’å‡¦ç†ã™ã‚‹å ´åˆã¨æ¯”ã¹ã¦ã€å¯ç”¨æ€§ãŒè½ã¡ã‚‹å¼•ãæ›ãˆã¨ã—ã¦è¦‹åˆã£ãŸæ€§èƒ½å‘ä¸ŠãŒå¾—ã‚‰ã‚Œã‚‹ã‹ã€ã¨ã„ã†
nagayama 2016/02/02
mysql
ãƒªãƒ³ã‚¯
blogã‚µãƒ¼ãƒ“ã‚¹ã®å…¨æ–‡æ¤œç´¢ã®è©± - #groonga ã‚’å›²ã‚€å¤•ã¹
MySQLã¯åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹RDBMSã§ã™ã€‚é€Ÿã„ã—ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒŽã‚¦ãƒã‚¦ã‚‚ã‚ã‚‹ã—ã€Webä¸Šã«ãŸãã•ã‚“ã®æƒ…å ±ã‚‚ã‚ã‚‹ã‹ã‚‰ã„ã–ã¨ã„ã†ã¨ãã‚‚å®‰å¿ƒã€ã¨ã„ã†ã®ãŒãã®ç†ç”±ã§ã—ã‚‡ã†ã€‚ ãã‚“ãªMySQLã®å¼±ç‚¹ã®1ã¤ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯æ—¥æœ¬èªžã§å…¨æ–‡æ¤œç´¢ã§ããªã„ã“ã¨ã§ã™ã€‚ã§ã‚‚ã€æ—¥æœ¬èªžã§å…¨æ–‡æ¤œç´¢ã—ãŸã„ã—ã€‚ã€‚ã€‚ã©ã†ã—ã‚ˆã†ã€‚ ãã‚“ãªã‚ãªãŸã«æœ€è¿‘ã®æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢äº‹æƒ…ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚Solrï¼ŸElasticsearchï¼ŸGroongaï¼ŸPostgreSQLã¯ã©ã†ã‚„ã£ã¦ã„ã‚‹ã®ï¼ŸMroongaï¼ŸSphinxï¼Ÿ ã„ã‚ã„ã‚è€ƒãˆã‚‹ã¨æ—¥æœ¬èªžã§å…¨æ–‡æ¤œç´¢ã™ã‚‹ã¨ãã‚‚MySQLã‚’ä½¿ã†ã®ãŒã„ã„ãï¼ã¨æ€ãˆã¦ãã‚‹ã‹ã‚‰ä¸æ€è°ã§ã™ã€‚æœ€è¿‘ã®æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢äº‹æƒ…ã‚’èžã„ã¦ä¸€ç·’ã«è€ƒãˆã¦ã¿ã¾ã›ã‚“ã‹ï¼Ÿ
nagayama 2014/12/01
mysql

mroonga

search
ãƒªãƒ³ã‚¯
é–‹ç™ºç’°å¢ƒã®ãƒ‡ãƒ¼ã‚¿ã‚’ã§ãã‚‹ã ã‘æœ¬ç•ªã«è¿‘ã¥ã‘ã‚‹ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚æŠ€è¡“éƒ¨ã®å‰å·ã§ã™ã€‚ ä»Šå›žã¯ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã®é–‹ç™ºç’°å¢ƒæ§‹æˆã€ç‰¹ã«é–‹ç™ºç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹æˆã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ é–‹ç™ºç’°å¢ƒã®æ§‹æˆ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã®ã‚·ã‚¹ãƒ†ãƒ ç’°å¢ƒã¯ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ•ã‚§ã‚¤ã‚ºã«åˆ†ã‹ã‚Œã¦ã„ã¾ã™ã€‚ â€» ã“ã‚Œã¯cookpad.comã®æ§‹æˆã§ã€ã‚µãƒ–ã‚·ã‚¹ãƒ†ãƒ ã‚„å€‹åˆ¥ã®ã‚µãƒ¼ãƒ“ã‚¹ã¯ãã®è¦æ¨¡ã‚„ç‰¹æ€§ã«å¿œã˜ã¦æ§‹æˆãŒç•°ãªã‚Šã¾ã™ã€‚ development é–‹ç™ºè€…ãŒå®Ÿéš›ã«é–‹ç™ºã‚’è¡Œã†ç’°å¢ƒã§ã™ã€‚ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯ä»®æƒ³ç’°å¢ƒã¯ç”¨ã„ãšã€æ‰‹å…ƒã®ãƒžã‚·ãƒ³ã§Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å‹•ã‹ã—ã¦é–‹ç™ºã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ãƒãƒ¼ã‚«ãƒ«ã§ã¯ãªãã€é–‹ç™ºè€…å…¨ä½“ã§å…±é€šã®é–‹ç™ºç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ã¦ã„ã¾ã™ã€‚ test æ‰‹å…ƒã§ãƒ†ã‚¹ãƒˆã‚’å®Ÿè¡Œã™ã‚‹å ´åˆã¯ã€ãƒãƒ¼ã‚«ãƒ«ãƒžã‚·ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã—ã¾ã™ã€‚CIï¼ˆrrrspecï¼‰ãªã©ã®å ´åˆã‚‚åŒæ§˜ã§ã€ãƒ†ã‚¹ãƒˆå®Ÿè¡Œã‚µãƒ¼ãƒãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒåˆ©ç”¨ã•ã‚Œã¾ã™ã€‚ staging stagingã¨ã„ãˆã°æº–æœ¬ç•ªç’°å¢ƒã¨ã—ã¦ã€æœ¬
nagayama 2014/10/03
mysql

development
ãƒªãƒ³ã‚¯
WebScaleSQL | "We're Gonna Need A Bigger Database"
What is WebScaleSQL? WebScaleSQL is a collaboration among engineers from several companies that face similar challenges in running MySQL at scale, and seek greater performance from a database techno logy tailored for their needs. Our goal in launching WebScaleSQL is to enable the scale-oriented members of the MySQL community to work more closely together in order to prioritize the aspects that are
nagayama 2014/03/28
mysql

database
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®masterã¨slaveã®ä½¿ã„åˆ†ã‘ã®è©±ã€‚2014å¹´ç‰ˆ - Hateburo: kazeburo hatenablog
ç¤¾å†…ã§å°‘ã—è©±é¡Œã«ãªã£ãŸã®ã§ã€‚ é‹ç”¨ä¸Šã®è©±ã¯fujiwaraã•ã‚“ã® MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº— MySQLã§å‚ç…§ã®è² è·åˆ†æ•£ã‚’è¡Œã†slaveã¯3å°ã‹ã‚‰æ§‹æˆã™ã‚‹ã®ãŒã‚ˆã„ã®ã§ã¯ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº— ã‚’ã¿ã¦ãã ã•ã„ã€‚ æœ€è¿‘ã€æ–°ã—ãã‚µãƒ¼ãƒ“ã‚¹ãŒã§ããŸã‚Šã€æ–°è¦æ©Ÿèƒ½ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’è¿½åŠ ã™ã‚‹éš›ã«ã¯å¿…ãšå…¨ã¦ã®å‚ç…§ã‚’masterã«å‘ã‘ã¦ã‚‚ã‚‰ã£ã¦ã„ã¾ã™ã€‚ç†ç”±ã¯ä¸Šè¨˜ã®ã‚¨ãƒ³ãƒˆãƒªã‚’èªã‚“ã§ãã ã•ã„ã€‚ã“ã®ã‚ˆã†ãªæ§‹æˆãŒå–ã‚Œã‚‹ã®ã¯ã‚‚ã¡ã‚ã‚“æ€§èƒ½çš„ã«ãã‚Œã§å•é¡Œãªã„ã‹ã‚‰ã§ã™ã€‚ æ–°ã—ã„ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã«ã€è¨å®šã•ã‚ŒãŸMySQLã€å•é¡Œã®ãªã„ã‚ˆã†ã«æ›¸ã‹ã‚ŒãŸSQLã§ã‚ã‚Œã°ã€æ•°åƒQPSã¯ä½™è£•ã«ã€ã¾ãŸå°‘ã—é ‘å¼µã‚Œã°æ•°ä¸‡QPSã‚’ä¸€å°ã§è³„ãˆã¾ã™ã€‚ãªã®ã§å¤§ä½“ã®ã‚µãƒ¼ãƒ“ã‚¹ã¯masterä¸€å°ã§ååˆ†ã§ã™ã€‚ ã•ã‚‰ã«ã“ã®è€ƒãˆæ–¹ã‚’é€²ã‚ã¦ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸ã§ sub d
nagayama 2014/02/12
mysql

architecture
ãƒªãƒ³ã‚¯
ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã‚ãã‚“ã§ã¿ãŸ
ã“ã†ãªã‚‹ã¯ãšã ã£ãŸã‚“ã§ã™ãŒlightningã®VGAå¤‰æ›ã‚¢ãƒ€ãƒ—ã‚¿ã¨mini display portã®å¤‰æ›ã‚¢ãƒ€ãƒ—ã‚¿ã‚’é–“é•ãˆã¦æŒã£ã¦è¡Œã£ã¦ã—ã¾ã„ã¾ã—ãŸorz æ¬¡å›žã‹ã‚‰å¿˜ã‚Œãªã„ã‚ˆã†ã«å…¨éƒ¨ã¾ã¨ã‚ã¦ã‚ãƒ¼ãƒ›ãƒ«ãƒ€ãƒ¼ã«ä»˜ã‘ã‚ˆã†ã¨æ€ã„ã¾ã™ï¼ˆÂ´ãƒ»Ï‰...:.;::..
nagayama 2013/10/29
mysql
ãƒªãƒ³ã‚¯
YAPC::Asia 2012 ã§ç™ºè¡¨ã—ã¦ãã¾ã—ãŸï¼æ—¥æœ¬ã‚ˆã€ã“ã‚ŒãŒ #yapcasia ã ãƒƒï¼ï¼ - blog.nomadscafe.jp
ï¼•ï¼Žï¼–ï¼ï¼•ï¼Žï¼–ï¼ï¼•ï¼Žï¼–ï¼ ä»Šå¹´ã‚‚ç„¡äº‹ã«YAPC::Asiaã«å‚åŠ ã¨ç™ºè¡¨ã•ã›ã¦é ‚ãäº‹ãŒå‡ºæ¥ã¾ã—ãŸã€‚ç‰§ã•ã‚“ã€941ã•ã‚“ã€JPAã®çš†æ§˜ã€ãƒœãƒ©ãƒ³ãƒ†ã‚£ã‚¢ã®çš†æ§˜ã€å‚åŠ ã—ãŸå…¨ã¦ã®Perl Mongersã«æ„Ÿè¬ã§ã™ã€‚ ä»Šå¹´ã®ç™ºè¡¨ã¯ã€åŽ»å¹´ã®ã“ã®æ™‚æœŸã«ã‚„ã£ã¦ã„ãŸlivedoor Blogã®ã‚µãƒ¼ãƒé›†ç´„ä½œæ¥ã¨ãã®ç‚ºã«ã¤ãã£ãŸãƒ„ãƒ¼ãƒ«ã‚„è‡ªå‹•åŒ–ã«ã¤ã„ã¦ç´¹ä»‹ã•ã›ã¦é ‚ãã¾ã—ãŸã€‚ è³ªå•ã§ã‚‚å‡ºã¦ããŸã€Œä½œæˆã—ãŸç§»è¡Œã‚¹ã‚¯ãƒªãƒ—ãƒˆã®æ¤œè¨¼ã€ã§ã™ãŒã€ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æ™‚é–“å†…ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚³ãƒ”ãƒ¼ãŒå®Œäº†ã™ã‚‹ã‹ã©ã†ã‹ã®æ¤œè¨¼ã¨ã‚ã‚ã›ã¦ã€å®Ÿéš›ã«å®Ÿè¡Œã—ã¦ç¢ºèªã—ã¦ã„ã¾ã—ãŸã€‚ä»Šã«ã—ã¦æ€ãˆã°dry-runãƒ¢ãƒ¼ãƒ‰ã‚’ä½œã£ã¦ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹æ›¸ã„ã¦ç¢ºèªã™ã‚‹ãã‚‰ã„ã‚„ã£ã¦ã‚‚ã‚ˆã‹ã£ãŸã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚æ¬¡å›žï¼ˆãŒã‚ã‚Œã°ï¼‰ãƒãƒ£ãƒ¬ãƒ³ã‚¸ã—ãŸã„ã§ã™ã€‚ ã‚‚ã†ä¸€ã¤è¨€ã„å¿˜ã‚Œã¦ã¾ã—ãŸãŒã€mysql40dumpã¯MySQL 5.1ã€5.5ã§ã‚‚æ¤œè¨¼æ¸ˆã¿ã§å¼Šç¤¾ã§ã‚‚ãƒ˜ãƒ“ãƒ¼ã«ã‚µãƒ¼ãƒé‹ç”¨ã«ä½¿ã£ã¦ã„ã¾ã™ã€‚è‡ªå‹•ã§m
nagayama 2012/10/02
mysql

yapc
ãƒªãƒ³ã‚¯
é–‹ç™ºã‚¹ãƒ”ãƒ¼ãƒ‰ã‚¢ã‚¯ã‚»ãƒ«å…¨é–‹ã¶ã£ã¡ãŽã‚Šï¼æ—¥æœ¬ã‚ˆã€ã“ã‚ŒãŒMySQL 5.6ã ãƒƒï¼ï¼
ç±³å›½ã§è¡Œã‚ã‚Œã¦ã„ã‚‹MySQL Connectã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã§ã€ã¤ã„ã«MySQL 5.6 RCï¼ˆãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆï¼‰ãŒç™ºè¡¨ã•ã‚ŒãŸã€‚ãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆã¨ã„ã†ã“ã¨ã¯ã€ã“ã‚ŒãŒæ¬¡ã®æ£å¼ç‰ˆã«ãªã‚‹ã¨ã„ã†ã“ã¨ã ã€‚MySQL 5.5ã¯5.1ã‹ã‚‰å‡„ã¾ã˜ã„é€²åŒ–ã‚’é‚ã’ãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã£ãŸã€‚ã ãŒã€MySQL 5.6ã¯ã•ã‚‰ã«ãã‚Œã‚’ä¸Šå›žã‚‹é€²åŒ–ã‚’é‚ã’ã¦ã„ã‚‹ï¼æ£ç›´ã“ã“ã¾ã§ã®é€²åŒ–ã‚’èª°ãŒäºˆæƒ³ã—ãŸã ã‚ã†ã‹ã€ã„ã‚„èª°ã‚‚å‡ºæ¥ãªã‹ã£ãŸã§ã‚ã‚ã†ã€‚ã“ã‚Œã¾ã§ã€Î±ç‰ˆãŒå‡ºãŸã¨ãã‹ã‚‰ä½•åº¦ã‹æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ããŸãŒã€ä»Šå›žæ”¹ã‚ã¦MySQL 5.6ã®æ–°æ©Ÿèƒ½ã‚’æŒ¯ã‚Šè¿”ã£ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ã™ã¹ã¦ã¾ã¨ã‚ã‚‹ã¨ã‚‚ã®å‡„ã„å†…å®¹ã ã€‚èˆˆå¥®ã—ã¦å¤œã‚‚çœ ã‚Œãªããªã‚‹ã“ã¨è«‹ã‘åˆã„ã ã€‚MySQLã®é€²åŒ–ãŒæ¢ã¾ã‚‹ã®ã§ã¯ï¼Ÿãªã©ã¨ã„ã†å¿ƒé…ã¯å¹ãé£›ã³ã€ã‚‚ã¯ã‚„ã‚‚ã†ã¡ã‚‡ã£ã¨å°å‡ºã—ã«ã—ãªãã¦è‰¯ã‹ã£ãŸã®ã‹ï¼Ÿã¨å¿ƒé…ã—ã¦ã—ã¾ã†ãƒ¬ãƒ™ãƒ«ã§ã‚ã‚‹ã€‚ ãã‚Œã§ã¯MySQL 5.6ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ã„ã“ã†ã€‚ InnoDB
nagayama 2012/10/01
mysql
ãƒªãƒ³ã‚¯
Lebaran 2025 : Tradisi THR 2025 bagi-bagi bonus bareng IMEISLOT
Lebaran 2025 : Tradisi THR 2025 bagi-bagi bonus bareng IMEISLOT Lebaran 2025 atau Idul Fitri adalah momen yang sangat dinanti umat Muslim di seluruh dunia, termasuk Indonesia. Tahun 2025, Lebaran diperkirakan jatuh pada tanggal 1 Syawal 1446 H, yang kemungkinan besar akan berlangsung pada Rabu, 30 April 2025 (tergantung hasil rukyatul hilal). Perayaan ini menjadi waktu untuk mempererat silaturahmi
nagayama 2012/08/14
node

mysql
ãƒªãƒ³ã‚¯
GitHub - olivierphi/Node-DBI: A SQL database abstraction layer strongly inspired by the PHP Zend Framework Zend_Db API, with support of multiple Node.js database engines
var DBWrapper = require('node-dbi').DBWrapper; var DBExpr = require('node-dbi').DBExpr; var dbConnectionConfig = { host: 'localhost', user: 'test', password: 'test', database: 'test' }; // Replace the adapter name with "mysql", "mysql-libmysqlclient", "sqlite3" or "pg" on the following line : dbWrapper = new DBWrapper( '[DB engine adapter name]', dbConnectionConfig ); dbWrapper.connect(); // ** fe
nagayama 2012/08/14
node

mysql
ãƒªãƒ³ã‚¯
The Art of Workï¼šMySQL InnoDB Pluginã®ãƒ‡ãƒ¼ã‚¿åœ§ç¸®æ©Ÿèƒ½ æ€§èƒ½ç·¨ - SH2ã®æ—¥è¨˜
MySQL InnoDB Pluginã®ãƒ‡ãƒ¼ã‚¿åœ§ç¸®æ©Ÿèƒ½ã®ç¶šãã§ã™ã€‚å‰å›žã¯InnoDB Pluginã®ç‹¬è‡ªæ©Ÿèƒ½ã§ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿åœ§ç¸®ã®ä»•çµ„ã¿ã‚’è§£èª¬ã—ã€Wikipediaæ—¥æœ¬èªžç‰ˆã®ãƒ‡ãƒ¼ã‚¿ãŒç´„åŠåˆ†ã«ã¾ã§åœ§ç¸®ã•ã‚Œã‚‹ã“ã¨ã‚’ç¢ºèªã—ã¾ã—ãŸã€‚ä»Šå›žã¯ãƒ‡ãƒ¼ã‚¿åœ§ç¸®ã«ã‚ˆã£ã¦æ€§èƒ½ãŒã©ã®ã‚ˆã†ã«å¤‰åŒ–ã™ã‚‹ã‹ã‚’ã€å®Ÿéš›ã«ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯è©¦é¨“ã‚’è¡Œã£ã¦è¦‹ã¦ã„ãã¾ã™ã€‚ è©¦é¨“ã®æ–¹é‡ ãƒ‡ãƒ¼ã‚¿åœ§ç¸®ã«ã‚ˆã‚‹æ€§èƒ½ã¸ã®å½±éŸ¿ã¯ã€ä»¥ä¸‹ã®äºŒç‚¹ãŒè€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ ãƒ¡ãƒªãƒƒãƒˆï¼šãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºãŒå°ã•ããªã‚‹ãŸã‚ã€ãƒ‡ã‚£ã‚¹ã‚¯I/OãŒæ¸›ã‚‹ ãƒ‡ãƒ¡ãƒªãƒƒãƒˆï¼šåœ§ç¸®ãƒ»å±•é–‹ã®å‡¦ç†ãŒè¡Œã‚ã‚Œã‚‹ãŸã‚ã€CPUè² è·ãŒé«˜ããªã‚‹ ãã“ã§ã€ã“ã‚Œã‚‰ã®ç‰¹å¾´ãŒã‚ˆãåˆ†ã‹ã‚‹ã‚ˆã†ã«è©¦é¨“ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’å·¥å¤«ã—ã¾ã™ã€‚Wikipediaæ—¥æœ¬èªžç‰ˆã®ãƒ‡ãƒ¼ã‚¿ã¯InnoDBä¸Šã§ãŠã‚ˆã5GBã‚ã‚Šã¾ã™ãŒã€ã¾ãšç‹ã„ç¯„å›²ã«çµžã£ã¦èªã¿å–ã‚Šå‡¦ç†ã‚’è¡Œã†ã“ã¨ã§ãƒ‡ã‚£ã‚¹ã‚¯I/OãŒã‚ã¾ã‚Šç™ºç”Ÿã—ãªã„ã‚ˆã†ã«ã—ã¾ã™ã€‚ã“ã‚Œã§CPUè² è·ã®å‚¾å‘ã‚’ç¢ºèªã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚æ¬¡
nagayama 2009/12/18
mysql
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: Perl ã®ãƒ†ã‚¹ãƒˆç”¨ã« MySQL ç’°å¢ƒã‚’è‡ªå‹•ã§æ§‹ç¯‰ã™ã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« Test::mysqld ã‚’æ›¸ã„ãŸ
ORM ã‚„ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–¢é€£ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãªã©ã®ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ã‚’æ›¸ãã«ã‚ãŸã£ã¦ã¯ã€ RDBMS ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ã—ã‹ã—ã€SQLite ã®ã‚ˆã†ãªã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ¼ãƒ³ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨æ¯”è¼ƒã™ã‚‹ã¨ã€ã‚µãƒ¼ãƒåž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹ MySQL ã«æŽ¥ç¶šã—ã¦ãƒ†ã‚¹ãƒˆã‚’æ›¸ãã®ã¯ã€æ—¢å˜ã® MySQL ã®æ¨©é™è¨å®šã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã‚’æ°—ã«ã™ã‚‹å¿…è¦ãŒã‚ã£ãŸã‚Šã¨ã€ã„ã‚ã„ã‚ä¸ä¾¿ã§ã™ã€‚ãã“ã§ã€MySQL ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«è‡ªå‹•ç”Ÿæˆã—ã€ãƒ†ã‚¹ãƒˆãŒçµ‚ã‚ã£ãŸã‚‰å‰Šé™¤ã—ã¦ãã‚Œã‚‹ Perl ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« Test::mysqld ã‚’æ›¸ãã¾ã—ãŸã€‚ã“ã‚“ãªæ„Ÿã˜ã§ä½¿ã„ã¾ã™ã€‚ use DBI; use Test::mysqld; use Test::More; my $mysqld = Test::mysqld->new( my_cnf => { 'skip-networking' => '' }, # TCPæŽ¥ç¶šã‚’
nagayama 2009/08/04
mysql

perl

test
ãƒªãƒ³ã‚¯
RethinkDB: the open-source database for the realtime web
RethinkDB pushes JSON to your apps in realtime. When your app polls for data, it becomes slow, unscala ble, and cumbersome to maintain. RethinkDB is the open-source, scala ble database that makes building realtime apps dramatically easier. What is RethinkDB?go
nagayama 2009/07/29
mysql

strage

ssd
ãƒªãƒ³ã‚¯
HowFriendFeedUsesMySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹
HowFriendFeedUses MySqlToStoreSchemaLessData - FriendFeed ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ç›®æ¬¡ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ èƒŒæ™¯ æ¦‚è¦³ è©³ç´° ä¸€è²«æ€§ã¨åŽŸåæ€§ æ€§èƒ½ FriendFeed? ã§ã¯ MySQL ã‚’ä½¿ã„ã©ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãƒ¬ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã®ã‹ ã“ã®è¨˜äº‹ã«ã¤ã„ã¦ "How FriendFeed? uses MySQL to store schema-less data" ã®æ—¥æœ¬èªžè¨³ã§ã™ http://bret.appspot.com/entry/how-friendfeed-uses-mysql CC 2.5 ã§ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã•ã‚Œã¦ã„ã¾ã™: http://creativecommons.org/
nagayama 2009/03/02
friendfeed

performance

optimization

storage

mysql
ãƒªãƒ³ã‚¯
1