[B! q4m][Q4M] TAKESAKOã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

TAKESAKO id:TAKESAKO

q4mã¨Q4Mã«é–¢ã™ã‚‹TAKESAKOã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (24)

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

mixi ã®å¹´æœ«å¹´å§‹å¯¾ç– 2009-2010 - mixi engineer blog
ã“ã‚“ã«ã¡ã¯ã€‚ãƒ‘ãƒ¼ãƒˆãƒŠãƒ¼ã‚µãƒ¼ãƒ“ã‚¹éƒ¨ã®åŠ è—¤å’Œè‰¯ã§ã™ã€‚ 2008å¹´æœ«ã«ã€mixi ã®å¹´æœ«å¹´å§‹å¯¾ç–ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã—ãŸã€‚ä»Šå›žã¯ã€ã“ã“æ•°å¹´ã®å¹´æœ«å¹´å§‹å¯¾ç–ã®æ©ã¿ã¨ã€ä»Šå¹´ã®å¯¾ç–ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚å®Ÿã‚’ã„ã†ã¨ã€è¨è¨ˆã‚‚å®Ÿè£…ã‚‚è‡ªåˆ†ã˜ã‚ƒãªã‹ã£ãŸã‚Šã™ã‚‹ã®ã§ã™ãŒã€ã“ã®ã¾ã¾æ´å²ã«åŸ‹ã‚‚ã‚Œã¦ã„ãã®ã‚‚æ‚²ã—ã„ã®ã§ã€é–¢ä¿‚å„æ‰€ã«å–æã—ã¦ã¿ã¾ã—ãŸã€‚ 2008å¹´æœ«ã‚’ãµã‚Šã‹ãˆã‚‹ ã¾ãšã¯ã€2008å¹´æœ«ã‚’ãµã‚Šã‹ãˆã£ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ã‚ã®ã“ã‚ã¯ã¾ã mixi ã®æ©Ÿèƒ½ã‚‚å°‘ãªãã€å¹´æœ«å¹´å§‹ã®è² è·ã¯ä¸»ã«æ—¥è¨˜ã«é›†ä¸ã—ã¦ã„ã¾ã—ãŸã€‚ãã“ã§å½“æ™‚ã¯ ID Generator ã®æ”¹å–„ - mod_perl ã‚’ã‚ã„ã ã«ã¯ã•ã‚“ã§ MySQL ã¸ã®æŽ¥ç¶šæœ¬æ•°ã‚’æ¸›ã‚‰ã™ æœ€æ–°æƒ…å ±DBã¸ã®æ›¸ãè¾¼ã¿ã‚’éžåŒæœŸã« - Q4M ã‚’ã¤ã‹ã£ã¦è² è·ã‚’æ™‚é–“è»¸ã§åˆ†æ•£ã™ã‚‹ ã¨ã„ã†2ã¤ã‚’æ—¥è¨˜ã«å®Ÿè£…ã—ãŸã®ã§ã—ãŸã€‚ ã—ã‹ã—ã€2008å¹´æœ«ã‹ã‚‰2009å¹´ã®ãŠæ£æœˆã«ã‹ã‘ã¦ã€mixi ã¯ã¾ãŸã‚‚æ—¥è¨˜ã«
TAKESAKO 2010/12/28
mixi Engineers' Blog >> mixi ã®å¹´æœ«å¹´å§‹å¯¾ç– 2009-2010

Q4M

MySQL
ãƒªãƒ³ã‚¯
ãƒã‚¿ã•ã‚“ã®ãƒ–ãƒã‚°(å¾©åˆ»ç‰ˆ) : PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹2009ã€ŒQ4Mã¨Flareã‚’ä½¿ã£ã¦ ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½œã‚‹ï¼ã€ã®è³‡æ–™
ã™ã„ã¾ã›ã‚“ã€é…ããªã£ã¦ã„ã¾ã—ãŸãŒã€ã¨ã‚Šã‚ãˆãšã“ã“ã«ç½®ã„ã¦ãŠãã¾ã™ã€‚ ref - http://www.slideshare.net/nowelium/building-highscala ble-web-applications-using-q4m-and-flare Building High-Scala ble Web Applications Using Q4M and Flare View more documents from nowelium. Ustreamã¯ã“ã®è¾º ref - http://www.ustream.tv/recorded/2107541 ã„ãã¤ã‹è³ªå•ãŒã‚ã£ãŸã‚‚ã®ã¯ã€åˆ¥é€”æ›¸ãã¾ã™
TAKESAKO 2009/09/18
Q4M

php

pcj09

flare
ãƒªãƒ³ã‚¯
Queue::Q4Pg::Lite ã‚’æ›¸ã„ãŸ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
PostgreSQL ã§ç°¡æ˜“ã« MQ - Mi manca qualche giovedi`? ã‚’èªã‚“ã§ã€ã“ã‚Šã‚ƒç´ æ™´ã‚‰ã—ã„ã¨æ€ã£ãŸã®ã§ Perl ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«åŒ–ã—ã¾ã—ãŸã€‚ simple message queue using PostgreSQL. http://github.com/fujiwara/perl-queue-q4pg-lite/tree/master å‰²ã¨ç°¡æ˜“ãª Message Queue ã¨ã„ã†ã“ã¨ã§ã€Lite ã£ã¦åå‰ã«ã€‚pg_advisory_lock() ã‚’ä½¿ç”¨ã—ã¦ã‚‹ã®ã§ã€PostgreSQL-8.2 ä»¥é™ã§ãªã„ã¨å‹•ãã¾ã›ã‚“ã€‚ ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã¯ Queue::Q4M ã¨ã»ã¨ã‚“ã©åŒã˜â€¦â€¦ã¨ã„ã†ã‹ã€ã‚³ãƒ¼ãƒ‰è‡ªä½“ã‚’åŠåˆ†ãã‚‰ã„ Queue::Q4M ã‹ã‚‰é ‚ã„ã¦ã„ã¾ã™ã€‚ use Queue::Q4Pg::Lite; my $q = Queue::Q4Pg::Lite->conn
TAKESAKO 2009/04/27
ãŠãŠãŠ

MQ

perl

postgresql

Q4M

Q4Pg
ãƒªãƒ³ã‚¯
http://labs.cybozu.co.jp/blog/kazuhoatwork/2009/04/q4m_presentation_slides_at_mys.php
TAKESAKO 2009/04/23
Q4M

MySQL
ãƒªãƒ³ã‚¯
myfinder's blog: Q4Mã‚’ä½¿ã†ã¨ãã«ã‚„ã£ã¦ã¯ã„ã‘ãªã„ä¸€ã¤ã®ã“ã¨
ã‚ã‚‹æ—¥Q4Mã‚’åˆ©ç”¨ã—ãŸã‚·ã‚¹ãƒ†ãƒ ã‚’é‹ç”¨ã—ã¦ã„ãŸã¨ã“ã‚ã€ãƒ—ãƒã‚°ãƒ©ãƒžã®æ–¹ã‹ã‚‰ ã€ŒQ4Mã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå£Šã‚ŒãŸã£ã½ã„ã®ã ã‘ã©ã‚‚ã€‚ã€‚ã€‚ã€ ã¨ã®å ±å‘ŠãŒã‚ã‚Šã€çŠ¶æ³ã‚’èžã„ã¦ã¿ãŸã€‚ ã©ã†ã‚‚ã€Queueã«çªã£è¾¼ã‚“ã ã‘ã©ã‚‚å‡¦ç†ã—ãŸããªã„ãƒ‡ãƒ¼ã‚¿ãŒã‚ã£ãŸã¨ã„ã†ç†ç”±ã§ä¸€éƒ¨ã®è¡Œã‚’DELETEã—ãŸã¨ã®ã“ã¨ã€‚ ã§ã€æ—©é€ŸDBã‚’èª¿ã¹ã¦ã¿ã‚‹ã¨ã€å…¨éƒ¨queue_waitã§å–ã‚Šå‡ºã—ãŸã«ã‚‚é–¢ã‚ã‚‰ãšè¡Œæ•°ãŒ0ã«ãªã‚‰ãªã‹ã£ãŸã‚Šã€ ç™ºè¡Œã—ã¦ã„ã‚‹queue_endãŒå®Ÿè¡Œã•ã‚Œãšã«ãšã£ã¨ãƒ—ãƒã‚»ã‚¹ãŒæ®‹ã£ã¦ã„ãŸã‚Šã—ã¦å¤§å¤‰ã‚«ã‚ªã‚¹ãªçŠ¶æ…‹ã«ãªã£ã¦ã„ãŸã€‚ (insertã‚‚æ¢ã¾ã£ã¦ã„ãŸ) ãã®å ´ã§ã¯MySQLã‚’å¼·åˆ¶çš„ã«å†èµ·å‹•ã—ã¦ã€tableã‚„schemaã‚’dropã—ã¦å†ä½œæˆã—ã¦ã‚‚ã‚‰ã†ã“ã¨ã§ã“ã¨ãªãã‚’å¾—ãŸã€‚ ãŒã€ä»Šæ—¥å¸°ã£ã¦ãã¦Q4Mã®ãƒšãƒ¼ã‚¸ã‚’è¦‹ã¦è¬ŽãŒè§£æ±ºã€‚ Q4Mã®ã€ŒLimitations and Known Issuesã€ã« removal of multiple
TAKESAKO 2009/03/24
ï¼žQ4Mã‚’ä½¿ã†ã¨ãã«ã¯ è¤‡æ•°è¡Œã«å¯¾ã—ã¦1ã¤ã®DELETEæ–‡ã«ã‚ˆã‚‹å‰Šé™¤ã¯ã‚„ã£ã¦ã¯ã„ã‘ãªã„

Q4M
ãƒªãƒ³ã‚¯
http://hibinokoto.jp/archives/2009/03/post-304.html
TAKESAKO 2009/03/02
q4m
ãƒªãƒ³ã‚¯
mixiã®å¹´æœ«å¹´å§‹å¯¾ç– æ—¥è¨˜æŠ•ç¨¿ã‚·ã‚¹ãƒ†ãƒ ã®æ”¹å–„ - mixi engineer blog
æœæ™©å†·ãˆã¦ãã¾ã—ãŸãã€‚é¢¨é‚ªãªã©å¼•ã„ã¦ã„ã¾ã›ã‚“ã§ã—ã‚‡ã†ã‹ã€‚ã•ã¦ã€å¹´æœ«ãŒè¿‘ã¥ã„ã¦ãã‚‹ã“ã®æ™‚æœŸã«å¼Šç¤¾ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒæœ€ã‚‚æ°—ã«ãªã‚‹ã®ã¯ã€ãŠæ£æœˆã€‚ãã‚Œã‚‚æ¥å¹´1æœˆ1æ—¥ã‚’è¿ŽãˆãŸçž¬é–“ã§ã™ã€‚ 1æ—¥1æ—¥0æ™‚ã«ä½•ãŒã‚ã‚‹ã®ã§ã—ã‚‡ã†ï¼Ÿãã†ã€mixiã®ã‚µãƒ¼ãƒ“ã‚¹ã§æœ€ã‚‚æ—¥è¨˜ãŒæ›¸ãè¾¼ã¾ã‚Œã‚‹ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã«ãªã‚‹ã®ã§ã™ã€‚å€‹äººçš„ã«ã€Œã‚ã‘ãŠã‚ã“ã¨ã‚ˆã‚ã‚¢ã‚¿ãƒƒã‚¯ã€ã¨å‘¼ã‚“ã§ã„ã¾ã™ã€‚ä»Šå¹´ã¯æ—¥è¨˜ã ã‘ã§ã¯ãªãã€ã‚¨ã‚³ãƒ¼ã§ã‚‚ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒé£›ã³äº¤ã†ã“ã¨ã§ã—ã‚‡ã†ã€‚ã“ã®æ™‚æœŸã¯æºå¸¯é›»è©±ã®ã‚ãƒ£ãƒªã‚¢ã§ã‚‚ã•ã¾ã–ã¾ãªå¯¾ç–ã‚’è¡Œã£ã¦ã„ã¾ã™ãŒã€ãƒŸã‚¯ã‚·ã‚£ã§ã‚‚å¹´æœ«å¹´å§‹ã§ã‚‚ãƒ¦ãƒ¼ã‚¶ã®æ–¹ã«å¿«é©ã«ã‚µãƒ¼ãƒ“ã‚¹æä¾›ãŒã§ãã‚‹ã‚ˆã†ã«åŠªã‚ã¦ã„ã¾ã™ ä»¥ä¸‹ã¯æ˜¨å¹´ã®å¹´æœ«å¹´å§‹ã®æ—¥è¨˜æŠ•ç¨¿æ•°ã®æŽ¨ç§»ã§ã™ã€‚é’è‰²ãŒ12/31ã‹ã‚‰1/1ã€èµ¤è‰²ãŒ1/1ã‹ã‚‰1/2ã«ãªã‚Šã¾ã™ 1/1ã®æ–¹ãŒå…¨ä½“çš„ã«å¤šã„ã§ã™ãŒã€ç‰¹ã«å¹´ãŒå¤‰ã‚ã‚‹å‰å¾Œã®æŠ•ç¨¿æ•°ã¯å€è¿‘ããªã£ã¦ã„ã‚‹ã“ã¨ãŒã‚ã‹ã‚Šã¾ã™ã€‚ã“ã®æ™‚ã«è² è·ã«ã‚ˆã‚Šæ—¥è¨˜ã®æŠ•ç¨¿ãŒã—ã¥ã‚‰ã„çŠ¶æ…‹ã«ãªã£ã¦ã„ãŸã®
TAKESAKO 2008/12/12
mixi

mysql

Q4M
ãƒªãƒ³ã‚¯
Q4Mã‚’ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ãŸãƒ¡ãƒ¢ - download_takeshiâ€™s diary
mysql5.1ã‚‚ã‚ˆã†ã‚„ãStableã«ãªã£ãŸã“ã¨ã§ã™ã—ã€ã†ã‚Œã—ã„ã®ã§è©±é¡Œã®Q4Mã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ã¾ã—ãŸã€‚ ä»Šå›žã¯ã‚½ãƒ¼ã‚¹ã‹ã‚‰ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¦ã¿ã¾ã—ãŸã€‚ ä»¥ä¸‹ã€ãã®éš›ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ¡ãƒ¢ã§ã™ã€‚ ä»Šå›žã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã®ã¯å„ã€…ã“ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã™ã€‚ * mysql-5.1.30.tar.gz * q4m-0.8.3.tar.gz mysqlã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã¾ãšã¯ mysql-5.1.30 ã§ã™ã€‚é©å½“ã«ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¦ãã ã•ã„ã€‚ configreã«æ¸¡ã™ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¯ç”¨é€”ã«ã‚ˆã£ã¦è‰²ã€…ä»£ã‚ã‚‹ã¨æ€ã„ã¾ã™ãŒã€ä»Šå›žã¯ã“ã‚“ãªãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã§configureã—ã¾ã—ãŸã€‚ $ ./configure \ --prefix=/usr/local/mysql \ --libexecdir=/usr/local/mysql/bin \ --sbindir=/usr/local/mysql/sbin \ --with-charse
TAKESAKO 2008/12/04
Q4M

mysql
ãƒªãƒ³ã‚¯
LDR ã§ Q4M ãŒæŽ¡ç”¨ã•ã‚ŒãŸä»¶ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ m(__)m éšœå®³ãŒç™ºç”Ÿã™ã‚‹ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ã¨ã‹ã‚ã‚Šå¾—ãªã„ã®ã§ã€ãƒã‚°ã‚’ç™ºè¦‹ã•ã‚ŒãŸæ–¹ã¯é æ–¹ã§ã‚‚ã”ä¸€å ±ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ RSS ãƒ‡ãƒ¼ã‚¿ã®å…ˆèªã¿ã®æŽ’ä»–å‡¦ç†ã« memcached ã§ãƒãƒƒã‚¯ã—ã¦ã‚‹ã®è¦‹ã¦ã€ãã‚Œã˜ã‚ƒãƒ¯ãƒ¼ã‚«ãƒ¼ãŒè½ã¡ãŸéš›ã®ãƒãƒƒã‚¯è§£æ”¾ã¨ã‹é¢å€’ã ã— kazuhoware çš„ã«ã¯ KeyedMutex ãŒã‚ªã‚¹ã‚¹ãƒ¡ã ã‰ *1 ã¨æ€ã£ãŸã‚‰ trylock ç›¸å½“ã®æ©Ÿèƒ½ãŒãªã‹ã£ãŸä»¶orz *1:over TCP ã§ã‚‚å‹•ãã¾ã™
TAKESAKO 2008/11/30
shibuya.pm

Q4M
ãƒªãƒ³ã‚¯
8/27 ã«ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ã‚„ã‚Šã¾ã™ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
8/27 (æ°´) ã«ã‚µã‚¤ãƒœã‚¦ã‚ºãƒ»ãƒ©ãƒœã§ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹#1 ã‚’é–‹å‚¬ã—ã¾ã™ã€‚ ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã®ã‚µãƒ¼ãƒ“ã‚¹ãŠã‚ˆã³ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢é–‹ç™ºè€…ã®é›†ã„ã¨ã„ã†ã“ã¨ã§ã€Wassr ã‚„ Mixi ã‚¨ã‚³ãƒ¼ã®ä¸ã®äººã®è©±ãŒèžã‘ã‚‹äºˆå®šã§ã™ã€‚å‚åŠ å¸Œæœ›ã®æ–¹ã¯ã€Wiki ã«åå‰ã®è¿½è¨˜ã‚’ãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ ãƒžã‚¤ã‚¯ãƒãƒ–ãƒã‚°ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹#1 PS. è‡ªåˆ†ã¯ Q4M ã®è©±ã‚’ã—ã¾ã™ã€‚
TAKESAKO 2008/08/12
event

twitter

mixi

wassr

q4m

mysql
ãƒªãƒ³ã‚¯
http://soozy.org/index.cgi?Q4Mcon1
TAKESAKO 2008/08/08
event

q4m

wassr

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

mixi

mysql

q4m
ãƒªãƒ³ã‚¯
q4mã®conditional subscriptionã«ã³ã³ã£ãŸä»¶ - D-6 [ç›¸å¤‰ã‚ã‚‰ãšæ ¹ç„¡ã—]
q4mã®conditional subscriptionã«ã³ã³ã£ãŸä»¶ Mvalveã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¦ã€è‰²ã€…æ©Ÿèƒ½æ”¹å–„ã‚’ã™ã‚‹å‰ã«ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’æ›¸ã“ã†ã¨æ€ã„ã¾ã—ãŸã€‚ãªã®ã§ã¾ãšQueue::Q4Mã«ã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã§ã™ã‚ˆã€‚ Queue::Q4M 0.00007ã®miscãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªå†…ã«ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãŒã‚ã‚Šã¾ã™ã€‚ã£ã¦ã“ã¨ã§ã€ä»¥ä¸‹ã®æ¡ä»¶ã§ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯èµ°ã‚‰ã›ã¦ã¿ã¾ã—ãŸ ã‚¹ãƒˆãƒ¬ãƒ¼ãƒˆã«1000ä»¶å…¥åŠ›ã—ã¦ã‹ã‚‰1000ä»¶å…¨éƒ¨conditionalç„¡ã—ã§æŠ½å‡ºã™ã‚‹1000ä»¶+ãã®ç´„50å€ã®ãƒ€ãƒŸãƒ¼ãƒ‡ãƒ¼ã‚¿ã®ä¸ã‹ã‚‰ã€conditionalã«ãƒžãƒƒãƒã™ã‚‹1000ä»¶ã‚’å…¨éƒ¨æŠ½å‡ºã™ã‚‹ã¨ã„ã†2ãƒ‘ã‚¿ãƒ¼ãƒ³ã§å®Ÿé¨“ã—ãŸçµæžœãŒä»¥ä¸‹ã®é€šã‚Š >> executing default + Start Tue Jul 8 01:54:44 2008 + End Tue Jul 8 01:54:53 2008 + Processed 1000 message
TAKESAKO 2008/07/08
q4m
ãƒªãƒ³ã‚¯
D-6 [ç›¸å¤‰ã‚ã‚‰ãšæ ¹ç„¡ã—] - Mvalveãƒªãƒªãƒ¼ã‚¹
Mvalveãƒªãƒªãƒ¼ã‚¹ Mvalveã¨ã„ã†ç‰©ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¦ã¿ã¾ã—ãŸã€‚èªã¿æ–¹ã¯ãƒ»ãƒ»ãƒ»ã€Œãƒ ãƒãƒ«ãƒ–ã€ã‹ãªã€‚è¦ã¯Message Valveã§ã™ã€‚å¤šåˆ†åˆã‚ã¦ï¼Ÿã®åŠåˆ†ä»¥ä¸Šå…±ä½œãªCPANãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã™ã€‚ Mvalveã¯Q4Mã‚’ãƒ™ãƒ¼ã‚¹ã«ã—ãŸã‚¹ãƒãƒƒãƒˆãƒªãƒ³ã‚°æ©Ÿèƒ½ä»˜ããƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãƒ‘ã‚¤ãƒ—ã§ã™ã€‚ä¸»ãªæ©Ÿèƒ½ã¨ã—ã¦ã¯ (1) ã‚¹ãƒãƒƒãƒˆãƒªãƒ³ã‚°ã®å½±éŸ¿ã‚’å…¨ãå—ã‘ãªã„ã€Œç·Šæ€¥ã‚ãƒ¥ãƒ¼ã€ (2) æ™®é€šãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®ã‚¹ãƒãƒƒãƒˆãƒªãƒ³ã‚° (3) ã‚¹ãƒãƒƒãƒˆãƒªãƒ³ã‚°ã•ã‚ŒãŸãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®ãƒªã‚ãƒ¥ãƒ¼ ã‚’ç°¡å˜ãªã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã§å®Ÿç¾ã—ã¾ã™ã€‚ ã¾ã ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¨ã‹ãªã‚“ã‚‚ãªã„ã®ã§è‰²ã€…ã‚³ãƒ¡ãƒ³ãƒˆã„ãŸã ã‘ã‚‹ã¨ã‚ã‚ŠãŒãŸã„ã§ã™ã€‚ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã¯codereposã«ç½®ã„ã¦ã‚ã‚Šã¾ã™ã€‚ ã‚«ãƒ†ã‚´ãƒª é–‹ç™º 2008å¹´7æœˆ 7æ—¥ 14:57 D | ãƒ–ãƒã‚°è¨˜äº‹ã®URL | ã‚³ãƒ¡ãƒ³ãƒˆ(1) | ãƒˆãƒ©ãƒƒã‚¯ãƒãƒƒã‚¯(0) |
TAKESAKO 2008/07/07
ktkr

q4m
ãƒªãƒ³ã‚¯
Kazuho at Work: Q4M - 0.6 release and benchmarks
Today I have uploaded Q4M (a Queue for MySQL) 0.6, which is basically a performance-improvement from previous releases. Instead of using pread's and a small user-level cache, Q4M (in default configuration) now uses mmap for reads with a reader/writer lock to improve concurrency. I also noticed that it would be possible to consume a queued row in one SQL statement. SELECT * FROM queue_table WHERE q
TAKESAKO 2008/06/02
Q4M

mysql
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2008/05/road_to_mq_with_q4m.php
TAKESAKO 2008/05/27
mysql

q4m
ãƒªãƒ³ã‚¯
Q4M and the need for XA
Q4M is a new storage engine that supports persistent queues. For a project that claims to have been started in December 2007, the code and ...
TAKESAKO 2008/05/27
ãŠãŠãŠ

q4m

mysql
ãƒªãƒ³ã‚¯
ãƒžãƒ«ãƒã‚¹ãƒ¬ãƒƒãƒ‰ãªã‚‰ pwrite ã‚ˆã‚Š mmap+msync ã®ãŒé€Ÿã„ (or Q4M ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®é™ç•Œå€¤ã«åˆ°é”) ã¨ã„ã†è©± - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
è‰²ã€…ãƒ¦ãƒ¼ã‚¶ãƒ©ãƒ³ãƒ‰ã§ã®ãƒãƒƒã‚¯ã‚’ä½¿ã‚ãªã„å½¢ã«æ›¸ãæ›ãˆã¦ã‚‚ã€ãªã‹ãªã‹é€Ÿããªã‚‰ãªã‹ã£ãŸã®ãŒã€pwrite ã‚’ã‚„ã‚ã¦ mmap(PROT_WRITE) çµŒç”±ã§ã®æ›¸ãè¾¼ã¿ã«ã—ãŸã‚‰ã€20% ç¨‹åº¦ã‚ã£ãŸ idle time ãŒ 0 ã«ãªã£ãŸã€‚ ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯çš„ã«ã¯ã“ã‚“ãªæ„Ÿã˜ã€‚ä¸ŠãŒ pwrite çµŒç”±ã€‚ä¸‹ãŒ msync(MS_ASYNC) çµŒç”±ã®æ›¸ãè¾¼ã¿ã€‚ã©ã¡ã‚‰ã‚‚èªã¿è¾¼ã¿ã¯ mmapã€‚ $ USE_C_CLIENT=1 MESSAGES=400000 CONCURRENCY=40 DBI='dbi:mysql:test;mysql_socket=/tmp/mysql51.sock;user=root' t/05-multireader.t 1..4 ok 1 - check number of messages ok 2 - min value of received message ok 3 - max v
TAKESAKO 2008/05/26
èˆˆå‘³æ·±ã„

linux

mmap

q4m
ãƒªãƒ³ã‚¯
Kazuho at Work: Maximum Peformance of MySQL and Q4M
I always use to blog my temporary ideas on one of my Japanese blog (id:kazuhooku's memos). When I wrote my thoughts on how to further optimize Q4M, Nishida-san asked me "how fast is the raw performance without client overhead?" Although it seems a bit diffcult to answer directly, it is easy to measure the performance of MySQL core and the storage engine interface, and by deducting the overhead, th
TAKESAKO 2008/05/21
mysql

Q4M
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2008/04/q4m_crawler.php
TAKESAKO 2008/04/07
Q4M

MySQL

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