[B! ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] nobuokaã®ãƒ

nobuoka id:nobuoka

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹nobuokaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

MySQLã§INSERTã®ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã«åµŒã‚‹äººã‚’1äººã§ã‚‚æ¸›ã‚‰ã™ãŸã‚ã« - ichirin2501's diary
ã“ã®è¨˜äº‹ã¯ã¯ã¦ãªãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼2015ã®12æœˆ24æ—¥ã®è¨˜äº‹ã§ã™ã€‚ æ˜¨æ—¥ã¯ id:stefafafan ã•ã‚“ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨è‹±èªžã§ã—ãŸã€‚ ã“ã‚“ã«ã¡ã¯ã€ã“ã‚“ã°ã‚“ã¯ã€‚ ã‚¯ãƒªã‚¹ãƒžã‚¹ãƒ»ã‚¤ãƒ´ã§ã™ãã€çš†ã•ã‚“ã¯ã©ã®ã‚ˆã†ãªä¸€æ—¥ã‚’éŽã”ã•ã‚Œã‚‹(ãŸ)ã®ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯ä¸€äººã§ã™ã€‚ æ”¹ã‚ã¾ã—ã¦ã€å…ˆæ—¥åˆã‚ã¦ã®åˆã‚³ãƒ³ã‚’çµŒé¨“/å¤±æ•—ã—ã¦äºŒåº¦ã¨è¡Œã‹ãªã„ã¨èª“ã£ãŸ ã¯ã¦ãªã® id:ichirin2501 ã§ã™ã€‚ä»Šå›žã¯å°ãƒã‚¿ã¨ã—ã¦MySQL(InnoDB)ã®BULK INSERTã«ãŠã‘ã‚‹ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã®è©±ã‚’ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ãŸã ã€å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ãŒçµ¡ã‚€ã¨è¤‡é›‘ã«ãªã‚‹ã®ã§ä»Šå›žã¯è§¦ã‚Œã¾ã›ã‚“ã€‚ãã‚Œã«ã¤ã„ã¦ã¯ã“ã¡ã‚‰ã‚’å‚ç…§ãã ã•ã„ã€‚ ã‚ã€ã‚¿ã‚¤ãƒˆãƒ«ã¯ã‚ªãƒžãƒ¼ã‚¸ãƒ¥ã§ã™*1ã€‚ Topic æ¤œè¨¼ç’°å¢ƒ INSERTã®ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ é¿ã‘ã‚‰ã‚Œãªã„ã‚±ãƒ¼ã‚¹ ã‚‚ã—ãã¯ãƒãƒƒã‚¯ã™ã‚‹ ãƒªãƒˆãƒ©ã‚¤å‡¦ç†ã«æ³¨æ„ åˆæœŸãƒ‡ãƒ¼ã‚¿ Duplicateã®å ´åˆ Deadlockã®
nobuoka 2017/11/17
ã“ã‚Œã‚’è¦‹ã¦ InnoDB ã®ãƒãƒƒã‚¯ã®ã“ã¨ã‚’èª¿ã¹ãŸã‚Šã—ã¦ã‚‹ã€‚

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

DB

ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯

MySQL

InnoDB
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒãƒ¬ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«ã‚ˆã‚‹æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹ç¯‰ã¨ç›£è¦– / Serverlessconf Tokyo 2017
ã‚µãƒ¼ãƒãƒ¬ã‚¹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«ã‚ˆã‚‹æ™‚ç³»åˆ—ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹ç¯‰ã¨ç›£è¦–
nobuoka 2017/11/03
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ç›£è¦–

ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£

serverless
ãƒªãƒ³ã‚¯
Welcome to the Atlas Device SDK Docs - Atlas Device SDKs
Atlas Device SDKs are deprecated. Refer to the deprecation page for details. Atlas Device SDK is a suite of app development tools optimized for data access and persistence on mobile devices. Use the SDKs to build data-driven mobile, web, desktop, and IoT apps. The SDKs provide tools to read and write Atlas data from devices. Your app can sync automatically with Mongo DB Atlas and other devices usin
nobuoka 2015/08/26
å…¨ç„¶çŸ¥ã‚‰ãªã‹ã£ãŸã‘ã©ã‚ˆã•ãã†ã€‚

Android ã‚¢ãƒ—ãƒªé–‹ç™º

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ©ç”¨æ™‚ã«è‡ªå‰ã§æŽ’ä»–åˆ¶å¾¡ãŒå¿…è¦ã‹ - ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãƒ¡ãƒ¢
ä¸¦è¡Œå‡¦ç†ãŒã‚ã‚‹ç’°å¢ƒã§ã¯ã€Webã‚¢ãƒ—ãƒªã«é™ã‚‰ãšæŽ’ä»–åˆ¶å¾¡ã®è€ƒæ…®ãŒå¿…è¦ã€‚å¿…è¦ã«ãªã‚‹å…¸åž‹ä¾‹ã¯æ¬¡ã®ãƒ‘ã‚¿ãƒ¼ãƒ³ã€‚ ãƒ‘ã‚¿ãƒ¼ãƒ³1 å€¤ã‚’å–å¾—ã—ã¦ã‹ã‚‰ ãã®å€¤ã«åŸºã¥ãè¨ˆç®—çµæžœã‚’æ›¸ãå‡ºã— ãƒ‘ã‚¿ãƒ¼ãƒ³2 å‰ææ¡ä»¶ã‚’ç¢ºèªã—ã¦ã‹ã‚‰ æ¡ä»¶ã‚’æº€ãŸã—ã¦ã„ã‚Œã°å‡¦ç†ã‚’å®Ÿè¡Œ 1ã‚’å–å¾—ãƒ»ç¢ºèªã—ã¦ã‹ã‚‰2ã‚’å®Ÿè¡Œã™ã‚‹ã¾ã§ã®é–“ã«åˆ¥ã®ã‚¹ãƒ¬ãƒƒãƒ‰ãƒ»ãƒ—ãƒã‚»ã‚¹ãŒãƒ‡ãƒ¼ã‚¿ã‚’æ›¸ãæ›ãˆã¦ã—ã¾ã†ã¨ã€1ã§å¾—ãŸæƒ…å ±ãŒã‚‚ã¯ã‚„æ£ã—ããªã„ã¾ã¾2ã‚’å®Ÿè¡Œã—ã¦ã—ã¾ã†å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ã“ã®ãŸã‚ã€ã“ã‚Œã‚‰ã®å‡¦ç†ãŒå®Œäº†ã™ã‚‹ã¾ã§ã®é–“ã«1ã®çµæžœã‚’å¤‰æ›´ã—ã¦ã—ã¾ã†ã‚ˆã†ãªå‡¦ç†ãŒå‰²ã‚Šè¾¼ã¾ãªã„ã‚ˆã†æŽ’ä»–åˆ¶å¾¡ãŒå¿…è¦ã«ãªã‚‹ã€‚ ä¾‹1 é é‡‘æ®‹é«˜ã‚’å–å¾—ã—ã¦ã‹ã‚‰ ãã‚Œã«100å††ã‚’åŠ ãˆãŸé‡‘é¡ã‚’é é‡‘æ®‹é«˜ã¨ã—ã¦è¨˜éŒ² ä¾‹2 ä¼šå“¡è³‡æ ¼ãŒåœæ¢ã•ã‚Œã¦ã„ãªã„ã“ã¨ã‚’ç¢ºèªã—ã¦ã‹ã‚‰ ãã®ä¼šå“¡ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾› ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžãƒ¬ãƒ™ãƒ«ã®åˆ¶å¾¡ãªã‚‰ Javaã®å ´åˆã€åŒä¸€VMå†…ã§ã‚ã‚Œã°ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒãƒƒã‚¯ã‚’åˆ©ç”¨ã—ã¦æŽ’ä»–åˆ¶å¾¡ãŒå®Ÿç¾ã§ãã‚‹ã€‚ ã‚ã‚‹ã‚ªãƒ–
nobuoka 2013/12/24
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®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
nobuoka 2013/11/28
é‹ç”¨

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
1