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

dk19810313 id:dk19810313

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

${{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 InnoDBãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®è¨è¨ˆ - ãƒ¡ãƒ¢å¸³
æ¬¡ã®è¦ä»¶ã§MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹æ–¹æ³•ã‚’è€ƒãˆã‚‹ã€‚ MySQLã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯InnoDBãƒ†ãƒ¼ãƒ–ãƒ«ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã§ã€MySQLã‚µãƒ¼ãƒãƒ¼ã‚’æ¢ã‚ãšã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹mysqldãƒ—ãƒã‚»ã‚¹ã®å†—é•·åŒ–ã«ã¯LifeKeeperãªã©ã®å…±æœ‰ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸åž‹ã®ã‚¯ãƒ©ã‚¹ã‚¿ãƒªãƒ³ã‚°ã‚’æŽ¡ç”¨ã™ã‚‹ ã“ã®è¦ä»¶ã«å¾“ã£ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹æ³•ã®æ¤œè¨¼ã®æ‰‹é–“ã€ç®¡ç†ã®ã—æ˜“ã•ãªã©ã‚’æ¤œè¨Žã™ã‚‹ã¨ã€è¡¨ã®é€šã‚Šã¨ãªã‚‹ã€‚ è¡¨ . ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ§‹æˆæ¤œè¨Žæ™‚ã®äºˆæƒ³æ¤œè¨¼å·¥æ•°ã¨ç®¡ç†ã®ã—æ˜“ã•
dk19810313 2012/07/23
MySQL
ãƒªãƒ³ã‚¯
MySQL :: ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã‚’ãƒã‚°ã«å‡ºåŠ›ã™ã‚‹ & ãƒ¡ãƒ¼ãƒ«é€šçŸ¥ [Tipsã¨ã„ã†ã‹ãƒ¡ãƒ¢]
cron ã§æ¯Žæ—¥ãƒãƒ¼ãƒ†ãƒ¼ãƒˆã•ã›ã¦ã€ãƒ¡ãƒ¼ãƒ«é€šçŸ¥ for host in db1.example.com db2.example.com do slowlog="/tmp/mysql-slow.log" ssh $host mysqldumpslow $slowlog | mail -s "slowquery@$host ["`date +\%Y\%m\%d`"]" [email protected] ssh $host mv $slowlog $slowlog.`date +%Y%m%d` ssh $host mysqladmin -uroot flush-logs done
dk19810313 2012/06/25
MySQL
ãƒªãƒ³ã‚¯
Facebookã€memcachedã«300TBä»¥ä¸Šã®ãƒ©ã‚¤ãƒ–ãƒ‡ãƒ¼ã‚¿ã‚’ç½®ãå¤§è¦æ¨¡é‹ç”¨ã®å†…å´
ã‚¯ãƒ©ã‚¦ãƒ‰ã®ã‚ˆã†ã«å¤§è¦æ¨¡ãªã‚·ã‚¹ãƒ†ãƒ ã§ã¯ã€ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã®é–‹ç™ºã¨åŒç‰ä»¥ä¸Šã«ã€å¤§è¦æ¨¡é‹ç”¨ã®å·§æ‹™ãŒã€ã‚·ã‚¹ãƒ†ãƒ å…¨ä½“ã®æˆåŠŸã‚’å¤§ããå·¦å³ã—ã¾ã™ã€‚ 6æœˆ22æ—¥ã‹ã‚‰ã€ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§è¡Œã‚ã‚Œã¦ã„ãŸWebã‚µã‚¤ãƒˆã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨é‹ç”¨ã«é–¢ã™ã‚‹ã‚ªãƒ©ã‚¤ãƒªãƒ¼ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒVelocity 2010ã€ã§ã€Facebookã®Technical Operations teamã‚’æ‹…å½“ã™ã‚‹Tom Cookæ°ãŒã€ŒA Day in the Life of Facebook Operationsã€ï¼ˆFacebooké‹ç”¨ã®ã‚ã‚‹1æ—¥ï¼‰ã¨é¡Œã—ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã€FacebookãŒãµã ã‚“ã©ã®ã‚ˆã†ãªé‹ç”¨ã‚’è¡Œã£ã¦ã„ã‚‹ã‹ã€ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ ä¸–ç•Œã§ãƒˆãƒƒãƒ—ã‚¯ãƒ©ã‚¹ã®å¤§è¦æ¨¡ã‚µã‚¤ãƒˆãŒã€æ™®æ®µã©ã®ã‚ˆã†ãªãƒ„ãƒ¼ãƒ«ã‚’ç”¨ã„ã€ã©ã®ã‚ˆã†ãªæ–¹æ³•ã§é‹ç”¨ã—ã¦ã„ã‚‹ã®ã‹ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®å†…å®¹ã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ 6å¹´ã§4å„„ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ãƒ¦ãƒ¼ã‚¶ãƒ¼ã€3ã‚«æ‰€ã®ãƒ‡ãƒ¼ã‚¿ã‚»ãƒ³ã‚¿ãƒ¼ Tom Cookæ°ã€‚Facebo
dk19810313 2011/08/11
ã“ã®ã¨ã300TBãªã‚‰ã€ä»Šã¯ã‚‚ã£ã¨å¢—ãˆã¦ã‚‹ã‹ãªã€‚

facebook

é‹ç”¨

MySQL

memcached

ã‚¤ãƒ³ãƒ•ãƒ©
ãƒªãƒ³ã‚¯
MySQL 5.1ã®ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°
MySQL 5.1ã§è¿½åŠ ã•ã‚ŒãŸãƒ¡ã‚¸ãƒ£ãƒ¼ãªæ©Ÿèƒ½ã®å½±ã«éš ã‚ŒãŸã€åœ°å‘³ã ãŒä¾¿åˆ©ãªæ”¹å–„ãŒã‚ã‚‹ã€‚ãã‚ŒãŒã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã«é–¢ã™ã‚‹ä»•æ§˜ã§ã‚ã‚‹ã€‚MySQL 5.0ã¾ã§ã¯ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã¯1ç§’æœªæº€ã®ã‚¯ã‚¨ãƒªã‚’æ•æ‰ã™ã‚‹ã“ã¨ãŒå‡ºæ¥ãªã‹ã£ãŸã€‚ãŒã€MySQL 5.1ã§ã¯1ãƒžã‚¤ã‚¯ãƒç§’ã¾ã§ã®ã‚¯ã‚¨ãƒªã‚’è¨˜éŒ²ã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹ã€‚å¾“ã£ã¦ã€0.5ç§’ã‹ã‹ã‚‹ã‘ã©å¤§é‡ã«å®Ÿè¡Œã•ã‚Œã¦ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å¤§ããªå½±éŸ¿ã‚’ä¸Žãˆã¦ã„ã‚‹ï¼ã¨ã„ã†ã‚ˆã†ãªã‚¯ã‚¨ãƒªã®ç™ºè¦‹ãŒå‡ºæ¥ã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚1ç§’æœªæº€ã®ã‚¯ã‚¨ãƒªã‚’è¿½è·¡ã—ãŸã„å ´åˆã€ä¾‹ãˆã°ä»¥ä¸‹ã®ã‚ˆã†ãªè¨å®šã‚’ã™ã‚‹ã€‚ [mysqld] slow_query_log=ON slow_query_log_file=mysql-slow.log long_query_time=0.1 MySQL 5.0ã¾ã§ã¯log_slow_queryã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã ã£ãŸã®ãŒã€MySQL 5.1ã§ã¯slow_query_logã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³å
dk19810313 2011/08/09
MySQL
ãƒªãƒ³ã‚¯
ã€ŒMobageã€å·¨å¤§ã‚µãƒ¼ãƒãƒ¼ã‚’æ”¯ãˆã‚‹DeNAã®MySQLæ´»ç”¨ã¨ã¯ï½œã€Techç·ç ”ã€‘
Mobageãªã©ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦MySQLã‚’æŽ¡ç”¨ã—ã¦ã„ã‚‹DeNAã¯ã€ã“ã®ã»ã©MySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£æœ€å¤§ã®ã‚¤ãƒ™ãƒ³ãƒˆã§ã€ã€ŒCorporate Contributor of the Year 2011ã€ã‚’å—è³žã—ãŸã€‚ãã“ã§ç¤ºã•ã‚ŒãŸDeNAã®ä¸–ç•Œã«é€šç”¨ã™ã‚‹æŠ€è¡“åŠ›ã¨ã¯â”€â”€ã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä¸–ç•Œä¸ã§ä½¿ã‚ã‚Œã¦ã„ã‚‹MySQLã€‚å¤§è¦æ¨¡ãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å‡¦ç†ã™ã‚‹ã‚µã‚¤ãƒˆæ§‹ç¯‰ã«ã¯ä¸å¯æ¬ ã®æŠ€è¡“ã ãŒã€æ ªå¼ä¼šç¤¾ãƒ‡ã‚£ãƒ¼ãƒ»ã‚¨ãƒŒãƒ»ã‚¨ãƒ¼ï¼ˆDeNAï¼‰ã¯MySQLã‚’å¾¹åº•ã—ã¦ä½¿ã„å€’ã—ã€ç‹¬è‡ªã®æ‹¡å¼µæŠ€è¡“ã‚’é–‹ç™ºã™ã‚‹ã“ã¨ã‚’é€šã—ã¦ã€ãã®å¯ç”¨æ€§ã‚’é«˜ã‚ã¦ããŸã€æ—¥æœ¬ã‚’ä»£è¡¨ã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼æ¥ã®ä¸€ã¤ã¨ã—ã¦çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ç¾åœ¨ã€Mobageï¼ˆãƒ¢ãƒã‚²ãƒ¼ï¼‰ã‚µãƒ¼ãƒ“ã‚¹ã‚’å‹•ã‹ã™ãŸã‚ã«ã€ç´„700å°ã®MySQLã‚µãƒ¼ãƒãƒ¼ãŒç¨¼åƒã—ã¦ãŠã‚Šã€ãã®æ•°ã¯ä¸–ç•Œçš„ã«ã‚‚æœ‰æ•°ã®ã‚‚ã®ã ã€‚ 4æœˆä¸æ—¬ã«ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§é–‹ã‹ã‚ŒãŸMySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£æœ€å¤§ã®ã‚¤ãƒ™ãƒ³ãƒˆã€MySQL
dk19810313 2011/05/11
ã‚ã¨ã§

MySQL
ãƒªãƒ³ã‚¯
MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 4.6.10 mysqlhotcopy â€” ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ—ãƒã‚°ãƒ©ãƒ
mysqlhotcopy ã¯ã‚‚ã¨ã‚‚ã¨ Tim Bunce ã«ã‚ˆã£ã¦æ›¸ã‹ã‚Œã€æä¾›ã•ã‚ŒãŸ Perl ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ã™ã€‚FLUSH TABLESã€LOCK TABLESã€ãŠã‚ˆã³ cp ã¾ãŸã¯ scp ã‚’ä½¿ç”¨ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ä½œæˆã—ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¾ãŸã¯å˜ä¸€ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ä½œæˆã™ã‚‹ãŸã‚ã®é«˜é€Ÿãªæ–¹æ³•ã§ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãŒç½®ã‹ã‚Œã¦ã„ã‚‹ã®ã¨åŒã˜ãƒžã‚·ãƒ³ã§ã—ã‹å®Ÿè¡Œã§ãã¾ã›ã‚“ã€‚mysqlhotcopy ã¯ MyISAM ãƒ†ãƒ¼ãƒ–ãƒ«ãŠã‚ˆã³ARCHIVE ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã¿ã«æ©Ÿèƒ½ã—ã¾ã™ã€‚Unix ã§å®Ÿè¡Œã•ã‚Œã¾ã™ã€‚ mysqlhotcopy ã‚’ä½¿ç”¨ã™ã‚‹ã«ã¯ã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’è¡Œã†ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ•ã‚¡ã‚¤ãƒ«ã¸ã®èªã¿å–ã‚Šã‚¢ã‚¯ã‚»ã‚¹ã€ã“ã‚Œã‚‰ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã® SELECT æ¨©é™ã€RELOAD æ¨©é™ (FLUSH TABLES ã‚’å®Ÿè¡Œã§ãã‚‹ã‚ˆã†ã«)ã€ãŠã‚ˆã³ LOCK TABLES æ¨©é™ (ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒãƒƒã‚¯ã§ãã‚‹ã‚ˆã†
dk19810313 2010/11/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 æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
dk19810313 2010/10/27
ã‚ã¨ã§

MySQL

DeNA
ãƒªãƒ³ã‚¯
CentOS 5.3ã«PHP5.2.9ã¨MySQL5.1.33ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«: ã‚µãƒ¼ãƒãƒ¼åˆå¿ƒè€…ã«ã‚ˆã‚‹è‡ªå®…ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰å‚™å¿˜éŒ²
CentOS5.3ã®åˆæœŸãƒªãƒã‚¸ãƒˆãƒªã«ã¯PHP5.1.6ã¾ã§ã—ã‹ãªã„ãŸã‚ã€è¿½åŠ ãƒªãƒã‚¸ãƒˆãƒªã‚’è¨å®šã—ã¾ã™ã€‚ yum-prioritiesã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« yum-prioritiesã¯ã€ã‚µãƒ¼ãƒ‰ãƒ‘ãƒ¼ãƒ†ã‚£ã®ãƒªãƒã‚¸ãƒˆãƒªã‚’è¿½åŠ ã—ãŸå ´åˆã«ã€å„ãƒªãƒã‚¸ãƒˆãƒªã®å„ªå…ˆåº¦ã‚’è¨å®šã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã™ã€‚ CentOS 5.3ã§æ§‹ç¯‰ã—ãŸè‡ªå®…ã‚µãƒ¼ãƒãƒ¼ã«ã€Œrootã€ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã§ãƒã‚°ã‚¤ãƒ³ã—ä¸‹è¨˜ã‚³ãƒžãƒ³ãƒ‰ã‚’å…¥åŠ›ã—ã¦ã€yum-prioritiesã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ # yum install yum-priorities æ¬¡ã«ã€Œ/etc/yum.repos.d/CentOS-Base.repoã€ã®ä¿®æ£ã‚’è¡Œã„ã¾ã™ã€‚ # vim /etc/yum.repos.d/CentOS-Base.repo ã€Œpriority=å„ªå…ˆåº¦ã€ã®å½¢å¼ã§ãƒ—ãƒ©ã‚¤ã‚ªãƒªãƒ†ã‚£ã‚’è¨å®šã—ã¾ã™ã€‚å„ªå…ˆåº¦ã¯1ï½ž99ã§ã€å€¤ãŒå°ã•ã„ã»ã©å„ªå…ˆåº¦ãŒé«˜ããªã‚Šã¾ã™ã€‚priori
dk19810313 2010/10/01
CentOS

PHP

MySQL
ãƒªãƒ³ã‚¯
MySQL ã‚’ä½¿ã£ãŸãŠæ‰‹è»½ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼å®Ÿè£… - ãƒ‰ãƒ¯ãƒ³ã‚´ ç ”ç©¶é–‹ç™ºãƒ–ãƒã‚°
ã¯ã˜ã‚ã« ã“ã®è¨˜äº‹ã§ã¯ã€MySQL ã‚’ä½¿ã£ã¦ç°¡å˜ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã‚’æ‰‹è»½ã«å®Ÿè£…ã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¨ã¯ã€ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’ä¸€æ™‚çš„ã«æºœã‚ã¦ãŠãã€é †æ¬¡å‡¦ç†ã™ã‚‹ãŸã‚ã®ä»•çµ„ã¿ã§ã™ã€‚è¿…é€Ÿãªãƒ¬ã‚¹ãƒãƒ³ã‚¹ãŒå¿…è¦ãª Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦ã€æ™‚é–“ã®ã‹ã‹ã‚‹å‡¦ç†ã‚’éžåŒæœŸã«è¡Œã†ãŸã‚ã«ã€ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ã§é †æ¬¡å‡¦ç†ã—ã¦ã„ãã‚ˆã†ãªå ´åˆã«åˆ©ç”¨ã§ãã¾ã™ã€‚ ç°¡å˜ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¨è¨€ã£ã¦ã‚‚ã€å¤§è¦æ¨¡ãªé‹ç”¨ã«ã‚‚è€ãˆã‚‰ã‚Œã‚‹ç¨‹åº¦ã®é€Ÿåº¦ã¨å …ç‰¢æ€§ã‚’æŒã¡ã¾ã™ã€‚ ã¾ãŸã€ã“ã“ã§è§£èª¬ã—ã¦ã„ã‚‹æ–¹æ³•ã§ä½œã‚‰ã‚ŒãŸãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¯ã€å¼Šç¤¾ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ãƒ‹ã‚³ãƒ‹ã‚³å‹•ç”»ã«æœ€è¿‘è¿½åŠ ã•ã‚ŒãŸtwitteré€£æºæ©Ÿèƒ½ã§ã‚‚åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã‚’ä½œã‚‹ã«ã‚ãŸã£ã¦ ä»Šå›žå®Ÿè£…ã™ã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¯ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®è¿½åŠ (push)ã‚’é«˜é€Ÿã«è¡Œã†äº‹ãŒã§ãã‚‹ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®å–å¾—(pop)ã¯ã‚ã‚‹ç¨‹åº¦é«˜é€Ÿã«è¡Œã†äº‹ãŒã§ãã‚‹ å¤šãã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰åŒæ™‚ã« p
dk19810313 2010/03/12
MySQL
ãƒªãƒ³ã‚¯
mixi Engineersâ€™ Blog Â» Tokyo Tyrantã«ã‚ˆã‚‹è€é«˜è² è·DBã®æ§‹ç¯‰
é€£ä¼‘ä¸ã¯Wiiã®ãƒžãƒªã‚ªã‚«ãƒ¼ãƒˆã‚’ã‚„ã‚Šã¾ãã£ã¦ã‚„ã£ã¨VR7000è¶ŠãˆãŸmikioã§ã™ã€‚æ„›è»Šã¯ãƒžãƒƒãƒãƒ»ãƒã‚¤ã‚¯ã¨ã‚¤ãƒ³ã‚¿ãƒ¼ã‚»ãƒ—ã‚¿ãƒ¼ã§ã™ã€‚ã•ã¦ä»Šå›žã¯ã€åˆ†æ•£ãƒãƒƒã‚·ãƒ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒTokyo Tyrantã§mixiã®æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã‚’ç®¡ç†ã™ã‚‹ã‚ˆã†ã«ã—ãŸæ™‚ã®è‹¦åŠ´è©±ã‚’æ›¸ãã¾ã™ã€‚ ãƒã‚°ã‚¤ãƒ³å‡¦ç†ã¯è² è·åœ°ç„ mixiã§ã¯ã€å…¨ã¦ã®ãƒ¦ãƒ¼ã‚¶ã«ã¤ã„ã¦ã€å„ã€…ã®æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã‚’ç®¡ç†ã—ã¦ã„ã¾ã™ã€‚ã€Œãƒžã‚¤ãƒŸã‚¯ã‚·ã‚£ä¸€è¦§ã€ã‚„ã€ŒãŠæ°—ã«å…¥ã‚Šã€ãªã©ã®ç”»é¢ã§ã€å‹äººãŒè¿‘ã„æ™‚é–“ã«ãƒã‚°ã‚¤ãƒ³ã—ã¦ã„ã¦ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã¨ã‚Šã‚„ã™ã„çŠ¶æ…‹ã«ã‚ã‚‹ã‹ã©ã†ã‹ç¢ºèªã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã§ã™ã€‚ mixiã®ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã¯ãƒã‚°ã‚¤ãƒ³ã—ãªã„ã¨è¦‹ã‚‰ã‚Œãªã„ãƒšãƒ¼ã‚¸ãªã®ã§ã€ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹ãŸã³ã«ãƒã‚°ã‚¤ãƒ³ç¢ºèªãŒè¡Œã‚ã‚Œã¾ã™ã€‚ã—ãŸãŒã£ã¦ã€æœ€çµ‚ãƒã‚°ã‚¤ãƒ³æ™‚åˆ»ã¯ã»ã¼å…¨ã¦ã®ãƒšãƒ¼ã‚¸ã«ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹åº¦ã«æ›´æ–°ã•ã‚Œã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚mixiã®ä¸ã§æœ€ã‚‚é‡ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã²ã¨ã¤ã¨ã—ã¦ã€Œ
dk19810313 2009/11/19
mixi

memcached

MySQL

tokyotyrant
ãƒªãƒ³ã‚¯
cl.pocari.org - æ‹¡å¼µã•ã‚Œç¶šã‘ã‚‹ InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚’å°ã•ãã™ã‚‹æ–¹æ³•
æ‹¡å¼µã•ã‚Œç¶šã‘ã‚‹ InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã®ã‚µã‚¤ã‚ºã‚’å°ã•ãã™ã‚‹æ–¹æ³• 2006-07-07-2: [MySQL] MySQL ã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å¯èƒ½ã«ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ InnoDB ãŒã‚ã‚Šã¾ã™ï¼Ž InnoDB ã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã¯ï¼ŒMyISAM ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ç•°ãªã£ã¦ï¼Œãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ ibdata1 ã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ãŒè“„ç©ã•ã‚Œã¦ã„ãã¨ã“ã«ãªã‚Šã¾ã™ï¼Ž MySQL ã® datadir ã«è‡ªå‹•æ‹¡å¼µã™ã‚‹ 10 MB ã® ibdata1 ãƒ•ã‚¡ã‚¤ãƒ«ãŒ 1 ã¤ã¨ã€5 MB ã® ib_logfile ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ãŒ 2 ã¤ä½œæˆã•ã‚Œã¾ã™ - 7.5.3. InnoDB èµ·å‹•ã‚ªãƒ—ã‚·ãƒ§ãƒ³ http://dev.mysql.com/doc/refman/4.1/ja/innodb-start.html ã“ã® ibdata1 ã¯ï¼Œå¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¿½åŠ ã—ã¦ã„ãã¨ï¼Œè‡ªå‹•çš„ã«ã‚µã‚¤ã‚ºã‚’æ‹¡å¼µã—ã¦ã„ãã¾ã™ï¼Ž ãŸã
dk19810313 2009/09/14
MySQL

innodb
ãƒªãƒ³ã‚¯
MySQL FULLTEXT Ngram : LIKEæ¤œç´¢ã‚ˆã‚Šæ•°åå€é«˜é€Ÿãªã€ãŠæ‰‹è»½ æ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢ ã«ã¤ã„ã¦ï½œblogï½œãŸãŸã¿ãƒ©ãƒœ
tatamilab.jp
dk19810313 2009/09/02
MySQL

FULLTEXT
ãƒªãƒ³ã‚¯
Memcacheã¯ã‚„ã£ã±ã‚Šã™ã”ã‹ã£ãŸ
æ£®å·ã§ã™ã€‚æ¥ãšã‹ã—ãªãŒã‚‰memcacheã‚’ä½¿ã†ãã‚‰ã„ãªã‚‰tmpfsã¨ã‹MySQLã®HEAPãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½¿ãˆã°ã„ã„ã˜ã‚ƒã‚“ã€ãªã©ã¨æ€ã£ã¦ã„ãŸã®ã§ã™ãŒã€ä»Šå›žç°¡å˜ãªãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ã‚„ã£ã¦ã¿ã¦å¿ƒã‚’å…¥ã‚Œæ›¿ãˆã¾ã—ãŸã€‚ ã¯ã„ã€memcacheã¯å‰å¤§ã§ã™ã€‚ã™ã”ãé€Ÿã„ã§ã™ã€‚ ãƒ†ã‚¹ãƒˆã¨ã—ã¦10ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã—ã¦ã€ãã“ã‹ã‚‰è©²å½“ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’10ä¸‡ä»¶å–å¾—ã—ã¾ã™ã€‚ã¾ãšã¯memcacheã‚’ä½¿ç”¨ã—ãŸå ´åˆã§ã™ã€‚ ä»Šå›žã¯dagãƒ¬ãƒã‚¸ãƒˆãƒªã®RPMç‰ˆmemcachedã¨ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸPHP 5.2.3ã‚’ä½¿ç”¨ã—ã¦pecl installã§memcacheã‚¨ã‚¯ã‚¹ãƒ†ãƒ³ã‚·ãƒ§ãƒ³ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ã¾ã™ã€‚memcachedã®è¨å®šã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã¾ã¾ã§ã™ã€‚ #Â yumÂ installÂ memcached #Â peclÂ installÂ memcache #Â viÂ /usr/local/lib/php.ini extension=
dk19810313 2009/08/03
ã‚ã¨ã§è©¦ã™

MySQL

memcached
ãƒªãƒ³ã‚¯
ç¾å ´æŒ‡å‘ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è©³èª¬
ã“ã®æ–‡æ›¸ã¯ã€æŠ€è¡“è©•è«–ç¤¾åˆŠã€ŽWEB+DB PRESS Vol.22ã€ã«åŸ·ç†ã—ãŸè¨˜äº‹ã‚’æŠ€è¡“è©•è«–ç¤¾ã® è¨±å¯ã‚’å¾—ã¦WWWã§å…¬é–‹ã—ã¦ã„ã‚‹ã‚‚ã®ã§ã™ã€‚ ã“ã®WWWç‰ˆã¯æ ¡æ£å‰ã®åŽŸç¨¿ã‚’å…ƒã«ã—ã¦ã„ã‚‹ç‚¹ã€WWWå…¬é–‹å¾Œã«å¿…è¦ãŒã‚ã‚Œã°ä¿®æ£ã™ã‚‹ç‚¹ã§ã€é›‘èªŒç‰ˆã®æ–‡ç« ã¨ã¯ç•°ãªã‚‹éƒ¨åˆ†ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å›³è¡¨ã‚‚é›‘èªŒç‰ˆã¨ã¯ç•°ãªã‚Šã¾ã™ã€‚ äºˆã‚ã”äº†æ‰¿ãã ã•ã„ã€‚ ã¾ãŸã€ã“ã®æ–‡ç« ãŒå¯¾è±¡ã—ã¦ã„ã‚‹ã®ã¯MySQL 4.0ç³»ãªã®ã§ã€æœ€æ–°ã®ãƒªãƒªãƒ¼ã‚¹ç‰ˆã¨æ¯”ã¹ã‚‹ã¨èª¬æ˜Žä¸è¶³ãªç‚¹ãªã©ãŒå¤šã€…ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®åŸºæœ¬ã‚’ãŠã•ãˆã‚‹ã«ã¯ã€ã“ã®æ–‡æ›¸ã¯ã¾ã æœ‰ç›Šã ã¨æ€ã„ã¾ã™ãŒã€è¨å®šãƒ¬ãƒ™ãƒ«ã®èª¬æ˜Žã¯æœ€æ–°ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’å‚ç…§ã™ã‚‹ã‚ˆã†ã«ã—ã¦ãã ã•ã„ã€‚
dk19810313 2009/05/20
MySQL

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
1