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

monomoti id:monomoti

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

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

mysqlclient ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸ - methaneã®ãƒ–ãƒã‚°
å‰å›žã®è¨˜äº‹ã§ ã—ã‹ã—ã€é•·å¹´ã®å®Ÿç¸¾ãŒã‚ã‚‹æœ¬å®¶ã¨ã„ãˆã©ã‚‚ã€å€‹äººãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã€ï¼‘å¹´ã«æ•°å›žã—ã‹ã‚³ãƒŸãƒƒãƒˆã•ã‚Œã¦ãªã„ç¾çŠ¶ã§ã™ã€‚ ä¸€å¿œã€ã€Œã„ã¾è»¢è·ç›´å¾Œã§æ™‚é–“ãªã„ã‚“ã ã‘ã©ã€ã§ãã‚Œã°é€±æœ«ã«è¦‹ã¦ãŠãã‚ˆã€ã¨ã„ã†æ„Ÿã˜ã®ãƒ¬ã‚¹ã‚’è²°ã£ãŸã®ã§ã—ã°ã‚‰ãå¾…ã£ã¦ã¿ã¾ã™ãŒã€é€²å±•ãŒãªã‘ã‚Œã°åˆ¥åã§ PyPI ã«ç™»éŒ²ã—ã¦ã—ã¾ã†ã¤ã‚‚ã‚Šã§ã™ã€‚ ã¨æ›¸ã„ãŸã®ã§ã™ãŒã€ã¾ã æœ¬å®¶ã«ãƒžãƒ¼ã‚¸ã•ã‚Œã¦ã„ãªã„ã®ã§ã€å¨˜ãŒå®¶ã«æ¥ã¦ã‚ã¾ã‚Šæ´»å‹•ãŒã§ããªããªã‚‹å‰ã«ãƒªãƒªãƒ¼ã‚¹ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ mysqlclient Windows ç”¨ã«ã¯ã€ä»Šé¢¨ã®ãƒã‚¤ãƒŠãƒªãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã‚ã‚‹ wheel ã‚’ãƒ“ãƒ«ãƒ‰ã—ã¦ã‚ã‚Šã¾ã™ã€‚ ãƒ“ãƒ«ãƒ‰ã«å¿…è¦ã ã£ãŸ MySQL Connector/C ãŒã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã‚’ä½¿ã†ã¨ã€ x86 ã¨ x64 ãŒæŽ’ä»–ã«ãªã‚‹ï¼ˆç‰‡æ–¹ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã‚‚ã†ç‰‡æ–¹ãŒè‡ªå‹•çš„ã«ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ï¼‰ã®ã§åœ°å‘³ã«ãƒãƒžã‚Šã¾ã—ãŸã€‚ Windows ç‰ˆã® wheel ã®æº–å‚™ã¯ã€ Windo
monomoti 2014/06/02
ã‚ã‚ŠãŒãŸã‚„

Python3

MySQL
ãƒªãƒ³ã‚¯
MySQL-python ã® Python 3 å¯¾å¿œ - methaneã®ãƒ–ãƒã‚°
åŽ»å¹´10æœˆã« Python 3 ã® MySQL ãƒ‰ãƒ©ã‚¤ãƒäº‹æƒ… ã¨ã„ã†è¨˜äº‹ã§æ¬¡ã®ã‚ˆã†ã«æ›¸ã„ã¦ã„ã¾ã—ãŸã€‚ å¤šåˆ†ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ãª MySQLãƒ‰ãƒ©ã‚¤ãƒãªã®ã§ã™ãŒã€ç¾çŠ¶ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¦ã„ã‚‹ 1.2.4 ã§ã¯ Python 3 å¯¾å¿œãŒã§ãã¦ã„ã¾ã›ã‚“ã€‚ Fork ã® MySQL-for-Python3 ãŒæŽ¨å¥¨ã•ã‚Œã¾ã™ã€‚ æœ€è¿‘ MySQL-python ã®æ–¹ã« Python 3 å¯¾å¿œã®æº–å‚™çš„ãª Pull Request (å¤ã„æ§‹æ–‡ã‚’ Python 2/3 ä¸¡å¯¾å¿œã®æ§‹æ–‡ã«ç½®ãæ›ãˆã‚‹) ãŒã¡ã‚‰ã»ã‚‰ã‚ã‚Šã€ã‚„ã£ã±ã‚Šä¸é€”åŠç«¯ã«ãƒ¡ãƒ³ãƒ†ã•ã‚Œã¦ãªã„ Fork ã‚ˆã‚Šæœ¬å®¶ã«å¯¾å¿œã—ã¦ã‚‚ã‚‰ã‚ãªã„ã¨ãªãã¨ã„ã†ã“ã¨ã§ã€ã‚¨ã‚¤ãƒ¤ã§ Python 3 å¯¾å¿œã—ã¦ã—ã¾ã£ã¦ å°‘ã—å¤§ãã‚ã® Pull Request ã‚’æŠ•ã’ã¾ã—ãŸã€‚ ã—ã‹ã—ã€é•·å¹´ã®å®Ÿç¸¾ãŒã‚ã‚‹æœ¬å®¶ã¨ã„ãˆã©ã‚‚ã€å€‹äººãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã€ï¼‘å¹´ã«æ•°å›žã—ã‹ã‚³ãƒŸãƒƒãƒˆã•ã‚Œã¦ãªã„ç¾çŠ¶ã§ã™ã€‚ ä¸€å¿œã€
monomoti 2014/06/02
ã•ã¦ã€Python3ã§åˆã®MySQLã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚„ã‚‹ãžãƒ¼ã¨æ€ã£ã¦ãŸã‚‰ã€æ„å¤–ãªã¨ã“ã‚ã§èº“ã„ãŸã€‚ãã†ãªã‚“ã‚„ãƒ¼ã€‚

python3

MySQL
ãƒªãƒ³ã‚¯
MacPorts ã§ MySQL5.5 ã‚’å…¥ã‚Œã‚‹ - Memo
æ–°ã—ã„ Mac ã‚’è²·ã£ãŸã®ã§ç’°å¢ƒã‚’å†æ§‹ç¯‰ã€‚ MacPorts*1 ã§ MySQL5.5 ã‚’å…¥ã‚Œã‚ˆã†ã¨ã—ã¦ãƒãƒžã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ $ sudo port install mysql55 +openssl +system_readline---> Computing dependencies for mysql55 ---> Fetching archive for mysql55 ---> Attempting to fetch mysql55-5.5.27_0+openssl+system_readline.darwin_12.x86_64.tbz2 from http://packages.macports.org/mysql55 ---> Attempting to fetch mysql55-5.5.27_0+openssl+system_readline.darwin_12.x86_6
monomoti 2013/01/06
MySQL5.5

MacPorts

MySQL
ãƒªãƒ³ã‚¯
AWS News Blog
AWS Week in Review â€“ March 20, 2023 This post is part of our Week in Review series. Check back each week for a quick roundup of interesting news and announcements from AWS! A new week starts, and Spring is almost here! If youâ€™re curious about AWS news from the previous seven days, I got you covered. Last Weekâ€™s Launches Here are the [â€¦] AWS Chatbot Now Integrates With Microsoft Teams I am pleased
monomoti 2012/10/12
MySQL

aws

Amazon

DB
ãƒªãƒ³ã‚¯
MySQL 5.6ã®InnoDB memcached pluginã‚’ä½¿ã£ã¦ã¿ã‚‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
MySQL 5.6ã® RC ç‰ˆãŒå‡ºã¾ã—ãŸãã€‚é…åŠ›çš„ãªæ©Ÿèƒ½ãŒæº€è¼‰ã§çš†ã•ã‚“wktkã—ã¦ã„ã‚‹ã“ã¨ã¨æ€ã„ã¾ã™ã€‚æ—©é€Ÿã€å€‹äººçš„ã«æ°—ã«ãªã£ã¦ã„ãŸ memcached plugin ã‚’è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ æœ€åˆã«çµè«–ã‹ã‚‰è¨€ã„ã¾ã™ãŒã€ç¾æ™‚ç‚¹ (5.6.7rc) ã§ã¯ HandlerSocket ã®ä»£ã‚ã‚Šã«ä½¿ãˆã‚‹ã‚ˆã†ãªã‚‚ã®ã§ã¯ãªã•ãã†ã§ã™ã€‚ memcached protocol ã§ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã®ã¯å…¨ä½“ã§ 1 ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã¿ è¨‚æ£: namespace ã¨ã„ã†ä»•çµ„ã¿ã§è¤‡æ•°ãƒ†ãƒ¼ãƒ–ãƒ«ã«mapãŒå¯èƒ½ã§ã™ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã¯ latin1 ã§ã‚ã‚‹å¿…è¦ãŒã‚ã‚‹ ã€2012-11-22 è¿½è¨˜ã€‘5.6.8RCã§ã¯ã€æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒ latin1 ã§ã‚ã‚‹ã¨ã„ã†åˆ¶é™ã¯æ’¤å»ƒã•ã‚Œã¾ã—ãŸ ã€ŒMySQL ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã« memcached protocol ã§ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã€ã¨ã„ã†ã‚ˆã‚Šã¯ã€ã€Œmemcached ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’ InnoDB ã«ã§
monomoti 2012/10/05
MySQL

innodb
ãƒªãƒ³ã‚¯
MySQLã®ç›£è¦–ã¯Cacti+Percona Monitoring PluginsãŒãŠã™ã™ã‚(ç›£è¦–ã‚µãƒ¼ãƒæ§‹ç¯‰ç·¨)
MySQLã®ç›£è¦–ã¯Cacti+Percona Monitoring PluginsãŒãŠã™ã™ã‚(ç›£è¦–ã‚µãƒ¼ãƒæ§‹ç¯‰ç·¨) 2012-05-18 MySQLã‚’ãƒªã‚½ãƒ¼ã‚¹ç›£è¦–ã™ã‚‹ä»•çµ„ã¿ã«ã¯ã„ãã¤ã‹ã‚ã‚‹ãŒã€å¯¾è±¡ã®MySQLã‚µãƒ¼ãƒãŒ5å°ä»¥ä¸Šã‚ã‚‹å ´åˆã¯CactiãŒãŠã™ã™ã‚ã€‚å°Žå…¥ã®ã—ã‚„ã™ã•ã ã‘ã§Muninã‚’é¸ã¶äººãŒå¤šã„æ°—ãŒã™ã‚‹ãŒã€ãã®é¸æŠžåŸºæº–ã¯é–“é•ã£ã¦ã„ã‚‹ï¼ Cactiã®ã„ã„ã¨ã“ã‚ã‚‹ã„ã¨ã“ å¤šæ•°ã®ã‚°ãƒ©ãƒ•ã‚’è¦‹ã‚„ã™ãä¸¦ã¹ã‚‰ã‚Œã‚‹ muninã¨æ¯”ã¹ã¦å¤šæ•°ã®ã‚µãƒ¼ãƒã‹ã‚‰è»½å¿«ã«æƒ…å ±ã‚’åŽé›†ãƒ»è¡¨ç¤ºã§ãã‚‹ ç›£è¦–å¯¾è±¡ã«ã¯ã€MySQLã®ãƒ¦ãƒ¼ã‚¶ã‚’è¿½åŠ ã™ã‚‹ã ã‘ã§ã‹ãªã‚Šã®é …ç›®æ•°ã‚’ç›£è¦–ã§ãã‚‹ ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå¿…é ˆã ã£ãŸã‚Šã—ã¦ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãŒã‚„ã‚„é¢å€’ æ…£ã‚Œã‚‹ã¾ã§ç›£è¦–ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’æ›¸ãã®ã«æ‰‹é–“å–ã‚‹ Muninã®ã„ã„ã¨ã“ã‚ã‚‹ã„ã¨ã“ ç›£è¦–ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’æ›¸ãã®ãŒç°¡å˜ ç›£è¦–ã‚µãƒ¼ãƒã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãªã©ãŒå¿…è¦ãªãã€ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãŒç°¡å˜ ã‚°ãƒ©ãƒ•ã®ä¸¦ã³æ–¹ãªã©ãŒ
monomoti 2012/05/18
MySQL

cacti

ç›£è¦–

ã‚µãƒ¼ãƒç›£è¦–

DB

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

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

DB

server
ãƒªãƒ³ã‚¯
ä»Šé¢¨ã®UIã€‚Ajaxã‚’ä½¿ã£ãŸPHPãƒ™ãƒ¼ã‚¹ã®MySQLç®¡ç†ã‚·ã‚¹ãƒ†ãƒ Â·MyWebSql MOONGIFT
MyWebSqlã¯Ajaxã‚’å¤šç”¨ã—ãŸä»Šé¢¨ã®UIã‚’ä½¿ã£ãŸMySQLç®¡ç†ãƒ„ãƒ¼ãƒ«ã€‚ MyWebSqlã¯PHPè£½ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚PHPã¨è¨€ãˆã°MySQLã€ãã®äºŒã¤ã®çµ„ã¿åˆã‚ã›ã‹ã‚‰ç”Ÿã¿å‡ºã•ã‚ŒãŸphpMyAdminã€‚LAMPã‚¹ã‚¿ãƒƒã‚¯ãªã‚“ã¦è¨€è‘‰ãŒç”Ÿã¿å‡ºã•ã‚ŒãŸã®ã«phpMyAdminã®å„ªç§€ã•ãŒã‚ã£ãŸã“ã¨ã¯å¦å®šã§ããªã„ã€‚ãã‚Œãã‚‰ã„èª°ã—ã‚‚ãŒä½¿ã£ã¦ã„ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ ãƒ‡ãƒ¼ã‚¿ä¸€è¦§ ã ãŒé•·ã„å¹´æœˆã®ã†ã¡ã«UIã¯å¤ã„ã‚‚ã®ã«ãªã‚Šã€ã¡ã‚‡ã£ã¨æ™‚ä»£ãŒå¤‰ã‚ã£ã¦ãã¦ã„ã‚‹ã‹ã¨ã„ã†æ°—ãŒã—ãªãã‚‚ãªã„ã€‚ãã“ã§ä»Šã®Webã«åˆã‚ã›ãŸMySQLç®¡ç†ãƒ„ãƒ¼ãƒ«ã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ãã‚ŒãŒMyWebSqlã ã€‚ MyWebSqlã¯Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é¢¨ã®ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«åŠ ãˆã¦ã€UIã®ãƒ‡ã‚¶ã‚¤ãƒ³ã‚‚ãƒãƒƒãƒ—ã§æ˜Žã‚‹ã„é…è‰²ã«ãªã£ã¦ã„ã¦ä½¿ã„å‹æ‰‹ãŒè‰¯ã„ã€‚å·¦å´ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸€è¦§ã€å³å´ã§ãƒ‡ãƒ¼ã‚¿ã®ç·¨é›†ã‚’è¡Œã†ã‚¹ã‚¿ã‚¤ãƒ«ã¯phpMyAdminã¨åŒã˜ã ã€‚ã•ã‚‰ã«ä¸‹ã«ã¯SQ
monomoti 2011/08/01
mysql

ãƒ„ãƒ¼ãƒ«

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
MySQLã®masterã¨slave 1:1ã«ã—ã¦å‚ç…§ã‚’slaveå‘ã‘ã‚‹ã®ã£ã¦ã‚„ã‚ŠãŸãŒã‚‹äººå¤šã„ã¿ãŸã„ã ã‘ã©ã€æ€§èƒ½ãŸã„ã—ã¦ä¸ŠãŒã‚‰ãªã„å‰²ã«å¯ç”¨æ€§è½ã¡ã‚‹ã ã‘ã ã‹ã‚‰ã‚„ã‚ã‚ˆã†ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³ 2011-06-19 00:16:30 via YoruFukurou MySQL ã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç°¡å˜ã«æ§‹æˆã§ãã‚‹ã®ã§ã™ãŒã€æ™‚æŠ˜ master 1å° ã«å¯¾ã—ã¦ slave 1å°ã€æ›´æ–°å‡¦ç†ã¯ master ã«ã€å‚ç…§ã¯ slave ã«ã€ã¨ã„ã†æ§‹æˆã‚’ç›®ã«ã—ã¾ã™ã€‚ å€‹äººçš„ã«ã¯ã“ã®æ§‹æˆã¯ãŠå‹§ã‚ã§ãªã„ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã€ãã®ç†ç”±ã‚’è€ƒå¯Ÿã—ã¦ã¿ã¾ã™ã€‚ 1. å¯ç”¨æ€§ãŒè½ã¡ã‚‹ å½“ç„¶ã§ã™ãŒã€master, slave ã®ã©ã¡ã‚‰ãŒè½ã¡ã¦ã‚‚å½±éŸ¿ã‚’å—ã‘ã‚‹ãŸã‚ã«å¯ç”¨æ€§ãŒä½Žä¸‹ã—ã¾ã™ã€‚ 2. å…¨ä½“ã®æ€§èƒ½ãŒã»ã¨ã‚“ã©ä¸ŠãŒã‚‰ãªã„ master 1å°ã§ã™ã¹ã¦ã®ã‚¯ã‚¨ãƒªã‚’å‡¦ç†ã™ã‚‹å ´åˆã¨æ¯”ã¹ã¦ã€å¯ç”¨æ€§ãŒè½ã¡ã‚‹å¼•ãæ›ãˆã¨ã—ã¦è¦‹åˆã£ãŸæ€§èƒ½å‘ä¸ŠãŒå¾—ã‚‰ã‚Œã‚‹ã‹ã€ã¨ã„ã†
monomoti 2011/06/20
ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å‚ç…§ç³»ã«ä½¿ã†ãªã‚‰è¤‡æ•°å°ã§ã€‚ãƒ¡ãƒ¢ã€‚

mysql

é‹ç”¨

database

server
ãƒªãƒ³ã‚¯
å¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ é–‹ç™ºã‹ã‚‰å¦ã‚“ã PHPï¼†MySQLå®Ÿè·µãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
OSC 2011 Hokkaidoã®ç™ºè¡¨ã§ä½¿ç”¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰è³‡æ–™ã§ã™ã€‚ å¼Šç¤¾ãŒã€Œãƒ–ãƒ©ã‚¦ã‚¶ä¸‰å›½å¿—ã€ã‚„ã€Œè‹±é›„ã‚¯ã‚¨ã‚¹ãƒˆã€ã¨ã„ã£ãŸã‚²ãƒ¼ãƒ ã‚’ã€PHPï¼‹MySQLã§æ§‹ç¯‰ã—ã¦ããŸä¸Šã§ã€èº«ã«ã¤ã‘ãŸãƒŽã‚¦ãƒã‚¦ã‚„ã€æ³¨æ„ã™ã¹ãç®‡æ‰€ã€æŒ‡é‡ãªã©ã‚’ã¾ã¨ã‚ãŸè³‡æ–™ã¨ãªã£ã¦ã„ã¾ã™ã€‚Read less
monomoti 2011/06/16
*ã‚ã¨ã§èªã‚€

php

mysql

web

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ

webé–‹ç™º

é–‹ç™º
ãƒªãƒ³ã‚¯
NoSQLã¨ã—ã¦MySQLã‚’ä½¿ã†DeNAãŒã€memcachedã‚ˆã‚Šã‚‚é«˜é€Ÿãª75ä¸‡ã‚¯ã‚¨ãƒªï¼ç§’ã‚’å®Ÿç¾
ãƒ¢ãƒã‚²ãƒ¼ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«NoSQLã‚’ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãªãœã‹ï¼Ÿ ãã‚Œã¯MySQL/InnoDB 5.1ã®ç’°å¢ƒã§ç§’é–“75ä¸‡ã‚¯ã‚¨ãƒªã¨ã„ã†ã€å¤šãã®NoSQLã§ã‚‚å®Ÿç¾ã§ããªã„ã‚ˆã†ãªé«˜æ€§èƒ½ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ã‚‰ã€‚DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ã¯ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã«ã“ã‚“ãªå†…å®¹ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverã€ï¼ˆè‹±èªžï¼‰ã‚’ãƒœã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
monomoti 2011/06/09
memcached

nosql

mysql

Database
ãƒªãƒ³ã‚¯
Twitterã«ãŠã‘ã‚‹å¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã€3ã¤ã®åŽŸå‰‡
4æœˆã«ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§è¡Œã‚ã‚ŒãŸMySQL Confernce & Expo 211ã§ã¯ã€Twitterã®Jeremy Coleæ°ãŒã€ŒBig and Small Data at @Twitterã€ã¨é¡Œã—ã¦ã€åŒç¤¾ã®ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹åŽŸå‰‡ã¨ã‚·ã‚¹ãƒ†ãƒ æ§‹æˆã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ 1æ—¥ã«1å„„5000ä¸‡ä»¥ä¸Šã®ãƒ„ã‚¤ãƒ¼ãƒˆãŒè¡Œã‚ã‚Œã¦ã„ã‚‹Twitterã®ã‚·ã‚¹ãƒ†ãƒ ã¯ã©ã®ã‚ˆã†ã«æ§‹ç¯‰ã•ã‚Œã¦ã„ã‚‹ã®ã‹ã€ãã®å†…å®¹ã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ Twitterã«ãŠã‘ã‚‹åŽŸå‰‡ Twitterã®Jeremy Coleæ°ã€‚
monomoti 2011/05/26
mysql

è¨è¨ˆ

db

ã‚·ã‚¹ãƒ†ãƒ

å¤§è¦æ¨¡ã‚µãƒ¼ãƒ“ã‚¹

twitter
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯NoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸã€‚NewSQLã®ç™»å ´ã¨NoSQLã®çµ‚ã‚ã‚Šã€ã¨ã„ã†äºˆæƒ³ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨PostgreSQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã©ã®ã‚ˆã†ãªæ–°æ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã‚‹ã®ã‹ã€æ˜¨æ—¥ã€ä¸€æ˜¨æ—¥ã®2æœ¬ã®è¨˜äº‹ã§ç´¹ä»‹ã—ã¾ã—ãŸã€‚ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Memcached APIã‚’å‚™ãˆã‚‹ï¼ MySQL Conference & Expo 2011åŸºèª¿è¬›æ¼” PostgreSQLã®ç¾çŠ¶ã¨æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³9.1ã®æ–°æ©Ÿèƒ½ã€‚MySQL Conference & Expo 2011 ã“ã®2ã¤ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«å…±é€šã—ã¦ã„ã‚‹ã®ãŒã€NoSQLã®æ©Ÿèƒ½ã‚’å–ã‚Šè¾¼ã‚“ã§ã„ã‚‹ã“ã¨ã§ã™ã€‚NoSQLã«å¯¾ã™ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚ˆã‚‹åæ’ƒãŒå§‹ã¾ã£ã¦ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒNoSQLã‚’å–ã‚Šè¾¼ã¿å§‹ã‚ãŸ MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã‚‹MySQL 5.6ã«æè¼‰äºˆå®šã®æ–°æ©Ÿèƒ½ã®1
monomoti 2011/04/20
memcached

NoSQL

database

mysql

postgresql
ãƒªãƒ³ã‚¯
1