[B! MySQL] ZAORIKUã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ZAORIKU id:ZAORIKU

MySQLã«é–¢ã™ã‚‹ZAORIKUã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (31)

${{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 with InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã‚ã‚ŠãŒã¡ãªé–“é•ã„ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºéƒ¨ã®è’å¼• (@a_bicky) ã§ã™ã€‚ çªç„¶ã§ã™ãŒã€RDBMS ã®æ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¦‹ã¦ã¿ãŸã‚‰ã€Œä½•ã§ã“ã‚“ãªã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã ã‚‰ã‘ãªã®ï¼Ÿã€ã¿ãŸã„ãªçµŒé¨“ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿä¸è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å®¹é‡ã‚’åœ§è¿«ã—ãŸã‚Šã€æŒ¿å…¥ãŒé…ããªã£ãŸã‚Šã¨è‰¯ã„ã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ãã‚“ãªã‚ã‘ã§ã€ä»Šå›žã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã€ã‚ˆãè¦‹ã‹ã‘ã‚‹ä¸é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯ Rails ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä¸»ã« MySQL 5.6ã€MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ä¸»ã« InnoDB ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã€MySQL 5.6 ã® InnoDB ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«é–¢ã™ã‚‹åŸºç¤ŽçŸ¥è˜ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹é€ (B+ æœ¨) InnoDB ã§ã¯ B+ æœ¨ãŒä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚B+ æœ¨ã¯æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ã‚’æŒã£ãŸæœ¨æ§‹é€ ã§ã™ã€‚ æ¬¡æ•°ã‚’ b ã¨ã™ã‚‹ã¨ã€
ZAORIKU 2017/04/18
mysql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› - NAVER ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
ZAORIKU 2014/12/05
mysql

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
MySQLã«ç”»åƒãƒ‡ãƒ¼ã‚¿ã®ãƒ‘ã‚¹ã‚’ä¿å˜ã™ã‚‹ç†ç”±ã‚’æ•™ãˆã¦ä¸‹ã•ã„ã€‚ - ã‚ã‚‹PHPã®æœ¬ã«MySQLã«ç”»åƒãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã®ã§ã¯ãªãã€... - Yahoo!çŸ¥æµè¢‹
MySQLã«ç”»åƒãƒ‡ãƒ¼ã‚¿ã®ãƒ‘ã‚¹ã‚’ä¿å˜ã™ã‚‹ç†ç”±ã‚’æ•™ãˆã¦ä¸‹ã•ã„ã€‚ ã‚ã‚‹PHPã®æœ¬ã«MySQLã«ç”»åƒãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã®ã§ã¯ãªãã€ç”»åƒãƒ‡ãƒ¼ã‚¿ã®ãƒ‘ã‚¹ã‚’ä¿å˜ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¦ãŸã®ã§ã™ãŒã€ç”»åƒãƒ‡ãƒ¼ã‚¿ã‚’ç›´æŽ¥ä¿å˜ã—ãªã„ç†ç”±ãŒåˆ†ã‹ã‚Šã¾ã›ã‚“ã€‚MySQLã«ç”»åƒã‚’ç›´æŽ¥ä¿å˜ã™ã‚‹äº‹ã¨ãƒ‘ã‚¹ã‚’ä¿å˜ã™ã‚‹äº‹ã®ã€ãã‚Œãžã‚Œã®ãƒ¡ãƒªãƒƒãƒˆã¨ãƒ‡ãƒ¡ãƒªãƒƒãƒˆã‚’æ•™ãˆã¦ä¸‹ã•ã„ã€‚ è‡ªåˆ†ã¯ã€ç”»åƒæŽ²ç¤ºæ¿ã®æ§˜ãªã‚µã‚¤ãƒˆã®ä½œæˆã‚’è€ƒãˆã¦ã‚‹ã®ã§ã™ãŒã€å‡ºæ¥ã‚‹ã ã‘ã‚·ãƒ³ãƒ—ãƒ«ã§ç”»åƒã®è¡¨ç¤ºãŒé€Ÿãè»½ã„ã‚µã‚¤ãƒˆã‚’ä½œã‚ŠãŸã„ã¨è€ƒãˆã¦ã¾ã™ã€‚ç”»åƒã¯èª°ã‚‚ãŒé–²è¦§ã§ãã‚‹ä¸€èˆ¬çš„ãªç”»åƒæŽ²ç¤ºæ¿ã§ã™ã€‚ åˆå¿ƒè€…ã§ã™ã®ã§ã€æ„å‘³ä¸æ˜Žãªæ–‡ç« ã«ãªã£ã¦ã‚‹ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ãŒã€ã©ã†ã‹æ•™ãˆã¦ä¸‹ã•ã„ã€‚ãŠé¡˜ã„ã—ã¾ã™ã€‚
ZAORIKU 2013/12/20
ç”»åƒ

DB

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

mysql
ãƒªãƒ³ã‚¯
ã¿ã™ã¨ã‚‹ã¦ãƒã‚“: PHPã¨MySQLã®æŽ¥ç¶šæ–¹æ³•æ¯”è¼ƒ
2012å¹´7æœˆ13æ—¥é‡‘æ›œæ—¥ PHPã¨MySQLã®æŽ¥ç¶šæ–¹æ³•æ¯”è¼ƒ ç„¡é™Excelåœ°ç„ã£ã¦æ€–ã„ã§ã™ãã€ã¿ã™ã¨ã§ã™ã€‚ ä¹…ã—ã¶ã‚Šã«PHP+MySQLã‚’è§¦ã£ã¦ã„ã¦ã€ã¯ã‚‹ã‹éŽåŽ»ã®è¨˜æ†¶ã‚’ã»ã˜ãã£ã¦ mysql_connect() ã‚’ä½¿ã£ã¦ã„ãŸã‚‰ã€ ä»Šã˜ã‚ƒéžæŽ¨å¥¨ãªã‚“ã§ã™ãã€‚ mysqlé–¢æ•°ã«å¤‰ã‚ã‚‹ã‚‚ã®ã¨ã—ã¦mysqlié–¢æ•°ã¨PDOé–¢æ•°ãŒã‚ã‚Šã¾ã™ãŒã€å…¨éƒ¨ã¾ã¨ã‚ã¦æ›¸ã„ã¦ã„ã‚‹ã‚µã‚¤ãƒˆãŒè¦‹å½“ãŸã‚‰ãªã‹ã£ãŸã®ã§ã€å‚™å¿˜éŒ²ä»£ã‚ã‚Šã«æ›¸ã„ã¦ãŠãã“ã¨ã«ã—ã¾ã—ãŸã€‚ MySQLã«æŽ¥ç¶šã—ã€SELECTåˆ†ã‚’å®Ÿè¡Œã—ã€è¡¨ç¤ºã•ã›ã‚‹ã€ã¨ã„ã†ä¸€é€£ã®å‹•ä½œã§ã®æ›¸å¼æ¯”è¼ƒã§ã™ã€‚ã¨ã‚Šã‚ãˆãšèª¿ã¹ãŸã¨ã„ã†ç¨‹åº¦ã§ã‚»ã‚ãƒ¥ã‚¢ã«ã‚‚ãªã£ã¦ã„ãªã„ã®ã§ã€å‚è€ƒã«ã™ã‚‹éš›ã¯ã”æ³¨æ„ãã ã•ã„ mysqlé–¢æ•°(éžæŽ¨å¥¨) å¤ãã‹ã‚‰PHPã‚’ä½¿ã£ã¦ã„ã‚‹äººã¯ç„¡æ„è˜ã«ä½¿ã£ã¦ã—ã¾ã†é–¢æ•°ã§ã™ãã€‚ ä½•ãŒå•é¡Œã‹ã£ã¦ã€ã¾ã å»ƒæ¢ã«ãªã£ã¦ã„ãªã„ã®ã§ã€æ™®é€šã«å‹•ã„ã¡ã‚ƒã†ã¨ã“ã‚ã§ã—ã‚‡ã†ã‹ã€‚ //æŽ¥ç¶š $link
ZAORIKU 2013/12/07
php

mysql
ãƒªãƒ³ã‚¯
Kirishiki Studios
å€‹äººäº‹æ¥ä¸»ã¨ã—ã¦ã‚‚æ´»å‹•ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®å±±ç”°ç›´è¡Œã®å€‹äººãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã§ã™ã€‚ äº‹æ¥ç´¹ä»‹ãƒ»è‡ªå·±ç´¹ä»‹ã¯ã“ã¡ã‚‰ -> About Posts Feb 24, 2025 å€‹äººãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‚’å°‘ã—ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ« Feb 24, 2025 Welcome to Jekyll! subscribe via RSS
ZAORIKU 2013/02/24
python

mysql
ãƒªãƒ³ã‚¯
Windowsç”¨XAMPPã®UTF-8åŒ–
çŽ„ç®±WEBã‚µãƒ¼ãƒã®ç¢ºèªç”¨ã§ã‚ã‚‹XAMPPã‚’UTF-8ãƒ™ãƒ¼ã‚¹ã«å¤‰æ›´ã—ã¾ã—ãŸã€‚ãƒãƒƒãƒˆã§èª¿ã¹ãªãŒã‚‰ã€è©¦è¡ŒéŒ¯èª¤ã—ã¦ã‚ˆã†ã‚„ãã§ãã¾ã—ãŸã®ã§ã€ç´¹ä»‹ã—ã¾ã™ã€‚æã‚‰ãã€XAMPPã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒé•ã†ã¨ã€å¤šå°‘é•ã£ã¦ãã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã®ã§ã€é©å®œå‚è€ƒã«ã—ã¦ãã ã•ã„ã€‚ç§ã®ç’°å¢ƒã¯ã€OSãŒWindowsXPã§ã€2007å¹´5æœˆç¾åœ¨ã®æœ€æ–°ç‰ˆXAMPP1.6.1ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚ä¸»ãªã‚½ãƒ•ãƒˆã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ã€æ¬¡ã®é€šã‚Šã§ã™ã€‚ Apache 2.2.4 PHP 5.2.1 MySQL 5.0.37 phpMyAdmin 2.10.02 PHPã®è¨å®šï¼ˆphp.iniï¼‰ ã¾ãšã€php.iniã®ä¿®æ£ã§ã™ã€‚ã“ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯C:\xampp\apache\binã«ã‚ã‚Šã¾ã™ã€‚ã€ŒWindowsç”¨XAMPPå°Žå…¥ã€ã®ãƒšãƒ¼ã‚¸ã§ã¯ã€EUC-JPã‚„SJISã‚’è¨å®šã—ã¦ã„ã¾ã—ãŸãŒã€ã“ã‚Œã‚‰ã‚’UTF-8ã«å…¥ã‚Œæ›¿ãˆã¾ã™ã€‚ output_buffering
ZAORIKU 2013/02/19
UTF8

php

xampp

mysql
ãƒªãƒ³ã‚¯
EXCELã§ä½œæˆã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’mySQLã«å–ã‚Šè¾¼ã‚‚ã†ã¨ã€csvå½¢å¼ã§ä¿å˜ã—ã¾ã—ãŸã€‚â€¦
EXCELã§ä½œæˆã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’mySQLã«å–ã‚Šè¾¼ã‚‚ã†ã¨ã€csvå½¢å¼ã§ä¿å˜ã—ã¾ã—ãŸã€‚ ä¿å˜ã—ãŸå¾Œã¯ãƒ¡ãƒ¢å¸³ã§é–‹ã„ã¦ã€æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’utf-8ã«å¤‰æ›´ã—ã¦å†åº¦ä¿å˜ã—ã¾ã—ãŸã€‚ ä¸€æ–¹XAMPPã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸphpMYadminã§studyãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ–°è¦ã«ä½œæˆã—ã¾ã—ãŸã€‚ test1ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¦ã€idï¼ˆINTï¼‰ã€urlï¼ˆTEXTï¼‰ã€title(TEXT)ã€category(TEXT)ã€hatena(TEXT)ã€point(TEXT)ã€since(DATE)ã€latest(DATE)ã‚’å…¥åŠ›ã—ã¾ã—ãŸã€‚ ã‚¤ãƒ³ãƒãƒ¼ãƒˆ->ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã®å½¢å¼ã‚’CSVã€ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã®ä½ç½®ã§è©²å½“ã™ã‚‹csvã‚’å‚ç…§ã—ã¦ã€æ–‡å—ã‚»ãƒƒãƒˆã‚’utf-8ã«è¨å®šã—ã¾ã—ãŸã€‚ ã“ã®çŠ¶æ³ã§ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ãŸã¨ã“ã‚ã€CSV å…¥åŠ›ã®ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰æ•°ãŒä¸æ£ã§ã™ (è¡Œ: 1)ã¨è¡¨ç¤ºã•ã‚Œã¾ã—ãŸã€‚ è‡ªåˆ†ã§ã‚‚ã„ã‚ã„ã‚åŽŸå› ã‚’è€ƒãˆã¦ã¿ã¾ã—ãŸãŒã€è§£æ±ºæ–¹æ³•ãŒã‚ã‹ã‚Š
ZAORIKU 2013/02/14
mysql

excel
ãƒªãƒ³ã‚¯
apache friends - xampp
Hi Apache Friends! We just released a new version of XAMPP for Windows for PHP versions 8.2.12, 8.1.25 and 8.0.30. New versions for Linux and OS X will come soon! You can download these new installers... Read moreÂ Â» About Apache Friends Apache Friends is a non-profit project to promote the Apache web server and is home to the XAMPP project. XAMPP is an easy to install Apache distribution containin
ZAORIKU 2013/02/09
php

xampp

MySQL

apache

mysql
ãƒªãƒ³ã‚¯
ã€Œã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã€ãªè¦æ¨¡ã®ãƒ‡ãƒ¼ã‚¿ã‚¯ãƒ©ã‚¹ã‚¿ãƒ¼ä¸Šã§ã®ãƒ‡ãƒ¼ã‚¿è§£æžå‡¦ç† Â« NAVER Engineers' Blog
ä»Šå¹´ã¯ã•ã ã¾ã•ã—ã•ã‚“ã®ãƒ‡ãƒ“ãƒ¥ãƒ¼40å‘¨å¹´ã¨ã„ã†ã“ã¨ã§ã€è¨˜å¿µã‚³ãƒ³ã‚µãƒ¼ãƒˆã€Œã•ã ã¾ã¤ã‚Šã€ã‚‚çµ¶è³›é–‹å‚¬ä¸ã®æŠ˜ã‚‚æŠ˜ã€æ®‹æš‘ã‚‚åŽ³ã—ã„ä¸çš†æ§˜ã„ã‹ãŒãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ã€‚å¤§å¹³ã§ã™ã€‚ ã•ã ã¾ã•ã—æ°ã¯çµŒé¨“ã®è±Šå¯Œãªæ–¹ã§ã™ã®ã§å½¼ã®æŒã‚„ç™ºè¨€ã‹ã‚‰å¦ã¶ã“ã¨ã¯å¤§å¤‰å¤šã„ã®ã§ã™ãŒã€å€‹äººçš„ã«éžå¸¸ã«æ„ŸéŠ˜ã‚’å—ã‘ã¦ã„ã‚‹ã®ã¯ã€ŒæŒã¯ã‚³ãƒ³ã‚µãƒ¼ãƒˆã§æˆé•·ã™ã‚‹ã€ã¨ã„ã†è¨€è‘‰ã§ã™ã€‚æŒã„æ‰‹ã¨ã—ã¦ã€ã€ŒæŒã€ã¨ã„ã†ä½œå“ã‚’ä½œã£ã¦å…¬é–‹ãƒ»è²©å£²ã™ã‚‹ã ã‘ãŒä»•äº‹ã§ã¯ãªãã€å®Ÿéš›ã«ã‚³ãƒ³ã‚µãƒ¼ãƒˆãªã©ã§ãŠå®¢ã•ã‚“ã«å±Šã‘ã€ãŠå®¢ã•ã‚“ã®åå¿œã‚’å‚è€ƒã«ã—ãŸã‚Šæ—¥ã€…ã®æ¼”å¥æ´»å‹•ã®ä¸ã§è©¦è¡ŒéŒ¯èª¤ã‚’ç¹°ã‚Šè¿”ã—ã¦ã€å†…å®¹ã‚’ãƒ–ãƒ©ãƒƒã‚·ãƒ¥ã‚¢ãƒƒãƒ—ã—æ´—ç·´ã•ã›ã¦ã„ãéŽç¨‹ã‚’æŒ‡ã—ã¦å…ˆã®è¨€è‘‰ãŒã‚ã‚‹ã®ã ã¨æ€ã„ã¾ã™ã€‚å®Ÿéš›ã«ã•ã ã¾ã•ã—æ°ã®æ›²ã¯CDã«åŽéŒ²ã•ã‚Œã¦ã„ã‚‹ã‚‚ã®ã¨å®Ÿéš›ã«ãƒ©ã‚¤ãƒ–ã§æ¼”å¥ã•ã‚Œã‚‹ã‚‚ã®ã¨ã§ã‚¢ãƒ¬ãƒ³ã‚¸ãŒå¤§ããç•°ãªã‚Šã€ã‹ã¤ä½œå“ã¨ã—ã¦ã‚‚è³ªãŒå‘ä¸Šã—ã¦ã„ã‚‹ã‚‚ã®ãŒå°‘ãªã‹ã‚‰ãšå˜åœ¨ã—ã¾ã™ã€‚ â€¦ã‚ã¾ã‚Šã•ã ã¾ã•ã—ã®è©±ã‚’ç¶šã‘ã‚‹ã¨æœ¬å½“ã«ä¸Šé•·ã«å±ã‚‰ã‚Œã¾ã™ã®
ZAORIKU 2012/09/13
Hadoop

NAVER

LINE

mysql
ãƒªãƒ³ã‚¯
MySQLã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¨ç”ŸPHPã«ã‚ˆã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ¯”è¼ƒ
çš†ã•ã‚“ã€ã“ã‚“ã°ã‚“ã¯ã€‚ç¬¹äº€ã§ã™ã€‚ 7æœˆã‚‚ã‚ã£ã¨ã„ã†é–“ã«10æ—¥é–“ãŒéŽãŽã¦ã€å¤çœŸã£ç››ã‚Šã«ãªã£ã¦ãã¾ã—ãŸã€‚ è‡ªåˆ†ã‚‚å¤å¯¾ç–ã§ã‚¢ã‚¤ã‚¹çœ ã¨ã„ã†ãƒžãƒƒãƒˆãƒ¬ã‚¹ã‚’è³¼å…¥ã—ã¦å¤ã‚’ä¹—ã‚Šè¶Šãˆã‚ˆã†ã¨æ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ ã•ã¦ã€æœ¬æ—¥ã¯ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã«ã¤ã„ã¦æ¤œè¨¼ã‚’ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¨ã¯ã€ä¸€é€£ã®SQLæ–‡ã‚„å‡¦ç†ã«åå‰ã‚’ã¤ã‘ã¦ä¿å˜ã—ãŸã‚‚ã®ã§ã™ã€‚ PHPã®é–¢æ•°ã¨åŒã˜ã§SQLã‚’é–¢æ•°ã¿ãŸã„ã«ã—ãŸã‚‚ã®ãŒã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã«ãªã‚Šã¾ã™ã€‚ MySQLã§ã¯ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¯MySQLã§ã¯5.0ã‹ã‚‰åˆ©ç”¨ãŒå¯èƒ½ã§ã™ã€‚ ä»Šå›žã¯MySQLã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®ä½¿ã„æ–¹ã ã‘ã§ã¯ãªãã€ ç”ŸPHPã§è¨˜è¼‰ã—ãŸã¨ãã¨ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ¯”è¼ƒã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ MySQLã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’å‘¼ã³å‡ºã—ã¦å‡¦ç†ã‚’ã™ã‚‹PHPãƒ—ãƒã‚°ãƒ©ãƒ ã¨ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§ä½œæˆã—ãŸã‚‚ã®ã¨åŒã˜SQLã‚’å®Ÿè¡Œã™ã‚‹PHPãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä½œæˆã—ã¾ã™ã€‚ ä¸Šè¨˜ï¼’ã¤ã®ãƒ—
ZAORIKU 2012/07/12
MySql

PHP

æ¯”è¼ƒ
ãƒªãƒ³ã‚¯
Microsoft PowerPoint - oracle_mysql_design_publish.ppt
1 Oracle Database MySQL ( ) Oracle OpenWorld Unconference presented by JPOUG 2012/04/06 2 â€¢ DB Oracle MySQL â€“ RDBMS â€“ Oracle MySQL 8 2 â€¢ Twitter @sh2nd â€¢ id:sh2 â€¢ 3 â€¢ Oracle Database MySQL â€¢ Oracle Database MySQL â€¦ â€¢ MySQL Oracle Database â€¦ 4 MySQL 5 MySQL â€¢ 2001/01 MySQL 3.23 RHEL 2.1/3 â€¢ 2003/03 MySQL 4.0 UNION â€¢ 2004/10 MySQL 4.1 4.1.12 Windows Shift_JIS (Microsoft Code Page 932) RHEL 4 â€¢ 2005/
ZAORIKU 2012/04/24
MySQL

mysql

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

pdf
ãƒªãƒ³ã‚¯
ãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ã€ã€ŒMySQLã€ã®æ‹¡å¼µæ€§ã‚’é«˜ã‚ã‚‹|ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹|ãƒˆãƒ”ãƒƒã‚¯ã‚¹|Computerworld
ãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ã€ã€ŒMySQLã€ã®æ‹¡å¼µæ€§ã‚’é«˜ã‚ã‚‹ã‚½ãƒ¼ã‚¹ãƒ»ã‚³ãƒ¼ãƒ‰ã‚’ãƒªãƒªãƒ¼ã‚¹ ã€ŒNoSQLã€ãƒ¬ãƒ™ãƒ«ã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’å®Ÿç¾ã™ã‚‹MySQLé–¢é€£ã®ã‚½ãƒ¼ã‚¹ãƒ»ã‚³ãƒ¼ãƒ‰ãŒç„¡æ–™ã§åˆ©ç”¨å¯èƒ½ã« ç±³å›½TwitterãŒç‹¬è‡ªé–‹ç™ºã—ãŸã€ŒMySQLã€é–¢é€£ã®ã‚½ãƒ¼ã‚¹ãƒ»ã‚³ãƒ¼ãƒ‰ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€‚ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã§ã‚ã‚‹MySQLã«ã€ã“ã‚Œã¾ã§ä»¥ä¸Šã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’ã‚‚ãŸã‚‰ã™ã‚‚ã®ã«ãªã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã€‚ Twitterã¯ã€MySQLã‚’åˆ©ç”¨ã™ã‚‹æœ€å¤§è¦æ¨¡ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®1ç¤¾ã€‚åŒç¤¾ã¯MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ä½¿ã£ã¦ã€1å„„4,000ä¸‡äººã«ã®ã¼ã‚‹Twitteråˆ©ç”¨è€…ãŒç”Ÿã¿å‡ºã™ãƒ‡ãƒ¼ã‚¿ã‚’ä¿ç®¡ã—ã¦ã„ã‚‹ã€‚ Twitterã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã€ã‚¸ã‚§ãƒ¬ãƒŸãƒ¼ãƒ»ã‚³ãƒ¼ãƒ«ï¼ˆJeremy Coleï¼‰æ°ã¨ãƒ€ãƒ´ã‚£ãƒ»ã‚¢ãƒ«ãƒŠã‚¦ï¼ˆDavi Arnauï¼‰æ°ã¯ã€ã‚‚ã¨ã‚‚ã¨TwitterãŒè‡ªç¤¾ã§åˆ©ç”¨ã™ã‚‹ãŸã‚ã«é–‹ç™ºã—ãŸå¤šæ•°ã®MySQLé–¢é€£ã‚½ãƒ¼ã‚¹ãƒ»ã‚³ãƒ¼ãƒ‰ã®ãƒªãƒª
ZAORIKU 2012/04/12
Twitter

mysql
ãƒªãƒ³ã‚¯
Twitterç‰ˆMySQLã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦å…¬é–‹
4æœˆ9æ—¥(ç±³å›½æ™‚é–“)ã€Twitterã¯MySQL 5.5ã«ç‹¬è‡ªã®æ©Ÿèƒ½å¼·åŒ–ã‚’è¡Œã£ãŸã€ŒTwitter MySQL 5.5ã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦å…¬é–‹ã—ãŸã€‚Twitterã§ã¯ã€ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã‚„ãƒ¦ãƒ¼ã‚¶ãƒ‡ãƒ¼ã‚¿ã€ã‚¤ãƒ³ã‚¿ãƒ¬ã‚¹ãƒˆã‚°ãƒ©ãƒ•ã€ãƒ„ã‚¤ãƒ¼ãƒˆãªã©ã‚’MySQLã§ç®¡ç†ã—ã¦ãŠã‚Šã€Twitter MySQLã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã‚ã‚‹MySQLã«å¯¾ã—ã¦ã€Twitterã®é–‹ç™ºè€…ãŒãƒ‹ãƒ¼ã‚ºã«åˆã‚ã›ã¦ç‹¬è‡ªã®æ”¹è‰¯ã‚’è¡Œã£ãŸã‚‚ã®ã ã¨ã—ã¦ã„ã‚‹ã€‚ Twitter MySQL 5.5ã§å¼·åŒ–ã‚„æ”¹è‰¯ã•ã‚ŒãŸæ©Ÿèƒ½ã¯æ¬¡ã®ã¨ãŠã‚Šã€‚ InnoDBå†…éƒ¨ã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹å¤‰æ•°ã®è¿½åŠ NUMAã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®ãƒ¡ãƒ¢ãƒªå‰²ã‚Šå½“ã¦ã®æœ€é©åŒ– ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã‚µãƒãƒ¼ãƒˆã®æ”¹å–„ InnoDBãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆåŠã³ãƒªã‚¹ãƒˆã‚¢ SSDå‘ã‘ã®æœ€é©åŒ– InnoDBå†…éƒ¨ã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹å¤‰æ•°ã®è¿½åŠ ã§ã¯ã€InnoDBãƒ•ã‚¡ã‚¤ãƒ«åŠã³ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«
ZAORIKU 2012/04/12
MySQL

Twitter

é–‹ç™º
ãƒªãƒ³ã‚¯
MySQLãŒãŠã‹ã—ã„ï¼ã‚ãªãŸãªã‚‰ã©ã†ã—ã¾ã™ã‹ï¼Ÿ â€“ MySQL Casual Advent Calendar 2011 - As a Futurist...
ã—ã‚ã£ã™ï¼DBA å…¼ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å…¼ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚„ã£ã¦ã‚‹ riywo ã§ã™ã€‚ä½•ã®ãƒã‚¿ã‚’æ›¸ã“ã†ã‹ãªãã¨è€ƒãˆãŸã®ã§ã™ãŒã€æ£ç›´ãƒã‚¿ã‚’ä»•è¾¼ã‚€æ™‚é–“ã‚‚ãªã‹ã£ãŸã®ã§åƒ•ãŒã„ã¤ã‚‚ã‚„ã£ã¦ã‚‹ã“ã¨ã‚’ã•ã‚‰ã£ã¨ç´¹ä»‹ã™ã‚‹ã¨ã„ã†ã“ã¨ã§å‹˜å¼ã—ã¦ä¸‹ã•ã„ï¼žï¼œ MySQL ãŒãŠã‹ã—ã„ï¼ 03:14 hidek: ãªã‚“ã‹ã‚¨ãƒ©ãƒ¼å‡ºã¾ãã£ã¦ã‚‹ã‚“ã ã‘ã©ï¼ 03:14 zigorou: MySQL ã¨é€šä¿¡ã—ã¦ã‚‹ã¨ã“ã£ã½ã„ 03:15 riywo: è¦‹ã¾ã™ ã“ã‚“ãªã‚„ã‚Šã¨ã‚Šã¯çš†ã•ã‚“æ—¥å¸¸èŒ¶é£¯äº‹ã§ã™ã‚ˆãï¼Ÿãï¼Ÿãï¼Ÿã“ã‚“ãªæ™‚ã«ã€DB ã«è²¬ä»»ã‚’æŒã¤ã‚‚ã®ã¨ã—ã¦çœŸã£å…ˆã«å¯¾å¿œã™ã‚‹ã®ãŒåƒ•ã‚‰ã®ä»•äº‹ã§ã™ã€‚ã§ã‚‚ã€ã˜ã‚ƒã‚å…·ä½“çš„ã«ã“ã®ã‚ã¨ä½•ã‚’ã—ã¾ã—ã‚‡ã†ï¼Ÿæ—¢ã«ã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¨ãƒ©ãƒ¼ã ã‚‰ã‘ã§ä¸€åˆ»ã‚’äº‰ã†çŠ¶æ…‹ã§ã™ã€‚ (å¯¾å¿œé–‹å§‹) ã¾ãšã¯ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ ä»Šå›žã®æ§˜ãªå ´åˆã¯ã‚¢ãƒ—ãƒªã®ã‚¨ãƒ©ãƒ¼ãƒã‚°ã«ã©ã°ã£ã¨ MySQL ã«é–¢ã™ã‚‹ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ã¾ãšã¯ãã‚Œã‚’è¦‹ã‚‹ã“ã¨ãŒå§‹ã¾
ZAORIKU 2011/12/03
MySQL

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

db
ãƒªãƒ³ã‚¯
ã€MySQLã€‘ãƒ‰ãƒ¯ãƒ³ã‚´æŠ€è¡“å‹‰å¼·ä¼š(2)ã€ã¯ã˜ã¾ã£ãŸã€‘
ãŠå¾…ãŸã›ã—ã¾ã—ãŸï¼(å®Ÿã«åŠå¹´ã¶ã‚Šã®)ãƒ‰ãƒ¯ãƒ³ã‚´æŠ€è¡“å‹‰å¼·ä¼šç”Ÿæ”¾é€ç¬¬2å›žã§ã™ï¼ ä»Šå›žã¯ã¿ã‚“ãªå¤§å¥½ãMySQLã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã«ã¤ã„ã¦ã€ã‚‚ã‚Šã‚‚ã‚Šå‹‰å¼·ã—ã¾ã™ã€‚ Spider Storage Engineã§æœ‰åãªã‚ã®ã²ã¨ã‚„ã€ãƒ‹ã‚³ãƒ‹ã‚³å¤§ç™¾ç§‘ã‚’ä½œã£ãŸã‚ã®ã²ã¨ãªã©ã€è±ªè¯ãªã‚²ã‚¹ãƒˆã«ã‚‚ãŠè¶Šã—ã„ãŸã ãã¾ã—ãŸï¼ ãƒ‰ãƒ¯ãƒ³ã‚´ã‹ã‚‰ã¯ã€æ‰æ°—æº¢ã‚Œã‚‹æ–°å’ç¤¾å“¡é”ãŒç™ºè¡¨ï¼LTã§ã¯æœ€è¿‘å™‚ã®å½¼ã‚‚ç™»å ´ã—ã¾ã™ï¼ â˜†ã‚¿ã‚¤ãƒ ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ« 18:30 é–‹å ´ 18:45 æŒ¨æ‹¶ 18:50 åŸºèª¿è¬›æ¼” 19:00 MySQL pluginã«ã¤ã„ã¦(ãƒ‰ãƒ¯ãƒ³ã‚´/é¬¼æµ·/æ˜Ÿé‡Ž/ä¸æ‘) 20:00 Spiderã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³(ãƒãƒ¼ãƒ ãƒ©ãƒœ/æ–¯æ³¢æ§˜) 21:00 LT(ãƒ‰ãƒ¯ãƒ³ã‚´/é³¥å±…) 21:10 MySQLã‚’é€šã˜ãŸå…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³Senna/Groongaã®åˆ©ç”¨ã«ã¤ã„ã¦(ãƒ–ãƒ©ã‚¸ãƒ«/æœ«æ°¸æ§˜) 22:00 çµ‚äº†
ZAORIKU 2010/12/07
MySQL

å‹•ç”»
ãƒªãƒ³ã‚¯
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 æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
ZAORIKU 2010/10/27
nosql

DeNA

MySQL

Database
ãƒªãƒ³ã‚¯
MySQLã§TF-IDFã®è¨ˆç®—ã€ã‚ã¨2ã¤ã®ãƒ™ã‚¯ãƒˆãƒ«ã®å†…ç©ã®è¨ˆç®— (2006-12-19)
æœ¬æ–‡ã‚’å½¢æ…‹ç´ åˆ†è§£ã—ã€å¿…è¦ãªå“è©žã‚’tfãƒ†ãƒ¼ãƒ–ãƒ«ã¨dfãƒ†ãƒ¼ãƒ–ãƒ«ã«å…¥ã‚Œã‚‹ã€‚åˆ†æžå¯¾è±¡ã¨ãªã‚‹æ–‡æ›¸ç¾¤ã™ã¹ã¦ã«ã¤ã„ã¦ã“ã®å‡¦ç†ã‚’è¡Œã„ã€å„å½¢æ…‹ç´ ã®TF-IDFå€¤ã‚’æ±‚ã‚ã¦æ–‡æ›¸ã‚’ãƒ™ã‚¯ãƒˆãƒ«åŒ–ã™ã‚‹ã€‚ä»–ã®æ–‡æ›¸ãƒ™ã‚¯ãƒˆãƒ«ã¨å†…ç©ã‚’æ¯”è¼ƒã—ã€å°ã•ã„é †ã«ã€Œä¼¼ã¦ã„ã‚‹è¨˜äº‹ã€ã‚’æ±‚ã‚ãŸã„ (ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã¨ã‹ã¯åˆ¥é€”)ã€‚ Harmanã«ã‚ˆã‚‹TFå€¤ã®æ£è¦åŒ–ã¨Sparok Jonesã«ã‚ˆã‚‹DFå€¤ã®æ£è¦åŒ–ã‚’ã™ã‚‹å ´åˆã®TF-IDFå€¤ã®è¨ˆç®—å¼ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚‹ (å‚è€ƒæ–‡çŒ®): tfidf(i,j) = log2(freq(i,j) + 1) / log2(NoT) * (log2(N / Dfreq(i)) + 1)
ZAORIKU 2010/03/15
tf-idf

è‡ªç„¶è¨€èªžå‡¦ç†

å½¢æ…‹ç´ è§£æž

mysql

é¡žä¼¼åº¦
ãƒªãƒ³ã‚¯
å®ŸéŒ²ã€ã»ã¼ç„¡åœæ¢ãªMySQLã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒ (å‹•ç”»ã‚‚ã‚ã‚‹ã‚ˆ) - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ ã§ã‚‚æŽ²ã’ãŸã‚´ãƒ¼ãƒ«ã§ã‚ã‚‹ã€ã€Œãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ã€ãŒã»ã¼ã§ããŸã®ã§ã€ã»ã¨ã‚“ã©ã‚µãƒ¼ãƒ“ã‚¹ãŒåœæ¢ã™ã‚‹ã“ã¨ãªãã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã™ã‚‹æ§˜ã‚’ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚ãƒ£ã‚¹ãƒˆã«åŽã‚ã¾ã—ãŸã€‚ åŸ‹ã‚è¾¼ã¿ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã ã¨ã€å°ã•ãã¦ã‚ã‹ã‚‰ãªã„ã¨æ€ã†ã®ã§ã€ãƒªãƒ³ã‚¯ç›´æŽ¥ã§ã¿ã¦ãã ã•ã„ã€‚ http://www.irori.org/pub/mysql-mm.mov ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆ ç™»å ´ã™ã‚‹ãƒ›ã‚¹ãƒˆã¯2å°ã€db 901ã¨db902ã§ã™ã€‚ æœ€åˆã¯ã€db 901ãŒæ›´æ–°ç³»ã‚¯ã‚¨ãƒªã‚’å—ã‘ã‚‹ãƒ—ãƒ©ã‚¤ãƒžãƒªã§db900ã®æµ®å‹•IPã‚¢ãƒ‰ãƒ¬ã‚¹ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ ç”»é¢åˆ†å‰² ç”»é¢ã¯5åˆ†å‰²ã—ã¦ã„ã¾ã™ã€‚ å·¦ä¸Š = ã€Œselect sysdate(),@@server_idã€ã‚’db900ã«å¯¾ã—ã¦(sleep 1ã—ãªãŒã‚‰)å»¶ã€…ã¨å®Ÿè¡Œã—ã¾ãã‚Šã‚“ã å³ä¸Š = ping -n
ZAORIKU 2009/11/12
DB

mysql

ã‚µãƒ¼ãƒ
ãƒªãƒ³ã‚¯
ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã—ã¦ã‚‹MySQLã§ã€ãƒžã‚¹ã‚¿ã‚„ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒéšœå®³åœæ¢ã—ãŸå ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQLã§ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ™ãƒ¼ã‚¹ã®HAãªæ§‹æˆã«ã¤ã„ã¦è€ƒãˆãŸãƒ¡ãƒ¢ã§ã™ã€‚ 3å°(ã¨ã„ã†ã‹2å°ï¼‹1å°)ãŒã„ã„ã‹ãªãã¨æ€ã£ã¦ã„ã¦ã€å‰åŠã¯ãã®ç†ç”±ã‚’ã€å¾ŒåŠã§ã¯{ãƒžã‚¹ã‚¿,ã‚¹ãƒ¬ãƒ¼ãƒ–}ãŒ{å†èµ·ä¸èƒ½ã«ãªã£ãŸ,ã¡ã‚‡ã£ã¨ãƒ€ã‚¦ãƒ³ã—ã¦ã™ãå¾©å¸°ã—ãŸ}å ´åˆã®ãƒªã‚«ãƒãƒªãƒ—ãƒ©ãƒ³ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ ä»Šã®ã¨ã“ã‚ã¯ã“ã‚ŒãŒãƒ™ã‚¹ãƒˆã‹ãªã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ã€Œã“ã†ã—ãŸã»ã†ãŒã„ã„ã¨æ€ã†ï¼ã€ã€Œã“ã“ãŒãŠã‹ã—ã„ï¼ã€ãªã©ãªã©ã®ã”æ„è¦‹ã¯ã‚³ãƒ¡ãƒ³ãƒˆã€TBãªã©ã§ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ã‚´ãƒ¼ãƒ« ãƒžã‚¹ã‚¿ãŒè½ã¡ã¦ã‚‚ããƒ¼ã™ã‹å¯ã¦ã„ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã„ ãƒªã‚«ãƒãƒªã®ä½œæ¥ã¯ã§ãã‚‹ã ã‘å˜ç´”ã«ã€ã‹ã¤ã€çŸæ™‚é–“ã§å®Œäº†ã™ã‚‹ã‚ˆã†ã«ã—ãŸã„ ã‚ã‚“ã©ãã•ã„ã®ã¯ã„ã‚„ åŸºæœ¬æ§‹æˆã€æ–¹é‡ 2å°ï¼‹1å° ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã†ã®ã¯2å° (db1, db2) ã‚‚ã†1å°ã¯ç®¡ç†ç”¨ (db3) ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚’å¤šæ•°ä¸¦ã¹ã‚‹æ§‹æˆã«ã¯ã—ãªã„ å°æ•°å¢—ãˆã‚‹ã¨ç®¡ç†ã‚³ã‚¹ãƒˆãŒä¸ŠãŒã‚‹ ãƒžã‚¹ã‚¿ãƒ€ã‚¦ãƒ³æ™‚ã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒã¨ãã®ãƒ•ã‚§ã‚¤ãƒ«ãƒ
ZAORIKU 2009/10/25
ã‚µãƒ¼ãƒ

ç®¡ç†

MySQL

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

ã‚¯ãƒ©ã‚¦ãƒ‰
ãƒªãƒ³ã‚¯
FacebookãŒå¤§è¦æ¨¡ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¸ã®æŒ‘æˆ¦ã§å¦ã‚“ã ã“ã¨ï¼ˆå¾Œç·¨ï¼‰ï½žã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæŠ±ãˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®å•é¡Œã¨ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã‚‹ä¸€è²«æ€§
FacebookãŒå¤§è¦æ¨¡ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¸ã®æŒ‘æˆ¦ã§å¦ã‚“ã ã“ã¨ï¼ˆå¾Œç·¨ï¼‰ï½žã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæŠ±ãˆã‚‹ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®å•é¡Œã¨ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ã«ã¾ãŸãŒã‚‹ä¸€è²«æ€§ å…¨ä¸–ç•Œã§3å„„äººã‚’è¶…ãˆã‚‹ä¼šå“¡ã‚’æŠ±ãˆã€ä¸–ç•Œæœ€å¤§ã®SNSã¨ãªã£ãŸFacebookã€‚åŒç¤¾ã®æŠ€è¡“æ‹…å½“ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆ Jeff Rothschildæ°ãŒã€10æœˆ8æ—¥ã«ç±³ã‚«ãƒªãƒ•ã‚©ãƒ«ãƒ‹ã‚¢å¤§å¦ã‚µãƒ³ãƒ‡ã‚£ã‚¨ã‚´æ ¡ã§è¡Œã£ãŸã‚»ãƒŸãƒŠãƒ¼ã€ŒHigh Performance at Massive Scale-Lessons learned at Facebookã€ã®å†…å®¹ã‚’å†æ§‹æˆã—ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ï¼ˆã“ã®è¨˜äº‹ã¯ã€ŒFacebookãŒå¤§è¦æ¨¡ãªã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã¸ã®æŒ‘æˆ¦ã§å¦ã‚“ã ã“ã¨ï¼ˆå‰ç·¨ï¼‰ï½ž800å„„æžšã®å†™çœŸãƒ‡ãƒ¼ã‚¿ã¨PHPã®ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£å•é¡Œã€ã®ç¶šãã§ã™ï¼‰ ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã«å¤§ããªå½¹å‰²ã‚’æžœãŸã—ã¦ã„ã‚‹ Facebookã®ä¸»ãªå½¹å‰²ã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒç°¡å˜ã«ï¼ˆå‹äººãŸã¡ã®ï¼‰æƒ…å ±ã‚’é›†ã‚ã‚‹ã“ã¨ãŒã§
ZAORIKU 2009/10/20
facebook

ã‚µãƒ¼ãƒãƒ¼

MySQL

PHP

ã‚ãƒ£ãƒƒã‚·ãƒ¥
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸