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

akatuki_sato id:akatuki_sato

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

${{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 Indexå‹‰å¼·ä¼šå¤–éƒ¨å…¬é–‹ç”¨
12. Â© CROOZ,Inc. 12 ï¼‘ï¼ŽINDEXã¨ã¯ãªã«ã‹ ä½•æžšç›®ãŒãªã«ã‹ã‚’äº‹å‰ã«ãƒ¡ãƒ¢ã£ã¦ãŠã‘ã°è‰¯ã„ï¼ ã‚¹ãƒ¼ãƒˆ ãƒ©ãƒ³ã‚¯ ä½ç½® ãƒãƒ¼ãƒˆ Q 1 ã‚¹ãƒšãƒ¼ãƒ‰ 9 2 : : : ãƒ€ã‚¤ãƒ¤ 1 40 : : : ã‚¹ãƒšãƒ¼ãƒ‰ 6 45 ãªãœãªã‚‰ã€è¦æ±‚ã¯ã€Œã‚«ãƒ¼ãƒ‰ã‚’å¼•ãå›žæ•°ã‚’æœ€ã‚‚å°‘ãªã ã—ã¦ã‚¹ãƒšãƒ¼ãƒ‰6ã‚’æŽ¢ã™ã“ã¨ã€ ã‚»ã‚³ã„ã¨ã‹ãŠã‚‚ã†ãƒ’ãƒˆã¯ã„ã‚‹ã‹ ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒä½•ã‚‚ã‚»ã‚³ã„ã“ ã¯ã—ã¦ã„ãªã„ã§ã™ã€‚ å‰ææ¡ä»¶ãªã©ä¸€åˆ‡ãªã„ã‹ã‚‰ ã“ã®ãƒ¡ãƒ¢ã•ãˆã‚ã‚Œã°ä½ç½®ã‚’æŒ‡å®šã—ã¦1å›žå¼•ã‘ã°æ¸ˆã‚€
akatuki_sato 2013/09/12
ã‚ã¨ã§èªã‚€

*ã‚ã¨ã§èªã‚€

DB
ãƒªãƒ³ã‚¯
ç¬¬ä¸€å›žä¸å›½åœ°æ–¹DBå‹‰å¼·ä¼šã§ç™ºè¡¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¾ã—ãŸã€‚
å²¡å±±ã§DBå‹‰å¼·ä¼šã‚’é–‹å‚¬ã™ã‚‹ã®ã ãŒMySQL 5.6ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦è©±ã—ã¦è²°ãˆãªã„ã‹ã€‚å…ˆæœˆãã®ã‚ˆã†ãªææ¡ˆã‚’ã„ãŸã ãã€å²¡å±±ã¾ã§ãƒŽã‚³ãƒŽã‚³ã¨é¡”ã‚’å‡ºã—ã¦ããŸã€‚JPUGï¼ˆæ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼šï¼‰ä¸»å‚¬ã‹ã¤å²¡å±±ã¨ã„ã†è‡ªåˆ†ã«ã¨ã£ã¦ã¯é æ–¹ã®åœ°ã§èª°ä¸€äººé¡”è¦‹çŸ¥ã‚ŠãŒå±…ãªã„ä¸ã€è‹¥å¹²ç·Šå¼µã—ã¦ã„ãŸã®ã ãŒã€çš†ã•ã‚“æ¸©ã‹ãè¿Žãˆã¦ã„ãŸã ãæ¥½ã—ã„æ™‚é–“ã‚’éŽã”ã™ã“ã¨ãŒã§ããŸã€‚ã‚„ã¯ã‚Šãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å—œã‚€åŒå£«ã€é€šã˜åˆã†ã‚‚ã®ã§ã‚ã‚‹ã€‚çš†ã•ã‚“å‹‰å¼·ç†±å¿ƒã§æ§˜ã€…ãªè³ªå•ã€æ„è¦‹äº¤æ›ã‚’é€šã—ã¦ã¨ã¦ã‚‚å‹‰å¼·ã«ãªã£ãŸã€‚å¤§åž£ã•ã‚“ã®ç™ºè¡¨ã‚‚ã¨ã¦ã‚‚å‹‰å¼·ã«ãªã£ãŸã€‚ã‚„ã¯ã‚Šã€Œå‹‰å¼·ä¼šã§ç™ºè¡¨ã™ã‚‹ã¨è‡ªåˆ†ãŒå‹‰å¼·ã«ãªã‚‹ã€ã¨ã„ã†æ³•å‰‡ãŒç™ºå‹•ã—ãŸã‚ˆã†ã«æ€ã†ã€‚ ã•ã¦ã€MySQL 5.6ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç™ºè¡¨ã—ãŸã®ã¯ã“ã‚ŒãŒåˆã‚ã¦ã§ã¯ãªã„ã€‚éŽåŽ»ã«ç™ºè¡¨ã—ãŸã‚‚ã®ã«æ”¹è‰¯ãƒ»ä¿®æ£ã‚’åŠ ãˆã¦ã„ã‚‹ã€‚MySQL 5.6ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã‚‚ã†åŠå¹´ã«ãªã‚ã†ã¨ã—ã¦ã„ã‚‹ãŒã€æ–°æ©Ÿèƒ½ã¯æº€è¼‰ãªã®ã§å…¨ã¦ã‚’ã‚ãƒ£ãƒƒãƒã‚¢ãƒƒãƒ—ã—ã¦ã„ã‚‹
akatuki_sato 2013/08/06
ã‚ã¨ã§èªã‚€

mysql

DB
ãƒªãƒ³ã‚¯
qpstudyã§ç™ºè¡¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¾ã—ãŸã€‚
æœ¬æ—¥ã€qpstudyã§ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯ã€ã¨ã„ã†å†…å®¹ã«ã¤ã„ã¦ã€ãã—ã¦ã€Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã¨ã¯ã€ã¨ã„ã†å†…å®¹ã«ã¤ã„ã¦è©±ã™æ©Ÿä¼šã‚’é ‚ã„ãŸã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã¨ã„ã†ç¡¬ã„å†…å®¹ã§ã‚ã£ãŸã«ã‚‚é–¢ã‚ã‚‰ãšã€å‡ºå¸è€…ã®çš†ã•ã‚“ã«ã¯æœ€å¾Œã¾ã§è‰¯ã„åå¿œã‚’ã—ã¦é ‚ã‘ãŸã‚ˆã†ã«æ€ã†ã€‚å®Ÿã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã«ã¤ã„ã¦èª¤è§£ã—ã¦ã„ã‚‹ã€ã‚ã‚‹ã„ã¯çŸ¥ã‚‰ãªã„äººãŒæœ¬å½“ã«å¤šã„ã€ãã—ã¦è‰¯ã„è§£èª¬æ›¸ãŒãªã„ã¨ã„ã†ã“ã¨ã‚’æ™®æ®µå•é¡Œã¨ã—ã¦æ„Ÿã˜ã¦ãŠã‚Šã€ãã†ã„ã£ãŸèƒŒæ™¯ã‹ã‚‰ä»Šå›žqpstudyã®è©±ã‚’å¼•ãå—ã‘ã•ã›ã¦è²°ã£ãŸã€‚ä»Šå›žç™ºè¡¨ã—ãŸå†…å®¹ãŒçš†ã•ã‚“ã®ãŠå½¹ã«ç«‹ã¦ã°å¹¸ã„ã§ã‚ã‚‹ã€‚ ç™ºè¡¨ã®å†…å®¹ã¯ã»ã¼ç¾åœ¨WEB+DB PRESSã§é€£è¼‰ã—ã¦ã„ã‚‹ã€Œç†è«–ã§å¦ã¶SQLå†å…¥é–€ã€ã®ã„ãã¤ã‹ã®å›žã®ã‚‚ã®ã‚’è¦ç´„ã—ãŸã‚‚ã®ã«ãªã£ã¦ã„ã‚‹ã€‚é€£è¼‰ã§ã¯ã•ã‚‰ã«è©³ã—ã„å†…å®¹ã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ã„ã‚‹ã®ã§ã€èˆˆå‘³ã®ã‚ã‚‹äººã¯ãœã²WEB+DB PRESSã®ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼ï¼ˆé€£è¼‰ã¯Vol.68ã€œï¼‰ã‚’è³¼å…¥ã—ã¦é ‚ããŸã„ã€‚ æœ¬æ—¥ç™ºè¡¨ã—ãŸã‚¹
akatuki_sato 2013/07/29
ã‚¹ãƒ©ã‚¤ãƒ‰

DB

MySQL
ãƒªãƒ³ã‚¯
WEB+DB PRESS ç·é›†ç·¨ Vol.1ï½ž72 ãƒ¬ãƒ“ãƒ¥ãƒ¼ | yamashitakoji.com
ä»Šå¹´ã‚‚æœŸå¾…ã«ç”ãˆã¦å‡ºã—ã¦ãã ã•ã„ã¾ã—ãŸã€ŒWEB+DB PRESSã€ã®ç·é›†ç·¨ã§ã”ã–ã„ã¾ã™ã€‚ Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦åƒã„ã¦ã„ã‚‹ã¨ã€ã©ã†ã‚‚ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§åˆ©ç”¨ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã®æŠ€è¡“ã«ç¸›ã‚‰ã‚Œã™ãŽã¦ã€æ¥ç•Œã®æµè¡Œã‚Šå»ƒã‚Šã«ã¤ã„ã¦ã„ã‘ãªããªã‚‹ã‚‚ã®ã€‚ã€€ãã‚Œã‚’è£œã£ã¦æ–¹å‘æ€§ã‚’ä¿®æ£ã—ã¦ãã‚Œã‚‹ã®ãŒæœ¬æ›¸ã«åŽã‚ã‚‰ã‚Œã¦ã„ã‚‹ãƒãƒƒã‚¯ãƒŠãƒ³ãƒãƒ¼PDFãŸã¡ã€‚ æ¤œç´¢ã§ã„ã¤ã§ã‚‚ç›®çš„ã®æŠ€è¡“ã‚’èª¿ã¹ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ã¦ãŠã æœ¬æ›¸ã®ä½¿ã„æ–¹ã¯ä¸»ã«ã€ã‚ˆãçŸ¥ã‚‰ãªã„æŠ€è¡“ã®åå‰ï¼ˆä¾‹ãˆã°ã€Œnode.jsã€ã¨ã‹ï¼‰ã«ã¤ã„ã¦èª¿ã¹ãŸã‚Šã™ã‚‹ã“ã¨ã‹ã¨æ€ã„ã¾ã™ã€‚ã€€ã©ã†ã„ã†ã‚‚ã®ã‹ã€ã©ã†ã‚„ã£ã¦ä½¿ã£ã¦ã„ãã‚‚ã®ã‹ã«ã¤ã„ã¦è©³ã—ãè¼‰ã£ã¦ã¾ã™ã‹ã‚‰ã€‚ PCã§ã¯ã€Œsearch.pdxã€ã¨ã—ãŠã‚Šæ¤œç´¢ã‚’ã†ã¾ãåˆ©ç”¨ã—ã‚ˆã† PCã§åˆ©ç”¨ã™ã‚‹å ´åˆã«ã‚ªã‚¹ã‚¹ãƒ¡ã—ãŸã„ã®ã¯ã€Œsearch.pdxã€ã‚’PDFãƒªãƒ¼ãƒ€ãƒ¼ã§é–‹ã„ã¦ã€æ¤œç´¢èªžã‚’å…¥åŠ›ã™ã‚‹æ–¹æ³•ã§ã™ã€‚ ãã®éš›ã«ã†ã¾ãè¦‹ã¤ã‘ã‚‹ã‚³ãƒ„ã¨ã—ã¦ã€Œã—ãŠã‚Šã‚’å«ã‚ã‚‹ã€ã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³
akatuki_sato 2013/06/27
web

DB
ãƒªãƒ³ã‚¯
http://www.owasoku.com/archives/24435520.html
akatuki_sato 2013/02/14
ã¨ã‚Šã‚ãˆãšèƒƒæ¶²ãŒé€†æµã™ã‚‹æ„ŸãŒã‚ã£ãŸã€‚ã€‚ã€‚

DB

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
ã€21ç¤¾ã‹ã‚‰5ç¤¾ã‚’SNSã®è©•åˆ¤ã‹ã‚‰åŽ³é¸ã€‘ãŠã™ã™ã‚ã®å‡ºä¼šã„ç³»ã‚¢ãƒ—ãƒªï¼†å¤±æ•—ã—ãªã„é¸ã³æ–¹ï½œãƒžãƒƒãƒãƒ³ã‚°ã‚¢ãƒ—ãƒªæ¼‚æµæ•™å®¤ â€“ ãƒžãƒƒãƒãƒ³ã‚°ã‚¢ãƒ—ãƒªã®æ„Ÿæƒ³ã‚’SNSã®æ„è¦‹ã‚’å‚è€ƒã«ç´¹ä»‹
akatuki_sato 2012/01/04
DB

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

ã¾ã¨ã‚

ã‚ã¨ã§èªã‚€

æœ¬
ãƒªãƒ³ã‚¯
ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã§Googleæ¤œç´¢ã—ã¦ä¸Šä½15è¨˜äº‹ã‚’æ¤œè¨¼ã—ãŸ - ockeghem's blog
ã“ã®ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€ãƒãƒƒãƒˆä¸Šã§ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã€ã§Googleæ¤œç´¢ã—ãŸçµæžœã®ä¸Šä½15ã‚¨ãƒ³ãƒˆãƒªã‚’æ¤œè¨¼ã—ãŸçµæžœã‚’å ±å‘Šã—ã¾ã™ã€‚ SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³è„†å¼±æ€§ã®å¯¾ç–ã¯ã€æ—¢ã«ã€Œå®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ã€ã«ãƒ•ã‚¡ã‚¤ãƒŠãƒ«ã‚¢ãƒ³ã‚µãƒ¼ï¼ˆå¾Œè¿°ï¼‰ã‚’ç¤ºã—ã¦ã„ã¾ã™ãŒã€ã¾ã ã“ã®æ–‡æ›¸ã‚’çŸ¥ã‚‰ãªã„äººãŒå¤šã„ã ã‚ã†ã“ã¨ã¨ã€ã‚„ã‚„ä¸Šç´šè€…å‘ã‘ã®æ–‡æ›¸ã§ã‚ã‚‹ã“ã¨ã‹ã‚‰ã€ã¾ã ååˆ†ã«å®Ÿè·µã•ã‚Œã¦ã¯ã„ãªã„ã¨æ€ã„ã¾ã™ã€‚ ã“ã®çŠ¶æ³ã§ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ã“ã¨ã‚’ã‚ˆãçŸ¥ã‚‰ãªã„äººãŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã—ã‚ˆã†ã¨ã—ãŸå ´åˆã®è¡Œå‹•ã‚’äºˆæ¸¬ã—ã¦ã¿ã‚‹ã¨ã€ã‹ãªã‚Šã®å‰²åˆã®äººãŒGoogleç‰ã§æ¤œç´¢ã—ã¦å¯¾å‡¦æ–¹æ³•ã‚’èª¿ã¹ã‚‹ã¨æ€ã‚ã‚Œã¾ã™ã€‚ãã“ã§ã€ä»¥ä¸‹ã®URLã§SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–æ–¹æ³•ã‚’æ¤œç´¢ã—ãŸçµæžœã®ä¸Šä½ã®ã‚¨ãƒ³ãƒˆãƒªã‚’æ¤œè¨¼ã—ã¦ã¿ã‚ˆã†ã¨æ€ã„ç«‹ã¡ã¾ã—ãŸã€‚ http://www.google.co.jp/search?q=SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç– ã©ã“ã¾ã§èª¿ã¹ã‚‹ã‹ã§ã™ãŒã€ä»¥å‰NH
akatuki_sato 2011/11/09
ã‚ã¨ã§èªã‚€ã€èªã‚€ãžã€‚ã§ã‚‚ã€æ™‚é–“ãŒç„¡ã„ãªã‚‰ã€€ã¾ã¨ã‚ã ã‘ã§ã‚‚å……åˆ†ä¾¡å€¤ã‚ã‚Šã€‚

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

DB

èª¿æŸ»
ãƒªãƒ³ã‚¯
ä½œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã®æ©Ÿèƒ½ã‚„æ€§èƒ½ã§å‹è² ã—ãŸã„ã€‚ãã†ã ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å‹‰å¼·ã—ã‚ˆã† - ãã—ã ã®ã¯ã¦ãª
ã•ã¦ã€ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã®å‹‰å¼·ã®ã—ã‹ãŸã¨ã€ãƒ©ãƒ ãƒ€è¨ˆç®—ã®å‹‰å¼·ã®ã—ã‹ãŸã®ç›®æ˜Ÿã‚’ã¤ã‘ã¾ã—ãŸã€‚ ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã®å‹‰å¼·ã®ã—ã‹ãŸ - ãã—ã ã®ã¯ã¦ãª ãƒ©ãƒ ãƒ€è¨ˆç®—ã®å‹‰å¼·ã®ã—ã‹ãŸã€ãƒ—ãƒã‚°ãƒ©ãƒ æ„å‘³è«– - ãã—ã ã®ã¯ã¦ãª ã“ã‚Œã§ã“ã“ã§æ›¸ã„ãŸãƒ—ãƒã‚°ãƒ©ãƒ ã®ç†è«–ã®åŸºç¤Žã¯å‹‰å¼·ã§ããŸã“ã¨ã«ãªã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒ ã®ç†è«–ã¨ã¯ãªã«ã‹ - ãã—ã ã®ã¯ã¦ãª ã¨ã“ã‚ã§ã€ãƒ—ãƒã‚°ãƒ©ãƒ ã®å‹‰å¼·åœ°å›³ã¨ã—ã¦ã“ã†ã„ã†å›³ã‚’æ›¸ãã¾ã—ãŸã€‚ ã§ã€ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã¾ã‚ã‚Šã«ã¤ã„ã¦ã‚‚ã€ãƒ—ãƒã‚»ãƒƒã‚µã‚’æ”¯ãˆã‚‹æŠ€è¡“ã‚„ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã¯ãªãœã¤ãªãŒã‚‹ã®ã‹ã§ã²ã¨ã¨ãŠã‚Šå‹‰å¼·ã—ãŸã¨ã—ã¾ã—ã‚‡ã†ã€‚ ã˜ã‚ƒã‚æ¬¡ã¯ã€ã‚¢ã‚¸ãƒ£ã‚¤ãƒ«ã‹ï¼Ÿãƒ†ã‚¹ãƒˆã‹ï¼ŸUIãƒ‡ã‚¶ã‚¤ãƒ³ã‹ï¼Ÿã¨ãªã‚‹ã‚ã‘ã§ã™ãŒã€ã‚„ã¯ã‚Šãƒ—ãƒã‚°ãƒ©ãƒžãªã‚‰ã€ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä½œã‚Šæ–¹ã‚„ä½¿ã„ã‚„ã™ã•ã®å‰ã«ã€ä½œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã®æ©Ÿèƒ½ã‚„æ€§èƒ½ã§å‹è² ã—ãŸã„ã˜ã‚ƒãªã„ã§ã™ã‹ã€‚ ã„ã„æ„Ÿã˜ã«é–¢æ•°ãŒåˆ†å‰²ã§ãã‚‹ã‚ˆã¨ã‹ã€èªã¿ã‚„ã™ã„åå‰ãŒã¤ã‘ã‚Œã‚‹ã‚ˆã¨ã‹ã€åŠ¹çŽ‡ã‚ˆãä»•äº‹ã—ã¦å®šæ™‚ã«å¸°ã‚Œã‚‹ã‚ˆã¨
akatuki_sato 2011/09/28
å‹‰å¼·

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

DB
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ–ã‚µãƒŸ2010ã€Œé«˜æ€§èƒ½ãƒ»å®‰å®šé‹ç”¨ã®ãŸã‚ã®Linux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/é‹ç”¨æŠ€è¡“ã€è¡Œã£ã¦ããŸ - hiroyã®ãƒ–ãƒã‚°
ãƒ‡ãƒ–ã‚µãƒŸã«ä¼šç¤¾ã‚’æŠœã‘å‡ºã—ã¦è¡Œã£ã¦ããŸã€‚å‚åŠ ã—ãŸã®ã¯1ã¤ã ã‘ã ã‘ã©ã€‚æ°—ã«ãªã£ãŸéƒ¨åˆ†ã¨ã‹ã®ãƒ¡ãƒ¢ã‚’å…¬é–‹ã€‚ DBè£½å“ã®å“è³ªã€ã¨ã„ã†è¦³ç‚¹ãŒé‡è¦ ä¸€èˆ¬è§£ã‚’æ±‚ã‚ã™ãŽãªã„ã“ã¨ ç¤¾å†…æ¨™æº–ã§å…¨éƒ¨æƒãˆã‚ˆã†ã¨ã—ãŸã‚Šã™ã‚‹ã¨åŠ¹çŽ‡ãŒæ‚ªã„ã“ã¨ã‚‚ ã‚¢ãƒ—ãƒªã®æ€§è³ªã«ã‚ˆã£ã¦è¨å®šã¯å¤‰ãˆã‚‹ã¹ã ã‚ˆã„ã¨ã“ã‚ã‚ˆã‚Šæ‚ªã„ã¨ã“ã‚ã‚’è¦‹ã‚ˆã† å®‰å®šæ€§é‡è¦ ãƒ¡ãƒ¢ãƒª ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆI/Oã‚’ä½¿ãŠã† innodb_flush_method = O_DIRECT ã‚¹ãƒ¯ãƒƒãƒ—/OOMã‚ãƒ©ãƒ¼ã‚’é¿ã‘ã‚‹ vm.swappiness = 0 Innodb Pluginãªã‚‰mallocã®è¨å®šãŒã§ãã‚‹ innodb_use_sys_malloc I/Oã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ© noopã‚„deadlineã«å¤‰æ›´ã™ã‚‹ã®ã‚‚ã„ã„ã‹ã‚‚ï¼ˆãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯cfqï¼‰ MySQL 5.4ã ã¨å¤§å·®ãªã„ã‘ã© MySQL 5.1ã ã¨ãã‚Œãªã‚Šã«å·®ãŒã‚ã‚‹ I/Oã‚¹ãƒ¬ãƒƒãƒ‰ã®æ•°ã«å·®ãŒã‚ã‚‹ãŸã‚ MyISAMãªã‚‰I/Oã®ã‚ãƒ¥ãƒ¼ã‚µ
akatuki_sato 2011/06/24
MySQL

DB

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

DB
ãƒªãƒ³ã‚¯
A5:SQL Mk-2 - ãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«/ERå›³ãƒ„ãƒ¼ãƒ«
A5:SQL Mk-2ã¯è¤‡é›‘åŒ–ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’æ”¯æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQLé–‹ç™ºãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ é«˜æ©Ÿèƒ½ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’ç›®æ¨™ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLã‚’å®Ÿè¡Œã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ç·¨é›†ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ERå›³ã‚’ä½œæˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ ç‰¹å¾´ãƒ»æ©Ÿèƒ½ OCIæŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãƒ»ADOã¾ãŸã¯ODBCã‚’ä»‹ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCIçµŒç”±ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBãƒ—ãƒãƒã‚¤ãƒ€ã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ç›´æŽ¥å‘¼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCã‚’åˆ©ç”¨ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL
akatuki_sato 2010/06/14
DB

sql

ERå›³
ãƒªãƒ³ã‚¯
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹
DBè¨è¨ˆã®ç¥žãƒ„ãƒ¼ãƒ«ã€ŒERMasterã€ãªã‚‰ã€ã“ã“ã¾ã§ã§ãã‚‹ï¼šãƒ¦ã‚«ã‚¤ã€ãƒ„ãƒ¼ã‚«ã‚¤ã€ã‚«ã‚¤ãƒãƒ„ç’°å¢ƒï¼ï¼ˆ11ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ ç„¡æ–™ã®Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŒERMasterã€ã¨ã¯ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆã‚’è¡Œã†ã¨ãã«çš†ã•ã‚“ã¯ã€ã©ã®ã‚ˆã†ã«ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã„ãã¤ã‹ã®ç„¡æ–™ã§åˆ©ç”¨ã§ãã‚‹ãƒ„ãƒ¼ãƒ«ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç†è€…ã¯ãã‚Œã‚‰ã‚’åˆ©ç”¨ã—ã¦ã„ã¾ã—ãŸãŒã€æœ€è¿‘ã€ŒERMasterã€ã¨å‘¼ã°ã‚Œã‚‹Eclipseãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã®å˜åœ¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ ERMasterã¯ã€ã»ã‹ã®ãƒ„ãƒ¼ãƒ«ã«æ¯”ã¹ã€ç›´æ„Ÿçš„ã§åˆ†ã‹ã‚Šã‚„ã™ã„UIï¼ˆãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ï¼‰ã«ã€ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºå¯èƒ½ãªã€Excelã§å‡ºåŠ›ã§ãã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã€è¾žæ›¸æ©Ÿèƒ½ãªã©ç—’ã„ã¨ã“ã‚ã«æ‰‹ãŒå±ŠãERãƒ¢ãƒ‡ãƒªãƒ³ã‚°ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚æœ¬ç¨¿ã§ã¯ã€ã“ã®ERMasterã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ERMasterã®ä¸»ãªç‰¹å¾´ã€8ã¤ ERMasterã«ã¯ã€ä¸»ã«æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚ ã€1ã€‘ç›´æ„Ÿçš„ã§ä½¿ã„ã‚„
akatuki_sato 2010/02/16
DB

ERMaster
ãƒªãƒ³ã‚¯
1