[B! db] snomofã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

snomof id:snomof

dbã«é–¢ã™ã‚‹snomofã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (18)

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

ã€Žå¤¢ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼Ÿã€ŒCloud Spannerã€ã®å®ŸåŠ›ã¯ï¼Ÿã€ã«ã¤ã„ã¦ - Software Transactional Memo
ã“ã‚“ãªè¨˜äº‹ãŒç›®ã«å…¥ã£ãŸã€‚ www.itmedia.co.jp å¤§é›‘æŠŠã«å®Œå…¨ã«é–“é•ã£ãŸã“ã¨ã‚’è¨€ã£ã¦ã„ã‚‹ã‚ã‘ã§ã‚‚ãªã„ãŒã€èªã‚“ã§ã„ãã¨ã„ã‚ã„ã‚é¼»ã«ã¤ãã¨ã“ã‚ãŒã‚ã‚Šã€ã©ã®ã‚ãŸã‚Šã‹ã‚‰é–“é•ã£ã¦ã„ã‚‹ã®ã‹ã¨è‡ªåˆ†ã«å•ã„ãŸã ã™ã®ã¯ç¾æ™‚ç‚¹ã§ã®è‡ªåˆ†ã®çŸ¥è˜ã‚’æ£šå¸ã—ã™ã‚‹ãŸã‚ã«ã‚‚æœ‰ç”¨ã‹ã‚‚çŸ¥ã‚Œãªã„ã¨æ€ã£ãŸã®ã§ä¸€è¨€ä¸€å¥æ¼ã‚‰ã•ãšæ€ã†ã¨ã“ã‚ã‚’æ›¸ã„ã¦ã„ã“ã†ã¨æ€ã†ã€‚ ä¸ã«ã¯æžè‘‰æœ«ç¯€ãªé›£ç™–ã‚‚ã‚ã‚‹ã®ã§å…¨éƒ¨ã‚’çœŸã«å—ã‘ãªã„æ„Ÿã˜ã§èªã‚“ã§æ¬²ã—ã„ã€‚ Cloud Spannerã®ç‰¹å¾´ã¯ã€ã“ã‚Œã¾ã§ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ä¸å¯èƒ½ã¨ã•ã‚Œã¦ã„ãŸã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã®å¤§è¦æ¨¡åˆ†æ•£å‡¦ç†ã€ã‚’å®Ÿç¾ã—ãŸã¨ã“ã‚ã«ã‚ã‚Šã¾ã™ã€‚ å˜ä¸€ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã‚’åˆ†æ•£ã—ã¦å®Ÿè¡Œã—ã¦ã„ã‚‹ã‹ã¨ã„ã†ã¨ã€Spannerã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã”ã¨ã«æ‹…å½“ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒžãƒãƒ¼ã‚¸ãƒ£ãŒãã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†å…¨ä½“ã‚’å–ã‚Šä»•åˆ‡ã£ã¦è¡Œã†ä»•çµ„ã¿ã«ãªã£ã¦ã„ã‚‹ã€‚ãªã®ã§ã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ã®å¤§è¦æ¨¡åˆ†æ•£å‡¦ç†
snomof 2017/07/04
DB

database
ãƒªãƒ³ã‚¯
Railsè¤‡æ•°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–¢é€£ã®è³‡æ–™ã¾ã¨ã‚
ãŠä»•äº‹ã§ä»Šã€Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§è¤‡æ•°DATABASEã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹ç™ºã—ã¦ã„ã¦ã€ã„ã‚ã„ã‚ã¨æ‚©ã‚€ã“ã¨ãŒå¢—ãˆã¦ããŸã®ã§ã€å‹‰å¼·ã‚’å…¼ãã¦ãƒãƒƒãƒˆã«ã‚ã£ãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’åŽé›†ã—ã¦ã„ãã¤ã‹èªã¿è¾¼ã‚“ã§ã¿ã¾ã—ãŸã€‚ä¿ºå¾—è¨˜äº‹ã§ã™ã€‚ã‚ã¨ã‚‚ã—ã‚ˆã„è³‡æ–™ã¨ã‹ã‚ã‚Œã°ãœã²ã‚³ãƒ¡ãƒ³ãƒˆãã ã•ã„ï¼ ðŸŽ³ ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã«ãŠã‘ã‚‹æœ€è¿‘ã®Active Recordé‹ç”¨äº‹æƒ…ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã«ãŠã‘ã‚‹æœ€è¿‘ã®ActiveRecordé‹ç”¨äº‹æƒ… - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚° ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã¯ä½¿ã£ã¦ã„ãªã„1,500ä»¥ä¸Šã®ãƒ¢ãƒ‡ãƒ«ãŒã‚ã‚Šã€è¤‡æ•°äººãŒä½œæ¥ã—ã¦ã„ã‚‹ãŸã‚ã€äº’ã„ã®ä½œæ¥ã‚’ãƒ–ãƒãƒƒã‚¯ã—ãªã„ãŸã‚ã«ã‚‚ãƒžã‚¤ãƒ³ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã§ã®é‹ç”¨ã¯è¡Œã£ã¦ã„ãªã„ã€‚ ã‚¹ã‚ãƒ¼ãƒžç®¡ç†ãƒ„ãƒ¼ãƒ«ï¼š Ridgepolewinebarrel/ridgepole - GitHubã‚¹ã‚ãƒ¼ãƒžç®¡ç†ãƒ„ãƒ¼ãƒ«ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚«ãƒ©ãƒ ã‚’æ›¸ãè¶³ã™ã¨ã€å®Ÿéš›ã®DBã®ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã¨æ¯”è¼ƒã—ã¦ã€ å·®åˆ†ãŒã‚ã‚Œã°ãã®ã¶ã‚“
snomof 2015/03/08
rails

db
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆ
2. è‡ªå·±ç´¹ä»‹ ï® MySQL/Linuxå‘¨ã‚Šã®ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆ ï¬ 2006å¹´9æœˆã‹ã‚‰2010å¹´8æœˆã¾ã§MySQL æœ¬å®¶(MySQL/Sun/Oracle)ã§ APAC/USåœã®MySQL ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã«å¾“äº‹ ï¬ ä¸»ãªè‘—æ›¸ã«ã€Œç¾å ´ã§ä½¿ãˆã‚‹MySQLã€ã€ŒLinux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/ é‹ç”¨å…¥é–€ã€ã€ŒJavaãƒ‡ãƒ¼ã‚¿ã‚¢ã‚¯ã‚»ã‚¹å®Ÿè·µè¬›åº§ã€ ï® DeNAã§ã®ä¸»ãªå½¹å‰² ï¬ å®‰å®šåŒ–/ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹/é‹ç”¨å‘¨ã‚Šã®ä¸é•·æœŸçš„ãªæ”¹å–„æ´»å‹• ï¬ L3ã‚µãƒãƒ¼ãƒˆ/é‹ç”¨/ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚° â€“ é›£åº¦ã®é«˜ã„MySQLå‘¨ã‚Šã®å•é¡Œã®æ ¹æœ¬åŽŸå› ã®ç‰¹å®šã¨è§£æ±º ï¬ å¤šãã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆæ”¯æ´ ï¬ ç¤¾å†…å‹‰å¼·ä¼š/ãƒˆãƒ¬ãƒ¼ãƒ‹ãƒ³ã‚° â€“ MySQLã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‘¨ã‚Šã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã‚’ç¤¾å†…ã§å…±æœ‰ã—ã€ æŠ€è¡“ã‚¹ã‚ãƒ«ã‚’åº•ä¸Šã’ã™ã‚‹ ï¬ æŠ€è¡“ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚° â€“ å›½å†…å¤–ã®ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚„ã€æŠ€è¡“é›‘èªŒç‰
snomof 2014/12/04
db

dena

database
ãƒªãƒ³ã‚¯
5ç« EAV (ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ãƒ»ã‚¢ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ãƒˆãƒ»ãƒãƒªãƒ¥ãƒ¼) - Qiita
ã“ã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªã«ã¯ã€2ã¤ã®å‰ææ¡ä»¶ãŒå¿…è¦ å€¤ãŒåŒã˜åˆ—ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ã“ã¨ ä¾‹: Bugs.date_reported GROUP BY ã§æ£ç¢ºã«æ—¥ä»˜ã‚’ã‚°ãƒ«ãƒ¼ãƒ—åŒ–ã™ã‚‹ãŸã‚ã«ã€å€¤ãŒæ¯”è¼ƒã§ãã‚‹ã“ã¨ Bugs.date_reported ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆãŒæƒã£ã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚‹ EAV (ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ãƒ»ã‚¢ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ãƒˆãƒ»ãƒãƒªãƒ¥ãƒ¼) ã¨å‘¼ã°ã‚Œã‚‹ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ç”¨ã„ã¦ã„ã‚‹ã¨ã€ä¸Šè¨˜ã®å‰ææ¡ä»¶ãŒæˆç«‹ã—ãªã„å•é¡Œã«éé‡ã™ã‚‹ æ—¥ä»˜ãŒè¡Œã«ã‚ˆã£ã¦é•ã†åˆ—ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ ä¾‹: date_reported, report_date æ—¥ä»˜ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆãŒç•°ãªã‚Šã€ç°¡å˜ã«ã¯æ¯”è¼ƒã§ããªã„ 5.1 ç›®çš„: å¯å¤‰å±žæ€§ã‚’ã‚µãƒãƒ¼ãƒˆã™ã‚‹ ãƒã‚°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¾‹ Issue (å•é¡Œ) ã‚’åŸºåº•åž‹ã¨ã—ã¦ã€Bug ã¨ FeatureRequest (æ©Ÿèƒ½è¦æœ›) ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ç®¡ç†ã™ã‚‹ Issue åŸºåº•åž‹ - å…±é€šã®å±žæ€§ Date_reported:
snomof 2014/11/10
sql

db
ãƒªãƒ³ã‚¯
Zero downtime migrations: 500 million rows
Data makes things hard In this article I'm going to go over some of the tricks we use to handle large data migrations at Honeybadger. Check out the video for a quick overview. When you have a lot of data, your life gets harder. When you only have 1000 rows, you can make DB-wide changes in IRB. With millions of rows, it's not that easy. If you don't believe me, just try it. RAM will spike. Your a
snomof 2014/11/08
database

rails

migration

db
ãƒªãƒ³ã‚¯
ã‚ªãƒˆã‚³ã®ã‚½ãƒ¼ãƒˆãƒ†ã‚¯ãƒ‹ãƒƒã‚¯2008
ä»Šæ—¥ã¯ä»•äº‹ç´ã‚ã ã£ãŸã®ã§ã€ä¸€å¹´ã®ç· ã‚ããã‚Šã¨ã—ã¦MySQLã«ãŠã‘ã‚‹ã‚½ãƒ¼ãƒˆã®è©±ã§ã‚‚ã—ã‚ˆã†ã¨æ€ã†ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’åˆ©ç”¨ã—ãªã„ã‚¯ã‚¨ãƒªã§æœ€ã‚‚ã‚ˆãè¦‹ã‹ã‘ã‚‹ã‚‚ã®ã®ã²ã¨ã¤ã¯ã€ORDER BYã‚’ç”¨ã„ãŸã‚½ãƒ¼ãƒˆå‡¦ç†ã ã‚ã†ã€‚ã‚‚ã—ã€ã‚½ãƒ¼ãƒˆå‡¦ç†ã«ãŠã„ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ç”¨ã„ã‚‹ã“ã¨ãŒå‡ºæ¥ã‚Œã°ã€MySQLã¯çµæžœã‚’æŠ½å‡ºã—ã¦ã‹ã‚‰çµæžœè¡Œã‚’ã‚½ãƒ¼ãƒˆã™ã‚‹ã®ã§ã¯ãªãã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹é †ã«è¡Œã‚’å–ã‚Šå‡ºã›ã°è‰¯ã„ã®ã§é«˜é€Ÿã«ã‚½ãƒ¼ãƒˆå‡¦ç†ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ã€‚ç‰¹ã«ã€LIMITå¥ã‚„WHEREå¥ã‚’ç”¨ã„ã¦è¡Œã®çµžã‚Šè¾¼ã¿ã‚’è¡Œã†å ´åˆã¯åŠ¹æžœãŒçµ¶å¤§ã§ã‚ã‚‹ã€‚ã—ã‹ã—ã€ã²ã¨ãŸã³ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’åˆ©ç”¨ã§ããªã„çŠ¶æ³ã«ç›´é¢ã™ã‚‹ã¨ã€ãŸã¡ã¾ã¡ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ãŒç™ºç”Ÿã—ã¦æ€§èƒ½ãŒåŠ£åŒ–ã—ã¦ã—ã¾ã†ã€‚ ä¾‹ãˆã°ã€100ä¸‡è¡Œã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ ¼ç´ã—ãŸt1ã¨ã„ã†ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚‹ã¨ã™ã‚‹ã€‚ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ãŸå ´åˆã‚’è€ƒãˆã‚ˆã†ã€‚ mysql> SELECT col1, col2 ... colx
snomof 2014/07/28
whereã¨orderãŒæ··åœ¨ã—ã¦ã„ã‚‹æ™‚ã«è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦é€Ÿã„ã‚¯ã‚¨ãƒªã‚’ä½œã‚‹

sql

db
ãƒªãƒ³ã‚¯
PostgreSQL Index Only Scan å¥®é—˜è¨˜ ãã®3 | TECHSCORE BLOG | TECHSCORE BLOG
ã©ã†ã‚‚ã€‚æ‘ä¸Šã§ã™ã€‚ ä»Šå›žã§3å›žç›®ã®PostgreSQLã§ã™ã€‚ ä»Šã¯ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ è¿½è¨˜åž‹ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ ãƒã‚ãƒ¥ãƒ¼ãƒ Visibility Mapã€€ã€€â† å‰å›žã“ã“ã¾ã§ ãƒ—ãƒ©ãƒ³æ¼”ç®—å â† ä»Šå›žã“ã“ Index Only Scan ã§ã¯ã€Œãƒ—ãƒ©ãƒ³æ¼”ç®—åã€ã„ã£ã¦ã¿ã‚ˆã†ï¼ï¼ ãƒ—ãƒ©ãƒ³æ¼”ç®—åï¼Ÿï¼Ÿï¼Ÿ ãƒ—ãƒ©ãƒ³æ¼”ç®—åã£ã¦ã‚ã¾ã‚Šèžããªã‚Œãªã„ã§ã™ã‘ã©ã€ç°¡å˜ã«è¨€ã†ã¨ã€Œexplainã€ã—ãŸã‚‰å‡ºã¦ãã‚‹ã‚¢ãƒ¬ã§ã™ã€‚ =# explain select * from users; QUERY PLAN ------------------------------------------------------------------- Seq Scan on users (cost=0.00..385179.80 rows=10010480 width=190)
snomof 2014/04/03
postgres

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

DB

development

operation
ãƒªãƒ³ã‚¯
DBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§ã¯ãƒ‡ã‚£ã‚¹ã‚¯I/Oæ€§èƒ½ã‚’æ³¨è¦–ã™ã‚‹
DBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦ã€æ°—ã‚’é…ã‚‹ã¹ãã¨ã“ã‚ã¯æ•°å¤šãã‚ã‚Šã¾ã™ãŒã€ä¸ã§ã‚‚çœŸã£å…ˆã«è¦‹ã‚‹ã¹ãã¨ã“ã‚ã¯ãƒ‡ã‚£ã‚¹ã‚¯I/Oã§ã—ã‚‡ã†ã€‚ãªãœã‹ã¨ã„ã†ã¨ã€ãƒ¡ãƒ¢ãƒªã‚¢ã‚¯ã‚»ã‚¹ã«æ¯”ã¹ã¦HDDã®æ–¹ãŒåœ§å€’çš„ã«é…ãã€æœ€ã‚‚ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹é˜»å®³è¦å› ã«ãªã‚Šã‚„ã™ã„ãŸã‚ã§ã™ã€‚ãƒ‡ã‚£ã‚¹ã‚¯I/Oãƒãƒƒã‚¯ã®è§£æ±ºæ–¹æ³•ã‚’æŽ¢ã£ã¦ã„ãã¨ã€ã€Œãƒ†ãƒ¼ãƒ–ãƒ«/ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¨è¨ˆã‚„SQLæ–‡ã®è¦‹ç›´ã—ã€ã«è¡Œãç€ãã“ã¨ã‚‚ã¾ãŸå¤šã„ã§ã™ã€‚ã“ã‚Œã‚‰ãŒä¸é©åˆ‡ã ã¨ã€çµæžœã¨ã—ã¦å¤§é‡ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã“ã¨ã«ãªã‚Šã€ãƒ‡ã‚£ã‚¹ã‚¯I/OãŒå¤šãç™ºç”Ÿã—ã¦ã—ã¾ã†ãŸã‚ã§ã™ã€‚æ ¹æœ¬çš„ãªåŽŸå› ã¯ãƒ‡ã‚£ã‚¹ã‚¯I/Oã«ã‚ã‚Šã¾ã™(CPUãƒãƒƒã‚¯ã«ãªã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ãŒã€ãã®ä¾‹ã¯åˆ¥ã®æ©Ÿä¼šã«å–ã‚Šä¸Šã’ã¾ã™)ã€‚ ãƒ‡ã‚£ã‚¹ã‚¯I/Oã«ã¯å¤§ããåˆ†ã‘ã¦ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ã‚¢ã‚¯ã‚»ã‚¹ã¨ãƒ©ãƒ³ãƒ€ãƒ ã‚¢ã‚¯ã‚»ã‚¹ã®2ç¨®é¡žã®ã‚¢ã‚¯ã‚»ã‚¹ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚Šã¾ã™ãŒã€RDBMSã§ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚¢ã‚¯ã‚»ã‚¹ãŒä¸»ä½“ã¨ãªã‚‹ãŸã‚ã€ãƒ«ãƒ¼ãƒˆâ†’ãƒ–ãƒ©ãƒ³ãƒâ†’ãƒªãƒ¼ãƒ•â†’å®Ÿãƒ¬ã‚³ãƒ¼ãƒ‰ã¨ã„ã†çµŒè·¯ã§ã®ãƒ©ãƒ³ãƒ€ãƒ
snomof 2013/11/10
DB

performance
ãƒªãƒ³ã‚¯
Facebookã€Twitterã€PayPalã€LinkedInã®MySQLæ‹…å½“è€…ã¯ã€MySQLã‚’ã©ã†ä½¿ã„ã€ä½•ã‚’èª²é¡Œã ã¨è€ƒãˆã¦ã„ã‚‹ã‹ï½žMySQL Connect 2013
Facebookã€Twitterã€PayPalã€LinkedInã®MySQLæ‹…å½“è€…ã¯ã€MySQLã‚’ã©ã†ä½¿ã„ã€ä½•ã‚’èª²é¡Œã ã¨è€ƒãˆã¦ã„ã‚‹ã‹ï½žMySQL Connect 2013 Facebookã€Twitterã€PayPalã€LinkedInã®MySQLæ‹…å½“ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒé›†ã¾ã‚Šã€ãã‚Œãžã‚Œã®ç¤¾å†…ã®MySQLåˆ©ç”¨çŠ¶æ³ã€èª²é¡Œã€ã“ã‚Œã‹ã‚‰æœŸå¾…ã™ã‚‹æ–°æ©Ÿèƒ½ãªã©ã‚’èªžã£ãŸãƒ‘ãƒãƒ«ãƒ‡ã‚£ã‚¹ã‚«ãƒƒã‚·ãƒ§ãƒ³ãŒã€9æœˆ21æ—¥ã‹ã‚‰23æ—¥ã¾ã§ã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã§é–‹å‚¬ã•ã‚ŒãŸMySQLã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒMySQL Connectã€ã®3ç•ªç›®ã®åŸºèª¿è¬›æ¼”ã¨ã—ã¦è¡Œã‚ã‚Œã¾ã—ãŸã€‚ ä¸–ç•Œã§ã‚‚ã£ã¨ã‚‚ãƒ˜ãƒ“ãƒ¼ãªMySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨ã„ãˆã‚‹4ç¤¾ã¯ã€MySQLã«ã¤ã„ã¦ã©ã®ã‚ˆã†ãªã“ã¨ã‚’è€ƒãˆã¦ã„ã‚‹ã®ã‹ã€åŸºèª¿è¬›æ¼”ã®å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã§ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ Current MySQL Usage Models and Future Developments â”€â”€â”€â”€ ã¾ãšã¯ãã‚Œãžã‚Œã®æ‰€
snomof 2013/10/06
Twitter

Facebook

LinkedIn

PayPal

mysql

db

performance
ãƒªãƒ³ã‚¯
ç¾å ´ã§å½¹ç«‹ã¤å®Ÿè·µãƒŽã‚¦ãƒã‚¦Webé–‹ç™ºã®ã€Œã¹ã—ã€ã€Œã¹ã‹ã‚‰ãšã€ | Let's POSTGRES
ï½žæ€§èƒ½ã‚’æœ€å¤§é™ã«å¼•ãå‡ºã™ãŸã‚ã®è¨è¨ˆãƒ»é–‹ç™ºãƒ»é‹ç”¨ï½ž æ°¸å®‰ æ‚Ÿå² æœ¬è¨˜äº‹ã¯ã€æŠ€è¡“è©•è«–ç¤¾ WEB+DB PRESS Vol.63 ã§æŽ²è¼‰ã•ã‚ŒãŸã‚‚ã®ã‚’ã€è‘—è€…ã¨å‡ºç‰ˆç¤¾ã®è¨±å¯ã‚’å¾—ã¦è»¢è¼‰ã—ãŸã‚‚ã®ã§ã™ã€‚ãªãŠã€ä¸€éƒ¨ è¨˜è¿°ã«å¤‰æ›´ã®ã‚ã‚‹ç®‡æ‰€ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æŠ€è¡“ã¯é•·ã„æ´å²ã®è“„ç©ãŒã‚ã‚Šã€ãã®å®Ÿè£…ã§ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è£½å“ã¯éžå¸¸ã«è¤‡é›‘ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¨ãªã£ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚ã€æ·±ãç†è§£ã™ã‚‹ã«ã¯ãã‚Œãªã‚Šã®å¦ç¿’æœŸé–“ã¨çµŒé¨“ã‚’å¿…è¦ã¨ã—ã¾ã™ã€‚ æœ¬ç« ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸ã§ã‚‚ç‰¹ã«ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆRDBMSï¼‰ã«ã¤ã„ã¦ã€ç†è§£ã™ã‚‹ãŸã‚ã®ãƒã‚¤ãƒ³ãƒˆï¼è¦³ç‚¹ã¨ã€å…·ä½“çš„ã«é–‹ç™ºï¼é‹ç”¨æ™‚ã«æ³¨æ„ã™ã¹ãç‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç†è§£ã¯ã€Œç«‹ä½“çš„ã€ã« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æŒ™å‹•ã‚’ãã¡ã‚“ã¨ç†è§£ã™ã‚‹ãŸã‚ã«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ§‹æˆã™ã‚‹è¦ç´ ã‚’ã€Œç«‹ä½“çš„ã€ã€ã¤ã¾ã‚Šè¤‡æ•°ã®è§’åº¦ï¼è»¸ã§ç†è§£ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ å‡¦ç†ã®
snomof 2013/08/21
DB

postgresql

postgres
ãƒªãƒ³ã‚¯
Pinterestã¯ã„ã‹ã«ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨æ ¼é—˜ã—ã¦ããŸã®ã‹ï¼ˆå‰ç·¨ï¼‰ã€‚QCon Tokyo 2013
4æœˆ23æ—¥ã«éƒ½å†…ã§é–‹å‚¬ã•ã‚ŒãŸã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å‘ã‘ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒQCon Tokyo 2013ã€ã€‚æ€¥é€Ÿã«äººæ°—ã‚µã‚¤ãƒˆã¸ã¨æˆé•·ã—ãŸPinterestãŒã€ãã®è£ã§ã„ã‹ã«ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¨æ ¼é—˜ã—ã¦ããŸã®ã‹ã‚’Pinterestã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢è‡ªèº«ãŒç´¹ä»‹ã™ã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒScaling Pinterestã€ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ãã®å†…å®¹ã‚’ãƒ€ã‚¤ã‚¸ã‚§ã‚¹ãƒˆã§ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ ã¤ãã«ã‚·ã‚¹ãƒ†ãƒ ã®ã©ã“ã‹ãŒå£Šã‚Œã¦ã„ã‚‹ Pinterestã€Marty Weineræ°ã€‚ Pinterestã¯ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã®ãƒ”ãƒ³ãƒœãƒ¼ãƒ‰ã§ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒã€Œãƒœãƒ¼ãƒ‰ã€ã‚’ä½œæˆã—ã¦ã€ãã“ã«ç”»åƒãªã©å¥½ããªã‚‚ã®ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ã‚·ã‚§ã‚¢ã§ãã‚‹ã¨ã„ã†ã‚‚ã®ã€‚ã€Œãƒ”ãƒ³ã€ã²ã¨ã¤ã²ã¨ã¤ãŒç”»åƒã‚„ãƒªãƒ³ã‚¯ã«ãªã£ã¦ã„ã‚‹ã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚„ãƒœãƒ¼ãƒ‰ã‚’ãƒ•ã‚©ãƒãƒ¼ã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã—ã€å†ãƒ”ãƒ³ã—ãŸã‚Šã‚¤ã‚¤ãƒã—ãŸã‚Šã€ã‚³ãƒ¡ãƒ³ãƒˆã®å…¥åŠ›ã‚‚ã§ãã‚‹ã€‚
snomof 2013/05/14
webservice

scalability

pinterest

mysql

DB
ãƒªãƒ³ã‚¯
å‰Šé™¤ãƒ•ãƒ©ã‚°ã®ã¯ãªã—
6. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 8. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 3 honda xxx FALSE
snomof 2013/05/01
DBè¨è¨ˆã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã§å¤§å¤‰ãªæ€ã„ã‚’ã—ãªã„ã§ã‚‚è«–ç†å‰Šé™¤ã‚’ä½¿ã†ã“ã¨ãŒã§ãã‚‹æ–¹æ³•ã€‚ã‚„ã£ã±RDBã¯è¨è¨ˆãŒã—ã£ã‹ã‚Šã—ã¦ã„ã‚Œã°æ›¸ãã‚³ãƒ¼ãƒ‰ã‚‚å°‘ãªããªã‚‹ã€‚å®‰å¿ƒã§ãã‚‹

db

slideshare

PostgreSQL

RDB
ãƒªãƒ³ã‚¯
10å„„IOPSã®æ–°æŠ€è¡“ã€ŒAuto Commit Memoryã€ã«è¦‹ã‚‹ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã®å±•æœ›
å…ˆæ—¥ã€Publickeyã«ã¦"Fusion-ioã€10å„„IOPSã®æ–°æŠ€è¡“ã€ŒAuto Commit Memoryã€ç™ºè¡¨ã€‚ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãªã‚“ã¦ãƒ¬ãƒ™ãƒ«ã˜ã‚ƒãªã„ã€ãƒ‘ãƒ¼ã‚·ã‚¹ãƒ†ãƒ³ãƒˆãªãƒ¡ãƒ¢ãƒªã "ã¨ã„ã†è¨˜äº‹ãŒç´¹ä»‹ã•ã‚ŒãŸã€‚10å„„IOPSï¼ãªã‚“ã¦ã„ã†ã¨ã€æ™®æ®µITã«æºã‚ã£ã¦ã„ã‚‹äººé–“ã¨ã—ã¦ã¯ä¿¡ã˜ãŒãŸã„æ•°å—ã§ã‚ã‚Šã€æ€ã‚ãšçœ‰ã«ãŸã£ã·ã‚Šå”¾ã‚’å¡—ã£ã¦èº«æ§‹ãˆã¦ã—ã¾ã†ã€‚ãã®ä¸€æ–¹ã§ã€ã€Œã‚ã®Fusion-IOãªã‚‰ã‚„ã‚Šã‹ããªã„ã€ã¨ã„ã†æ·¡ã„æœŸå¾…ã‚‚æŠ±ã‹ãšã«ã¯å±…ã‚‰ã‚Œãªã„ã€‚è¨˜äº‹ã‚’èªã‚“ã ã¨ã“ã‚ã€æ—¢å˜ã®ioDrive2 Duoã‚’ä½¿ã„ã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§10å„„IOPSã‚’é”æˆã—ãŸã¨ã®ã“ã¨ã€‚åŒã˜ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ãªã®ã«ã„ããªã‚Šæ€§èƒ½ãŒé£›èºçš„ã«å‘ä¸Šã—ãŸï¼ã¨ã„ã†ã®ã‚‚ã«ã‚ã‹ã«ã¯ä¿¡ã˜ãŒãŸã„ã€‚ä¸€ä½“ã©ã†ã„ã†ã“ã¨ã ã‚ã†ã‹ï¼Ÿã¨è‰²ã€…è€ƒå¯Ÿã—ãŸã“ã¨ã‚’ã¾ã¨ã‚ã¦ã¿ãŸã€‚ï¼ˆã‚ãã¾ã§ã‚‚ç†è€…ã®è€ƒå¯ŸãŠã‚ˆã³æŽ¨æ¸¬ã§ã‚ã‚‹ã¨ã„ã†ç‚¹ã¯ã”ç†è§£é ‚ããŸã„ã€‚ï¼‰ ã©ã®ã‚ˆã†ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã‚ã†ã‹ï¼ŸAuto Commit M
snomof 2012/11/27
DB

Fusion-io
ãƒªãƒ³ã‚¯
waj.cc Â» Dumping triggers, routines, and tables in MySQL
snomof 2012/11/09
DB

mysql
ãƒªãƒ³ã‚¯
Transfer data between AWS RDS MySQL db's
What is the best way to transfer data out of one amazon rds mySQL instance into another aws account's RDS mySQL instance? This is for transf erring a website on Heroku to a different owner.
snomof 2012/11/06
mysql

DB

AWS

RDS
ãƒªãƒ³ã‚¯
Defining foreign key relationships for Rails' models
I have a Comment class with a :foreign_key of post_id in the Post class. class Comment < ActiveRecord::Base belongs_to :post, :class_name => "Post", :foreign_key => "post_id", :counter_cache => true belongs_to :author, :class_name => "User", :foreign_key => "author_id" end But my CreateComments migration does not define a database-level foreign key: class CreateComments < ActiveRecord::Migration d
snomof 2012/10/27
ruby

rails

DB

programming
ãƒªãƒ³ã‚¯
SQLiteã®ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã¯4567ä¸‡8000è¡Œï¼ æœ¬ä½“ã®ã‚³ãƒ¼ãƒ‰ã¯6ä¸‡7000è¡Œ
è»½é‡ãªãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦äººæ°—ã®SQLiteã€‚ãã®Webã‚µã‚¤ãƒˆã«æŽ²è¼‰ã•ã‚Œã¦ã„ã‚‹ã€ŒHow SQLite Is Testedã€ã®å†…å®¹ãŒã€æµ·å¤–ã®ãƒ—ãƒã‚°ãƒ©ãƒžãªã©ã®ã‚ã„ã ã§è©±é¡Œã«ãªã£ã¦ã„ã¾ã™ã€‚ 3æœˆã«å…¬é–‹ã•ã‚ŒãŸæœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®SQLite 3.6.23ã€‚æœ¬ä½“ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯ç´„6ä¸‡7200è¡Œï¼ˆ67.2KSLOCã€Kilo Source Lines of Codeï¼šç©ºè¡Œã‚„ã‚³ãƒ¡ãƒ³ãƒˆã‚’é™¤ã„ãŸè¡Œæ•°ï¼‰ãªã®ã«å¯¾ã—ã€ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã¯ãªã‚“ã¨4567ä¸‡8300è¡Œï¼ˆ45678.3KSLOCï¼‰ã ã¨ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã®ã§ã™ï¼ ã“ã‚Œã¯ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ãŒæœ¬ä½“ã®ç´„679å€ã‚‚ã®å¤§ãã•ã ã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ 100ï¼…ã®ãƒ–ãƒ©ãƒ³ãƒã‚«ãƒãƒ¬ãƒƒã‚¸ SQLiteã‚³ã‚¢ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ãƒ†ã‚¹ãƒˆã™ã‚‹ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã¨ã—ã¦ã€ä»¥ä¸‹ã®3ã¤ãŒç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ TCL Tests TCL Testsã¯ã‚‚ã£ã¨ã‚‚å¤ã„ãƒ†ã‚¹ãƒˆã‚³ãƒ¼ãƒ‰ã§ã€TCL scripting lang
snomof 2012/10/14
sqlite

programming

DB

test
ãƒªãƒ³ã‚¯
1