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

yappo id:yappo

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

DeNAãŒç¤¾å†…åˆ©ç”¨ã—ã¦ã„ã‚‹MySQLã®è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ãƒ„ãƒ¼ãƒ«ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹é–‹å§‹
MySQLãŒãƒ€ã‚¦ãƒ³ã—ãŸã¨ãã«è‡ªå‹•çš„ã«åˆ¥ã®MySQLã¸å‡¦ç†ã‚’å¼•ãç¶™ãã“ã¨ã§ã€é«˜å¯ç”¨æ€§ã‚’å®Ÿç¾ã™ã‚‹ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ãƒ„ãƒ¼ãƒ«ã€ŒMySQL-MHA: MySQL Master High Availability manager and toolsã€ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦å…¬é–‹ã•ã‚ŒãŸã“ã¨ã‚’ã€ä½œè€…ã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ãŒãƒ–ãƒã‚°ã§ä¼ãˆã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Announcing MySQL-MHA: "MySQL Master High Availability manager and tools" æ¾ä¿¡æ°ã¯ãƒ¢ãƒã‚²ãƒ¼ãªã©ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã«å‹¤å‹™ã—ã¦ãŠã‚Šã€MySQL-MHAã«ã‚ˆã‚‹è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼æ©Ÿèƒ½ã¯DeNAã®ã‚¤ãƒ³ãƒ•ãƒ©é‹ç”¨ã‚’æ”¯ãˆã¦ã„ã‚‹ã¨ã®ã“ã¨ã€‚åŒæ°ã®ãƒ–ãƒã‚°ã‹ã‚‰å¼•ç”¨ã—ã¾ã™ã€‚ Difficulties of master failover is one of
yappo 2011/08/04
dena++

mysql
ãƒªãƒ³ã‚¯
MyISAMã¨InnoDBã®ã©ã¡ã‚‰ã‚’ä½¿ã†ã¹ãã‹
Twitterã§è©±é¡Œã«ãªã£ã¦ãŸã®ã§ç°¡å˜ã«ã¾ã¨ã‚ã¾ã—ãŸã€‚ â—MyISAMã«ã—ã‹ç„¡ã„æ©Ÿèƒ½ã‚’ä½¿ã„ãŸã„å ´åˆã¯MyISAMã‚’ä½¿ã†ã—ã‹ãªã„ ãƒ»å…¨æ–‡æ¤œç´¢ (Tritonnã‚„Sphinx) ãƒ»GIS â—InnoDBã®åˆ©ç‚¹(MyISAMã®æ¬ ç‚¹) â–²éšœå®³å¯¾å¿œç³» ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ã¦ã‚‚å†èµ·å‹•ã™ã‚‹ã ã‘ã§ãƒªã‚«ãƒãƒªãŒã§ãã‚‹ ãƒ»ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒªã«ã‹ã‹ã‚‹æ™‚é–“ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã«æ¯”ä¾‹ã™ã‚‹ã‚ˆã†ãªã“ã¨ã¯ãªãã€ã‚³ãƒŸãƒƒãƒˆæ¸ˆã¿ã®ãƒ‡ãƒ¼ã‚¿ã¯ä¿®å¾©ã§ãã‚‹ (å·¨å¤§ãªMyISAMãƒ†ãƒ¼ãƒ–ãƒ«ã®REPAIRã«ã¯æ•°æ—¥å˜ä½ã§æ™‚é–“ãŒã‹ã‹ã‚‹ã“ã¨ãŒã‚ã‚‹) ãƒ»ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒã§ãã‚‹ ãƒ»INSERTã‚„LOAD DATAãªã©ã‚’å®Ÿè¡Œã—ã¦ã„ã‚‹é€”ä¸ã§Ctrl+Cã§ãã®æ›´æ–°ç³»SQLæ–‡ã‚’æ¢ã‚ã¦ã‚‚ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã¯å£Šã‚Œãªã„ã—ã€ä¸é€”åŠç«¯ãªçŠ¶æ…‹ã§æ›´æ–°ã•ã‚Œã‚‹ã“ã¨ã‚‚ç„¡ã„ã—ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ãŒæ¢ã¾ã‚‹ã“ã¨ã‚‚ç„¡ã„ â–²æ€§èƒ½ç³» ãƒ»è¡Œãƒ¬ãƒ™ãƒ«ãƒãƒƒã‚¯ãªã®ã§ä¸¦åˆ—æ€§ãŒé«˜ã„(MyISAMã¯ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯)ã€‚ã¾ãŸSEL
yappo 2009/10/27
mysql
ãƒªãƒ³ã‚¯
InnoDB Plugin 1.0.4 - InnoDBå²ä¸Šæ¥µã‚ã¦é‡è¦ãªãƒªãƒªãƒ¼ã‚¹
æ—¥æœ¬æ™‚é–“ã®ä»Šæ—¥ã€InnoDB Pluginã®æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³1.0.4ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ã“ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ã€ã€Œãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’æœ‰åŠ¹ã«ã™ã‚‹ã¨ã‚°ãƒ«ãƒ¼ãƒ—ã‚³ãƒŸãƒƒãƒˆãŒåŠ¹ã‹ãªããªã‚‹å•é¡Œã€ãŒä¿®æ£ã•ã‚Œã¦ã„ã¾ã™ã€‚ã»ã¨ã‚“ã©ã®ç’°å¢ƒã«ã¨ã£ã¦æ¥µã‚ã¦åŠ¹æžœã®é«˜ã„ä¿®æ£ã§ã™ã€‚ã»ã‹ã«ã‚‚I/Oã‚¹ãƒ¬ãƒƒãƒ‰ã®å¤šé‡åŒ–(åŒæ§˜ã®ã‚‚ã®ãŒMySQL5.4ã«ã‚‚æè¼‰)ãªã©åŠ¹æžœçš„ãªä¿®æ£ãŒè¡Œãªã‚ã‚Œã¦ã„ã¾ã™ã€‚ InnoDB Pluginã¯ã¾ã GA(å®‰å®šç‰ˆ)ã§ã¯ãªã„ã®ã§ã€å“è³ªé¢ã§ã¯æ¨™æº–æè¼‰ã•ã‚Œã¦ã„ã‚‹InnoDBã‚ˆã‚Šã‚‚è½ã¡ã¾ã™ã€‚ãŸã ã—MySQL Enterpriseã‚µãƒ–ã‚¹ã‚¯ãƒªãƒ—ã‚·ãƒ§ãƒ³ã‚’è²·ã£ã¦ã„ã‚‹æ–¹ã§ã‚ã‚Œã°è¿½åŠ è²»ç”¨ç„¡ã—ã§InnoDB Pluginã®ã‚µãƒãƒ¼ãƒˆã‚’å—ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã§ã€ãŠæ°—è»½ã«è©¦ã—ã¦ã¿ã¦é ‚ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ ã‚°ãƒ«ãƒ¼ãƒ—ã‚³ãƒŸãƒƒãƒˆå•é¡Œä¿®å¾©ã®åŠ¹æžœã®ã»ã©ã¯ã€ä¸€ç›®çžç„¶ãªã®ã§å›³ã‚’è¦‹ãŸæ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã§ã—ã‚‡ã†ã€‚ä¸‹å›³ã¯ã€mysqlslapã§ã€è¤‡æ•°ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ä¸¦
yappo 2009/09/04
InnoDBã®2pc

db

mysql
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: Mycached: memcached protocol support for MySQL
It is a well-known fact that the bottlenecks of MySQL does not exist in its storage engines, but rather in the core, for example, its parser and execution planner.Â Last weekend I started to wonder how fast MySQL could be if those bottlenecks were skipped.Â Not being able to stop my curiousity, I startedÂ adding memcached proctol support to MySQL as a UDF.Â And that is Mycached. From what I unders
yappo 2009/08/26
:msgpack ã‚‚ã»ã™ãƒ

mycached

memcached

mysql
ãƒªãƒ³ã‚¯
å‹‰å¼·ä¼šã€ŒMySQL Hackingã®æ‰‹å¼•ãã€ã‚’çµ‚ãˆã¦
æ˜¨æ—¥ã¯ã€ã‚°ãƒªãƒ¼å‹‰å¼·ä¼šã«ã¦ã€ŒMySQLãƒãƒƒã‚ãƒ³ã‚°ã®æ‰‹å¼•ãã€ã¨ã„ã†ãƒ†ãƒ¼ãƒžã§ç™ºè¡¨ã‚’ã—ã¾ã—ãŸã€‚è³‡æ–™ã¨ãƒ‡ãƒ¢ã«ä½¿ç”¨ã—ãŸã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚„ãƒ“ãƒ«ãƒ‰ã‚¹ã‚¯ãƒªãƒ—ãƒˆç‰ã¯ã“ã¡ã‚‰ã«å…¬é–‹ã—ã¦ã„ã¾ã™(ã‚µãƒ³ãƒ—ãƒ«ãƒ—ãƒã‚°ãƒ©ãƒ ã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã«ã¯ã‚½ãƒ¼ã‚¹ã‹ã‚‰ãƒ“ãƒ«ãƒ‰ã—ãŸMySQL5.1ä»¥é™ãŒå¿…è¦)ã€‚å£°ã‚’ã‹ã‘ã¦ãã ã•ã£ãŸã‚°ãƒªãƒ¼ã®ä¸€äº•ã•ã‚“ã‚„ã€ä¼šå ´æº–å‚™ãªã©è«¸æ‰‹ç¶šãã‚’è¡Œãªã£ã¦ãã ã•ã£ãŸã‚°ãƒªãƒ¼ã®ã‚¹ã‚¿ãƒƒãƒ•ã®æ–¹ã€…ã€å‚åŠ ã•ã‚ŒãŸçš†ã•ã¾ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ â—å‚åŠ è€…æ•°ã®æ„å¤–ãªå¤šã• ç„¡æ–™ã®å‹‰å¼·ä¼šã¨ã¯ã„ãˆã€ã“ã®ã‚ˆã†ãªãƒžãƒ‹ã‚¢ãƒƒã‚¯ãªãƒ†ãƒ¼ãƒžã§ã€60åå®šå“¡ã®ã¨ã“ã‚ã«150åã‚’è¶…ãˆã‚‹å¿œå‹ŸãŒæ¥ãŸã¨ã„ã†ã®ã¯é©šãã¾ã—ãŸã€‚ç›¸å½“æ•°ã®æ–¹ãŒæŠ½é¸è½ã¡ã—ã¦ã—ã¾ã£ãŸã®ã¯æ®‹å¿µã§ã—ãŸãŒã€è©•åˆ¤ãŒè‰¯ã‘ã‚Œã°ä¼¼ãŸã‚ˆã†ãªãƒ†ãƒ¼ãƒžã§ã®ã‚»ãƒŸãƒŠãƒ¼ã‚’ã¾ãŸã©ã“ã‹ã§è¡Œãªã„ãŸã„ã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ è‡ªåˆ†ã¯MySQLã®ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚°ã¨ã„ã†ã€MySQLã®ä½¿ã„æ‰‹ã¨ã—ã¦ã®å°‚é–€è·(ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‹é‹ç”¨ç®¡ç†ã¨ã‹)ã«å¾“äº‹
yappo 2009/08/10
mysql

udf
ãƒªãƒ³ã‚¯
InnoDBãƒ†ãƒ¼ãƒ–ãƒ«ã§unique keyãŒã‚ã‚‹å ´åˆã€ãã‚Œã‚’primary keyã«ã™ã‚‹ã¹ãã‹ã©ã†ã‹ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
InnoDBãªãƒ†ãƒ¼ãƒ–ãƒ«ã®ãŠè©±ã§ã™ã€‚ ã¨ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã€ã„ãã¤ã‹ã‚ã‚‹ã‚«ãƒ©ãƒ ã®ã†ã¡ã€ãŸã ã²ã¨ã¤ã®ã‚«ãƒ©ãƒ ãŒunique keyã«ãªã‚Šå¾—ã‚‹ã‚‚ã®ã ã¨ã—ã¾ã™ã€‚ ã“ã†ã„ã†ã¨ãã¯ã€ãã®unique keyã¯ç„¡æ¡ä»¶ã§primary keyã«ã—ãŸã»ã†ãŒã‚¤ã‚¤ï¼ã¨æ€ã£ã¦ãŸã‚“ã§ã™ãŒã€èª¿ã¹ã¦ã¿ã‚‹ã¨å¿…ãšã—ã‚‚ãã†ã§ãªã„ã‚ˆã†ãªã®ã§ã€ä»Šã®ã¨ã“ã‚ã®ãƒ¢ãƒ¤ãƒ¢ãƒ¤ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ æ•™ãˆã¦ï¼ å‰ã„äººï¼ï¼ äºˆå‚™çŸ¥è˜ High Performance MySQL ä½œè€…: Baron Schwartz,Peter Zaitsev,Vadim Tkachenko,Jeremy D. Zawodny,Arjen Lentzå‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: Oreilly & Associates Incç™ºå£²æ—¥: 2008/06/01ãƒ¡ãƒ‡ã‚£ã‚¢: ãƒšãƒ¼ãƒ‘ãƒ¼ãƒãƒƒã‚¯è³¼å…¥: 4äºº ã‚¯ãƒªãƒƒã‚¯: 33å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (8ä»¶) ã‚’è¦‹ã‚‹ã‹ã‚‰ã®è¶…æŠœç²‹ã€‚ã—ã‹ã—ã“ã®æœ¬ã¯ç¥žæœ¬
yappo 2009/07/27
mysql
ãƒªãƒ³ã‚¯
Time to move on
Rambling thoughts about recent events in MariaDB / MySQL or Free software/Open source I have now departed from Sun and joined my own company, Monty Program Ab. There were a lot of rumors around me resigning in August/September last year. I didn't back then want to comment on the rumors, because I was still trying to work something out with Sun. Now I can finally describe a bit of what was going on
yappo 2009/02/05
]ã†ã£ã»

mysql
ãƒªãƒ³ã‚¯
mixi Engineersâ€™ Blog Â» æœŸé–“é™å®šã®æ–°æ©Ÿèƒ½ã€Œã‚¨ã‚³ãƒ¼ã€ç™»å ´
ã“ã‚“ã«ã¡ã¯ã€‚mixié–‹ç™ºéƒ¨ã®youheiã§ã™ã€‚ ä»Šå›žã¯å…ˆæ—¥8æœˆ4æ—¥ã«ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€Œã‚¨ã‚³ãƒ¼ã€ã«ã¤ã„ã¦æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚¨ã‚³ãƒ¼ã¨ã¯ ã¾ãšã¯ã‚¨ã‚³ãƒ¼ã¨ã¯ã©ã†ã„ã†æ©Ÿèƒ½ã‹ã®ã”ç´¹ä»‹ã§ã™ãŒã€ãƒ—ãƒãƒ¢ãƒ¼ã‚·ãƒ§ãƒ³ãƒšãƒ¼ã‚¸ãŒã”ã–ã„ã¾ã™ã®ã§ãã¡ã‚‰ã‚’ã”è¦§ã„ãŸã ã‘ã‚Œã°å¹¸ã„ã§ã”ã–ã„ã¾ã™ã€‚ http://mixi.jp/guide_echo.pl ã„ãã¤ã‹æŠœç²‹ã—ã¾ã™ã¨ã€ ã‚ãªãŸã®"ä»Š"ã‚’ä¸€è¨€ã«ã—ã¦ã¿ã¾ã›ã‚“ã‹ï¼Ÿèª°ã‹ã«ä¼ãˆãŸã„ã“ã¨ã€ã²ã¨ã‚Šã”ã¨ç‰ã€ä½•ã§ã‚‚OKï¼ æ°—è»½ãªæ–°ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã§ã™ã€‚ ãŸã¨ãˆã°ã€ã€Œä»Šæ—¥ã¯ã„ã„å¤©æ°—ã ãªã€œã€ã¨ã„ã†ã€ã²ã¨ã‚Šã”ã¨ã‹ã‚‰ã€ã€ŒãŠè…¹ã™ã„ãŸãƒ¼ï¼èª°ã‹ãƒ©ãƒ³ãƒã«ã„ã“ã†ã‚ˆï¼ã€ã¨ã„ã†ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸çš„ãªä½¿ã„æ–¹ã¾ã§ã€ã€Œã‚¨ã‚³ãƒ¼ã€ã®æ¥½ã—ã¿æ–¹ã¯ã‚ãªãŸæ¬¡ç¬¬ï¼ ãƒžã‚¤ãƒŸã‚¯ã‚·ã‚£åŒå£«ã§ã€Œã‚¨ã‚³ãƒ¼ã€ã‚’ä½¿ã†ã¨ãƒ›ãƒ¼ãƒ ã«ãŠäº’ã„ã®æ›¸ãã“ã¿ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚ æ°—ã«ãªã£ãŸæ›¸ãã“ã¿ã«ã¯ã€è¿”ä¿¡ã™ã‚‹ã“ã¨ã‚‚ã§ãã¡ã‚ƒã„ã¾ã™ã€‚ã‚ãªãŸãŒãµã¨æ›¸ãã“ã‚“ã ä¸€è¨€ã«ã€æ€ã‚ã¬è¿”
yappo 2008/08/06
mysql

q4m
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2008/02/triton-embed-primary-key.php
yappo 2008/02/05
joinãƒžãƒ‹ã‚¢

tritonn

mysql

senna
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2008/01/dbix-replicate.php
yappo 2008/01/29
mysql

coderepos
ãƒªãƒ³ã‚¯
MySQL Server Blog | News from the MySQL Server Team
yappo 2008/01/16
mysql

sun
ãƒªãƒ³ã‚¯
mysqlã«perlã‚¤ãƒ³ã‚¿ãƒ—ãƒªã‚¿ã‚’çµ„ã¿è¾¼ã‚“ã§ã¿ã‚‹ - ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãŸã‘ã—ï¼ˆå¯…å¹´ï¼‰ã®æ—¥è¨˜
ä»¥å‰ã€Œmysqlã«ç‹¬è‡ªé–¢æ•°ã‚’çµ„ã¿è¾¼ã‚€ï¼ˆUDFï¼‰ã€ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ã¦ã¿ã¾ã—ãŸãŒã€ä»Šå›žã¯ãã‚Œã®å»¶é•·ã§ã€mysqlã®UDFã¨ã—ã¦perlã‚¤ãƒ³ã‚¿ãƒ—ãƒªã‚¿ã‚’çµ„ã¿è¾¼ã‚“ã§ã¿ã‚ˆã†ã¨è¨€ã†å®Ÿé¨“ã§ã™ã€‚ mysqlã«perlã‚’çµ„ã¿è¾¼ã‚“ã§ä½•ãŒã†ã‚Œã—ã„ã‹ã£ã¦ã„ã†ã¨ã€ç°¡å˜ãªperlã‚¹ã‚¯ãƒªãƒ—ãƒˆã§è‡ªç”±ã«mysqlã®é–¢æ•°ã‚’ä½œã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ä¾‹ãˆã° URLãƒªã‚¹ãƒˆã‹ã‚‰å®Ÿéš›ã«LWPã§å†…å®¹ã‚’å–å¾—ã—ã¦ãã¦ä½•ã‹ã®å‡¦ç†ã‚’ã—ãŸçµæžœã‚’è¡¨ç¤ºã—ãŸã‚Š perlã®æ£è¦è¡¨ç¾ã§ä»»æ„ã®ãƒ•ã‚£ãƒ«ã‚¿ãƒªãƒ³ã‚°é–¢æ•°ã‚’æ›¸ã„ã¦ã¿ãŸã‚Š ä½•ã‹ã®æ›´æ–°å‡¦ç†ã®ã‚ã¨ã«è£ã§ãƒãƒƒãƒå‡¦ç†ã‚’èµ°ã‚‰ã›ã‚‹ãŸã‚ã®ãƒˆãƒªã‚¬ãƒ¼ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’é–¢æ•°ã¨ã—ã¦çµ„ã¿è¾¼ã‚“ã§ã¿ãŸã‚Š ã¿ãŸã„ãªã“ã¨ãŒmysqlã®ä¸ã ã‘ã§ã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ è»Šè¼ªã®å†é–‹ç™º å®Ÿã¯å…ˆã«è¿°ã¹ã¦ãŠãã¾ã™ã¨ã€ä»Šå›žã®ã“ã®ã‚¢ã‚¤ãƒ‡ã‚¢ã§ã™ãŒã€ãªã‚“ã¨ä»Šã‹ã‚‰ï¼•å¹´ã»ã©å‰ã«ã‹ã®æœ‰åãªBrian Akeræ°ãŒLinuxJournalã«ã¦Embedding Per
yappo 2008/01/15
è‡ªåˆ†ã‚‚MySQLã®Engineã¨ã—ã¦Perlã‚’çµ„ã¿è¾¼ã‚‚ã†ã¨ã—ãŸã‘ã© http://svn.coderepos.org/share/lang/c/misc/oreoreperl/oreoreperl.c ã“ã“è¿„æ›¸ã„ã¦ç§‹ç”°çœŒ

perl

mysql
ãƒªãƒ³ã‚¯
Q4M - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
Kazuho Oku on Twitter: "P::C::MQ ã®ãƒã‚°å ±å‘Šã—ãŸã—ã€ç‹¬è‡ªMQã®é–‹ç™ºã™ã‚‹ã‹ãª (ã‰" ã£ã¦æ›¸ã„ãŸã‚‰ Toru Yamaguchi on Twitter: "@kazuho æ˜Žå¾Œæ—¥ã«ãªã‚‹ã¨90%ãã‚‰ã„ã®ç¢ºçŽ‡ã§ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã‚¨ãƒ³ãƒˆãƒªãŒæŒ™ãŒã‚‹æ‚ªå¯’" ã¨ã‹è¨€ã‚ã‚ŒãŸã®ã§ã€ãªã‚“ã¨ã‹ ãƒªãƒªãƒ¼ã‚¹ ã—ã¾ã—ãŸã‚ˆã¨ã„ã†è©±ã€‚MySQL ç”¨ã®ã‚ãƒ¥ãƒ¼ã ã‹ã‚‰ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆåã‚’ã€Œm9ã€ã«ã™ã¹ãã‹æ‚©ã‚“ã ã‘ã©ã€ç„¡é›£ãªç·šã«è½ã¡ç€ãã¾ã—ãŸã€‚ MySQL ã® Pluggable Storage Engine ã¯ã€ã„ã„ã§ã™ãã€‚ã‚ã‹ã‚Šã‚„ã™ã„ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ (http://forge.mysql.com/wiki/MySQL_Internals_Custom_Engine) ã‚‚ã‚ã‚‹ã—ã€‚ ã‚ã¨ã¯ã€ ãƒ•ã‚¡ã‚¤ãƒ«ãƒ™ãƒ¼ã‚¹ã®æ°¸ç¶šåŒ– ç¾çŠ¶ã¯ãƒ¡ãƒ¢ãƒªãƒ™ãƒ¼ã‚¹ãªã®ã§ ç´°ã‹ãªè¨å®šã®ç¢ºèª å¯¾å¿œéžå¯¾å¿œã®æ©Ÿèƒ½ã‚’ã¡ã‚ƒã‚“ã¨ãƒ•ãƒ©ã‚°ãŸã¦ã¦ MyS
yappo 2007/12/22
mysql
ãƒªãƒ³ã‚¯
MySQL
HeatWave Use automated and integrated generative AI and machine learning (ML) in one cloud service for transactions and lakehouse scale analytics. Get faster insights from all your data with unmatched performance and deploy apps in your choice of cloud providers. Learn More Â» MySQL Enterprise Edition The most comprehensive set of advanced features, management tools and technical support to achieve
yappo 2007/12/21
ã‚ªãƒ¬ã‚ªãƒ¬ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®æ›¸ãæ–¹ã€‚ãªã‚“ã‹ã‹ã

mysql
ãƒªãƒ³ã‚¯
Users Conference Japan 2007çµ‚äº† - mir the developer
ã†ã¡ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ãƒ–ãƒ¼ã‚¹ã«ãŠè¶Šã—ãã ã•ã£ãŸæ–¹ã€…ã€ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ 2æ—¥é–“ã«ã‚ãŸã‚‹MySQL UC Japan 2007ã‚‚ç„¡äº‹çµ‚äº†ã—ã€ä»Šæ—¥ã¯å°‘ã—ã®ã‚“ã³ã‚Šã—ã¦ã¾ã™ã€‚ ä»Šå›žã¯è‡ªç¤¾ãƒ–ãƒ¼ã‚¹ã‚’å®ˆã‚‰ãªã‘ã‚Œã°ã„ã‘ãªã‹ã£ãŸãŸã‚ã€Cybozuã•ã‚“(MySQL+Senna!!)ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ä»¥å¤–ã¯ã»ã¨ã‚“ã©èžãã«è¡Œãã“ã¨ãŒã§ããšæ®‹å¿µã ã£ãŸã®ã§ã™ãŒã€ã¡ã‚‡ã£ã¨ã—ãŸæ™‚é–“ã‚„ãƒ¬ã‚»ãƒ—ã‚·ãƒ§ãƒ³ã®æ™‚ã«ã€Monty & Brianã®2äººã¨Tritonnã®è©±ãŒã§ããŸã®ã¯å¤§ããªåŽç©«ã§ã—ãŸã€‚ Brianã¨ã¯å½¼ãŒ4æœˆã«æ¥æ—¥ã—ãŸéš›ã«ã€Tritonnã®ã‚½ãƒ¼ã‚¹ãªã©ã‚’è¦‹ã›ã¤ã¤ä¸€åº¦èª¬æ˜Žã‚’ã—ãŸã®ã§æ—¢ã«ç†è§£ã‚’å¾—ã¦ã„ã¾ã—ãŸãŒã€Montyã¯ã¾ã ã§ã—ãŸã®ã§æ‹™ã„è‹±èªžã§ãªã‚“ã¨ã‹èª¬æ˜Žã—ãŸã‚ã‘ã§ã™ã€‚ã¨ã„ã£ã¦ã‚‚ã€Œãã‚Œã‚ˆã‚Šã‚½ãƒ¼ã‚¹è¦‹ã›ã¦ã¿ã„ã€ã¿ãŸã„ãªé›°å›²æ°—ã«ãªã£ã¦#ifdef ENABLE_SENNAä»¥ä¸‹ã‚’ãƒã‚¤ãƒ³ãƒˆã¨ãªã‚‹ã‚½ãƒ¼ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«ã§è¦‹ã›ã¦ç†è§£ã—ã¦ã‚‚ã‚‰ã†ã¨ã„ã†ãŠæ±ºã¾
yappo 2007/09/13
mysql

senna
ãƒªãƒ³ã‚¯
ãƒãƒƒãƒˆé€šè²©ã‚µã‚¤ãƒˆã®æ§‹ç¯‰ã¨è²©ä¿ƒæ”¯æ´ã®ã‚¤ãƒ³ãƒ•ã‚©ãƒžãƒ¼ã‚¯ã‚¹
EC ãƒ“ã‚¸ãƒã‚¹ã®ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã§ã™ã€‚ ç‚¹ã§ã¯ãªãã€ç·šã®ãŠä»˜ãåˆã„ã‚’å¤§åˆ‡ã«ã—ãŸã„ã€‚å˜ãªã‚‹ãƒ™ãƒ³ãƒ€ã§ã¯ãªãã€ãŠå®¢æ§˜ã¨å…±ã«æˆé•·ã™ã‚‹ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã€ãã‚ŒãŒã‚¤ãƒ³ãƒ•ã‚©ãƒžãƒ¼ã‚¯ã‚¹ã§ã™ã€‚ã‚ã‚‰ã‚†ã‚‹å±€é¢ã§ã”ä¸€ç·’ã•ã›ã¦ãã ã•ã„ã€‚ EC ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚° ã€Get started! ECã€‘ ECäº‹æ¥è¨ˆç”»ç«‹æ¡ˆã§ã‚‚ã€æ¥æ…‹ã®å¤‰æ›´ã§ã‚‚ã€èª²é¡Œè§£æ±ºã§ã‚‚ã€ãŠæ°—å…¼ããªãã”ç›¸è«‡ãã ã•ã„ã€‚äº‹æ¥æˆ¦ç•¥ã‹ã‚‰å§‹ã¾ã£ã¦ã€ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ã® RFP ä½œæˆã¾ã§ã€ä¸ç«‹ãªç«‹å ´ã§ãŠæ‰‹ä¼ã„ã—ã¾ã™ã€‚ EC ãƒ“ã‚¸ãƒã‚¹ãƒ»ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚° EC ã‚·ã‚¹ãƒ†ãƒ ãƒ»ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚° çµ±åˆ EC ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ ã€Make it! ECã€‘ ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—æ™‚ã¯ã‚‚ã¡ã‚ã‚“ã§ã™ãŒã€ã‚µã‚¤ãƒˆã®ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã§ã‚‚æŠœç¾¤ã®ãƒ—ãƒ¬ã‚¼ãƒ³ã‚¹ã‚’ç™ºæ®ã—ã¦ã„ã¾ã™ã€‚ãªãœãªã‚‰ã€æ¨¡å€£ã®æ®µéšŽã‹ã‚‰å·®åˆ¥åŒ–ã¸å‘ã‹ã†åˆ†ã‹ã‚Œé“ã ã‹ã‚‰ã§ã™ã€‚ Make it! EC ã‚·ãƒªãƒ¼ã‚º ã‚³ãƒ©ãƒœãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³
yappo 2007/09/11
mysql
ãƒªãƒ³ã‚¯
akiyan.com ç®¡ç†äººãƒ¡ãƒ¢ - MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2007 ï¼‘æ—¥ç›® ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ãƒ¬ãƒãƒ¼ãƒˆ
æ³¨ï¼šã“ã®ãƒ¬ãƒãƒ¼ãƒˆã¯ã‹ãªã‚Šã®å‰²åˆã§ã‚¹ãƒ©ã‚¤ãƒ‰ã®å†…å®¹ã®å†™ã—ã§ã€ã¨ãã©ãè©±ã—ã¦ã„ã‚‹ã“ã¨ã‚’çµ¡ã‚ã¦ã„ã¾ã™ã€‚ã¾ã¨ã‚ãŒã™ã”ã„ã‚“ã˜ã‚ƒãªãã¦ãƒ—ãƒ¬ã‚¼ãƒ³ã‚¹ãƒ©ã‚¤ãƒ‰ã®å†…å®¹ãŒã™ã”ãã¾ã¨ã¾ã£ã¦ã‚‹ã£ã¦ã“ã¨ã§ã™ã‚ˆãƒ¼ MySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2007ã«æ¥ã¦ã„ã¾ã™ã€‚ä¼šå ´ã‚«ã‚³ãƒ¨ã‚¹ï¼ Larryç¤¾é•·æ—¥æœ¬èªžã§æŒ¨æ‹¶ä¸ã€‚ãŒã‚“ã°ã‚Œãƒ¼ ã‚¹ãƒ†ãƒ•ã‚¡ãƒ³ãƒ»ãƒŽãƒ¬ãƒ¼ãƒ³é–£ä¸‹ é§æ—¥ã‚¹ã‚¦ã‚§ãƒ¼ãƒ‡ãƒ³å¤§ä½¿ ã‚¢ã‚¸ã‚¢ã§MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãŒé–‹ã‹ã‚Œã‚‹ã®ã¯åˆã‚ã¦ã ãã† ã“ã‚“ã«ã¡ã¯ã€‚Rubyã®ã¾ã¤ã‚‚ã¨ã§ã™ã€‚ MySQLã«è©³ã—ããªã„ã®ã«ã€ã©ã†ã—ã¦ã‚‚æ–ã‚Œãªã„ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’é€šã—ã¦ä¾é ¼ã•ã‚ŒãŸã®ã§æ¥ã¾ã—ãŸï¼ˆä¼šå ´ç¬‘ï¼‰ MySQLã®ã“ã¨ã¯ã‚ã‹ã‚‰ãªã„ã‹ã‚‰ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ã¤ã„ã¦è©±ã™ã‚ˆ ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒç„¡ä¾¡å€¤ã ã£ãŸç‰§æŒçš„ãªæ™‚ä»£ã®è©±ã‹ã‚‰ ãƒ•ãƒªãƒ¼ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ è‡ªç”±ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ å®Ÿè¡Œã™ã‚‹è‡ªç”± å¦ç¿’ã™ã‚‹è‡ªç”± ä¿®æ£ã™ã‚‹è‡ªç”± å†é…å¸ƒã™ã‚‹è‡ªç”± is GPL. ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹(1998) ãƒžãƒ¼ã‚±ãƒ†ã‚£
yappo 2007/09/11
mysql

matz
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2007/09/mysql_async.php
yappo 2007/09/10
perl

mysql
ãƒªãƒ³ã‚¯
mir the archive
Contents æ›´æ–°:2007/08/31 MySQLå†…éƒ¨ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨ã‚½ãƒ¼ã‚¹è§£æž ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¨ç›¸é–¢å›³ ä¸»è¦ã‚¯ãƒ©ã‚¹ã¨æ§‹é€ ä½“ ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£é–¢æ•° ãƒ—ãƒªãƒ—ãƒã‚»ãƒƒã‚µãƒžã‚¯ãƒ ã‚°ãƒãƒ¼ãƒãƒ«å¤‰æ•° ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ MySQL Hacking Tips InnoDBé–¢é€£ã®ã‚½ãƒ¼ã‚¹è§£æž InnoDBèµ·å‹•ãƒ—ãƒã‚»ã‚¹ InnoDBãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã«é–¢ã™ã‚‹ã‚½ãƒ¼ã‚¹ã‚³ãƒ¡ãƒ³ãƒˆã®å’Œè¨³ InnoDB Recordæ§‹é€ MySQLã®æ‹¡å¼µ å¯å¤‰å¼•æ•°ã‚’æŒã¤NativeãªSQLé–¢æ•°ã®å®Ÿè£…æ–¹æ³• Warningã¨Errorã®å‡ºåŠ›æ–¹æ³• HelloWorldãƒã‚¿ GNU Autotoolsã§Hello World! ãã®ä»– ã‚µãƒ³ãƒ—ãƒ«ã‚³ãƒ¼ãƒ‰é›† å½“ã‚µã‚¤ãƒˆã¨ç®¡ç†è€…ã«ã¤ã„ã¦
yappo 2007/07/31
mysql
ãƒªãƒ³ã‚¯
spiritlooseã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - MySQL ProxyãŒãŠã‚‚ã—ã‚ãã†
http://forge.mysql.com/wiki/MySQL_Proxy ã»ãƒ¼ãƒ»ãƒ»ãƒ»ãªã‹ãªã‹ãŠã‚‚ã—ã‚ãã†ã€‚ mod_proxy_balancer and mod_rewrite for MySQLã¿ãŸã„ãªã‹ã‚“ã˜ã‹ãªãã€‚ ã¨ã„ã£ã¦ã‚‚ã€tritonn ã¿ãŸã„ã« MySQL ã«çµ„ã¿è¾¼ã‚€ã‚“ã˜ã‚ƒãªãã£ã¦ã€åˆ¥ãƒ—ãƒãƒ€ã‚¯ãƒˆã®ã‚µãƒ¼ãƒã€‚ load balancing fail over ã‚ãŸã‚ŠãŒ mod_proxy_balancer ã£ã½ãã¦ Query interception Query rewriting Injecting queries ã‚ãŸã‚ŠãŒ mod_rewrite ã£ã½ã„ã€‚ mod_rewrite ã¿ãŸã„ã«æŒ™å‹•ã‚’é¸ã¶(Pã¨ã‹Rã¨ã‹PTã¨ã‹)ã‚“ã˜ã‚ƒãªãã¦ã€ã‚³ã‚¢ã®æŒ™å‹•ã¯ãªãã¦ã€å…¨éƒ¨ Rewrit eMap prg:/path/to/script ã¿ãŸã„ãªã‚¤ãƒ¡ãƒ¼ã‚¸ã£ã½ã„ã€‚ ã€Œ--proxy-lu
yappo 2007/06/28
ãŠã‚‚ã—ã‚ã’

mysql
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸