[B! mysql] khiroakiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

khiroaki id:khiroaki

mysqlã«é–¢ã™ã‚‹khiroakiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

OSCåºƒå³¶ã¨ä¸å›½åœ°æ–¹DBå‹‰å¼·ä¼šã«å‚åŠ ã—ã¾ã—ãŸã€‚
ã‹ãã¦ã‹ã‚‰äºˆå‘Šã—ã¦ã„ãŸé€šã‚Šã€OSCåºƒå³¶ã¨ä¸å›½åœ°æ–¹DBå‹‰å¼·ä¼šï¼ˆç¬¬5å›žï¼‰ã«å‚åŠ ã•ã›ã¦é ‚ã„ãŸã€‚ä¸¡æ–¹ã®ã‚¤ãƒ™ãƒ³ãƒˆãŒã“ã®åœŸæ—¥ã§é€£ç¶šã—ã¦è¡Œã‚ã‚ŒãŸã®ã§ã€ã„ãšã‚Œã®ã‚¤ãƒ™ãƒ³ãƒˆã«ã‚‚é æ–¹ã‹ã‚‰ã®å‚åŠ è€…ãŒãŸãã•ã‚“ã„ã¦ç››æ³ã ã£ãŸã‚ˆã†ã«æ€ã†ã€‚OSCåºƒå³¶ã§ã¯ãƒ‡ãƒ¢ãƒžã‚·ãƒ³ã®å±•ç¤ºã‚’ã€ä¸å›½åœ°æ–¹DBå‹‰å¼·ä¼šã§ã¯ã‚¹ãƒ©ã‚¤ãƒ‰ï¼ˆMySQLã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã«ã¤ã„ã¦ï¼‰ã®ç™ºè¡¨ã‚’ãã‚Œãžã‚Œã‚„ã‚‰ã›ã¦é ‚ã„ãŸã®ã§ã€ä»Šæ—¥ã¯ãã®å ±å‘Šã‚’ã•ã›ã¦é ‚ã“ã†ã€‚ OSCåºƒå³¶ã«æŒã£ã¦ã„ã£ãŸãƒ‡ãƒ¢ãƒžã‚·ãƒ³æ—¢ã«ãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ã‚„Facebookã§ç›®ã«ã•ã‚ŒãŸæ–¹ã‚‚ã„ã‚‰ã£ã—ã‚ƒã‚‹ã‹ã‚‚çŸ¥ã‚Œãªã„ãŒã€ä»Šå›žå±•ç¤ºã—ãŸãƒžã‚·ãƒ³ã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã¯ã€ŒæŒã¡é‹ã¹ã‚‹MySQL Clusterã®ãƒ‡ãƒ¢ç’°å¢ƒã€ã¨ã„ã†ã‚‚ã®ã ã€‚MySQL Clusterã‚’å‹•ä½œã•ã›ã‚‹ãŸã‚ã®Beagle Bone Black 6å°ã¨ã€ã‚³ãƒ³ã‚½ãƒ¼ãƒ«ç”¨ã®RaspberryPiã€100Mbpsã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚¹ã‚¤ãƒƒãƒã€è–„åž‹ã®ãƒ¢ãƒã‚¤ãƒ«ãƒ¢ãƒ‹ã‚¿ãƒ¼ã€ãƒˆãƒ©ãƒƒã‚¯ãƒã‚¤ãƒ³ãƒˆã¤ã
khiroaki 2014/09/24
mysql

cluster
ãƒªãƒ³ã‚¯
MySQL SQLã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã®ã‚³ã‚¹ãƒˆè¨ˆç®—ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ - SH2ã®æ—¥è¨˜
ã„ã¡ã„ã•ã‚“ã«ãŠèª˜ã„ã„ãŸã ã„ã¦ã€å‹‰å¼·ä¼šã§ç™ºè¡¨ã‚’ã™ã‚‹ã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ InnoDB Deep Talk #1 : ATND ãŠãã‚‰ãåˆè¦‹ã§ã¯å†…å®¹ãŒé›£ã—ã„ã¨æ€ã„ã¾ã™ã®ã§ã€å…ˆã«è³‡æ–™ã‚’å…¬é–‹ã—ã¦ãŠãã¾ã™ã€‚ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ (PDF) ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ç”Ÿæˆã‚¹ã‚¯ãƒªãƒ—ãƒˆ (JdbcRunnerã§åˆ©ç”¨ã—ã¾ã™ã€‚) ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã‹ã‚‰ãƒªãƒ³ã‚¯ã—ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä¸€è¦§ã§ã™ã€‚ MySQL Bugs: #64567: Last_query_cost is not updated when executing an unique key lookup Understanding and Control of MySQL Query Optimizer: Traditional and Novel Tools and Techniques: MySQL Conference & Expo 2009 - O'R
khiroaki 2012/06/24
mysql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

MySQL
ãƒªãƒ³ã‚¯
ç¤¾å†…ã‚µãƒ¼ãƒã‚¤ãƒ³ãƒ•ãƒ©å‹‰å¼·ä¼š(DB)
2. ä»Šå›žã®ç›®çš„ 1. ã€Œãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã€ã¨ã„ã†ã“ã¨ãŒã€å®Ÿéš›ã«ã© ã†ã„ã†ã“ã¨ãªã®ã‹ã‚’çŸ¥ã‚‹ã€‚ 2. ä¸ã®å‹•ä½œã‚’è¸ã¾ãˆã‚‹ã“ã¨ã§ã€åŠ¹çŽ‡ã®ã‚ˆã„ã‚¢ãƒ— ãƒªã‚’æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ 3. å•é¡ŒãŒèµ·ããŸã¨ãã«ã€ãã®åŽŸå› ã‚’çªãæ¢ã‚ã‚‰ ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ ä¸€èˆ¬è«–ã‚’ãƒ¡ã‚¤ãƒ³ã¨ã—ã€MySQLç‰ã®ç´°ã‹ã„ å€‹åˆ¥ãƒŽã‚¦ãƒã‚¦ã¯å–ã‚Šä¸Šã’ã¾ã›ã‚“ã€‚ 3. ãŠã—ãªãŒã 1. ã€Œãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã€ã¨ã¯ã©ã†ã„ã†ã“ã¨ã‹ 2. MySQLãŒãƒ‡ã‚£ã‚¹ã‚¯ã«æ›¸ãã¾ã§ 3. ä»®æƒ³ãƒ¡ãƒ¢ãƒªã¨ãƒšãƒ¼ã‚¸ã‚ãƒ£ãƒƒã‚·ãƒ¥ 4. ã¨ã£ã¦ã‚‚è¤‡é›‘ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®å‹•ä½œ 5. MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ãƒ¡ãƒ¢ãƒªã®é–¢ä¿‚
khiroaki 2011/12/02
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

SIer

UNIX
ãƒªãƒ³ã‚¯
sqlite3
1. åˆã‚ã« (æ›¸ãã‹ã‘) SQLite ã¯ RDMS (é–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ) ã®ä¸€ç¨®ã§ã™ã€‚ é€šå¸¸ã® RDMS ã¨ç•°ãªã‚Šé¢å€’ãªã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãŒä¸è¦ã§ã€ç°¡å˜ã«åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ é€šå¸¸ã®ãƒ•ã‚¡ã‚¤ãƒ«ä¸¦ã«ç°¡å˜ã«æ‰±ãˆã‚‹ã®ã§ã€ ä»Šã¾ã§ã¯ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ãªã©ã«ä¿å˜ã—ã¦ã„ãŸãƒ‡ãƒ¼ã‚¿ã¯ sqlite ã«ä¿å˜ã™ã‚‹ã‚ˆã†ã«ã™ã‚‹ã¨ä¾¿åˆ©ã§ã™ã€‚ 2. Python ã‹ã‚‰ SQLite ã‚’ä½¿ã† ã‚‚ã¡ã‚ã‚“ã€Python ã‹ã‚‰ã‚‚ SQLite ã‚’åˆ©ç”¨ã§ãã¾ã™ã€‚ Python 2.5 ã‹ã‚‰ sqlite3 ãŒ build-in package ã¨ã—ã¦é…å¸ƒã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ ã™ãã«ä½¿ã†ã“ã¨ãŒã§ãã¾ã™ã€‚ æ¬¡ã®ä¾‹ã®ã‚ˆã†ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã« connect ã™ã‚‹ã ã‘ã§ã€ä½¿ã†ã“ã¨ãŒã§ãã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€ å˜åœ¨ã—ãªã‘ã‚Œã°è‡ªå‹•çš„ã«ä½œæˆã•ã‚Œã€ å˜åœ¨ã™ã‚Œã°ã€ãã‚ŒãŒé–‹ã‹ã‚Œã¾ã™ã€‚ ã¾ãŸã€ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã® co
khiroaki 2011/12/02
Python

mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
Good night, Posterous
Posterous Spaces is no longer available Thanks to all of my @posterous peeps. Y'all made this a crazy ride and it was an honor and pleasure working with all of y'all. Thanks to all of the users. Thanks to the academy. Nobody will read this.
khiroaki 2011/12/02
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

Web
ãƒªãƒ³ã‚¯
1