[B! MySQL] ninnin2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ninnin2 id:ninnin2

MySQLã«é–¢ã™ã‚‹ninnin2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

${{author_name}}$

{{author_name}} {{created}}

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

{{#following_bookmarks}}

${{author_name}}$

{{author_name}} {{created}}

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

{{/following_bookmarks}}

{{/is_wiped}}

MySQL/Aurora/TiDBãƒãƒƒã‚¯å…¥é–€ â€“ ç¬¬ï¼’å›žãƒãƒƒã‚¯ãƒ¢ãƒ‹ã‚¿ãƒ¼ã®èªã¿æ–¹ã€å‹•ç”»è§£èª¬ä»˜ã€‘ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
MySQL/Aurora/TiDBãƒãƒƒã‚¯å…¥é–€ â€“ ç¬¬ï¼’å›žãƒãƒƒã‚¯ãƒ¢ãƒ‹ã‚¿ãƒ¼ã®èªã¿æ–¹ã€å‹•ç”»è§£èª¬ä»˜ã€‘ MySQL ã¨ãã®äº’æ› DB ã®ãƒãƒƒã‚¯ã‚„ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®æŒ™å‹•ã‚’ç´¹ä»‹ã™ã‚‹å…¥é–€ã‚·ãƒªãƒ¼ã‚ºã€ã€Œç¬¬ï¼‘å›ž ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã€ ã§ã¯ READ COMMITTED ã‚„ REPEATABLE READ ã§ã©ã†ã„ã†æŒ™å‹•ã«ãªã‚‹ã‹ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ç¬¬ï¼’å›žç›®ã®ä»Šå›žã¯ MySQL InnoDB ã®ãƒãƒƒã‚¯ãƒ¢ãƒ‹ã‚¿ãƒ¼ã®èªã¿æ–¹ã€ä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚MySQL ã®ãƒãƒƒã‚¯æ©Ÿæ§‹ã‚’ç†è§£ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ä¾¿åˆ©ãªã®ã§ãœã²ã”ä¸€èªãã ã•ã„ï¼ â˜… ç¬¬ï¼‘å›ž ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ« â˜… ç¬¬ï¼’å›ž ãƒãƒƒã‚¯ãƒ¢ãƒ‹ã‚¿ãƒ¼ã®èªã¿æ–¹ â˜… ç¬¬ï¼“å›ž ãƒãƒƒã‚¯èªå–ã‚Šã‚‚ SELECT ã¯æ¢ã‚ã‚‰ã‚Œãªã„ â˜… ç¬¬ï¼”å›ž INSERT ã‚’æ¢ã‚ã‚‹ã‚¤ãƒ³ãƒ†ãƒ³ã‚·ãƒ§ãƒ³ãƒãƒƒã‚¯ â˜… ç¬¬ï¼•å›ž WHERE æ¡ä»¶ã¨é•ã†ãƒãƒƒã‚¯èªå–ã‚Š â˜… ç¬¬ï¼–å›ž performance_schema â˜… ç¬¬ï¼—
ninnin2 2024/06/04
MySQL

DB

æŠ€è¡“

Aurora

TiDB
ãƒªãƒ³ã‚¯
MySQL/Aurora/TiDBãƒãƒƒã‚¯å…¥é–€ â€“ ç¬¬ï¼‘å›žãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
MySQL/Aurora/TiDBãƒãƒƒã‚¯å…¥é–€ â€“ ç¬¬ï¼‘å›žãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ« MySQL InnoDB ãŠã‚ˆã³ AWS Aurora ã‚„ PingCAP TiDB ã«ãŠã‘ã‚‹ãƒãƒƒã‚¯ã®ä»•çµ„ã¿ã‚„ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®å‹•ä½œã‚’å…¨ï¼‘ï¼‘å›žã®ã‚·ãƒªãƒ¼ã‚ºã§è§£èª¬ã—ã¾ã™ï¼ æœ€åˆã¯ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦é‡è¦ãª MySQL 8.0 InnoDB å‰æã§ãƒ¦ãƒ¼ã‚¶ãƒ¼è¦–ç‚¹ã§ã®ãƒãƒƒã‚¯ã®ä»•çµ„ã¿ã‚’å¦ã³ã€å¾ŒåŠç¬¬ï¼‘ï¼å›žä»¥é™ã§ã¯ MySQL äº’æ› DB ã¨ã—ã¦äººæ°—ã®é«˜ã„ AWS Aurora ã‚„ PingCAP TiDB ã¨ MySQL InnoDB ã¨ã®é•ã„ã«ã¤ã„ã¦å¦ã³ã¾ã™ã€‚ ï¼‘å›žç›®ã®ä»Šå›žã¯ãƒãƒƒã‚¯æ©Ÿæ§‹ã¨åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Šé›¢ã›ãªã„ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¨ãã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã«ã¤ã„ã¦ã€å®Ÿéš›ã«æŒ™å‹•ã‚’ç¢ºã‹ã‚ãªãŒã‚‰è§£èª¬ã—ã¾ã™ã€‚ãƒ©ã‚¤ãƒ–æ„Ÿã®ã‚ã‚‹èª¬æ˜Žã‚‚ç†è§£ã«å½¹ç«‹ã¡ã¾ã™ã®ã§ã€è§£èª¬å‹•ç”»ã‚‚ä»˜ã‘ã¦ã¿ã¾ã—ãŸã€‚åˆã‚ã›ã¦ã”è¦§ãã ã•ã„ï¼ â˜… ç¬¬ï¼‘å›ž ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ« â˜… ç¬¬ï¼’å›ž ãƒ
ninnin2 2024/05/31
æŠ€è¡“

MySQL

AWS
ãƒªãƒ³ã‚¯
MySQL ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ EXPLAIN ã®ç¤¾å†…è¬›ç¿’ä¼šã—ã¾ã—ãŸï¼ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
MySQL ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ EXPLAIN ã®ç¤¾å†…è¬›ç¿’ä¼šã—ã¾ã—ãŸï¼ ã¿ãªã•ã‚“MySQLä½¿ã£ã¦ã„ã¾ã™ã‹ï¼Ÿ ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã® nobuh ã“ã¨æ³¢å¤šé‡Žã§ã™ã€‚ å¼Šç¤¾ã¯ã‚µãƒ¼ãƒãƒ¼é–‹ç™ºã«æºã‚ã‚‹ã“ã¨ãŒå¤šãã€ã‚µãƒ¼ãƒãƒ¼é–‹ç™ºã®è¨€èªžã¨ã—ã¦ã¯ PHP ã‚’ã¯ã˜ã‚ C# ãªã©ã„ã‚ã„ã‚ãªè¨€èªžã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ãã®ã‚µãƒ¼ãƒãƒ¼ã¨åˆã‚ã›ã¦å¿…é ˆã¨ãªã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã¤ã„ã¦ã¯ MySQL ãªã„ã— AWS RDS Aurora ãªã© MySQL äº’æ›ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å«ã‚ã€ã»ã¼ 100% MySQL ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ ãã—ã¦ã€ã©ã‚“ãªã‚µãƒ¼ãƒ“ã‚¹ã‚„ãƒ—ãƒãƒ€ã‚¯ãƒˆã§ã‚‚ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã—æä¾›ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€æ€§èƒ½ã§ã‚‚é‡è¦ãªéƒ¨åˆ†ã«ãªã‚Šã¾ã™ã€‚ ä»Šå›žãã‚“ãª MySQL ã®æ€§èƒ½ã§é‡è¦ã¨ãªã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã€ã¾ãŸã‚¯ã‚¨ãƒªã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹å ´åˆã«å¿…è¦ã¨ãªã‚‹ EXPLAIN ã«ã¤ã„ã¦ã®ç¤¾å†…è¬›ç¿’ä¼šã‚’ã€Œæ–°å’è¬›ç¾©ã€ã®å ´ã‚’å€Ÿã‚Šã¦å®Ÿæ–½ã„ãŸã—ã¾ã—ãŸã€‚ãã®å†…å®¹ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„
ninnin2 2023/08/30
PHP

MySQL
ãƒªãƒ³ã‚¯
MySQL 5.6 ã® ALTER TABLE ã¨ Percona Toolkit ã® pt-online-schema-change ã‚’æ¯”è¼ƒã—ã¦ã¿ãŸï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ãƒ›ãƒ¼ãƒ æŠ€è¡“ãƒ–ãƒã‚° MySQL 5.6 ã® ALTER TABLE ã¨ Percona Toolkit ã® pt-online-schema-change ã‚’æ¯”è¼ƒã—ã¦ã¿ãŸ MySQL 5.6 ã® ALTER TABLE ã¨ Percona Toolkit ã® pt-online-schema-change ã‚’æ¯”è¼ƒã—ã¦ã¿ãŸ ã“ã‚“ã«ã¡ã‚ï¼ã¿ãªã•ã‚“ MySQL ä½¿ã£ã¦ã¾ã™ã‹ï¼Ÿã‚¤ãƒ³ãƒ•ãƒ©ã® nobuh ã§ã™ã€‚ ã‚²ãƒ¼ãƒ ãªã©ã®ã‚µãƒ¼ãƒãƒ¼ã§ã¯ã€æ™‚ã€…ã‚µãƒ¼ãƒ“ã‚¹ã‚’åœæ¢ã—ã¦ã„ã‚ã‚†ã‚‹ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã¨ã„ã†ä½œæ¥ãŒè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ã€€ã‚²ãƒ¼ãƒ ã‚’ãƒ—ãƒ¬ã‚¤ã—ã¦ã„ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®çš†æ§˜ã«ã¯ã”ä¸ä¾¿ã‚’ãŠæŽ›ã‘ã—ã¦å¤§å¤‰ç”³ã—è¨³ãªã„ã¨ã“ã‚ã§ã™ãŒã€ã‚µãƒ¼ãƒ“ã‚¹ã‚’åœæ¢ã—ã¦ã¾ã§æˆ‘ã€…ã‚¢ãƒ—ãƒªé–‹ç™ºã‚„ã‚µãƒ¼ãƒãƒ¼é‹ç”¨ã®ä¼šç¤¾ã®äººãŸã¡ãŒä½•ã‚’ã‚„ã£ã¦ã„ã‚‹ã‹ã¨ã„ã„ã¾ã™ã¨ã€ãã®ç†ç”±ã®å¤§ããªã‚‚ã®ã®ä¸€ã¤ãŒãƒ‡ãƒ¼ã‚¿ãƒ¼ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã®å¤‰æ›´ã§ã™ã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä¿®æ£ã—ãŸã‚Šã€æ–°æ©Ÿèƒ½ã‚’è¿½åŠ ã™ã‚‹ã¨ãã¯ãƒ‡
ninnin2 2015/11/19
æŠ€è¡“ãƒ–ãƒã‚°æ›´æ–°ã§ã™ï¼

æŠ€è¡“

MySQL
ãƒªãƒ³ã‚¯
OSC2015åŒ—æµ·é“ã§ã€Œã“ã‚Œã ã‘ã¿ã‚Œã°å¤§ä¸ˆå¤«ãƒ¼Cactiã«ã‚ˆã‚‹MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœã€ã¨ã„ã†ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
OSC2015åŒ—æµ·é“ã§ã€Œã“ã‚Œã ã‘ã¿ã‚Œã°å¤§ä¸ˆå¤«ãƒ¼Cactiã«ã‚ˆã‚‹MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœã€ã¨ã„ã†ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸ ã“ã‚“ã«ã¡ã¯ nobuh ã§ã™ã€‚ æ˜¨å¹´ã® ç¬¬å››å›žæœå¹ŒMySQLå‹‰å¼·ä¼š ä»¥é™ã€å¤šå¿™ã®ãŸã‚ãªã‹ãªã‹å‹‰å¼·ä¼šã‚’é–‹ã‘ã¦ã„ãªã„æœå¹ŒMySQLå‹‰å¼·ä¼šã§ã™ãŒã€å„ãƒ¡ãƒ³ãƒãƒ¼ã¯ã“ã¤ã“ã¤ã¨ã‚¹ã‚ãƒ«ã‚¢ãƒƒãƒ—ã‚’ç¶šã‘ã¦ã„ã¾ã—ãŸã€‚ ãã—ã¦ä»Šå›žã€æ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼š æ§˜ã‹ã‚‰ãŠè©±ã‚’é ‚ãã€OSC2015åŒ—æµ·é“ ã«ã¦æœå¹ŒMySQLå‹‰å¼·ä¼šã‹ã‚‰ç™ºè¡¨ã•ã›ã¦é ‚ãã¾ã—ãŸã€‚ã“ã¡ã‚‰ãŒãã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§ã™ã€‚ InnoDB ã® I/O ã®ã—ãã¿ã«ã¤ã„ã¦ã®è§£èª¬éƒ¨åˆ† ã‚°ãƒ©ãƒ•ã‚’è¦‹ã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®çŠ¶æ³ã‚’çŸ¥ã‚‹ã«ã¯ã€MySQL ã‚„ InnoDB ãŒã©ã†ã„ã†å‹•ä½œã‚’ã—ã¦ã„ã‚‹ã®ã‹çŸ¥ã£ã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ãŒã€InnoDB ã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ‡ã‚£ã‚¹ã‚¯ã«æ›¸ãè¾¼ã‚€ checkpoint ã®ä»•çµ„ã¿ã¯ã¨ã¦ã‚‚è¤‡é›‘ã§è³‡æ–™ã‚‚å°‘ãªã„ã§ã™ã€‚ç™ºè¡¨å½“æ—¥ã®ãƒ—ãƒ¬ã‚¼ãƒ³ã§ã¯å°‘ã—ã§ã‚‚ã‚ã‹ã‚Š
ninnin2 2015/06/15
æŠ€è¡“ãƒ–ãƒã‚°æ›´æ–°ã§ã™ï¼ï¼

MySQL

Cacti

æŠ€è¡“

OSC
ãƒªãƒ³ã‚¯
2014å¹´11æœˆ15æ—¥(åœŸ)ã«æœå¹Œã§ã€ŒåŒ—æµ·é“ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹DAYã€ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¾ã™ï¼ï½œåºƒå ±ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
2014å¹´11æœˆ15æ—¥(åœŸ)ã«æœå¹Œã§ã€ŒåŒ—æµ·é“ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹DAYã€ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¾ã™ï¼ matsuiã§ã™ã€‚ã‚¤ãƒ™ãƒ³ãƒˆã®ãŠçŸ¥ã‚‰ã›ã§ã™ã€‚ 2014å¹´11æœˆ15æ—¥(åœŸ)ã«æœå¹Œã§ã€ŒåŒ—æµ·é“ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹DAYã€ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¾ã™ï¼ ã‚¤ãƒ™ãƒ³ãƒˆæ¦‚è¦ â€œåŒ—æµ·é“ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹DAYâ€ã¯é“å†…ã§æ´»å‹•ã—ã¦ã„ã‚‹RDBMSã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®æœå¹ŒMySQLå‹‰å¼·ä¼šã¨ã€æ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼š åŒ—æµ·é“æ”¯éƒ¨ã®åˆåŒã‚¤ãƒ™ãƒ³ãƒˆã§ã™ã€‚ ä»Šå›žã®ã‚¤ãƒ™ãƒ³ãƒˆã§ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®RDBMSã¨ã—ã¦äººæ°—ã®é«˜ã„MySQLã¨PostgreSQLãã‚Œãžã‚Œã®æœ€æ–°å‹•å‘ã¨ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†å…¨ã¦ã®æŠ€è¡“è€…ã«çŸ¥ã£ã¦æ¬²ã—ã„ã€Œæ£ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€ã‚’ã¾ã¨ã‚ã¦ãŠå±Šã‘ã—ã¾ã™ï¼ å„æ–¹é¢ã§ã”æ´»èºä¸ã®ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆã®å£°ã‚’ãœã²ç”Ÿã§ãŠèžããã ã•ã„ã€‚ æ—¥æ™‚:ã€€2014å¹´11æœˆ15æ—¥(åœŸ) å ´æ‰€:ã€€æœå¹Œå¸‚ä¸å¤®åŒºåŒ—1æ¡è¥¿1ä¸ç›® æœå¹Œå¸‚æ°‘ãƒ›ãƒ¼ãƒ« ç¬¬1ä¼šè°å®¤
ninnin2 2014/10/16
æœå¹Œã§DBã‚¤ãƒ™ãƒ³ãƒˆã‚„ã‚Šã¾ã™ã€‚ã¿ã‚“ãªæ¥ã¦ãï¼

MySQL

PostgreSQL

DB

Oracle
ãƒªãƒ³ã‚¯
åŒ—æµ·é“ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹DAY
"åŒ—æµ·é“ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹DAY"ã¯é“å†…ã§æ´»å‹•ã—ã¦ã„ã‚‹RDBMSã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®æœå¹ŒMySQLå‹‰å¼·ä¼šã¨ã€æ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ä¼š åŒ—æµ·é“æ”¯éƒ¨ã®åˆåŒã‚¤ãƒ™ãƒ³ãƒˆã§ã™ã€‚ ä»Šå›žã®ã‚¤ãƒ™ãƒ³ãƒˆã§ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®RDBMSã¨ã—ã¦äººæ°—ã®é«˜ã„MySQLã¨PostgreSQLãã‚Œãžã‚Œã®æœ€æ–°å‹•å‘ã¨ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†å…¨ã¦ã®æŠ€è¡“è€…ã«çŸ¥ã£ã¦æ¬²ã—ã„ã€Œæ£ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã€ã‚’ã¾ã¨ã‚ã¦ãŠå±Šã‘ã—ã¾ã™ï¼ å„æ–¹é¢ã§ã”æ´»èºä¸ã®ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆã®å£°ã‚’ãœã²ç”Ÿã§ãŠèžããã ã•ã„ã€‚ ã‚¿ã‚¤ãƒ ãƒ†ãƒ¼ãƒ–ãƒ« æ™‚åˆ» ã‚¿ã‚¤ãƒˆãƒ«
ninnin2 2014/10/14
ã‚¤ãƒ™ãƒ³ãƒˆã‚„ã‚Šã¾ã™ï¼

Tech

æŠ€è¡“

MySQL
ãƒªãƒ³ã‚¯
ã€Žã€Œæ–°å…¥ç¤¾å“¡ã®ãŸã‚ã®å¤§è¦æ¨¡ã‚²ãƒ¼ãƒ é–‹ç™ºå…¥é–€ ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ç·¨ã€ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’å…¬é–‹ã—ã¾ã—ãŸï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—ã€ã¸ã®ã‚³ãƒ¡ãƒ³ãƒˆ
ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼ ã€Œæ–°å…¥ç¤¾å“¡ã®ãŸã‚ã®å¤§è¦æ¨¡ã‚²ãƒ¼ãƒ é–‹ç™ºå…¥é–€ ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ç·¨ã€ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’å…¬é–‹ã—ã¾ã—ãŸï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ninnin2 2014/06/16
PHP

MySQL

Dev

ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³
ãƒªãƒ³ã‚¯
MySQL5.6ã®æ–°æ©Ÿèƒ½ã€ŒInnoDB Memcached Pluginã€ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’æ¤œè¨¼ã—ã€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ æ¡ˆä»¶ã«ä½¿ãˆãã†ã‹æ¤œè¨¼ã—ã¦ã¿ã¾ã—ãŸï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ãƒ›ãƒ¼ãƒ æŠ€è¡“ãƒ–ãƒã‚° MySQL5.6ã®æ–°æ©Ÿèƒ½ã€ŒInnoDB Memcached Pluginã€ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’æ¤œè¨¼ã—ã€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ æ¡ˆä»¶ã«ä½¿ãˆãã†ã‹æ¤œè¨¼ã—ã¦ã¿ã¾ã—ãŸ MySQL5.6ã®æ–°æ©Ÿèƒ½ã€ŒInnoDB Memcached Pluginã€ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’æ¤œè¨¼ã—ã€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ æ¡ˆä»¶ã«ä½¿ãˆãã†ã‹æ¤œè¨¼ã—ã¦ã¿ã¾ã—ãŸ matsuiã§ã™ã€‚ å…ˆæ—¥6/1ã«è¡Œã‚ã‚ŒãŸç¬¬å››å›žæœå¹ŒMySQLå‹‰å¼·ä¼šã®ä¸ã§ã€MySQL5.6ã®æ–°æ©Ÿèƒ½ã€ŒInnoDB Memcached Pluginã€ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã«ã¤ã„ã¦èª¿ã¹ã¦ã¿ã¾ã—ãŸã®ã§ã€è¨˜äº‹ã«ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ InnoDB Memcached Pluginã¨ã¯ ã€ŒInnoDB Memcached Pluginã€ã¨ã¯ã€MySQL5.6ã‹ã‚‰ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã€SQLã‚’ä½¿ã‚ãšMemcachedãƒ—ãƒãƒˆã‚³ãƒ«ã‚’ä½¿ã£ã¦InnoDBã®ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ ä¸»ãªãƒ¡ãƒªãƒƒãƒˆã¯ãã®é«˜
ninnin2 2013/06/04
æŠ€è¡“ãƒ–ãƒã‚°æ›´æ–°ã—ã¾ã—ãŸï¼ï¼ ã€è¿½è¨˜ã€‘å†æ¤œè¨¼ã‚‚ã—ã¾ã—ãŸã€‚ã‚¢ãƒ‰ãƒã‚¤ã‚¹ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚

é–‹ç™º

MySQL
ãƒªãƒ³ã‚¯
ã“ã®ãƒšãƒ¼ã‚¸ã‚’è¦‹ã‚‹ã«ã¯ã€ãƒã‚°ã‚¤ãƒ³ã¾ãŸã¯ç™»éŒ²ã—ã¦ãã ã•ã„
Facebookã§æŠ•ç¨¿ã‚„å†™çœŸãªã©ã‚’ãƒã‚§ãƒƒã‚¯ã§ãã¾ã™ã€‚
ninnin2 2012/09/30
åŒ—æµ·é“æœå¹Œã«ã‚ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ä¼šç¤¾ã€‚ä¸»ã«ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®é–‹ç™ºã‚’è¡Œã£ã¦ã„ã‚‹ã€‚ãƒ—ãƒã‚°ãƒ©ãƒžã‚‚æ±‚äººå‹Ÿé›†ä¸ã€‚

IT

PHP

MySQL

ã‚²ãƒ¼ãƒ é–‹ç™º
ãƒªãƒ³ã‚¯
ke-tai.org > Blog Archive > æœå¹ŒMySQLå‹‰å¼·ä¼šã€ç››æ³ã®ã†ã¡ã«çµ‚äº†ã—ã¾ã—ãŸ
ninnin2 2011/08/22
MySQL
ãƒªãƒ³ã‚¯
ke-tai.org > Blog Archive > Technology of DeNAã«ã€Œã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ãã®ï¼’ã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™
Techno logy of DeNAã«ã€Œã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ãã®ï¼’ã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ Tweet 2011/2/16 æ°´æ›œæ—¥ matsui Posted in è¨˜äº‹ç´¹ä»‹ãƒ»ãƒªãƒ³ã‚¯ | No Comments Â» DeNAã®æŠ€è¡“ãƒ–ãƒã‚°ã€ŒTechno logy of DeNAã€ã«ã€ã€Œã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ãã®ï¼’ã€ã¨ã„ã†è¨˜äº‹ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ â†’ã€€Techno logy of DeNAã€€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ãã®ï¼’ [engineer.dena.jp] å‰å›žã®è¨˜äº‹ã‚‚ã€å½“ãƒ–ãƒã‚°ã§ç´¹ä»‹ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ãã®ã¨ãã®è¨˜äº‹ã¯ã“ã¡ã‚‰ã§ã™ã€‚ DELETEãŒé…ã„ã®ã§ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’ä½¿ã£ã¦è§£æ±ºã™ã‚‹ã¨ã„ã†ã®ã¯ã€ç›®ã‹ã‚‰ã†ã‚ã“ã§ã—ãŸã€‚ â†’ã€€ke-tai.orgã€€DeNAã®MySQLã®ãƒŽã‚¦ãƒã‚¦ãŒã¾ã¨ã‚ã‚‰ã‚ŒãŸè¨˜äº‹ã€Œã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ã€ [ke-t
ninnin2 2011/02/16
mobile

MySQL
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@HatenaBookmark
ãƒªãƒªãƒ¼ã‚¹ã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“ã‚¹ã®ãŠçŸ¥ã‚‰ã›
@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx