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

tiadeen2 id:tiadeen2

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

â€œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆXã®èˆžå°è£â€ã‚µãƒ¼ãƒãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã®ãƒ—ãƒãŒèªžã‚‹ã€æ•°åä¸‡äººãŒã„ã£ã—ã‚‡ã«éŠã¹ã‚‹ã‚²ãƒ¼ãƒ ãŒã§ãã‚‹ã¾ã§ã€CEDEC 2012ã€‘ - ãƒ•ã‚¡ãƒŸé€š.com
â€œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆXã®èˆžå°è£â€ã‚µãƒ¼ãƒãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã®ãƒ—ãƒãŒèªžã‚‹ã€æ•°åä¸‡äººãŒã„ã£ã—ã‚‡ã«éŠã¹ã‚‹ã‚²ãƒ¼ãƒ ãŒã§ãã‚‹ã¾ã§ã€CEDEC 2012ã€‘ æ•°åä¸‡äººã®å†’é™ºè€…ã‚’æ”¯ãˆã‚‹â€œãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰â€ã¨ã¯ 2012å¹´8æœˆ20æ—¥ï½ž22æ—¥ã€ãƒ‘ã‚·ãƒ•ã‚£ã‚³æ¨ªæµœã«ã¦é–‹å‚¬ã•ã‚Œã¦ã„ã‚‹ã€æ—¥æœ¬æœ€å¤§ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ†ã‚¤ãƒ³ãƒ¡ãƒ³ãƒˆé–‹ç™ºè€…å‘ã‘ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹â€œCEDEC2012â€ã€‚3æ—¥ç›®ã®2012å¹´8æœˆ22æ—¥ã«è¡Œã‚ã‚ŒãŸã€â€œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆXã®èˆžå°è£â€ã¨é¡Œã—ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’ãƒªãƒãƒ¼ãƒˆã—ã‚ˆã†ã€‚ éžå¸¸ã«èƒ¸èºã‚‹ã‚¿ã‚¤ãƒˆãƒ«ãŒä»˜ã‘ã‚‰ã‚ŒãŸã“ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€‚CEDECã«è¨ªã‚ŒãŸã‚¯ãƒªã‚¨ã‚¤ã‚¿ãƒ¼ãŸã¡ã®èˆˆå‘³ã‚‚é«˜ãã€ç«‹ã¡è¦‹ã©ã“ã‚ã‹ã€ä¼šå ´ã«å…¥ã‚Šãã‚‰ãªã„ã»ã©ã®å¤šãã®è´è¡†ãŒè©°ã‚ã‹ã‘ãŸã€‚ã‚¹ãƒ”ãƒ¼ã‚«ãƒ¼ã¯ã€ã‚¹ã‚¯ã‚¦ã‚§ã‚¢ãƒ»ã‚¨ãƒ‹ãƒƒã‚¯ã‚¹é–‹ç™ºéƒ¨ ãƒ—ãƒã‚°ãƒ©ãƒžã®æ£®å±±æœ‹è¼æ°ã€‚æ£®å±±æ°ã¯ã€ã€Œã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã®ãƒžãƒ‹ã‚¢ãƒƒã‚¯ãªãƒ†ãƒ¼ãƒžãªã®ã§ã€ã¾ã•ã‹ã“ã‚Œã»ã©å¤šãã®æ–¹ãŒé›†ã¾ã‚‹ã¨ã¯â€¦â€¦ã€ã¨é©šã„ãŸæ§˜åã‚’è¦‹ã›ã¤ã¤ã‚‚ã€æ¥µã‚ã¦èˆˆ
tiadeen2 2012/08/24
ãªã‚“ã‹ã€ã“ã†ã„ã†è©±ã‚’èžãã¨ã‚„ã£ã¦ã¿ãŸã„ãƒŠãƒ¼ã€‚ã§ã‚‚wiiæŒã£ã¦ãªã„ã—â€¦è²¸ã—ã¦ã£ï¼ï½—

ãƒ‰ãƒ©ã‚¯ã‚¨

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
NoSQLç™»å ´ã®èƒŒæ™¯ã€CAPå®šç†ã€ãƒ‡ãƒ¼ã‚¿ãƒ¢ãƒ‡ãƒ«ã®åˆ†é¡ž
ãã®ä¾‹ã¨ã—ã¦Beckæ°è‡ªèº«ãŒéŽåŽ»ã«å–ã‚Šçµ„ã‚“ã§ããŸç”Ÿå‘½ä¿é™ºä¼šç¤¾ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä¾‹ã«æŒ™ã’ã¾ã™ã€‚ãã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯æ¯Žæ—¥ã®ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžãŒå¤‰åŒ–ã™ã‚‹ãŸã‚ã€SQLã¨ORM(Object-Relational Mappingï¼‰ã§ã¯å¯¾å¿œã§ããšã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®Gemstoneã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã§å¯¾å¿œã§ããŸã¨è¿°ã¹ã¦ã„ã¾ã™ã€‚ ã“ã†ã—ãŸSQLã ã‘ã§ã¯æº€ãŸã›ãªã„ã•ã¾ã–ã¾ãªè¦ä»¶ã€ä¸Šè¨˜ã®å›³ã«ã‚ã‚‹ã‚ˆã†ã«ã‚¹ã‚ãƒ¼ãƒžã®å¯å¡‘æ€§ã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªãƒ‡ãƒ¼ã‚¿èªã¿è¾¼ã¿ã€æ›¸ãè¾¼ã¿ã€å‡¦ç†ã®æŸ”è»Ÿæ€§ãªã©ã‚’æº€ãŸã™ãŸã‚ã«ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä»¥å¤–ã®NoSQLãªè£½å“ãŒé–‹ç™ºã•ã‚ŒãŸã€‚ã“ã‚ŒãŒNoSQLã®ç™»å ´ã®èƒŒæ™¯ã«ã‚ã‚‹ã¨Beckæ°ã¯è§£èª¬ã—ã¾ã™ã€‚ä¸€æ–¹ã§ã€ã“ã†ã—ãŸã•ã¾ã–ã¾ãªNoSQLã‚’ã€NoSQLã¨ã„ã†è¨€è‘‰ã§è¡¨ã™ã®ã¯é©å½“ã§ã¯ãªã„ã¨ã„ã†æ†‚æ…®ã‚‚ç¤ºã—ã¦ã„ã¾ã™ã€‚ Here is where the futility of defining NoSQ
tiadeen2 2010/03/18
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ã¾ã¨ã‚

nosql
ãƒªãƒ³ã‚¯
MySQL4.0ç³»â†’MySQL5.0ç³» | feedforce Engineers' blog
MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ— MySQL 4.0 ã¾ã§ã¯ã€3.X ã‹ã‚‰ 4.0 ã« upgrade ã—ã¦ã‚‚ã€ãªã‚“ã®å½±éŸ¿ã‚‚ãªããã®ã¾ã¾å¤ã„ãƒ‡ãƒ¼ã‚¿(/var/lib/mysql)ã‚’ä½¿ãˆã¾ã—ãŸã€‚ ãƒ€ãƒ³ãƒ—â†’ãƒªã‚¹ãƒˆã‚¢ä¸è¦ã€ã€ŒALTER TABLEã€ã‚‚ä¸è¦ã€‚ 4.1 ä»¥ä¸Šã«upgradeã™ã‚‹ã¨ãã¯ã€æ—¥æœ¬èªžã‚ãƒ£ãƒ©ã‚¯ã‚¿ãƒ¼ã‚»ãƒƒãƒˆã‚’ä½¿ã£ã¦ã„ã‚‹å ´åˆã€æ³¨æ„ã—ãªãã¦ã¯ãªã‚‰ãªã„ç‚¹ãŒè¤‡æ•°å˜åœ¨ã—ã¾ã™ã€‚ 4.0â†’5.0 è¿½åŠ æ©Ÿèƒ½ è©³ç´°ï¼š http://lists.mysql.com/mysql-ja/262 http://www.klab.org/media/mysql/ - ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®Ÿè£… - ãƒˆãƒªã‚¬ãƒ¼ã‚’å®Ÿè£… - ãƒ“ãƒ¥ãƒ¼ã‚’å®Ÿè£… - ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚«ãƒ¼ã‚½ãƒ«æ©Ÿèƒ½ã‚’å®Ÿè£… - æƒ…å ±ã‚¹ã‚ãƒ¼ãƒžã‚’å®Ÿè£… - XA åˆ†æ•£ãƒ»ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®å®Ÿè£… - HEAP(MEMORY) ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã€BT
tiadeen2 2009/12/07
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
PostgreSQL ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚ - å¾’ç„¶ãªã‚‹ã¾ã¾ã«Blog
PostgreSQLã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ ãã®æ™‚ã«èª¿ã¹ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é …ç›®ã‚’å‚™å¿˜éŒ²ã¨ã—ã¦æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®é•ã„ã‚„ã‚µãƒ¼ãƒã®è¦æ¨¡ãªã©ã«ã‚ˆã£ã¦ã‚‚ åŠ¹æžœã¯å¤‰ã‚ã£ã¦ãã‚‹ã¨æ€ã†ã®ã§ã‚ãã¾ã§å‚è€ƒç¨‹åº¦ã®ã‚‚ã®ã§ã™ãŒã€‚ ãƒ»shared_buffers 7ç³»ã§ã¯8000ã€œ10000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ 8ç³»ã§ã¯150000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ã“ã¨ãŒå¯èƒ½ã€100000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ã“ã‚Œã«å¤šãå‰²ã‚Šå½“ã¦ã‚‹ã‚ˆã‚ŠOSã®ãƒãƒƒãƒ•ã‚¡é ˜åŸŸã¨ã—ã¦ä½¿ã†æ–¹ãŒæ€§èƒ½ãŒå‘ä¸Šã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã‚’å‰²ã‚Šå‡ºã—ã¦è¨å®šã™ã‚‹ã®ãŒãƒ™ã‚¹ãƒˆ ç°¡å˜ã«è¨å®šã™ã‚‹ãªã‚‰æè¼‰ãƒ¡ãƒ¢ãƒªé‡ã®1/4ã€æè¼‰ãƒ¡ãƒ¢ãƒªãŒå¤šã‘ã‚Œã°1/2ãã‚‰ã„ã§ã‚‚å¯ ãƒ»max_connections 7ç³»ã§ã¯256ç¨‹åº¦ã€8ç³»ã§ã¯1000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ãƒ»work_mem(sort_mem) é©åˆ‡ãªã‚µã‚¤ã‚ºã«èª¿æ•´ã™ã‚‹ã€2048ã€œ4096ç¨‹åº¦ ãƒ—ãƒã‚»ã‚¹æ¯Ž
tiadeen2 2007/08/02
database

postgres

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

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
1