[B! DB] taniai114ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

taniai114 id:taniai114

DBã«é–¢ã™ã‚‹taniai114ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

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

ä»Šã¾ã§è¦‹ãŸã‚‚ã£ã¨ã‚‚ã‚¯ã‚½ãªãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆ - ä½•ã‹ç€ã¦ã„ã‚Œã°ã„ã„ã‚ˆ
ã‚ã‚Œã¯ã€åƒ•ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ‰±ã†ã†ã¡æœ€åˆã‹ã‚‰ï¼“ä»¶ç›®ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã ã£ãŸã€‚ C++ã®ã‚½ãƒ¼ã‚¹ãŒé›£è§£ã§ç«ã‚’å¹ã„ã¦ã„ã‚‹ã¨ã„ã†è©±ã§ã€è‡ªåˆ†ã¯ä½Žã‚¹ã‚ãƒ«ã®è‹¥é€ ã€‚ç«ã«ãã¹ã‚‹ã«ã¯ä¸åº¦è‰¯ã„ç¨‹åº¦ã®ã‚„ã‚‹æ°—ã¨è²¬ä»»æ„Ÿã‚’ã‚‚ã£ã¦ã„ãŸã€‚æŠ˜æ‚ªãåˆ¥ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒçµ‚äº†ã—ãŸç›´å¾Œã ã£ãŸã‚‚ã®ã§æŠ•å…¥ã•ã‚ŒãŸã®ã§ã—ãŸã€‚ ç¾å ´ã§ã€ŽDBã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å¸ã„å‡ºã™ãƒ„ãƒ¼ãƒ«ã‹SQLã‚’ä½œã£ã¦ãã‚Œã€ã¨ã„ã‚ã‚Œè©±ã‚’ããã¨ä»–ç¤¾ãŒä½œã£ãŸDBå®šç¾©ãŒã™ã“ã¶ã‚‹ä½¿ã„ã¥ã‚‰ã„ã¨ã„ã†ã€‚ ERå›³ã‚„DBå®šç¾©ã‚’è¦‹ã›ã¦ãã ã•ã„ã¨è¨€ã£ãŸã®ã ã‘ã©ã€ãã‚“ãªã‚‚ã®ã¯ç„¡ã„ã¨ã„ã†è¿”äº‹ã€‚ ä»Šãªã‚‰ã‚‚ã†ã“ã“ã‚‰è¾ºã§é€ƒã’å‡ºã™ã¨ã“ã‚ã§ã™ãŒã€å½“æ™‚ã¯ã€Žãµãƒ¼ã‚“ã€‚ã€ã¦ãªã‚‚ã‚“ã§ãã†ã„ã†ã“ã¨ã‚‚ã‚ã‚‹ã®ã‹ãã‚‰ã„ã®è»½ã„æ°—æŒã¡ã§è€ƒãˆã¦ã„ã¾ã—ãŸã€‚ ã§ã€ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®è³‡æ–™ã‚’ã‚ã•ã‚Šã¾ãã£ã¦ä½•ã¨ã‹DBå®šç¾©ã®ã‚ˆã†ãªã‚‚ã®ã‚‚è¦‹ã¤ã‘DBã®ãƒ‡ãƒ¼ã‚¿ã‚’èª¿æŸ»ã—å§‹ã‚ãŸã®ã§ã™ãŒä½•ã‹ãŒãŠã‹ã—ã„ã€‚ æ©Ÿèƒ½ã®æ•°ã«æ¯”ã—ã¦ç•°æ§˜ã«ãƒ†ãƒ¼ãƒ–ãƒ«æ•°ãŒå°‘ãªã„ã®ã§ã™ã€‚ ãµã¨å‘¨ã‚Šã‚’è¦‹ã‚‹ã¨ã€çš†
taniai114 2014/03/05
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

programming

ã“ã‚Œã¯ã²ã©ã„

DB
ãƒªãƒ³ã‚¯
ã‚±ã‚™ãƒ¼ãƒ ã‚µãƒ¼ãƒã‚™é–‹ç™ºç¾å ´ã®è€ƒãˆæ–¹
11. é€šä¿¡ã‚·ã‚¹ãƒ†ãƒ ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ é€šä¿¡ãŒä¸è¦ã§ã‚ã‚Œã°HTTP é€å—ä¿¡ï¼ˆPOSTï¼‰ã™ã‚‹ãƒ‡ãƒ¼ã‚¿å½¢å¼ã¯ï¼Ÿ XML, JSON, MessagePack, Google Protocol Buffers, ç‹¬è‡ªã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚º é€šä¿¡ã®é »åº¦ã¨ãƒ‡ãƒ¼ã‚¿é‡ã€ãƒ‡ã‚·ãƒªã‚¢ãƒ©ã‚¤ã‚ºå‡¦ç†ã®é‡ ã•ã€é–‹ç™ºï¼†ãƒ‡ãƒãƒƒã‚°ã®ã‚„ã‚Šã‚„ã™ã•ãªã©ã‹ã‚‰æ¤œè¨Žï¼ˆæ…£ ã‚Œãªã„ã†ã¡ã¯JSONã‚ªã‚¹ã‚¹ãƒ¡ï¼‰ 11 12. æƒ³å®šè² è· ä¾‹ï¼‰DAU(Daily Active Users) 10ä¸‡ 10ä¸‡ x 20 Login/æ—¥= 200ä¸‡ Login/æ—¥ = 23 Login/ç§’ 3å€ã—ã¦ 23 x 3 â‰’ 70 Login/ç§’ ã“ã‚ŒãŒæ—¥ã€…ã®ãƒ”ãƒ¼ã‚¯ Webã‚µãƒ¼ãƒ1å°ã§12ç¨‹åº¦ã•ã°ã‘ã‚‹ã¨ä»®å®šã™ã‚‹ã¨ã€Webã‚µãƒ¼ãƒ6å° ã¨ãªã‚‹ã€‚ï¼ˆã“ã®æ™‚ç‚¹ã¯ã–ã£ãã‚Šï¼‰ åŸºæœ¬çš„ã«ãƒã‚°ã‚¤ãƒ³ãŒæœ€ã‚‚é‡ã„ï¼ˆå¤šãã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã¿è¾¼ã¿ã€é€ä¿¡ ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ï¼‰ã®ã§ã€ã¾ãšã¯ãƒã‚°ã‚¤ãƒ³ã®è² è·ã‚’ç›®å®‰ã«è€ƒãˆã‚‹ã€‚
taniai114 2014/02/12
ã‚²ãƒ¼ãƒ

ã‚µãƒ¼ãƒ

DB

é–‹ç™º

game

ã‚¤ãƒ³ãƒ•ãƒ©
ãƒªãƒ³ã‚¯
DBè¨è¨ˆã®é›£ã—ã•
ä»Šæ—¥ã¯å¾’ç„¶ãªã‚‹ã¾ã¾ã«DBè¨è¨ˆã«ã¤ã„ã¦æ€ã£ã¦ã„ã‚‹ã“ã¨ã‚’ä¸¦ã¹ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ ã‚ˆã†ã‚„ãWEB+DB Pressã®æ¬¡å·ã®åŽŸç¨¿ã‚’æ›¸ãçµ‚ãˆãŸã€‚2å¹´é–“ã®é€£è¼‰ã§ã‚ã‚‹ãŒã€æ¥å¹´ã¯ãƒ—ãƒ©ã‚¤ãƒ™ãƒ¼ãƒˆãŒå¿™ã—ããªã‚‹äºˆå®šãªã®ã§ã€é€£è¼‰ã¯ã“ã‚Œã«ã¦çµ‚äº†ã¨ã•ã›ã¦ã‚‚ã‚‰ã†ã¤ã‚‚ã‚Šã§ã‚ã‚‹ã€‚ ã€Œãªãœäººã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã„ã“ãªã›ãªã„ã®ã‹ã€ ã“ã®ã¨ã“ã‚åŸ·ç†ã‚„è¬›æ¼”ã‚’é€šã˜ã¦ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦èª¬æ˜Žã™ã‚‹æ©Ÿä¼šã‚’è‰²ã€…é ‚ã„ã¦ã„ã‚‹ãŒã€ãã‚Œã‚‰ã®æ´»å‹•ã®æ ¹æºã¨ãªã£ã¦ã„ã‚‹ã®ãŒã€ã“ã®ç´ æœ´ãªç–‘å•ã§ã‚ã‚‹ã€‚ãã®ç–‘å•ã‚’ãƒ‘ãƒ¯ãƒ¼ã«ã—ã¦ã“ã‚Œã¾ã§æ´»å‹•ã‚’è¡Œãªã£ã¦ããŸã€‚ ç¾æ™‚ç‚¹ã§ã®è‡ªåˆ†ã®å›žç”ã¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆãŒé›£ã—ã„ã‹ã‚‰ã€ã§ã‚ã‚‹ã€‚ã‚‚ã¡ã‚ã‚“ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ãã®ã‚‚ã®ã®é›£ã—ã•ã¨ã„ã†ã®ã‚‚ã‚ã‚‹ãŒã€ãã‚Œã‚ˆã‚Šã¯ã€Œé©åˆ‡ãªä½¿ã„åˆ†ã‘ãŒã§ãã¦ã„ãªã„ã€ã¨ã„ã†ã“ã¨ãŒå¤§ãã„ã‚ˆã†ã«æ€ã†ã€‚è¨€è‘‰ã‚’å¤‰ãˆã‚‹ã¨ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã‚’é©ç”¨ã™ã¹ããƒ‡ãƒ¼ã‚¿ã¨ãã†ã§ãªã„ãƒ‡ãƒ¼ã‚¿ã®åˆ¤æ–ãŒã§ãã¦ã„ãªã„ã‹ã‚‰DBè¨
taniai114 2013/12/27
DB

ä»•äº‹

dev

database

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

è¨è¨ˆ
ãƒªãƒ³ã‚¯
Devsã®å¸¸è˜ã€DBAã¯éžå¸¸è˜
1. MySQL Admin ãŒè¦‹ãŸ Devs ã®å¸¸è˜ã€ DBA ã¯éžå¸¸è˜ 2013/09/14 yoku0825@MyNA PHP Conference 2013 2. ï¼¼ã“ã‚“ã«ã¡ã¯ï¼ï¼ â— yoku0825 â— ã¨ã‚ã‚‹ä¼æ¥ã® DBA â— MySQL æ´ 5 å¹´ãã‚‰ã„ â— ã‚ªãƒ©ã‚¯ã‚Œãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ â— æ—¥æœ¬ MySQL ãƒ¦ãƒ¼ã‚¶ä¼š (MyNA) ã®ã‚¹ãƒ™ã‚Šæ‹…å½“ 3. ï¼¼ã—ã‚ƒã¹ã‚‹ã“ã¨ï¼ï¼ â— æ—¥å¸¸çš„ã« MySQL ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã«è§¦ã‚Œã‚‹å¤‰æ…‹ DBA ãŒãƒ•ãƒ„ãƒ¼ã® Devs ã«æŠ•ã’ãŸæ„›ã®ãƒžã‚µã‚«ãƒªé›† ( ã®ã¤ã‚‚ã‚Š ) â— ã‚¦ãƒã®é–‹ç™ºè¨€èªžã¯ PHP > Java >> Ruby ã‚‰ã—ã„ã§ã™ â— ã‚¦ãƒã§ã¯ DBA ãŒã‚µãƒ¼ãƒãƒ¼ã®æ§‹ç¯‰ã€ Devs ãŒè¨è¨ˆãƒ» ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹ç¯‰ãƒ»é‹å–¶ã€ DBA ã¯ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒˆã‚„æ”¹ å–„ææ¡ˆ ( é‹ç”¨ ) ã€ã¨ã„ã†ã‚µã‚¤ã‚¯ãƒ«ã§å›žã—ã¦ã„ã¾ã™ã€‚
taniai114 2013/09/14
php

ruby

MySQL

DB

database
ãƒªãƒ³ã‚¯
1