[B! RDBMS] Ehrenã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Ehren id:Ehren

RDBMSã«é–¢ã™ã‚‹Ehrenã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (17)

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

MySQL Connector/J (JDBC ãƒ‰ãƒ©ã‚¤ãƒ)ã®ç½ ã¾ã¨ã‚ - ~saiya/hatenablog
MySQL JDBC ãƒ‰ãƒ©ã‚¤ãƒ(MySQL Connector/J)ã€Java ã§ MySQL ã¨ã„ãˆã°ã¾ãšã‚³ãƒ¬ã ãŒã€ã“ã‚Œã¾ãŸåœ°å‘³ã«ç½ ãŒå¤šã„(ãã—ã¦å¤šãã®äººãŒè¸ã‚“ã§è‹¦ã—ã‚€)ã®ã§ã¾ã¨ã‚ã¦ã¿ãŸã€‚ (2015/03/19) ã“ã¡ã‚‰ ã®ã‚³ãƒ¡ãƒ³ãƒˆæ¬„ã§ã”æŒ‡æ‘˜ãŸã ã„ãŸ wait_timeout ã®ä»¶ã«ã¤ã„ã¦è¨˜äº‹ä¿®æ£ã„ãŸã—ã¾ã—ãŸã€‚ Summary ä»¥ä¸‹ã€ã„ãšã‚Œã‚‚ãƒ—ãƒã‚°ãƒ©ãƒ è¨è¨ˆæ™‚ã«ç†è§£ã—ã¦ãŠã‹ãªã„ã¨ã€é–‹ç™ºä¸ã¯å¤§ä¸ˆå¤«ãã†ã§ã‚‚å®Ÿç”¨ã—ãŸé€”ç«¯ã«è‹¦ã—ã¾ã•ã‚Œã‚Œã¦ã—ã‹ã‚‚è¨è¨ˆã‹ã‚‰æ²»ã™ç¾½ç›®ã«ãªã‚‹è¦æ³¨æ„ãªç½ ã§ã‚ã‚‹: SELECT çµæžœã¯å…¨éƒ¨ãƒ¡ãƒ¢ãƒªã«è¼‰ã£ã¦ã—ã¾ã† (ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã§) å¤§é‡ SELECT ã™ã‚‹å ´åˆã¯ FetchSize, ResultSetType ã‚’è¦è¨å®š åˆ©ç”¨æ™‚ã«ã¯åˆ¶ç´„ãŒã‚ã‚‹ã®ã§ã€è¨è¨ˆæ®µéšŽã‹ã‚‰è€ƒæ…®ã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ (å¾Œè¿°) idle æ™‚é–“ã®ã€Œåˆè¨ˆã§ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒåˆ‡ã‚‰ã‚Œã‚‹ å‰å›žã®ã‚¯ã‚¨ãƒªå‡¦ç†ã‹ã‚‰ä¸€å®šæ™‚é–“ä»¥ä¸ŠçµŒ
Ehren 2016/04/11
RDBMS

mysql

java
ãƒªãƒ³ã‚¯
RDBã«ãŠã‘ã‚‹ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã„ã†è€ƒãˆæ–¹
RDBã®å°‚é–€å®¶ã¨ã—ã¦æ—¥ã€…æ´»å‹•ã—ã¦ã„ã‚‹ä¸ã§æ°—ã¥ã„ãŸã“ã¨ã®ã²ã¨ã¤ã«ã€ã€ŒRDBã¯ãƒ‡ãƒ¼ã‚¿ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã®å®Ÿè£…ã‚’ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«é ¼ã£ã¦ã„ã‚‹ãŒã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å…¨ã¦ã®å•é¡Œã‚’è§£æ±ºã§ãã‚‹ã»ã©ä¸‡èƒ½ã§ã¯ãªã„ã€ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã„ã†ã®ã¯ã¨ã¦ã‚‚å¼·åŠ›ãªéƒ¨å“ã§ã‚ã‚Šã€ãã®ç‚¹ã«ã¯å…¨ãç•°è«–ã¯ãªã„ã€‚ã ãŒã€ä¸–ã®ä¸ã®å…¨ã¦ã®å•é¡Œï¼ˆã‚¯ã‚¨ãƒªï¼‰ã‚’è§£æ±ºã§ãã‚‹ã»ã©ã€æŸ”è»Ÿæ€§ã«å¯Œã‚“ã ã‚‚ã®ã§ã¯ãªã„ã¨ã„ã†ã“ã¨ã ã€‚RDBã¯ã€ã©ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‹ã¨ã„ã†ã“ã¨ã‚’ã€ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã‚’ç”¨ã„ã¦åˆ¤æ–ã™ã‚‹ã€‚å¤§æŠµã®RDBè£½å“ã§ã¯ã€ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã¯ã‚ˆã„ä»•äº‹ã‚’ã™ã‚‹ã®ã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã®çµ„ã¿åˆã‚ã›ã«ã‚ˆã£ã¦ã€ã»ã¨ã‚“ã©ã®å•é¡Œã«å¯¾å¿œã§ãã‚‹ã€‚ã ãŒã€100%ã§ã¯ãªã„ã®ã§ã‚ã‚Šã€ãã®ã‚ˆã†ãªã‚±ãƒ¼ã‚¹ãŒã‚·ã‚¹ãƒ†ãƒ ã®æ€§èƒ½å•é¡Œã‚’å¼•ãèµ·ã“ã—ãŸã‚Šã€ãƒ—ãƒã‚°ãƒ©ãƒžï¼ˆã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨è¨ˆè€…ï¼‰ã«ã€NoSQLã¸å®Œå…¨ã«ç§»è¡Œã—ãŸã‚Šã€ã‚¯ã‚¨ãƒªé«˜é€ŸåŒ–ã®ãŸã‚ã«éžæ£è¦åŒ–ã‚’ã™ã‚‹ã¨è¨€ã£
Ehren 2015/06/17
RDBMS
ãƒªãƒ³ã‚¯
SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ...
A site explaining SQL indexing to developersâ€”no crap about administration. SQL indexing is the most effective tuning methodâ€”yet it is often neglected during development. Use The Index, Luke explains SQL indexing from grounds up and doesnâ€™t stop at ORM tools like Hibernate. Use The Index, Luke is the free web-edition of my book SQL Performance Explained (from Ð„9.95). Be sure to subscribe my free ne
Ehren 2013/07/29
RDBMS
ãƒªãƒ³ã‚¯
RethinkDB: the open-source database for the realtime web
RethinkDB pushes JSON to your apps in realtime. When your app polls for data, it becomes slow, unscala ble, and cumbersome to maintain. RethinkDB is the open-source, scala ble database that makes building realtime apps dramatically easier. What is RethinkDB?go
Ehren 2013/02/01
rdbms

ssd
ãƒªãƒ³ã‚¯
SQLã®ã„ã„ç‚¹ - still deeper
SQLä¸Šç´šè€…ã“ãçŸ¥ã£ã¦æ¬²ã—ã„ã€ãªãœO/Rãƒžãƒƒãƒ‘ãƒ¼ãŒé‡è¦ã‹ï¼Ÿã‚’å—ã‘ã¦ã€‚ SQLãŒDisã‚‰ã‚ŒãŸã‹ã‚‰ã£ã¦ORMã‚’Disã‚Šã‹ãˆã™ã‚ˆã‚Šã€SQLã®ã‚ˆã„ã¨ã“ã‚ã‚’ä¸»å¼µã—ã¦ã»ã—ã„ãªâ€” é€™ã„å¯„ã‚‹å‚µå‹™è€…ã‚†ã‚‹ã‚ˆã‚(æ—§æ”¯é…è€…)ã•ã‚“ (@yuroyoro) 12æœˆ 7, 2012 ã ãã†ãªã®ã§ã€‚ SQLã®ã„ã„ç‚¹ DBMSã®ãƒ•ãƒ«æ©Ÿèƒ½ãŒä½¿ãˆã‚‹ DBMSã¯è‰²ã€…ä¾¿åˆ©ãªæ©Ÿèƒ½ãŒã‚ã£ã¦SQLã‚’ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã¨ã—ã¦æä¾›ã•ã‚Œã¦ã„ã‚‹ åˆ†ã‹ã‚Šã‚„ã™ã„ã¨ã“ã‚ã ã¨ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ã‚¸ãƒ£ã¨ã‹withå¥ã¨ã‹OLAPã‚¯ã‚¨ãƒªã¨ã‹ ORMã ã¨ãã‚Œã‚‰ã®å…¨ã¦ã«ã¯å¯¾å¿œã§ããªã„ï¼ˆã¯ãšï¼‰ DBMSä¾å˜ã®æ©Ÿèƒ½ã ã¨ç‰¹ã« ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã—ã‚„ã™ã„ SQLã¯æŠ½è±¡åº¦ãŒé«˜ã„è¨€èªžã§å®Ÿéš›ã«å®Ÿè¡Œã•ã‚Œã‚‹ã®ã¯planner/optimizerã§ä½œã‚‰ã‚ŒãŸå®Ÿè¡Œè¨ˆç”»ã§ã¯ã‚ã‚‹ãŒã€SQLã‹ã‚‰ãã‚Œãªã‚Šã«ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã§ãã‚‹ ORMã®æ°—æŒã¡ãŒåˆ†ã‹ã‚‹äººãªã‚‰ORMã‹ã‚‰ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ã§ãã‚‹ã®ã‹ã‚‚ã€‚è‡ªåˆ†ã¯ç”ŸSQ
Ehren 2012/12/07
orm

rdbms
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã‚’çŸ¥ã‚‹
SQLã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã¯å¥¥ãŒæ·±ã„ã€‚ç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è¦³ç‚¹ã‹ã‚‰ã€ãã†è¨€ãˆã‚‹ã ã‚ã†ã€‚ ã¿ãªã•ã‚“ã”æ‰¿çŸ¥ã®é€šã‚Šã€åŒã˜çµæžœã‚’å‡ºã™ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚‚ã€SQLã®æ›¸ãæ–¹æ¬¡ç¬¬ã§å‡¦ç†æ™‚é–“ã«ä½•å€ã‚‚ã®å·®ãŒç”Ÿã˜å¾—ã‚‹ã€‚åŠ¹çŽ‡ã®æ‚ªã„SQLã‚’æ›¸ã„ã¦ã—ã¾ã†åŽŸå› ã¯ã€å¤šãã®å ´åˆã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã‚„ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«é–¢ã™ã‚‹ç†è§£ä¸è¶³ã§ã‚ã‚‹ã€‚ä¸¡è€…ã‚’ã‚ˆãçŸ¥ã£ãŸä¸Šã§æœ€é©ãªSQLã‚’æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã‚‹ã“ã¨ã¯ã€ã‚·ã‚¹ãƒ†ãƒ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ã®é‡è¦ãªã‚¹ã‚ãƒ«ã®ä¸€ã¤ã§ã‚ã‚‹ã€‚ ç‰¹é›†ã€ŽåŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ã€ã§ã¯ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã«ã¤ã„ã¦ã€åŸºæœ¬çš„ãªéƒ¨åˆ†ã‚’åˆ†ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ã¦ã„ã‚‹ã€‚SQLãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«å½¹ç«‹ã¤ã“ã¨ã¯ã‚‚ã¡ã‚ã‚“ã€SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆã®ãŸã‚ã®åŸºç¤ŽçŸ¥è˜ã¨ã—ã¦ã‚‚ä¸å¯æ¬ ã ã€‚ ã‚¤ãƒ³ãƒˆãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã®ã¾ã¾ã§ã„ã„ã®ï¼Ÿ Part 1ï¼šSQLæ–‡ã¯ã©ã®ã‚ˆã†ã«å®Ÿè¡Œã•ã‚Œã‚‹ã®ã‹ SQLå®Ÿè¡Œã¾ã§ã®
Ehren 2011/07/01
ã‚ã¨ã§ã˜ã£ãã‚Šèªã‚€

SQL

RDBMS
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/oracle4engineer/post/entry/post_85
Ehren 2011/06/28
oracle

RDBMS
ãƒªãƒ³ã‚¯
æ´¥å³¶åšå£«ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¬›åº§ã€€ç¬¬7å›žã€€å…±æœ‰ãƒ—ãƒ¼ãƒ«ã«ã¤ã„ã¦ | oracletech.jp
ç¬¬6å›žã‹ã‚‰å¤§åˆ†æœŸé–“ãŒç©ºã„ã¦ã—ã¾ã„ç”³ã—è¨³ã‚ã‚Šã¾ã›ã‚“ã€‚ å€‹äººçš„ãªäº‹æƒ…ã«ã‚ˆã‚Šã€åŸ·ç†ã®æ™‚é–“ãŒå–ã‚Œã¾ã›ã‚“ã§ã—ãŸã€‚ã‚„ã£ã¨è½ã¡ç€ã„ã¦ãã¾ã—ãŸã®ã§ã€ä»Šæœˆã‹ã‚‰é€£è¼‰ã‚’å†é–‹ã—ã¾ã™ã®ã§ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚ ãã‚Œã§ã¯ã€ä»Šå›žã¯ãƒ¡ãƒ¢ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ãã®ä¸ã§ã‚‚ã€æœ€ã‚‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãŒé›£ã—ã„å…±æœ‰ãƒ—ãƒ¼ãƒ«ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚æœ€è¿‘ã¯ã€ç¬¬3å›žç›®ã§ç´¹ä»‹ã—ãŸè‡ªå‹•ãƒ¡ãƒ¢ãƒªç®¡ç†ã‚„è‡ªå‹•å…±æœ‰ãƒ¡ãƒ¢ãƒªç®¡ç†ã‚’ä½¿ç”¨ã™ã‚Œã°è‡ªå‹•çš„ã«è¨å®šã—ã¦ãã‚Œã‚‹ã‹ã‚‰ã‹ã€åŸºæœ¬ãƒ¡ã‚«ãƒ‹ã‚ºãƒ ã‚’ã‚ã¾ã‚ŠçŸ¥ã‚‰ãªã„æ–¹ã‚‚å¤šã„ã‚ˆã†ã§ã™ãã€‚ Oracle Databaseã®ãƒ¡ãƒ¢ãƒªç®¡ç†ã®ä»•çµ„ã¿ã«ã¤ã„ã¦ã¯ã€ä¸‹è¨˜ã‚’å‚ç…§ãã ã•ã„ã€‚ ã‚ªãƒ©ã‚¯ãƒ«ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢é€šä¿¡ï¼šã€Œã€ã‚»ãƒŸãƒŠãƒ¼å‹•ç”»/è³‡æ–™ã€‘ä»Šã•ã‚‰èžã‘ãªã„!? Oracleå…¥é–€ ï½žã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ç·¨ï½žã€ â– 1ï¼Žå…±æœ‰ãƒ—ãƒ¼ãƒ«ã«ã¤ã„ã¦ å…ˆãšã¯å…±æœ‰ãƒ—ãƒ¼ãƒ«ã®ãƒ¡ã‚«ãƒ‹ã‚ºãƒ ã‹ã‚‰èª¬æ˜Žã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ã„ãã¤ã‹ã®ãƒˆãƒ”ãƒƒã‚¯ã¯ã”å˜çŸ¥ã§ã™ãŒã€å®Œå…¨ã«æŠŠæ¡ã§ãã¦ã„ã‚‹
Ehren 2011/06/22
oracle

RDBMS
ãƒªãƒ³ã‚¯
MySQLã¯Oracleã«æ•‘ã‚ã‚ŒãŸâ€•æ¾ä¿¡å˜‰ç¯„æ°
EnterpriseZineï¼ˆã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¸ãƒ³ï¼‰ç·¨é›†éƒ¨ã§ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“ã®æ–¹ã€…å‘ã‘ã«ã€EnterpriseZine Dayã€Security Online Dayã€DataTechã¨ã„ã†ã€3ã¤ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œç·¨é›†éƒ¨ç‹¬è‡ªã®åˆ‡ã‚Šå£ã§ã€æ¥ç•Œãƒˆãƒ¬ãƒ³ãƒ‰ã‚„æœ€æ–°äº‹ä¾‹ã‚’ç¶²ç¾…ã€‚æœ€æ–°ã®å‹•å‘ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹å ´ã¨ã—ã¦ã€å¥½è©•ã‚’å¾—ã¦ã„ã¾ã™ã€‚
Ehren 2011/05/30
RDBMS

mysql
ãƒªãƒ³ã‚¯
https://blogs.oracle.com/oracle4engineer/post/column/technical/026790.html
Ehren 2011/04/26
RDBMS

oracle
ãƒªãƒ³ã‚¯
æ´¥å³¶åšå£«ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¬›åº§ã€€ç¬¬6å›žã€€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®åŸºç¤Žã§ã‚ã‚‹ç´¢å¼•ã«ã¤ã„ã¦ | oracletech.jp
ä»Šå›žã¯ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ä¸€ç•ªå½±éŸ¿ã™ã‚‹ç´¢å¼•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã™ã‚‹ãŸã‚ã«ã¯åŠ¹çŽ‡ã‚ˆã„ç´¢å¼•ã®è¨è¨ˆã‚’è¡Œã£ã¦ä¸‹ã•ã„ã€ã¨è¨€ã‚ã‚Œã¾ã™ãŒã€å…·ä½“çš„ã«ã©ã®ã‚ˆã†ã«è¨è¨ˆã™ã‚Œã°ã‚ˆã„ã‹åˆ†ã‹ã‚‰ãªã„æ–¹ã‚‚å¤šã„ã¨æ€ã„ã¾ã™ï¼ˆå¤šãä½œæˆã™ã‚Œã°ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã«ãªã‚Šã¾ã™ã—ã€é€†ã«å¿…è¦ãªSQLæ–‡ã§ç´¢å¼•ãŒä½¿ç”¨ã•ã‚Œãªã„ã“ã¨ãŒã‚ã‚Šã¾ã™ã‚ˆãï¼‰ã€‚ãã“ã§ä»Šå›žã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŽŸç‚¹ã«æˆ»ã£ã¦ç´¢å¼•ã«ã¤ã„ã¦èª¬æ˜Žã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã®ã§ã€å‚è€ƒã«ã—ã¦ä¸‹ã•ã„ã€‚ Oracle Databaseã«ã¯ã€ã„ãã¤ã‹ã®ç´¢å¼•ã®ç¨®é¡žãŒã‚ã‚Šã¾ã™ã€‚ã“ã¡ã‚‰ã‚’æŠ¼ã•ãˆã¦ãŠãã¨ã€ã•ã‚‰ã«ç†è§£ãŒé€²ã‚€ã¨æ€ã„ã¾ã™ã€‚ ã‚ªãƒ©ã‚¯ãƒ«ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢é€šä¿¡ï¼šã€ŒOracle Databaseã®ç´¢å¼•ã®ç¨®é¡ž - Bãƒ„ãƒªãƒ¼ã€ãƒ“ãƒƒãƒˆãƒžãƒƒãƒ—ã€ç´¢å¼•æ§‹æˆè¡¨ã€ç´¢å¼•ã‚¯ãƒ©ã‚¹ã‚¿ã€ â– ï¼‘ï¼Žç´¢å¼•ã¨ã¯ å…ˆãšã¯ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«é–¢ã™ã‚‹åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ã€Œç´¢å¼•ã¨ã¯ã€ã«ã¤ã„ã¦ç°¡å˜ã«èª¬æ˜Žã—ã¾ã™ã€‚çš†ã•ã‚“ã¯å½“ç„¶ã”å˜çŸ¥ã‹ã¨æ€ã„ã¾ã™ãŒ
Ehren 2011/04/20
oracle

RDBMS

db
ãƒªãƒ³ã‚¯
Scaling an RDBMS in 6 Steps
Ehren 2011/04/19
ã‚ãƒ¼ã“ã“ã¾ã§ã‚„ã‚“ãªã„ã¨ã ã‚ã‹

RDBMS

Scale
ãƒªãƒ³ã‚¯
ã‚ãˆã¦NoSQLã§ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã«ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¢ãƒ—ãƒªã‚’ä½œã£ã¦ã¿ã‚‹ : å°é‡Žå’Œä¿Šã®ãƒ–ãƒã‚°
RDBMSã¨NoSQLã‚’å·¡ã‚‹è°è«–ã§ã„ã¤ã‚‚ç§ãŒé•å’Œæ„Ÿã‚’æ„Ÿã˜ã‚‹ã®ã¯ã€RDBMSã«å›ºåŸ·ã—ã‚ˆã†ã¨ã™ã‚‹äººã¨ã€NoSQLã«å›ºåŸ·ã—ã‚ˆã†ã¨ã™ã‚‹äººã¨ã€ãã‚Œãžã‚ŒãŒæ¥µç«¯ã«ã©ã¡ã‚‰ã‹ã‚’æ“è·ã—ã€æ¥µç«¯ã«ã©ã¡ã‚‰ã‹ã®é•·æ‰€ã‚„å¯èƒ½æ€§ã«å¯¾ã—ã¦ç›®ã‚’çž‘ã‚ã†ã¨ã—ã¦ã„ã‚‹ã‚ˆã†ã«è¦‹å—ã‘ã‚‰ã‚Œã‚‹ã“ã¨ã§ã‚ã‚‹ã€‚ ã“ã‚Œã¾ã§RDBMSã‚’æ¥å‹™ã§ä½¿ã£ã¦ããŸäººã«NoSQLã®åˆ¶ç´„ã®è©±ã‚’ã™ã‚‹ã¨ã€å¤§æŠµã®å ´åˆã€ã€Œãã‚“ãªã®ã˜ã‚ƒæ¥å‹™ã«ã¯ä½¿ãˆãªã„ã€ã¨ã„ã†åå¿œãŒè¿”ã£ã¦ãã‚‹ã€‚ç‰¹ã«å³æ™‚ä¸€è²«æ€§ãŒä¿ã¦ãªã„ã¨ã„ã†è©±ã‚’ã™ã‚‹ã¨ã€Œã¾ã£ãŸãä½¿ã„ç‰©ã«ãªã‚‰ãªã„ã€ã¨è„Šé«„åå°„çš„ã«æ‹’å¦åå¿œã‚’ç¤ºã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã€‚ ç§ãŒæ€ã†ã«ã€ã‚¯ãƒ©ã‚¦ãƒ‰ãŒã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã§æ´»ç”¨ã•ã‚Œã¦ã„ãã®ã«æ¯”ä¾‹ã—ã¦ã€ã“ã‚Œã‹ã‚‰ã¯ã€ŒRDBMSã¨NoSQLã‚’é©æé©æ‰€ã§ä½¿ã„åˆ†ã‘ã‚‹ã€ã“ã¨ãŒã“ã‚Œã‹ã‚‰ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆã«æ±‚ã‚ã‚‰ã‚Œã‚‹ã®ã§ã¯ãªã„ã‹ã€‚ ã“ã‚Œã¾ã§ã¯RDBMSãŒã‚ã£ãŸã‹ã‚‰ä½•ã‚‚ã‹ã‚‚ä¸€è²«æ€§ãŒä¿éšœã•ã‚Œã¦ã„ãŸã€‚ã ãŒã€æœ¬å½“ã«ãã“ã¾ã§ã™ã¹ã¦ã®ãƒ‡ãƒ¼ã‚¿ã«å³æ™‚ä¸€è²«æ€§ãŒå¿…è¦
Ehren 2011/03/02
RDBMSã¨KVSã¯ãŠäº’ã„è£œå®Œã—ã¦ã¤ã‹ã†ã¨å¹¸ã›ã«ãªã‚Œã‚‹ã¨æ€ã†

RDBMS

NoSql
ãƒªãƒ³ã‚¯
çªç„¶ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ€ã‚¦ãƒ³ã‚’é˜²ããŸã‚ã®ãƒãƒƒãƒå‡¦ç†SQLãƒªãƒ†ãƒ©ãƒ«åŒ–ã®ã‚¹ã‚¹ãƒ¡ Â« WR blog
December 2014Â (1) February 2014Â (1) January 2014Â (1) September 2012Â (1) April 2012Â (1) March 2012Â (2) October 2011Â (1) June 2011Â (5) May 2011Â (1) April 2011Â (1) March 2011Â (1) February 2011Â (1) January 2011Â (1) December 2010Â (1) September 2009Â (1) April 2009Â (1) March 2009Â (1) January 2009Â (3) November 2008Â (2) October 2008Â (1) December 2005Â (2) October 2005Â (2) September 2005Â (2) August 2005Â (7)
Ehren 2011/01/03
oracle

RDBMS
ãƒªãƒ³ã‚¯
PostgreSQLã‚’æœ¬å½“ã«é«˜é€ŸåŒ–ã—ãŸã„äººã®ãŸã‚ã®10ã®ãƒã‚¤ãƒ³ãƒˆ | ç‹¬ã‚Šè¨€v6
ç©ºæ°—ã‚’èªã¾ãšã«PostgreSQLã®ã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®ãƒã‚¤ãƒ³ãƒˆ - è±¡ã¨æˆ¯ã‚Œ -ç©ºæ°—ã‚’èªã¾ãšã«PostgreSQLã®ã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®ãƒã‚¤ãƒ³ãƒˆ - è±¡ã¨æˆ¯ã‚Œ - postgresqlã‚°ãƒ«ãƒ¼ãƒ—.ã®å…ƒã‚¨ãƒ³ãƒˆãƒªã‚’èªã‚“ã§æ€ã†ã¨ã“ã‚ãŒã‚ã£ãŸã®ã ãŒã€ PostgreSQLã‚’é«˜é€ŸåŒ–ã™ã‚‹16ã®ãƒã‚¤ãƒ³ãƒˆ ã ã‹ã‚‰ãã‚“ãªã›ã¾ã£ãã‚‹ã—ã„ã¨ã“ã‚ã§ãƒˆãƒ³ãƒãƒ³ã‚«ãƒ³ã«disã‚‹æš‡ã‚ã‚‹ã‚“ã ã£ãŸã‚‰è‡ªåˆ†ã®ãƒ–ãƒã‚°ã§ãŠå¥½ã¿ã®è°è«–ã‚’æ›¸ãã‹ã•ã‚‚ãªãã‚ƒ/dev/nullã«ã§ã‚‚åã‘ã¨ã‚„ã‚“ã‚ã‚Šã¨è¨€ã£ã¦ã‚‹ã‚“ã ã‚ˆãƒã‚²ã€‚ ã¨ã„ã†ã‚ã‘ã§ï½—ã€‚ ã ã‚ˆãï½—ã€‚ ã¾ã‚æ£ç›´ã€ä¸Šè¨˜å…ƒãƒã‚¿ã®ã»ã†ã«ã¯è‰²ã€…çªã£è¾¼ã¿ã©ã“ã‚æº€è¼‰ãªã®ã ãŒã€ãã‚Œã¯ç½®ã„ã¦ãŠãã¨ã—ã¦L.starãªã‚Šã®é«˜é€ŸåŒ–ãƒã‚¤ãƒ³ãƒˆã‚’ä¸€åº¦æ›¸ã„ã¦ãŠã‹ãªã„ã¨ã€ã¨æ€ã£ãŸã®ã§è¨˜ã™ã€‚ãŸã ã€L.starã¯ã‚‚ã†PostgreSQLç•Œéšˆã‹ã‚‰é›¢ã‚Œã¦ä¹…ã—ã„ã®ã§ã€å¿…ãšã—ã‚‚æœ€æ–°ã®å†…å®¹ã‚’ç¶²ç¾…ã—ã¦ã„ãªã„ã“ã¨ã«æ³¨æ„ã•ã‚ŒãŸã—ã€‚ã¾ãŸã€å‡ºæ¥ã‚‹ã ã‘Pos
Ehren 2010/12/02
postgreSQL

db

RDBMS
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
Ehren 2010/11/15
db

RDBMS

mysql
ãƒªãƒ³ã‚¯
ã‚¹ã‚ãƒ¼ãƒžä¸å®šã®ãƒ‡ãƒ¼ã‚¿ã‚’RDBã«æ°¸ç¶šåŒ–ã™ã‚‹æ–¹æ³•ã®æ¯”è¼ƒ â€” ã‚ã‚Šãˆã‚‹ãˆã‚Šã‚
Recent entries Apache2.4ã®ãƒªãƒªãƒ¼ã‚¹äºˆå®šã¯æ¥å¹´(2011å¹´)åˆã‚(ã‚ãã¾ã§äºˆå®š) inoue 2010-12-23 Herokuã®ç™ºéŸ³ inoue 2010-12-20 é›‘èªŒè¨˜äº‹ã€Œã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãƒ»ãƒ†ã‚¹ãƒˆPRESS Vol.9ã€ã®åŽŸç¨¿å…¬é–‹ inoue 2010-12-18 IPAæœªè¸ã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ inoue 2010-12-15 åŠ´åŸºæ³•ã¨ãƒã‚ãƒ³ã‚²ãƒ¼ãƒ inoue 2010-12-06 ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ inoue 2010-12-03 ASCII.techno logiesèªŒã«MapReduceã®è¨˜äº‹ã‚’æ›¸ãã¾ã—ãŸ inoue 2010-11-25 æŠ€è¡“è©•è«–ç¤¾ãƒ‘ãƒ¼ãƒ•ã‚§ã‚¯ãƒˆã‚·ãƒªãƒ¼ã‚ºçµ¶è³›ç™ºå£²ä¸ inoue 2010-11-24 é›‘èªŒé€£è¼‰ã€ŒEmacsã®ãƒˆãƒ©ãƒŽãƒžã‚ã€ã®åŽŸç¨¿(part8)å…¬é–‹ inoue 2010-11-22 RESTã®å½“æƒ‘ inoue 2010-11-22 ã€Œãƒ—
Ehren 2009/11/16
kvs

RDBMS

db
ãƒªãƒ³ã‚¯
1