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

clavier id:clavier

Pluginã¨MySQLã«é–¢ã™ã‚‹clavierã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

${{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ã‚’æ‹¡å¼µã™ã‚‹
1. MySQLã‚’æ‹¡å¼µã™ã‚‹ Powered by Rabbit 2.1.9 MySQLã‚’æ‹¡å¼µã™ã‚‹ MySQL User Conference 2015 ã¨ã¿ãŸã¾ã•ã²ã‚ 2015-12-15 2. MySQLã‚’æ‹¡å¼µã™ã‚‹ Powered by Rabbit 2.1.9 è‡ªå·±ç´¹ä»‹ ã¨ã¿ãŸ ã¾ã•ã²ã‚ http://tmtms.hatena blog.com http://twitter.com/tmtms https://github.com/tmtm é•·é‡ŽçœŒåŒ—éƒ¨åœ¨ä½ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼( Ruby & C ) é•·é‡Žã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢æŠ€è¡“è€…ã‚°ãƒ«ãƒ¼ãƒ—(NSEG) 3. MySQLã‚’æ‹¡å¼µã™ã‚‹ Powered by Rabbit 2.1.9 è‡ªå·±ç´¹ä»‹ æ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼šä»£è¡¨ MySQL 3.21 ã®æ—¥æœ¬èªžå¯¾å¿œ (1998) MySQLã®Rubyãƒã‚¤ãƒ³ãƒ‡ã‚£ãƒ³ã‚°ä½œæˆ (1998) OSSè²¢çŒ®è€…è³ž 2013
clavier 2015/12/22
MySQL

plugin
ãƒªãƒ³ã‚¯
MySQL5.6ã®æ–°æ©Ÿèƒ½ã€ŒInnoDB Memcached Pluginã€ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’æ¤œè¨¼ã—ã€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ æ¡ˆä»¶ã«ä½¿ãˆãã†ã‹æ¤œè¨¼ã—ã¦ã¿ã¾ã—ãŸï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ãƒ›ãƒ¼ãƒ æŠ€è¡“ãƒ–ãƒã‚° MySQL5.6ã®æ–°æ©Ÿèƒ½ã€ŒInnoDB Memcached Pluginã€ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’æ¤œè¨¼ã—ã€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ æ¡ˆä»¶ã«ä½¿ãˆãã†ã‹æ¤œè¨¼ã—ã¦ã¿ã¾ã—ãŸ MySQL5.6ã®æ–°æ©Ÿèƒ½ã€ŒInnoDB Memcached Pluginã€ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’æ¤œè¨¼ã—ã€ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ æ¡ˆä»¶ã«ä½¿ãˆãã†ã‹æ¤œè¨¼ã—ã¦ã¿ã¾ã—ãŸ matsuiã§ã™ã€‚ å…ˆæ—¥6/1ã«è¡Œã‚ã‚ŒãŸç¬¬å››å›žæœå¹ŒMySQLå‹‰å¼·ä¼šã®ä¸ã§ã€MySQL5.6ã®æ–°æ©Ÿèƒ½ã€ŒInnoDB Memcached Pluginã€ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã«ã¤ã„ã¦èª¿ã¹ã¦ã¿ã¾ã—ãŸã®ã§ã€è¨˜äº‹ã«ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ InnoDB Memcached Pluginã¨ã¯ ã€ŒInnoDB Memcached Pluginã€ã¨ã¯ã€MySQL5.6ã‹ã‚‰ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã€SQLã‚’ä½¿ã‚ãšMemcachedãƒ—ãƒãƒˆã‚³ãƒ«ã‚’ä½¿ã£ã¦InnoDBã®ãƒ‡ãƒ¼ã‚¿ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ ä¸»ãªãƒ¡ãƒªãƒƒãƒˆã¯ãã®é«˜
clavier 2013/06/05
memcached

innodb

mysql

plugin
ãƒªãƒ³ã‚¯
[Linux] yum ã‚³ãƒžãƒ³ãƒ‰ã‚’æ‹¡å¼µã™ã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¾ã¨ã‚ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
å…ˆæ—¥ã€æ±äº¬ã‚¹ã‚«ã‚¤ãƒ„ãƒªãƒ¼ã‚’è¦‹ã«è¡Œã£ã¦ãã¾ã—ãŸ nakamura ã§ã™ï¼ã‚¹ã‚«ã‚¤ãƒ„ãƒªãƒ¼ã¯ã‚‚ã¡ã‚ã‚“ã™ã”ã‹ã£ãŸã‚“ã§ã™ã‘ã©ã€ãã‚Œä»¥ä¸Šã«ã™ãè¿‘ãã«ã‚ã‚‹ ç©ºé£›ã¶ã†ã‚“ã¡ ã«ãƒ“ãƒƒã‚¯ãƒªã—ã¾ã—ãŸã€‚ã™ã”ã„æ™‚ä»£ã«ãªã£ãŸãªãƒ»ãƒ»ãƒ»ã€‚ ã•ã¦ã•ã¦ä»Šæ—¥ã¯ Redhatã€CentOSã€Fedora ãªã© rpm ç³»ã®ãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½¿ã£ã¦ã„ã‚‹äººãªã‚‰ãŠã•ãˆã¦ãŠããŸã„ yum ã‚³ãƒžãƒ³ãƒ‰ã‚’æ‹¡å¼µã™ã‚‹ãŸã‚ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’ã„ãã¤ã‹ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ãƒ—ãƒ©ã‚°ã‚¤ãƒ³è‡ªä½“ã‚‚ yum ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ã®ã§å°Žå…¥ã‚‚æ¥½ãƒãƒ³ã§ã™ã‚ˆï½žã€‚ ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ç´¹ä»‹ ç’°å¢ƒã¯ CentOS-6.x ç³»ã§ã™ã€‚ fastestmirror æŽ¥ç¶šé€Ÿåº¦ã®é€Ÿã„ãƒŸãƒ©ãƒ¼ã‚µãƒ¼ãƒã‚’è‡ªå‹•ã§é¸æŠžã—ã¦ãã‚Œã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã™ã€‚ç¢ºã‹ä»Šã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§å…¥ã£ã¦ã‚‹ã®ã‹ãªï¼Ÿ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ä»¥ä¸‹ã€‚ yum install yum-plugin-fastestmirror changelog --chan
clavier 2013/04/28
mysql

plugin

linux

yum

tips
ãƒªãƒ³ã‚¯
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 ã«ã§
clavier 2013/04/27
innodb

memcached

mysql

Plugin
ãƒªãƒ³ã‚¯
mysql5.6ã‹ã‚‰å¯¾å¿œã—ãŸInnoDB memcached pluginã‚’ä½¿ã† - UNIXçš„ãªã‚¢ãƒ¬
ã¤ã„ã«MySQL5.6ã®GAç‰ˆãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ä»Šå›žã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã¯ã‹ãªã‚Šå¤§å¹…ãªæ©Ÿèƒ½æ”¹ä¿®ãŒå…¥ã£ã¦ã„ã¦ã€ã„ã‚ã„ã‚ã¨è©¦ã—ã¦ã¿ãŸã„ã‚‚ã®ãŒãŸãã•ã‚“ã‚ã‚Šã¾ã™ã€‚ ãã®ä¸ã§ã‚‚æ°—ã«ãªã‚‹ã®ãŒInnodb memcached pluginã§ã™ã€‚å°‘ã—å‰ã‹ã‚‰è©±é¡Œã«ã¯ãªã£ã¦ã„ã¾ã—ãŸãŒã€MySQLã‚’memcacheã®ãƒ—ãƒãƒˆã‚³ãƒ«ã§æ“ä½œã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã¨ã„ã†ã‚¢ãƒ¬ã§ã™ã€‚ ã‚‚ã®ã™ã”ã„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå‡ºã‚‹ã¨ã„ã†ã‚¦ãƒ¯ã‚µã®handersocketã¨ã„ã†é¸æŠžè‚¢ã‚‚ã‚ã‚Šã¾ã™ãŒã€æ¨™æº–ã§ã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†éƒ¨åˆ†ã«ä»Šå¾Œã®æœŸå¾…ã‚‚ã§ãã‚‹ã®ã§è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã¾ãšã€MySQL5.6.10ã‚’ãƒ“ãƒ«ãƒ‰ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ä»Šå›žã®æ‰‹é †ã¯CentOS5.8ã§è©¦ã—ã¦ã„ã¾ã™ã€‚ $ yum install -y gcc-c++ zlib-devel cmake ncurses-devel $ test -d ~/src || mkdir ~
clavier 2013/02/17
memcached

mysql

plugin
ãƒªãƒ³ã‚¯
MySQL 5.1â†’5.6ã®my.cnfã®å·®åˆ†ã¨ã‹ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQL 5.1ã§ä½¿ã£ã¦ãŸmy.cnfã‚’è©¦ã—ã«5.6ã§å‹•ãã‚ˆã†ã«ã—ãŸã¨ãã®å·®åˆ†ã™ã€‚ç¶²ç¾…çš„ã«ã¯èª¿ã¹ã¦ãªã„ã‚“ã§ä»–ã«ã‚‚å»ƒæ¢ã«ãªã£ãŸãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ã‚ã‚‹ã‹ã‚‚ã§ã™ã€‚ã‚ãã¾ã§å‚è€ƒã¾ã§ã«ã€‚ # log-binã«ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿æŒ‡å®šã—ãªã„ã¨æ€’ã‚‰ã‚Œã¾ã™ -log-bin +log-bin = mysqld-bin # old-passwordsã¯ã‚ªãƒ³ã€ã‚ªãƒ•ã ã‘ã˜ã‚ƒãªãã¦å¼•æ•°(0, 1, 2)ãŒå¿…é ˆã«ãªã£ã¦ã€å¼•æ•°ã®å€¤ã«ã‚ˆã£ã¦æŒ™å‹•ãŒã‹ã‚ã‚Šã¾ã™ã€‚ -old-passwords +old-passwords = 1 # ã“ã‚ŒæŒ‡å®šã—ãªã„ã¨ã€ãƒªãƒ¢ãƒ¼ãƒˆã‹ã‚‰ã®pre-4.1ãªèªè¨¼æ–¹æ³•ã§æŽ¥ç¶šã§ããªã„ã§ã™ +skip-secure-auth # ã“ã‚ŒæŒ‡å®šã—ãªã„ã¨ã€pre-4.1ãªèªè¨¼æ–¹æ³•ã§æŽ¥ç¶šã§ããªã„ã§ã™â˜…ä¸‹ã«è¿½è¨˜ã‚ã‚Š +default-authentication-plugin = mysql_old_password # ãƒ‘ãƒ©ãƒ¡ãƒ¼
clavier 2012/10/03
plugin

MySQL

ã‚ã¨ã§èªã‚€

innodb

my.cnf
ãƒªãƒ³ã‚¯
Firefox æ¤œç´¢ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã« MySQL Reference ã‚’è¿½åŠ ã™ã‚‹ - memo.xight.org
mysql.src # Mozilla search plugin for MySQL Reference # by Yoshiki SATO <xight.org+memo@gmail.com>. # http://xight.org/misc/firefox/searchplugins/ # This file is released into the public domain. # # Version: 0.0.1 (2006-03-12) # Country: JP # Language: ja <search version="0.0.1" name="MySQL Reference" description="MySQL Reference" sourceTextEncoding="0" method="get" action="http://dev.mysql.com/do
clavier 2006/03/15
firefox

plugin

mysql
ãƒªãƒ³ã‚¯
1