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

kopug id:kopug

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

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

4ã‚¹ãƒ†ãƒƒãƒ—ã§ä½œæˆã™ã‚‹ã€DBè«–ç†è¨è¨ˆã®æ‰‹é †ã¨ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆã¾ã¨ã‚ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã¯ã˜ã‚ã« ã€Œé”äººã«å¦ã¶DBè¨è¨ˆã€ã€ã€ŒSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã€ã‚’èªã‚“ã ã®ã§DBè¨è¨ˆã‚’ã™ã‚‹æµã‚Œã¨ãã®éŽç¨‹ã§ã®ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ä»Šå›žã¯æœ¬ã«è¼‰ã£ã¦ã„ã‚‹ã‚‚ã®ã®ä¸ã§ã‚‚ç‰¹ã«é‡è¦ãã†ãªéƒ¨åˆ†ã«çµžã£ã¦ã¿ã¾ã—ãŸã€‚ ã•ã‚‰ã«è©³ã—ã„ã“ã¨ã‚’çŸ¥ã‚ŠãŸã„æ–¹ã¯æœ¬ã‚’è³¼å…¥ã—ã¦ã¿ã¦ãã ã•ã„ã€‚å€‹äººçš„ã«ã¯é”äººã«å¦ã¶DBè¨è¨ˆå¾¹åº•æŒ‡å—æ›¸ã®ã»ã†ãŒãŠã™ã™ã‚ã§ã™ã€‚ã“ã¡ã‚‰ã ã‘ã‚ã‚Œã°ååˆ†ã ã¨æ€ã„ã¾ã™ã€‚ DBè¨è¨ˆã«ã¯å¤§ããåˆ†ã‘ã¦è«–ç†è¨è¨ˆã¨ç‰©ç†è¨è¨ˆã®äºŒã¤ãŒã‚ã‚Šã¾ã™ãŒã€ä»Šå›žã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã§ãƒ¡ã‚¤ãƒ³ã¨ãªã‚‹è«–ç†è¨è¨ˆã®éƒ¨åˆ†ã«ç„¦ç‚¹ã‚’ã‚ã¦ã¦èª¬æ˜Žã‚’ã—ã¾ã™ã€‚ ä¸€ç•ªæœ€å¾Œã«ãƒã‚§ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆã ã‘ã‚’ã¾
kopug 2016/11/01
DB

SQL

design
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä»•çµ„ã¿ (1/3) | POSTD
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒè©±é¡Œã«æŒ™ãŒã‚‹ã¨ãã€ç§ã¯ä½•ã‹ãŒè¶³ã‚Šãªã„ã¨æ€ã‚ãšã«ã¯ã„ã‚‰ã‚Œã¾ã›ã‚“ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚ã‚‰ã‚†ã‚‹ã¨ã“ã‚ã§ä½¿ã‚ã‚Œã¦ãŠã‚Šã€ãã®ç¨®é¡žã‚‚ã€å°è¦æ¨¡ã§ä¾¿åˆ©ãªSQLiteã‹ã‚‰ãƒ‘ãƒ¯ãƒ•ãƒ«ãªTeradataã¾ã§æ§˜ã€…ã§ã™ã€‚ã—ã‹ã—ã€ãã‚ŒãŒã©ã†ã„ã†ä»•çµ„ã¿ã§æ©Ÿèƒ½ã—ã¦ã„ã‚‹ã‹ã‚’èª¬æ˜Žã—ãŸã‚‚ã®ã¨ãªã‚‹ã¨ã€ãã®æ•°ã¯ã”ãã‚ãšã‹ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ä¾‹ãˆã°ã€Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ä»•çµ„ã¿ã€ãªã©ã§æ¤œç´¢ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ãƒ’ãƒƒãƒˆæ•°ã®å°‘ãªã•ã‚’å®Ÿæ„Ÿã§ãã‚‹ã¨æ€ã„ã¾ã™ã€‚ã•ã‚‰ã«ãã‚Œã‚‰ã®è¨˜äº‹ã¯çŸã„ã‚‚ã®ãŒã»ã¨ã‚“ã©ã§ã™ã€‚é€†ã«ã€è¿‘å¹´æµè¡Œã—ã¦ã„ã‚‹æŠ€è¡“ï¼ˆãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã€NoSQLã€JavaScriptãªã©ï¼‰ã‚’æ¤œç´¢ã—ãŸå ´åˆã€ãã‚Œã‚‰ã®æ©Ÿèƒ½ã‚’è©³ã—ãèª¬æ˜Žã—ãŸè¨˜äº‹ã¯ãŸãã•ã‚“è¦‹ã¤ã‹ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ã‚‚ã¯ã‚„å¤§å¦ã®æŽˆæ¥ã‚„ç ”ç©¶è«–æ–‡ã€å°‚é–€æ›¸ãªã©ã§ã—ã‹æ‰±ã‚ã‚Œãªã„ã‚ˆã†ãªå¤ãã¦é€€å±ˆãªæŠ€è¡“ãªã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ç§ã¯é–‹ç™ºè€…ã¨ã—ã¦ã€ç†è§£ã—ã¦ã„ãªã„ã‚‚ã®ã‚’
kopug 2015/09/16
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ä»•çµ„ã¿

æŠ€è¡“

DB
ãƒªãƒ³ã‚¯
MySQL äº’æ›ã®DBã€Percona Server ã‚’ä½¿ã†ç†ç”± - Qiita
# Time: 120114 6:34:33 # User@Host: user[user] @ [10.10.10.10] # Thread_id: 28313080 Schema: mydb Last_errno: 0 Killed: 0 # Query_time: 0.588882 Lock_time: 0.000068 Rows_sent: 3 Rows_examined: 183839 Rows_affected: 0 Rows_read: 100 # Bytes_sent: 121 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 /+ Percona Server ç‹¬è‡ªã®ãƒã‚° +/ # InnoDB_trx_id: 9903E4DB1 # QC_Hit: No Full_scan: No Full_join: No Tmp
kopug 2015/06/10
MySQL

percona

DB
ãƒªãƒ³ã‚¯
AWS News Blog
AWS Weekly Roundup â€“ AWS AppSync, AWS CodePipeline, Events and More â€“ August 21, 2023 In a few days, I will board a plane towards the south. My tour around Latin America starts. But I wonâ€™t be alone in this adventure, you can find some other News Blog authors, like Jeff or Seb, speaking at AWS Community Days and local events in Peru, Argentina, Chile, and Uruguay. If you see [â€¦] New â€“ Amazon EC2 H
kopug 2014/05/29
DB

aws

rds
ãƒªãƒ³ã‚¯
ã€Žã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã«ãŠã‘ã‚‹DBæ§‹æˆ&å¯¾å¿œè¨˜ã€
2ãƒ¶æœˆå‰ã«ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ã¨ã‚¦ã‚£ãƒ«ã‚¹æ€§èƒƒè…¸ç‚Žã§ã²ã©ããƒ€ãƒ¡ãƒ¼ã‚¸ã‚’å—ã‘ãŸå¢—ç”°(@masudaK)ã§ã™ã€‚ã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã¯2009å¹´2æœˆã«å§‹ã¾ã£ãŸã‚µãƒ¼ãƒ“ã‚¹ã§ã€FLASHãƒ»Javaã§ä½œã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ãã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã«MySQLã‚’ç”¨ã„ã¦ã¾ã™ã€‚æœ¬è¨˜äº‹ã§ã¯ã€ã‚ãŸãã—ãŒ2å¹´ã»ã©è¦‹ç¶šã‘ã¦ã„ã‚‹ã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã®DBç’°å¢ƒã«ã¤ã„ã¦æ§‹æˆã‚„ã€æ—¥ã€…ã©ã®ã‚ˆã†ã«ã—ã¦å•é¡Œã¨å‘ãåˆã£ã¦ã„ã‚‹ã‹ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ã‚¤ãƒ³ãƒ•ãƒ©å¯„ã‚Šã®å†…å®¹ãŒå¤šã„ãŸã‚ã€ã‚¢ãƒ—ãƒªå¯„ã‚Šã®è©±ã¯å¼Šç¤¾ç”Ÿæ²¼ã®è³‡æ–™ã‚’å¾¡è¦§ãã ã•ã„ã€‚ 1. æ§‹æˆã¨è¦æ¨¡ 1.1. æ§‹æˆ ã¾ãšæ§‹æˆã§ã™ãŒã€èªã¿æ›¸ãã¯ã™ã¹ã¦ãƒžã‚¹ã‚¿ãƒ¼ã¸è¡Œã†ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã¯å‚ç…§ã‚’å‘ã‘ãšã€ãƒ›ãƒƒãƒˆã‚¹ã‚¿ãƒ³ãƒã‚¤ã¨ã—ã¦ä½¿ã£ã¦ã„ã¾ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«é–¢ã—ã¦ã¯2012å¹´ä¸æ—¬ã¾ã§ã¯5.0ã‚’ä½¿ã£ã¦ã¾ã—ãŸãŒã€DCç§»è»¢ã«ã‚ã‚ã›ã¦5.5ã«ã‚ã’ã¾ã—ãŸã€‚ãƒãƒƒã‚¯æ©Ÿèƒ½ã‚’ç”¨ã„ãŸã‚·ãƒ£ãƒ¼ãƒ‰æ§‹æˆã‚’ã—ã¦ã¾ã—ã¦ã€2014å¹´3æœˆç¾åœ¨6ã‚·ãƒ£ãƒ¼ãƒ‰ã«ãª
kopug 2014/05/22
DB

mysql
ãƒªãƒ³ã‚¯
Cassandraå…¥é–€ã¨ã€ã•ã‚‰ã«è©³ã—ãçŸ¥ã‚‹ãŸã‚ã®ãƒªã‚½ãƒ¼ã‚¹é›†
ã‚¯ãƒ©ã‚¦ãƒ‰æ™‚ä»£ã®æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€éžãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãªæ§‹é€ ã‚’æŒã¤NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒè©±é¡Œã«ãªã£ã¦ã„ã¾ã™ï¼ˆNoSQLï¼Not Only SQLã€‚å‘½åã®çµŒç·¯ã¯ã“ã¡ã‚‰ï¼‰ã€‚ãã®NoSQLã®ä¸ã§ã€ã‚‚ã£ã¨ã‚‚æ³¨ç›®ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®1ã¤ãŒApacheã®Cassandraã§ã™ã€‚ Cassandraã¯ã€Facebookã§å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®ãŸã‚ã«é–‹ç™ºã•ã‚Œã€ãã®å¾Œã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ãªã‚Šã€ç¾åœ¨ã§ã¯Apache Software Foundationã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã¨ã—ã¦é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ ç¾åœ¨ã€Cassandraã¯Facebookã‚„Diggãªã©ã§ä½¿ã‚ã‚Œã¦ã„ã‚‹ã€ã‚‚ã—ãã¯ä½¿ã†ã“ã¨ãŒæ¤œè¨Žã•ã‚Œã¦ã„ã‚‹ã¨ã•ã‚Œã€Twitterã§ã‚‚ï¼ˆãƒ„ã‚¤ãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã«ã¯ä½¿ã‚ã‚Œãªã„ã‚ˆã†ã§ã™ãŒã€ãã‚Œä»¥å¤–ã®ç”¨é€”ã§ï¼‰åˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ Twitterã¨DiggãŒNoSQLã®ã€ŒCassandraã€ã‚’é¸ã¶ç†ç”± TwitterãŒã€Cassandr
kopug 2010/07/29
db

nosql
ãƒªãƒ³ã‚¯
ç¬¬1å›žã€€NoSQLã€ãã—ã¦Cassandraã¨ã¯ | gihyo.jp
NoSQLãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã®ç‰¹å¾´ã‚’ã‚‚ã†å°‘ã—ç´°ã‹ãæŒ™ã’ã¦ã¿ã¾ã™ã€‚åˆ†é‡ã®éƒ½åˆã‚‚ã‚ã‚Šå€‹åˆ¥ã«ã¯è§¦ã‚Œã¾ã›ã‚“ãŒã€ãã‚Œãžã‚Œã®NoSQLãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã§å·®åˆ¥åŒ–éƒ¨åˆ†ã«é–¢ã—ã¦ã¯ã‹ãªã‚Šè©³ç´°ã«èª¬æ˜ŽãŒã•ã‚Œã¦ã„ã¾ã™ã®ã§ã€ãœã²ãã¡ã‚‰ã‚’å‚ç…§ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ é«˜é€Ÿã«å‹•ä½œã™ã‚‹ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ¢ãƒ‡ãƒ«ã§ã¯ãªã„ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ« ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆåž‹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ ã‚³ãƒ¢ãƒ‡ã‚£ãƒ†ã‚£ã‚µãƒ¼ãƒã«ã‚ˆã£ã¦æ§‹ç¯‰ã•ã‚Œã‚‹ ã‚¹ã‚ãƒ¼ãƒžãƒ•ãƒªãƒ¼ SPOFï¼ˆå˜ä¸€æ•…éšœç‚¹ï¼‰ã‚’æŒãŸãªã„ è‡ªå‹•çš„ã«è¤‡æ•°å°ã¸ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã™ã‚‹ ã‚¤ãƒ™ãƒ³ãƒãƒ¥ã‚¢ãƒ«ã‚³ãƒ³ã‚·ã‚¹ãƒ†ãƒ³ã‚·ã¾ãŸã¯ä¸€è²«æ€§ã®é¸æŠžãŒå¯èƒ½ SQLã®ã‚ˆã†ãªå¼·åŠ›ãªã‚¯ã‚¨ãƒªè¨€èªžã‚’æŒãŸãšã€ã‚·ãƒ³ãƒ—ãƒ«ãªå•ã„åˆã‚ã›ã—ã‹ã§ããªã„ Cassandraã¨ã¯ä½•ã‹ NoSQLãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã®ç†é ã¨ã„ãˆã°Google BigTableã‚„Amazon Dynamoã§ã™ãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ä¸–ç•Œã§ã‚‚ã„ã‚ã„ã‚ãªã‚‚ã®ãŒå‡ºã¦ãã¦ã„ã¾ã™ã€‚ãã®ä¸ã§ã‚‚æœ€è¿‘ç‰¹ã«æ³¨ç›®ã‚’é›†ã‚ã¦ã„ã‚‹ã®ãŒã€Apach
kopug 2010/04/27
nosql

db
ãƒªãƒ³ã‚¯
mixi Engineersâ€™ Blog Â» Tokyo Tyrantã«ã‚ˆã‚‹è€é«˜è² è·DBã®æ§‹ç¯‰
é€£ä¼‘ä¸ã¯Wiiã®ãƒžãƒªã‚ªã‚«ãƒ¼ãƒˆã‚’ã‚„ã‚Šã¾ãã£ã¦ã‚„ã£ã¨VR7000è¶ŠãˆãŸmikioã§ã™ã€‚æ„›è»Šã¯ãƒžãƒƒãƒãƒ»ãƒã‚¤ã‚¯ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ã‚»ãƒ—ã‚¿ãƒ¼ã§ã™ã€‚ã•ã¦ä»Šå›žã¯ã€åˆ†æ•£ãƒãƒƒã‚·ãƒ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒTokyo Tyrantã§mixiã®æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã‚’ç®¡ç†ã™ã‚‹ã‚ˆã†ã«ã—ãŸæ™‚ã®è‹¦åŠ´è©±ã‚’æ›¸ãã¾ã™ã€‚ ãƒã‚°ã‚¤ãƒ³å‡¦ç†ã¯è² è·åœ°ç„ mixiã§ã¯ã€å…¨ã¦ã®ãƒ¦ãƒ¼ã‚¶ã«ã¤ã„ã¦ã€å„ã€…ã®æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã‚’ç®¡ç†ã—ã¦ã„ã¾ã™ã€‚ã€Œãƒžã‚¤ãƒŸã‚¯ã‚·ã‚£ä¸€è¦§ã€ã‚„ã€ŒãŠæ°—ã«å…¥ã‚Šã€ãªã©ã®ç”»é¢ã§ã€å‹äººãŒè¿‘ã„æ™‚é–“ã«ãƒã‚°ã‚¤ãƒ³ã—ã¦ã„ã¦ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã¨ã‚Šã‚„ã™ã„çŠ¶æ…‹ã«ã‚ã‚‹ã‹ã©ã†ã‹ç¢ºèªã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã§ã™ã€‚ mixiã®ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã¯ãƒã‚°ã‚¤ãƒ³ã—ãªã„ã¨è¦‹ã‚‰ã‚Œãªã„ãƒšãƒ¼ã‚¸ãªã®ã§ã€ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹ãŸã³ã«ãƒã‚°ã‚¤ãƒ³ç¢ºèªãŒè¡Œã‚ã‚Œã¾ã™ã€‚ã—ãŸãŒã£ã¦ã€æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã¯ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹åº¦ã«æ›´æ–°ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚mixiã®ä¸ã§æœ€ã‚‚é‡ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã²ã¨ã¤ã¨ã—ã¦ã€Œ
kopug 2008/05/08
programming

memcached

DB

tips
ãƒªãƒ³ã‚¯
1