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

riywo id:riywo

mysqlã«é–¢ã™ã‚‹riywoã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

MySQL 5.5 GAç‰ˆãŒå‡ºãŸã®ã§Semisynchronous Replicationã‚’ä½¿ã£ã¦ã¿ãŸ - As a Futurist...
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚ã„ã¤ã‚‚ã†ã¡ã®å«ãŒãŠä¸–è©±ã«ãªã£ã¦ãŠã‚Šã¾ã™ã€‚ã¨ã„ã†ã‚ã‘ã§ã€ã¤ã„ã« å¾…ã¡ã«å¾…ã£ãŸ MySQL 5.5 ã® GA ç‰ˆã§ã‚ã‚‹ MySQL 5.5.8 ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚http://dev.mysql.com/doc/refman/5.5/en/news-5-5-8.html å…ˆæ—¥ã® MySQL Casual Talks #1 ã§@Rkajiyama ã•ã‚“ãŒã»ã®ã‚ã‹ã—ã¦ã„ã¾ã—ãŸãŒã€æœŸå¾…ã‚’è£åˆ‡ã‚‰ãš å¹´å†…ãƒªãƒªãƒ¼ã‚¹ã‚’é”æˆã—ã¦é ‚ã„ãŸ Oracle ã¯æœ¬å½“ã«ã™ã°ã‚‰ã—ã„ã¨æ€ã„ã¾ã™ã€‚Casual User ã¨ã—ã¦ã¯ ã“ã®ãƒªãƒªãƒ¼ã‚¹ã«å¯¾ã—ã¦ã€Œä½¿ã£ã¦ã¿ãŸã‚¨ãƒ³ãƒˆãƒªã€ã§å¿œãˆã‚‹ã—ã‹ãªã„ï¼ã¨ã„ã†ã‚ã‘ã§æ—©é€Ÿä½¿ã£ã¦ã¿ã¾ã—ãŸã€‚ ã¾ãšã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã«ã¤ã„ã¦ã¯ã»ã¨ã‚“ã© MySQL 5.1 ã¨å¤‰ã‚ã‚Šã¾ã›ã‚“ã€‚InnoDB(ã—ã‹ã‚‚ 5.1 ã® plugin ç›¸å½“)ãŒ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«
riywo 2010/12/17
ã‚»ãƒ«ã‚¯ãƒžã€‚ã¨ã‚Šã‚ãˆãšä½¿ã£ã¦ã¿ãŸã€‚

-AsaFuturist

mysql
ãƒªãƒ³ã‚¯
MySQL Casual Talks #1ã§å–‹ã£ã¦ã‚ˆã‹ã£ãŸ - As a Futurist...
ã“ã‚“ã«ã¡ã¯ã€‚ãŠä¹…ã—ã¶ã‚Šã§ã™ã€‚æ˜¨æ—¥ã¯ MySQL Casual ã¨ã„ã†ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã§ 10 åˆ†ã®ãƒˆãƒ¼ã‚¯ã‚’ã—ã¦ãã¾ã—ãŸã€‚ ä¹…ã€…ã«çœŸé¢ç›®ã«ã—ã‚ƒã¹ã£ãŸã®ã§å¤§å¤‰ã§ã—ãŸãŒã€çµå±€æ™‚é–“è¶³ã‚Šãªãã¦å¾ŒåŠã¯ã—ã‚‡ã£ã¦ã—ã¾ã„ç”³ã—è¨³ã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ ã‚ˆãè€ƒãˆã‚‹ã¨ã€ã“ã†ã„ã†å ´ã§ç™ºè¡¨ã—ãŸã®ã¯ Tsukuba.R ä»¥æ¥ã§ã—ãŸã€‚ã‚„ã£ã¦ãªã•ã™ãŽï¼žï¼œ å†…å®¹ã¨ã—ã¦ã¯ã€tcpdump ã§ã‚¯ã‚¨ãƒªã®åˆ†æžã‚’ã™ã‚‹ mk-query-digest ã‚’ç¶™ç¶šçš„ã«å›žã—ã¦è¨˜éŒ²ã—ã¦ãŠã web ã®ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã§ç°¡å˜ã«åˆ†æžã™ã‚‹ãŸã‚ã«ã€ŒMyQueryshowã€ã¨ã„ã†ã®ã‚’ä½œã£ã¦ã¿ãŸã‚ˆãƒ¼ã¨ã„ã†ã®ã¨ã€ xtrabackup ã¨ã„ã†ãƒ›ãƒƒãƒˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã®ç°¡å˜ãªèª¬æ˜Žã§ã—ãŸã€‚MyQueryShow ã«ã¤ã„ã¦ã¯ ã“ã¡ã‚‰ã® github ã«ä¸Šã’ã¦ã„ã¾ã™ã€‚ã¾ã ã™ãã«ä½¿ãˆã‚‹ãƒ¬ãƒ™ãƒ«ã«æ•´ç†ã§ãã¦ãªã„ã§ã™ãŒã€ è©¦ã—ã¦ã¿ãŸã„æ–¹ã¯ã©ã†ãžã€‚ https://github.com/
riywo 2010/12/12
ã‚»ãƒ«ã‚¯ãƒžã€‚æ¬¡å›žã‚‚ãŒã‚“ã°ã‚ŠãŸã„ã€‚

-AsaFuturist

mysql
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
riywo 2010/11/15
è©•åˆ¤ã‚ˆã‘ã‚Œã°ç¬¬2å¼¾æ›¸ãã¾ã™ï¼æ‚ªã‘ã‚Œã°ããï½—ã›ï½„ï½’ï½†ï½”ï½‡ï½™ãµã˜ã“ï½Œï½ï¼›

DeNA

MySQL
ãƒªãƒ³ã‚¯
InnoDB ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2007 - akiyan.com ç®¡ç†äººãƒ¡ãƒ¢
http://www.mysql-ucj2007.jp/details/j25.html æœ¨ä¸‹ é–æ–‡ æ° NTTã‚³ãƒ ã‚¦ã‚§ã‚¢æ ªå¼ä¼šç¤¾ ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆç®¡ç†çµ±æ‹¬éƒ¨æŠ€è¡“SEéƒ¨é–€ DB æŠ€è¡“ã‚°ãƒ«ãƒ¼ãƒ— ï¼ˆã€ŒInnoDBã€ã¯ã€Œã„ã‚“ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã†ã‚‰ã—ã„...ä»Šã¾ã§ã€Œã„ã®ã§ãƒ¼ã³ãƒ¼ã€ã¨è¨€ã£ã¦ã¾ã—ãŸï¼‰ InnoDBã‚’ãªãœä½¿ã†ã‹ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ ã‚³ãƒŸãƒƒãƒˆã€ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã€ã‚»ãƒ¼ãƒ–ãƒã‚¤ãƒ³ãƒˆ å¤–éƒ¨ã‚ãƒ¼ è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒª MyISAMã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã¨ã‚‚ã«æ™‚é–“ãŒã‹ã‹ã‚‹ InnoDBã¯ãƒ‡ãƒ¼ã‚¿é‡ã®å¢—å¤§ã¨ã®ç›¸é–¢ãŒãªã„ InnoDBãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®çŽ‹é“çš„ã‚¢ãƒ—ãƒãƒ¼ãƒ ã‚¯ã‚¨ãƒªã‚’æ”¹å–„ã—ã¦å…¨ä½“çš„ã«å‡¦ç†åŠ¹çŽ‡ã‚’ä¸Šã’ã‚‹ ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºã‚’ã§ãã‚‹ã ã‘å°ã•ã ãƒ¡ãƒ¢ãƒªã‚’ã§ãã‚‹ã ã‘å¤šãç©ã‚€ ã‚³ãƒŸãƒƒãƒˆæ€§èƒ½ï¼ˆåŒæœŸæ›¸ãè¾¼ã¿ï¼‰ innodb_flush_log_at_trx_commit=1,0,2
riywo 2010/01/20
ã‚„ã°ã„ã€è¶…å‚è€ƒã«ãªã‚‹ã€‚

mysql
ãƒªãƒ³ã‚¯
phpMyAdminã§MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—
å½“ã‚µã‚¤ãƒˆã¯dbã«MySQLã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ã€‚BarkleyDBã§ã‚ã‚Œã°ã€FTPã§dbã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªãƒ¼ã”ã¨ãƒãƒ¼ã‚«ãƒ«ã«è½ã¨ã—ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å‡ºæ¥ã‚‹ã®ã§ã™ãŒã€MySQLã§ã¯ãã†ã‚‚è¡Œãã¾ã›ã‚“ã€‚ãƒãƒªãƒãƒƒãƒ—ã®ã‚µãƒ¼ãƒãƒ¼ã§ã¯phpMyAdminã‚’ä½¿ç”¨ã—ã¦ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å‡ºæ¥ã‚‹ã®ã§ã€ä½œæ¥æ‰‹é †ã®è¦šãˆæ›¸ãã¨ã—ã¦è¨˜ã—ã¦ãŠãã¾ã™ã€‚å®Ÿã¯Ogawa::Memorandaã•ã‚“ã®ã€ŒLolipopã®MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç°¡å˜ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹CGIã‚¹ã‚¯ãƒªãƒ—ãƒˆã€ã¨è¨€ã†ç´ æ™´ã‚‰ã—ã„ç‰©ã‚‚æœ‰ã‚‹ã®ã§ã€ã”è¦§ã«ãªã£ã¦ã¿ã¦ãã ã•ã„ã€‚ ãƒãƒªãƒãƒƒãƒ—ã®ãƒ¦ãƒ¼ã‚¶ãƒ¼å°‚ç”¨ãƒšãƒ¼ã‚¸ã‚ˆã‚Šã€ã€ŒWEBãƒ„ãƒ¼ãƒ«>ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œæˆ>phpMyAdminã‚’é–‹ãã€ã‚’é¸æŠžã—ã¾ã™ã€‚ãƒã‚°ã‚¤ãƒ³ç”»é¢ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã®ã§ã€Language:ã«MTã§ä½¿ç”¨ã—ã¦ã„ã‚‹è¨€èªžãƒ»æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’é¸æŠžã™ã‚‹ã®ã§ã™ãŒã€å½“ã‚µã‚¤ãƒˆã§ä½¿ç”¨ã—ã¦ã„ã‚‹UTF-8ãŒãªãã€English(en-iso-885901)ã§é€²ã‚ã‚‹ã“ã¨ã«ã—ã¾ã—
riywo 2008/01/04
ãƒãƒªãƒãƒƒãƒ—ã®MySQLãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹æ–¹æ³•ã€‚ãƒã‚§ãƒƒã‚¯ã™ã‚‹ã‚‚ã®ãŒã‚ã‚‹ã®ã§ã“ã†ã„ã†ãƒšãƒ¼ã‚¸ã¯åŠ©ã‹ã‚‹ã€‚

#è‡ªã‚µãƒ¼ãƒ

*ã“ã‚Œã¯ã™ã”ã„

mysql
ãƒªãƒ³ã‚¯
1