[B! database] foosinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

foosin id:foosin

databaseã«é–¢ã™ã‚‹foosinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ8ï¼‰
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§æ¤œç´¢ã‚’é«˜é€Ÿã«ã™ã‚‹ ã“ã“ã¾ã§ã®èª¬æ˜Žã§ãŠã‚ã‹ã‚Šã®ã‚ˆã†ã«ï¼Œä¸€èˆ¬ã«ãƒ†ãƒ¼ãƒ–ãƒ«å†…ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒãƒ‡ã‚£ã‚¹ã‚¯ä¸Šã«æ ¼ç´ã•ã‚Œã‚‹é †åºã¯ï¼Œãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿½åŠ ã™ã‚‹é †åºã‚„ãƒšãƒ¼ã‚¸ã«ç©ºããŒã‚ã‚‹ã‹ã©ã†ã‹ãªã©ã«å·¦å³ã•ã‚Œï¼Œç‰¹å®šã®ã‚ãƒ¼ã®é †ç•ªã«ä¸¦ã‚“ã§ã„ã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãã®ãŸã‚ä¾‹ãˆã°ï¼Œå¾“æ¥å“¡ãƒ†ãƒ¼ãƒ–ãƒ«ï¼ˆempï¼‰ã‹ã‚‰å¾“æ¥å“¡ç•ªå·ï¼ˆenoï¼‰ãŒ71ã§ã‚ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æŠ½å‡ºã™ã‚‹SQLæ–‡ã§ã‚ã‚‹ SELECT * FROM emp WHERE eno = 71 ã®ã‚ˆã†ãªå˜ç´”ãªæ¤œç´¢å‡¦ç†ã§ã‚‚ï¼Œãƒ†ãƒ¼ãƒ–ãƒ«å†…ã®ã™ã¹ã¦ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ä¸€ã¤ãšã¤èª¿ã¹ã¦ã„ã‹ãªãã¦ã¯ãªã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã§ã¯ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŒè†¨å¤§ãªå ´åˆã«å¤§å¤‰ãªæ™‚é–“ãŒã‹ã‹ã£ã¦ã—ã¾ã„ã¾ã™ã€‚ãã“ã§ï¼Œã“ã†ã—ãŸç‰¹å®šã®ã‚ãƒ¼ã«å¯¾ã™ã‚‹æ¤œç´¢ã‚’é«˜é€ŸåŒ–ã™ã‚‹ãŸã‚ã«ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ä»•çµ„ã¿ãŒã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆç´¢å¼•ï¼‰ã§ã™ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºæœ¬çš„ãªè€ƒãˆæ–¹ã¯ï¼Œæ›¸ç±ã®ç´¢å¼•ã¨åŒã˜ã§ã™ã€‚ä¾‹ãˆã°ï¼Œæ›¸ç±ã®ä¸ã‹ã‚‰ã€Œãƒ†ãƒ¼ãƒ–ãƒ«ã€ã¨ã„ã†ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã™ã‚‹å ´åˆï¼Œã‚
foosin 2009/08/31
ãƒªãƒ¼ãƒ•ãƒŽãƒ¼ãƒ‰

database
ãƒªãƒ³ã‚¯
tokuhirom blog
Blog Search when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: ${entry.path} [in template "__entry.ftlh" at line 3, column 25] - Reached through: #include "__entry.ftlh" [in template "entry.ftlh" at
foosin 2009/08/31
database
ãƒªãƒ³ã‚¯
ã‚·ãƒ³ã‚°ãƒ«ãƒžã‚¹ã‚¿ï¼ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒ¼ãƒ–æ§‹æˆã«èˆˆå‘³ãŒãªã„ç†ç”± - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
ã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã§å¿…è¦ãªæ›¸ãè¾¼ã¿ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒã€RDBMSãƒŽãƒ¼ãƒ‰ï¼‘åŸºã® IOPS ã® W% ã®å ´åˆã€ã‚·ãƒ³ã‚°ãƒ«ãƒžã‚¹ã‚¿+ã‚¹ãƒ¬ãƒ¼ãƒ–nå°æ§‹æˆã®ã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¯ã€ æ›¸ãè¾¼ã¿ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹: W èªã¿è¾¼ã¿ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹: R=(1-w)*(n+1) ã«ãªã‚‹ã€‚ã“ã® n=R/(1-w)-1 ã£ã¦ w ãŒå¢—åŠ ã™ã‚‹ã¨ã‚¹ãƒ¬ãƒ¼ãƒ–å¢—è¨ã®ãƒ¡ãƒªãƒƒãƒˆãŒåŠ é€Ÿåº¦çš„ã«å¤±ã‚ã‚Œã¦ã„ãç‚¹ãŒã‚¤ãƒ¤ã€‚ ä¾‹ãˆã°ã€ã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã§è¦æ±‚ã•ã‚Œã‚‹æ›¸ãè¾¼ã¿ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒ W=0.3 ã§ã€èªã¿è¾¼ã¿ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒ 3 ãªã‚‰ã°ã€ã‚·ãƒ³ã‚°ãƒ«ãƒžã‚¹ã‚¿ï¼ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒ¼ãƒ–æ§‹æˆã§å¿…è¦ãªãƒŽãƒ¼ãƒ‰æ•°ã¯5å°ã€‚ãƒžãƒ«ãƒãƒžã‚¹ã‚¿æ§‹æˆã‚’æŽ¡ã£ãŸå ´åˆã§ã‚‚ç†æƒ³å€¤ã¯4å°ãªã®ã§ã€ãã†éœè‰²ãŒã‚ã‚‹ã‚ã‘ã§ã¯ãªã„ã€‚ ã—ã‹ã—ã€ä»®ã«å¿…è¦ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒï¼’å€ (W=0.6, R=6) ã«ãªã‚‹ã¨ã€å¿…è¦ãƒŽãƒ¼ãƒ‰æ•°ã¯ãƒžãƒ«ãƒãƒžã‚¹ã‚¿æ§‹æˆã§ã®8å°ã«å¯¾ã—ã€ã‚·ãƒ³ã‚°ãƒ«ãƒžã‚¹ã‚¿ï¼ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒ¼ãƒ–æ§‹æˆã§ã¯16å°ã¨ã€ä¸€æ°—ã«ã‚³ã‚¹
foosin 2009/08/11
database
ãƒªãƒ³ã‚¯
Sequel: The Database Toolkit for Ruby
Ruby Sequel is a lightweight database toolkit for Ruby.Sequel provides thread safety, connection pooling and a concise DSL for constructing database queries and table schemas. Sequel also includes a lightweight but comprehensive ORM layer for mapping records to Ruby objects and handling associated records. Sequel supports advanced database features such as prepared statements, bound variables, mas
foosin 2009/06/09
Sequel

ruby

database
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç”¨ã„ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã«ã¤ã„ã¦ - LukeSilviaâ€™s diary
Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã¯åˆ‡ã£ã¦ã‚‚åˆ‡ã‚Œãªã„ã‚»ãƒƒã‚·ãƒ§ãƒ³æ©Ÿæ§‹ã€‚DB ãƒ™ãƒ¼ã‚¹ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ç®¡ç†ã‚’è¡Œãªã£ã¦å¾—ã‚‰ã‚ŒãŸçŸ¥è¦‹ã¨ã€ãã‚Œã‚’å…ƒã«è€ƒå¯Ÿã—ãŸçµæžœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã®ç‰¹æ€§ DB ã§ç®¡ç†ã•ã‚Œã‚‹ä»–ã®ãƒ‡ãƒ¼ã‚¿ã«æ¯”ã¹ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã¯ã‹ãªã‚Šç‰¹æ®Šã§ã™ã€‚ä¸»ãªç‰¹å¾´ã¯æ¬¡ã®ã‚ˆã†ãªæ„Ÿã˜ã€‚ ãƒ‡ãƒ¼ã‚¿ãŒå¢—åŠ ã™ã‚‹ã®ãŒé€Ÿã„ å®šæœŸçš„ãªå‰Šé™¤ãŒå¿…è¦ é »ç¹ã«æ›´æ–°ã•ã‚Œã‚‹ ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ¯Žã«èªã¿ã«è¡Œãå¿…è¦ãŒã‚ã‚‹ ã“ã®ãƒ‡ãƒ¼ã‚¿ã‚’èªã‚ãªã„ã¨ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å…¨ä½“ã«ã‚¢ã‚¯ã‚»ã‚¹ã§ããªã„ ã‚¢ã‚¯ã‚»ã‚¹é »åº¦ãŒé«˜ã„ã¨ã„ã†ã“ã¨ã§ã™ã€‚ã‚ã¨ã€1ã¤ç›®ã®ç‰¹å¾´ã‹ã‚‰ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã¯æ„è˜çš„ã«ç®¡ç†ã—ã¦ã‚„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ç¾åœ¨ã®ç’°å¢ƒ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é ˜åŸŸãŒå°‘ã—ç‰¹æ®Šã§ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ãŒã‚„ãŸã‚‰ãŸã¾ã‚Šã¾ã™(ãƒ¦ãƒ¼ã‚¶æ•°ä½•ç™¾ä¸‡ã®ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ãã†ã„ã†ã®ã§ã¯ãªã„ã§ã™)ã€‚ RDBMS MySQL 4.0.22 ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ InnoDB ãƒ¬ã‚³ãƒ¼ãƒ‰æ•° 6åƒä¸‡ ãƒ†ãƒ¼ã‚¿ã‚µ
foosin 2009/05/24
mysql

database
ãƒªãƒ³ã‚¯
ALTER TABLEã‚’ä¸Šæ‰‹ã«ä½¿ã„ã“ãªãã†ã€‚
ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’å¤‰æ›´ã—ãŸã„ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒå£Šã‚Œã¦ã—ã¾ã£ãŸã®ã§å†ä½œæˆã—ãŸã„ã€‚ãã‚“ãªå ´åˆã¯ALTER TABLEã‚’ä½¿ã†ã€‚ALTER TABLEã¯ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’å¤‰æ›´ã™ã‚‹ãŠé¦´æŸ“ã¿ã®ã‚³ãƒžãƒ³ãƒ‰ã§ã‚ã‚‹ãŒã€ãã®æŒ™å‹•ã¯æ„å¤–ã¨çŸ¥ã‚‰ã‚Œã¦ã„ãªã„ã€‚ï¼ˆã‚¨ã‚ã‚¹ãƒ‘ãƒ¼ãƒˆã¨ãŠã¼ã—ãæ–¹ã€…ã‹ã‚‰ã‚‚åº¦ã€…è³ªå•ã‚’å—ã‘ã‚‹ã€‚ï¼‰ãã‚“ãªã‚ã‘ã§ã€ä»Šæ—¥ã¯ALTER TABLEã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€‚ ã¾ãšçµè«–ã‹ã‚‰è¨€ã†ã¨ã€ãªã‚“ã¨MySQLã®ALTER TABLEã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’å…¨ã¦ã‚³ãƒ”ãƒ¼ã—ç›´ã™ã®ã§ã‚ã‚‹ã€‚ãªã‚“ã¦ç„¡é§„ãªã“ã¨ã‚’ï¼ï¼Ÿã¨æ€ã†ã‹ã‚‚çŸ¥ã‚Œãªã„ãŒã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ï¼ˆã‚¹ã‚ãƒ¼ãƒžï¼‰ã®å¤‰æ›´ã‚’å‹•çš„ã«è¡Œã†ã«ã¯ã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã‚ˆã‚‹ã‚µãƒãƒ¼ãƒˆãŒå¿…è¦ã§ã‚ã‚Šã€å‹•çš„ãªã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯ã¾ã å°‘ãªã„ã®ã§ã‚ã‚‹ã€‚ï¼ˆå‹•çš„ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã¯MySQL Clusterãã‚‰ã„ã ã€‚ã—ã‹ã‚‚è¿½åŠ ã ã‘ã€‚ï¼‰ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§åˆ©ç”¨å‡ºæ¥ã‚‹MyISAMã¯Inn
foosin 2009/05/11
database
ãƒªãƒ³ã‚¯
é«˜é€ŸSSDã®è½ã¨ã—ç©´ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§åˆ©ç”¨ã™ã‚‹ã¨ãã¯ã”æ³¨æ„ã‚’ï¼
ä»Šå¹´ã¯SSDã®å°é ãŒã‚ã–ã¾ã—ã„ã€‚ä¾¡æ ¼ã®ä½Žä¸‹ã€å¤§å®¹é‡åŒ–ã€ãã—ã¦é«˜é€ŸåŒ–ã€ã•ã‚‰ã«ã¯ä½Žé›»åŠ›åŒ–ã¾ã§æœŸå¾…ã§ãã‚‹ã¨ã„ã†ã‹ã‚‰ã‚‚ã†HDDã®å‡ºç•ªã¯ãªããªã‚‹ã‚“ã˜ã‚ƒãªã„ã ã‚ã†ã‹ã¨ã„ã†ãã‚‰ã„ã®å‹¢ã„ã§ã‚ã‚‹ã€‚ã—ã‹ã—ãã‚“ãªSSDã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§åˆ©ç”¨ã™ã‚‹æ™‚ã«ã¯æ°—ã‚’ã¤ã‘ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ MySQL Performance Blogã§ã‚¤ãƒ³ãƒ†ãƒ«è£½SSDã‚’ä½¿ã£ã¦æ¤œè¨¼ã—ãŸçµæžœãŒãƒ¬ãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã€‚ ã‚¤ãƒ³ãƒ†ãƒ«è£½SSDã¯ã‚ã£ã½ã†æ—©ã„ã€‚å½¼ã‚‰ã®ãƒ†ã‚¹ãƒˆã§ã¯ä¸€ç§’é–“ã«5250å›žã‚‚ã®æ›¸ãè¾¼ã¿ãŒå‡ºæ¥ãŸãã†ã ã€‚ã—ã‹ã—ãã‚Œã¯ãƒ©ã‚¤ãƒˆãƒãƒƒã‚¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæœ‰åŠ¹ã«ãªã£ã¦ã„ã‚‹ã¨ãã®è©±ã§ã‚ã£ã¦ã€ãƒ©ã‚¤ãƒˆãƒãƒƒã‚¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ç„¡åŠ¹ã«ã™ã‚‹ã¨æ›¸ãè¾¼ã¿ã¯ç§’é–“1200å›žã¾ã§ä½Žä¸‹ã—ãŸã‚‰ã—ã„ã€‚ï¼ˆãã‚Œã§ã‚‚é«˜é€Ÿã ãŒã€‚ï¼‰ ã§ã€ã“ã®ã‚¤ãƒ³ãƒ†ãƒ«è£½SSDã®ãƒ©ã‚¤ãƒˆãƒãƒƒã‚¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯ãã›è€…ã§ã€ãƒãƒƒãƒ†ãƒªãƒ¼ç‰ã§ä¿è·ã•ã‚Œã¦ã„ãªã„ã€‚ã¤ã¾ã‚Šã€ãƒ©ã‚¤ãƒˆãƒãƒƒã‚¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ã«ãƒ€ãƒ¼ãƒ†ã‚£ãªï¼ˆã¾ã ãƒ‡ã‚£ã‚¹ã‚¯ã¸ã®æ›¸ãå‡ºã—ãŒå®Œäº†ã—ã¦ã„ãªã„
foosin 2009/03/27
ssd

database
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
foosin 2008/12/25
database
ãƒªãƒ³ã‚¯
1