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

twainy id:twainy

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

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

å¤§ç‰© alter table ã®é€”ä¸ã§ Lost connection to MySQL server during query ãŒç™ºç”Ÿã—ãŸã¨ãã«ç¢ºèªã—ãŸã„ã“ã¨ - Studio3104::BLOG.new
5æ™‚é–“ãƒ¢ãƒŽã® alter table ãŒ Lost connection to MySQL server during query ã—ãŸã‚“ã ã‘ã© show processlist ã™ã‚‹ã¨ã¾ã å‹•ã„ã¦ã‚‹ã£ã½ã„ã‹ã‚‰æ”¾ç½®ã—ã¨ã‘ã°å®Œé‚ã™ã‚‹ã®ã‹ãªã¨æ€ã£ã¦ã‚‹ã‚“ã ã‘ã©å¤§ä¸ˆå¤«ã ã‚ã†ã‹ã€ã€ã€ 2015-03-30 16:47:05 via Twitter for iPhone ã¨ã‚Šã‚ãˆãš show processlist ã—ã¦ã¾ã å‹•ã„ã¦ã‚‹ã£ã½ã‹ã£ãŸã‚‰ã€datadir é…ä¸‹ã§ #sql-xxxx_xxxxx.ibd ãªåå‰ã®ãƒ•ã‚¡ã‚¤ãƒ«ãŒè‚²ã£ã¦ã„ã‚‹ã‹ã©ã†ã‹ç¢ºèªã™ã‚‹ã€‚ ã‚¿ã‚¤ãƒ ã‚¹ã‚¿ãƒ³ãƒ—ãŒæ›´æ–°ã•ã‚Œã¦ã„ã‚Œã°ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ãƒ‡ãƒ¼ã‚¿ã‚³ãƒ”ãƒ¼ãŒç”Ÿãã¦ã‚‹ã¨ã„ã†ã“ã¨ã«ãªã‚‹ã®ã§ã€ã‚ã¨ã¯ show processlist ã‚’ç›£è¦–ã—ã¦çµ‚ã‚ã‚‹ã®ã‚’å¾…ã¦ã°è‰¯ã„ã€‚ ã§ã€çµ‚ã‚ã£ãŸã£ã½ã‹ã£ãŸã‚‰ show create table ã‚’ç¢ºèªã—ã¦å¤‰æ›´ãŒ
twainy 2015/03/31
ã¡ã‚‡ã†ã“ã‚ã„ã®ã§sshã§ãƒã‚°ã‚¤ãƒ³ã—ã¦ã‹ã‚‰å®Ÿè¡Œã—ã¦ã‚‹ãŒã€ã¾ã‚å¤§ä¸ˆå¤«ãªã‚“ã™ã

mysql
ãƒªãƒ³ã‚¯
VOYAGE GROUPã€€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚° : MySQL InnoDBã®insertã¨lockã®è©±
2015å¹´03æœˆ08æ—¥17:06 ã‚«ãƒ†ã‚´ãƒª MySQL InnoDBã®insertã¨lockã®è©± ã“ã‚“ã«ã¡ã¯ã€‚ECãƒŠãƒ“ã§ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚’ã‚„ã£ã¦ã„ã‚‹é§’å´Žã§ã™ã€‚ ä»Šå›žã¯MySQLã®InnoDBã‚¨ãƒ³ã‚¸ãƒ³ã«ãŠã‘ã‚‹INSERTã¨ãƒãƒƒã‚¯ã®æŒ™å‹•ã«ã¤ã„ã¦æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ã¯ã˜ã‚ã« ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒ¬ã‚³ãƒ¼ãƒ‰ã®é‡è¤‡ãƒã‚§ãƒƒã‚¯ã‚’ã—ã¦ã‹ã‚‰INSERTã‚’ã™ã‚‹ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¯UNIQUEåˆ¶ç´„ã‚’ã‹ã‘ã¦ãƒ‡ãƒ¼ã‚¿ä¸æ•´åˆãŒèµ·ããªã„ã‚ˆã†ã«ã—ã¦ã„ã‚‹ã€‚ã¨ã„ã†ä»•æ§˜ã¯ã‚ˆãã‚ã‚‹ã‚±ãƒ¼ã‚¹ã ã¨æ€ã„ã¾ã™ã€‚ ã“ã†ã„ã£ãŸã‚±ãƒ¼ã‚¹ã§INSERTã—ãŸã¨ãã«ã©ã®ã‚ˆã†ãªä»•çµ„ã¿ãŒåƒã„ã¦é‡è¤‡ãƒ‡ãƒ¼ã‚¿ã‚’é˜²ã„ã§ã„ã‚‹ã®ã ã‚ã†ï¼Ÿã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§é‡è¤‡ãƒã‚§ãƒƒã‚¯ã‚’ã—ã¦ã¯ã„ã‚‹ã‘ã©MySQLã§ã¯ã©ã‚“ãªæŒ™å‹•ã‚’ã—ã¦ã„ã‚‹ã‚“ã ã‚ã†ï¼Ÿã¨ã„ã†ã®ãŒæ°—ã«ãªã£ãŸã®ã§èª¿ã¹ã¾ã—ãŸã€‚ èª¿ã¹ã‚‹ã“ã¨ INSERTã—ãŸå ´åˆã®ãƒãƒƒã‚¯ã®æŒ™å‹• FOR UPDATEæ–‡ã§æŽ’ä»–ãƒãƒƒã‚¯ã‚’ã‹ã‘ãŸå ´åˆã®ãƒãƒƒã‚¯ã®æŒ™å‹•
twainy 2015/03/10
è‰¯ã‚¨ãƒ³ãƒˆãƒª

mysql
ãƒªãƒ³ã‚¯
MySQL 5.5ã®ç§˜ä¼ã®ã‚¿ãƒ¬ãŒ5.6ã§ã¯è…ã£ã¦ã„ãŸã¯ãªã— | GMOãƒ¡ãƒ‡ã‚£ã‚¢ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã‚‚ã†å¯’ã®å…¥ã‚Šã‚’éŽãŽã¾ã—ãŸãã€‚DBAã®ãŸãªã‹ã§ã™ã€‚ GAã‹ã‚‰ã‚‚ã†ã™ã1å¹´ã€ç¤¾å†…ã§ã¯ã‚‚ã†ç›¸å½“ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«MySQL 5.6ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ã¾ã™ã€‚ä»Šã¾ã§ã¯æ–°è¦ã‚µãƒ¼ãƒ“ã‚¹(ã‚„ã€æ–°è¦æ©Ÿèƒ½)ã§ã®å°Žå…¥ãŒã»ã¨ã‚“ã©ã ã£ãŸ5.6ã‚’ã€ã“ã®ãŸã³ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¬ãƒ³ã‚¬ãƒ³ã®ã‚µãƒ¼ãƒ“ã‚¹ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã§å°Žå…¥ã—ã¾ã—ãŸï¼ˆã¨ã€å‰ãã†ã«è¨€ã£ã¦ã„ã¾ã™ãŒç§ã§ãªã„åˆ¥ã®DBAæ°ãŒä¸»æ‹…å½“ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ï¼‰ ä¸»ãªç†ç”±ã¯InnoDB Compressedã‚’ä½¿ã£ã¦ã„ãŸã®ã§ãã®æ€§èƒ½ã‚¢ãƒƒãƒ—ã«æœŸå¾…â€¦ã¨ã„ã†ã¨ã“ã‚ã ã£ãŸã‚“ã§ã™ãŒã€å¼Šç¤¾DBAãŒç¥žä»£ã®æ™‚ä»£ã‚ˆã‚Šè©¦è¡ŒéŒ¯èª¤ã‚’é‡ããŸã©ã‚Šç€ã„ãŸç©¶æ¥µã®my.cnf(?)ã€ã„ã‚ã‚†ã‚‹ç§˜ä¼ã®ã‚¿ãƒ¬ãŒ æ®‹ã€€å¿µã€€ãªã€€ãŒã€€ã‚‰ã€€è…ã€€ã£ã€€ã¦ã€€ãŠã€€ã‚Š å¤œã‚’å¾¹ã—ã¦ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ä½œæ¥ã‚’ã—ã¦ã„ãŸæ‹…å½“DBAæ°ãŒé’ã„é¡”(æŽ¨å®šã€‚ãƒãƒ£ãƒƒãƒˆã ã£ãŸ)ã§ ã‚¹ã€€ãƒã€€ãƒ¼ã€€ã‚¯ã€€ã‚¨ã€€ãƒªã€€ãƒ¼ã€€ãŒã€€1ã€€0ã€€å€ã€€ãã€€ã‚‰ã€€ã„ã€€ã«ã€€ãªã€€ã£ã€€ãŸã€€ã‚“ã€€ã ã€€ã‘ã€€ã©ã€€â€¦ ã¨è¨´ãˆã€å½¼ã¯ãã®
twainy 2014/01/14
mysql
ãƒªãƒ³ã‚¯
Debugging MySQL SSL problems
All of Perconaâ€™s open-source software products, in one place, to download as much or as little as you need.
twainy 2012/11/10
mysql

ssl
ãƒªãƒ³ã‚¯
L2 cache for MySQL
The idea to use SSD/Flash as a cache is not new, and there are different solutions for this, both OpenSource like L2ARC for ZFS and Flashcache from Facebook, and proprietary, like directCache from Fusion-io. They all however have some limitations, thatâ€™s why I am considering to have L2 cache on a database level, as an extension to InnoDB buffer pool. Fortunately, there is a project in progress Fla
twainy 2012/10/26
mysql
ãƒªãƒ³ã‚¯
MySQL æœ€æ–°æƒ…å ± | OSSã‚µãƒãƒ¼ãƒˆã®OpenStandiaâ„¢ã€NRIã€‘
MySQLæƒ…å ± MySQLã¨ã¯ ä¸»ãªæ©Ÿèƒ½ ä¸»ãªç‰¹å¾´ å°Žå…¥äº‹ä¾‹ é¡žä¼¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ å•†ç”¨è£½å“ã¨ã®æ©Ÿèƒ½æ¯”è¼ƒ å‹•ä½œç’°å¢ƒ MySQLã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ è£½å“ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ MySQLå–ã‚Šæ‰±ã„è£½å“ å•†ç”¨ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®ç¨®é¡žã¨è³¼å…¥æ–¹æ³• ã‚¯ãƒ©ã‚¦ãƒ‰ç‰ˆ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹å¹´é–“ã‚µãƒãƒ¼ãƒˆã‚µãƒ¼ãƒ“ã‚¹ MySQLã¨ã¯ MySQLã¨ã¯ã€ä¸–ç•Œä¸ã§åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ï¼ˆDBMSï¼‰ã§ã™ã€‚ ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä¸–ç•Œã§æœ€ã‚‚æ™®åŠã—ã¦ãŠã‚Šã€ã€Œæ€§èƒ½ï¼ˆé«˜é€Ÿï¼‰ã€ã‚„ã€Œå®‰å®šæ€§ã€ã«å®šè©•ãŒã‚ã‚Šã¾ã™ã€‚ 1995å¹´ã«TcX DataKonsaltç¤¾ã®Michael Wideniusæ°ã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚Œã¦ä»¥æ¥ã€å¤šãã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã‚’ç¹°ã‚Šè¿”ã™ä¸ã§æ©Ÿèƒ½è¿½åŠ ãŒè¡Œã‚ã‚Œã€ç¾åœ¨ã§ã¯å•†ç”¨è£½å“ã¨æ¯”è¼ƒã—ã¦ã‚‚éœè‰²ã®ç„¡ã„æ©Ÿèƒ½ã‚’æŒã£ã¦ã„ã¾ã™ã€‚ MySQLã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§ã™ãŒã€ã‚ªãƒ©ã‚¯ãƒ«ç¤¾ã«ã‚ˆã£ã¦ã€é–‹ç™ºã‚„ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ç®¡ç†ãŒè¡Œã‚ã‚Œã¦ã„ã¾ã™ã€‚ç„¡å„Ÿã®ã‚³
twainy 2012/10/09
mysql
ãƒªãƒ³ã‚¯
é–‹ç™ºã‚¹ãƒ”ãƒ¼ãƒ‰ã‚¢ã‚¯ã‚»ãƒ«å…¨é–‹ã¶ã£ã¡ãŽã‚Šï¼æ—¥æœ¬ã‚ˆã€ã“ã‚ŒãŒMySQL 5.6ã ãƒƒï¼ï¼
ç±³å›½ã§è¡Œã‚ã‚Œã¦ã„ã‚‹MySQL Connectã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã§ã€ã¤ã„ã«MySQL 5.6 RCï¼ˆãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆï¼‰ãŒç™ºè¡¨ã•ã‚ŒãŸã€‚ãƒªãƒªãƒ¼ã‚¹å€™è£œç‰ˆã¨ã„ã†ã“ã¨ã¯ã€ã“ã‚ŒãŒæ¬¡ã®æ£å¼ç‰ˆã«ãªã‚‹ã¨ã„ã†ã“ã¨ã ã€‚MySQL 5.5ã¯5.1ã‹ã‚‰å‡„ã¾ã˜ã„é€²åŒ–ã‚’é‚ã’ãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚ã£ãŸã€‚ã ãŒã€MySQL 5.6ã¯ã•ã‚‰ã«ãã‚Œã‚’ä¸Šå›žã‚‹é€²åŒ–ã‚’é‚ã’ã¦ã„ã‚‹ï¼æ£ç›´ã“ã“ã¾ã§ã®é€²åŒ–ã‚’èª°ãŒäºˆæƒ³ã—ãŸã ã‚ã†ã‹ã€ã„ã‚„èª°ã‚‚å‡ºæ¥ãªã‹ã£ãŸã§ã‚ã‚ã†ã€‚ã“ã‚Œã¾ã§ã€Î±ç‰ˆãŒå‡ºãŸã¨ãã‹ã‚‰ä½•åº¦ã‹æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ããŸãŒã€ä»Šå›žæ”¹ã‚ã¦MySQL 5.6ã®æ–°æ©Ÿèƒ½ã‚’æŒ¯ã‚Šè¿”ã£ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ã™ã¹ã¦ã¾ã¨ã‚ã‚‹ã¨ã‚‚ã®å‡„ã„å†…å®¹ã ã€‚èˆˆå¥®ã—ã¦å¤œã‚‚çœ ã‚Œãªããªã‚‹ã“ã¨è«‹ã‘åˆã„ã ã€‚MySQLã®é€²åŒ–ãŒæ¢ã¾ã‚‹ã®ã§ã¯ï¼Ÿãªã©ã¨ã„ã†å¿ƒé…ã¯å¹ãé£›ã³ã€ã‚‚ã¯ã‚„ã‚‚ã†ã¡ã‚‡ã£ã¨å°å‡ºã—ã«ã—ãªãã¦è‰¯ã‹ã£ãŸã®ã‹ï¼Ÿã¨å¿ƒé…ã—ã¦ã—ã¾ã†ãƒ¬ãƒ™ãƒ«ã§ã‚ã‚‹ã€‚ ãã‚Œã§ã¯MySQL 5.6ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¦ã„ã“ã†ã€‚ InnoDB
twainy 2012/10/02
mysql
ãƒªãƒ³ã‚¯
MySQL Connect 2012ã§ã®ç™ºè¡¨äº‹é … - rkajiyamaâ€™s diary
æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«åºƒå ±å®¤é•·ã®[twitter:@Wagamatt]ãŒé€£ç¶šãƒ„ã‚¤ãƒ¼ãƒˆã—ã¦ãã‚Œã¾ã—ãŸãŒã€ç±³å›½ã§ã®MySQL Connect 2012ã«ã¦å¤šãã®ç™ºè¡¨ãŒã‚ã‚Šã¾ã—ãŸã®ã§è¦ç‚¹ã‚’ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ 10æœˆå¾ŒåŠã«MySQL Tech Tourã¨ã—ã¦ã“ã‚Œã‚‰ã«ã¤ã„ã¦ã®ã‚»ãƒŸãƒŠãƒ¼ã‚’é–‹å‚¬äºˆå®šã§ã™ã®ã§æ˜¯éžã”å‚åŠ ãã ã•ã„ã€‚MySQL Tech Tourã®ãŠç”³ã—è¾¼ã¿ã¯ã“ã¡ã‚‰ã‹ã‚‰ MySQL 5.6 RCãƒªãƒªãƒ¼ã‚¹ ãƒ—ãƒ¬ã‚¹ãƒªãƒªãƒ¼ã‚¹ MySQL Cluster 7.3 DMR (Dvelopment Milestone Release) ãƒ—ãƒ¬ã‚¹ãƒªãƒªãƒ¼ã‚¹ Connector/Python GAãƒªãƒªãƒ¼ã‚¹ MySQL :: Download Connector/Python å•†ç”¨ç‰ˆã®MySQL Enterprise Editionã®æ©Ÿèƒ½è¿½åŠ ãƒ—ãƒ¬ã‚¹ãƒªãƒªãƒ¼ã‚¹ ãƒãƒªã‚·ãƒ¼ãƒ™ãƒ¼ã‚¹ã®ç›£æŸ»æ©Ÿèƒ½ DRBDã‚µãƒãƒ¼ãƒˆã®å†é–‹ Solaris C
twainy 2012/10/01
mysql
ãƒªãƒ³ã‚¯
Logging Deadlock errors
All of Perconaâ€™s open-source software products, in one place, to download as much or as little as you need.
twainy 2012/09/20
mysql
ãƒªãƒ³ã‚¯
How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
twainy 2012/09/16
çµ¶å¯¾ä½¿ã†æ©Ÿä¼šãªã„ã‘ã©ã‚‚ãƒ¼

mysql
ãƒªãƒ³ã‚¯
MySQL vs. LevelDB Â· m1ch1/mapkeeper Wiki Â· GitHub
Introduction The goal of this benchmark is to compare MySQL and LevelDB for disk I/O bound, multiple-reader/multiple-writer workload. Configurations Hardware 2 x Xeon E5620 2.40GHz (HT enabled, 8 cores, 16 threads) Memory: 4GB Disk: RAID-10/2 == 4 Ã— 300GB 15K rpm RAID cache: 512MB Disk cache: off Operating System RHEL Server 5.4, Linux 2.6.18-164.2.1.el5 x86_64, 64-bit File System XFS â€“ noatime,lo
twainy 2012/09/15
MySQL

LevelDB
ãƒªãƒ³ã‚¯
socialtoprunners.jp
This domain may be for sale!
twainy 2012/08/29
mysql
ãƒªãƒ³ã‚¯
ç¬¬2å›ž ioDrive+MySQLå‹‰å¼·ä¼šã®è³‡æ–™ã¾ã¨ã‚
ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã¯ã€IEã‚’æ“¬äººåŒ–ã—ãŸãƒžã‚¹ã‚³ãƒƒãƒˆã‚ãƒ£ãƒ©ã€Œè—æ¾¤ç¥ˆã€ã®PVã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚PVã®å†…å®¹ã¯ã€Œã¤ã¥ãã€ã®æ–‡å—ãŒå‡ºã¦ãã‚‹ãªã©ã€æ—¥æœ¬ã®ã‚¢ãƒ‹ãƒ¡ã‚’æ„è˜ã—ãŸã¤ãã‚Šã¨ãªã£ã¦ãŠã‚Šã¾ã™ã€‚ ã¾ãŸã€Facebookãƒšãƒ¼ã‚¸ãªã©ã‚‚æ—¢ã«å˜åœ¨ã—ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ ãƒ»A...
twainy 2012/08/29
ã‚ˆã¿ãŸã„

MySQL
ãƒªãƒ³ã‚¯
MySQLã§ALTER TABLEæ–‡ã®é€²æ—çŠ¶æ³ã‚’ç¢ºèªã™ã‚‹ - SH2ã®æ—¥è¨˜
MySQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚«ãƒ©ãƒ è¿½åŠ ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†ç·¨æˆã‚’è¡Œã†ã«ã¯ã€ALTER TABLEæ–‡ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚MySQLã®ALTER TABLEæ–‡ã¯ã€å¤‰æ›´å¾Œã®å®šç¾©ã«ã‚‚ã¨ã¥ãä½œæ¥ç”¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã€å¤‰æ›´å‰ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ä½œæ¥ç”¨ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ãƒ‡ãƒ¼ã‚¿ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã€æœ€å¾Œã«äºŒã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å…¥ã‚Œæ›¿ãˆã‚‹ã¨ã„ã†ä»•çµ„ã¿ã«ãªã£ã¦ã„ã¾ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¿½åŠ ã«ã¤ã„ã¦ã‚‚ã€ç¾åœ¨ã®ã¨ã“ã‚å¤§åŠã®ã‚±ãƒ¼ã‚¹ã§å†…éƒ¨çš„ã«ALTER TABLEæ–‡ãŒå®Ÿè¡Œã•ã‚Œã¦ã„ã¾ã™ã€‚ ALTER TABLEæ–‡ã®æ€–ã„ã¨ã“ã‚ã¯ã€å‡¦ç†ãŒã‚‚ã†ã™ãçµ‚ã‚ã‚‹ã®ã‹ã©ã†ã‹ãŒåˆ†ã‹ã‚‰ãªã„ã¨ã“ã‚ã§ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºãŒ1GBã‚’è¶…ãˆã‚‹ã‚ãŸã‚Šã‹ã‚‰åˆ†å˜ä½ã®æ™‚é–“ãŒã‹ã‹ã‚‹ã‚ˆã†ã«ãªã‚Šã€100GBã¨ã‚‚ãªã‚‹ã¨æœ¬å½“ã«çµ‚ã‚ã‚‹ã®ã‹ï¼Ÿã¨è¦‹ã¦ã„ã¦ä¸å®‰ã«ãªã‚Šã¾ã™ã€‚ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹æ™‚é–“ãŒé™ã‚‰ã‚Œã¦ã„ã‚‹å ´åˆã¯ã€ä½œæ¥ã‚’ä¸æ–ã™ã¹ãã‹ã©ã†ã‹é›£ã—ã„åˆ¤æ–ã‚’è¿«ã‚‰ã‚Œã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ å®Ÿã¯ã€ã¨ã„ã†ã»ã©ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€ALTER
twainy 2012/08/07
mysql
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 Reference Manual :: 17.20 InnoDB memcached Plugin
Enabling Automatic InnoDB Configuration for a Dedicated MySQL Server
twainy 2012/08/06
mysql
ãƒªãƒ³ã‚¯
MySQL 5.6ã«ãŠã‘ã‚‹sync_binlog=1ã®æ”¹å–„ã«ã¤ã„ã¦ï¼†å‹‰å¼·ä¼šã®ãŠçŸ¥ã‚‰ã› - SH2ã®æ—¥è¨˜
2012å¹´6æœˆã®ã‚¨ãƒ³ãƒˆãƒªã®ç¶šãã§ã™ã€‚å‰å›žã¯åŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã‚ˆã‚‹ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯é…å»¶ã®ã‚ã‚‹ç’°å¢ƒã«ãŠã„ã¦ã€MySQLã®æ€§èƒ½ãŒã©ã®ç¨‹åº¦ä½Žä¸‹ã™ã‚‹ã®ã‹ã¨ã„ã†ã“ã¨ã‚’ç¢ºèªã—ã¾ã—ãŸã€‚ãã®ä¸ã§ã‚‚ç‰¹ã«sync_binlogãŒ1ã«è¨å®šã•ã‚Œã¦ã„ã‚‹å ´åˆã€æ€§èƒ½ãŒå¤§ããä½Žä¸‹ã™ã‚‹ã¨ã„ã†ã“ã¨ãŒåˆ†ã‹ã‚Šã¾ã—ãŸã€‚å‚è€ƒã¨ã—ã¦Amazon RDSã®ãƒžãƒ«ãƒAZãƒ‡ãƒ—ãƒã‚¤ãƒ¡ãƒ³ãƒˆã«ãŠã„ã¦ã¯ã€æ€§èƒ½ã¨ä¿¡é ¼æ€§ã®ãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•ã‚’è€ƒæ…®ã—ãŸçµæžœã€sync_binlogãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§0ã«è¨å®šã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã‚’èª¿æŸ»ã—ã¾ã—ãŸã€‚ ã‚¿ã‚¤ãƒˆãƒ«ã§ãƒã‚¿ãƒãƒ¬ã—ã¦ã„ã¾ã™ãŒã€MySQLã®æ¬¡æœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã€MySQL 5.6ã§ã“ã®sync_binlog=1ã®æ€§èƒ½ãŒå¤§ããæ”¹å–„ã—ã¾ã™ã€‚å‰å›žã¨åŒã˜è² è·ãƒ†ã‚¹ãƒˆã‚’MySQL 5.5.25ã‹ã‚‰MySQL 5.6.6-labsã«å·®ã—æ›¿ãˆã¦è¡Œã£ãŸçµæžœã‚’ã€ä»¥ä¸‹ã«ç¤ºã—ã¾ã™ã€‚ å‰å›žã®MySQL 5.5.25ã¨ç•°ãªã‚Šã€sync_binlog=1ã«ãŠ
twainy 2012/07/17
mysql
ãƒªãƒ³ã‚¯
Meet Percona Team at OSCON
twainy 2012/07/16
mysql
ãƒªãƒ³ã‚¯
MySQL binlog API ã¯ row based mode ã§ã“ãã€ãã®çœŸä¾¡ã‚’ç™ºæ®ã™ã‚‹!! - tokuhirom's blog
ç©ºå‰ã® MySQL binlog API ãƒ–ãƒ¼ãƒ ã§ã™ãŒã€ã¿ãªã•ã‚“ libreplication ã® examples/basic-[12] ã‚’å®Ÿè¡Œã™ã‚‹ã ã‘ã§æº€è¶³ã—ã¦ã—ã¾ã£ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ã—ã‹ã—ã€libreplication ã®ãŠã‚‚ã—ã‚ã„ã®ã¯ examples/mysql2lucene ã®æ–¹ãªã‚“ã§ã™ã€‚ 3ã¤ã®ãƒã‚®ãƒ³ã‚°ãƒ¢ãƒ¼ãƒ‰æ™®æ®µã¯ã‚ã¾ã‚Šæ„è˜ã—ãªã„ã‹ã‚‚ã—ã‚Œãªã„ã§ã™ãŒ mysql ã® binlog ã«ã¯ statement based, row based, mixed ã®3ç¨®é¡žãŒã‚ã‚Šã¾ã™ã€‚ statement based ã¯ã€å®Ÿéš›ã«å®Ÿè¡Œã•ã‚ŒãŸ SQL ãŒè¨˜éŒ²ã•ã‚Œã¾ã™ã€‚ä¸€éƒ¨ã®é–¢æ•°ã§ã¡ã‚‡ã£ã¨å±é™ºã§ã™ã€‚ row based ã§ã¯ã€å®Ÿéš›ã«å¤‰æ›´ã•ã‚ŒãŸè¡Œã®ãƒ‡ãƒ¼ã‚¿ãŒè¨˜éŒ²ã•ã‚Œã¾ã™ã€‚ mixed ã§ã¯ã€å±é™ºãªé–¢æ•°ã‚’ã¤ã‹ã£ãŸå ´åˆãªã©ã«ã¯ row based ã§è¨˜éŒ²ã—ã€ãã†ã§ãªã‘ã‚Œã° statement based
twainy 2012/07/11
mysql
ãƒªãƒ³ã‚¯
Impact of memory allocators on MySQL performance
All of Perconaâ€™s open-source software products, in one place, to download as much or as little as you need.
twainy 2012/07/09
mysql
ãƒªãƒ³ã‚¯
MySQL Binlog APIã‚’è©¦ã—ã¦ã¿ã‚‹ - As a Futurist...
MySQL ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ç´ æ™´ã‚‰ã—ã„ä»•çµ„ã¿ãªã®ã§ã™ãŒã€ã¡ã‚‡ã£ã¨å‡ã£ãŸã“ã¨ã‚’ã—ã‚ˆã†ã¨ã™ã‚‹ã«ã¯æ©Ÿèƒ½ãŒé™ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ç‰¹ã«ã€MySQL ã®æ›´æ–°ã‚’ä»–ã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã«ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã—ãŸã„ã‚ˆã†ãªæ™‚ã¯ã€Trigger ã‚’ä½¿ã£ã¦è¶…é ‘å¼µã‚‹ã®ã¯ã‚¤ãƒžã‚¤ãƒã§ã€ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ä½¿ã£ãŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ä»•çµ„ã¿ã‚’ãã®ã¾ã¾æ‹¡å¼µã—ã¦ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã™ã‚‹ã‚ˆã†ãªãƒ¯ãƒ¼ã‚«ãƒ¼ã‚’æ›¸ããŸããªã‚‹ã‚‚ã®ã§ã™ã€‚ ãã‚“ãªæ™‚ã«ä½¿ãˆã‚‹ä¾¿åˆ©ãª API ã¨ã—ã¦ã€Binlog API ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ã¾ã é–‹ç™ºé€”ä¸Šã§ã¯ã‚ã‚Šã¾ã™ãŒã€æœŸå¾…ã®æŒã¦ã‚‹ API ã§ã™ã€‚ assets.en.oreilly.com/1/event/61/Binary log API_ A Library for Change Data Capture using MySQL Presentation.pdf è©¦ã—ã«ã©ã‚“ãªã‚‚ã‚“ãªã®ã‹ä½¿ã£ã¦ã¿ã¾ã—ãŸã€‚ è¿½è¨˜ 2012/07/09
twainy 2012/07/09
ã“ã‚Œã¯é¢ç™½ãã†

MySQL

API
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸