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

heavenshell id:heavenshell

q4mã«é–¢ã™ã‚‹heavenshellã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

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

2014å¹´ã ã‘ã© Q4M ã®ç´¹ä»‹ã‚’ã—ã¦ã¿ã‚‹ã‚ˆ - Qiita
å…ˆæ—¥ MySQL Casual Talks vol.7 ã§ LT ã‚’ã—ã¦ãã¾ã—ãŸã€‚ LT ã§ã¯ Ruby(Rails) ã‹ã‚‰ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã« Q4M ã‚’ä½¿ãˆã‚‹ä½•ã‹ã‚’ä½œã£ãŸãŠè©± ã¨ã—ã¦ Q4M å‘¨ã‚Šã®ãŠè©±ã‚’ã—ã¦ããŸã®ã§ã™ãŒã€ãã“ã§å†’é "Q4M ä½¿ã£ã¦ã‚‹äººãƒ¼" ã¨æŒ™æ‰‹ã‚’æ±‚ã‚ãŸã‚‰èª°ä¸€äººã¨ã—ã¦æ‰‹ãŒæŒ™ãŒã‚‰ãªã‹ã£ãŸã“ã¨ã«çµ¶æœ›ã—ã¦ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‚’ã—ãŸãŸã‚ã¦ã„ã¾ã™ã€‚ (ã¾ãƒ¼ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã ã‹ã‚‰ãªãƒ¼ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã ã‹ã‚‰ Q4M ä½¿ã£ã¦ãªãã¦ã‚‚ã—ã‚‡ã†ãŒãªã„ã‹ã‚‰ãªãƒ¼) (ä½¿ã£ã¦ãªã„ã ã‘ã§çŸ¥ã£ã¦ã„ã‚‹äººã¯ã„ãŸã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€ã‚ã¨æ¥ãšã‹ã—ãŒã‚Šå±‹ã•ã‚“) ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã¯ç°¡å˜ãª Q4M ã®ä½¿ã„æ–¹ã¨ç‰¹å¾´ã«ã¤ã„ã¦èª¬æ˜Žã—ã¦ã„ãã¾ã™ã€‚ Q4M ã£ã¦ Q4M ã¯ç°¡å˜ã«è¨€ã†ã¨ DeNA ã®å¥¥ä¸€ç©‚ã•ã‚“ãŒé–‹ç™ºã•ã‚Œã¦ã„ã‚‹ MySQL ã‚’ä½¿ã£ãŸã‚ãƒ¥ãƒ¼ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã§ã™ã€‚ Q4M è‡ªä½“ã¯ MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦å®Ÿè£…ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ãƒ†ãƒ¼ãƒ–ãƒ«
heavenshell 2014/12/14
q4m

mysql
ãƒªãƒ³ã‚¯
livedoor Readerã®ã‚¯ãƒãƒ¼ãƒ©ã¨Streaming APIãªã©ã®è©±
livedoor Readerã®ã‚¯ãƒãƒ¼ãƒ©ã¨Streaming APIãªã©ã®è©± - Download as a PDF or view online for free
heavenshell 2010/03/11
perl

javascript

q4m

queue
ãƒªãƒ³ã‚¯
q4m ã‚’ rpm åŒ–ã™ã‚‹ with checkinstall - æ—¥å‘å¤ç‰¹æ®Šå¿œæ´éƒ¨éšŠ
ä½œæ¥ãƒ¡ãƒ¢ã§ã™ã€‚ src.rpm ã®å–å¾— # cd /usr/src/redhat/SRPMS # wget http://dev.mysql.com/get/Downloads/MySQL-5.1/MySQL-community-5.1.42-0.rhel5.src.rpm/from/http://ftp.iij.ad.jp/pub/db/mysql/ rpm build --recompile ãƒ“ãƒ«ãƒ‰æ™‚ã®ã‚½ãƒ¼ã‚¹ãƒ„ãƒªãƒ¼ãŒå¿…è¦ãªã®ã§ recompile # rpm build --recompile --define 'community 1' /usr/src/redhat/SRPMS/MySQL-community-5.1.42-0.rhel5.src.rpm checkinstall ã§ rpm åŒ– make æ™‚ã« MYSQL_LIBDIR ã‚’ã¤ã‘ã¦ã‚‹ã®ã¯ libmysqlclient.s
heavenshell 2010/02/05
q4m

rpm
ãƒªãƒ³ã‚¯
MySQL ã‚’ä½¿ã£ãŸãŠæ‰‹è»½ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼å®Ÿè£… - ãƒ‰ãƒ¯ãƒ³ã‚´ ç ”ç©¶é–‹ç™ºãƒ–ãƒã‚°
ã¯ã˜ã‚ã« ã“ã®è¨˜äº‹ã§ã¯ã€MySQL ã‚’ä½¿ã£ã¦ç°¡å˜ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã‚’æ‰‹è»½ã«å®Ÿè£…ã™ã‚‹æ–¹æ³•ã‚’è§£èª¬ã—ã¾ã™ã€‚ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¨ã¯ã€ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’ä¸€æ™‚çš„ã«æºœã‚ã¦ãŠãã€é †æ¬¡å‡¦ç†ã™ã‚‹ãŸã‚ã®ä»•çµ„ã¿ã§ã™ã€‚è¿…é€Ÿãªãƒ¬ã‚¹ãƒãƒ³ã‚¹ãŒå¿…è¦ãª Web ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ãŠã„ã¦ã€æ™‚é–“ã®ã‹ã‹ã‚‹å‡¦ç†ã‚’éžåŒæœŸã«è¡Œã†ãŸã‚ã«ã€ãƒãƒƒã‚¯ã‚°ãƒ©ã‚¦ãƒ³ãƒ‰ã§é †æ¬¡å‡¦ç†ã—ã¦ã„ãã‚ˆã†ãªå ´åˆã«åˆ©ç”¨ã§ãã¾ã™ã€‚ ç°¡å˜ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¨è¨€ã£ã¦ã‚‚ã€å¤§è¦æ¨¡ãªé‹ç”¨ã«ã‚‚è€ãˆã‚‰ã‚Œã‚‹ç¨‹åº¦ã®é€Ÿåº¦ã¨å …ç‰¢æ€§ã‚’æŒã¡ã¾ã™ã€‚ ã¾ãŸã€ã“ã“ã§è§£èª¬ã—ã¦ã„ã‚‹æ–¹æ³•ã§ä½œã‚‰ã‚ŒãŸãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¯ã€å¼Šç¤¾ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ãƒ‹ã‚³ãƒ‹ã‚³å‹•ç”»ã«æœ€è¿‘è¿½åŠ ã•ã‚ŒãŸtwitteré€£æºæ©Ÿèƒ½ã§ã‚‚åˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã‚’ä½œã‚‹ã«ã‚ãŸã£ã¦ ä»Šå›žå®Ÿè£…ã™ã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã¯ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®è¿½åŠ (push)ã‚’é«˜é€Ÿã«è¡Œã†äº‹ãŒã§ãã‚‹ ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã®å–å¾—(pop)ã¯ã‚ã‚‹ç¨‹åº¦é«˜é€Ÿã«è¡Œã†äº‹ãŒã§ãã‚‹ å¤šãã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰åŒæ™‚ã« p
heavenshell 2010/01/26
q4m
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: PHPã§æš—å·åŒ–ãƒ»å¾©å·åŒ–ã‚ã‚Œã“ã‚Œ
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
heavenshell 2009/12/10
php

template
ãƒªãƒ³ã‚¯
Debian (lenny) ã¸ Q4M ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - usualoma's blog
ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ‰‹é †ã®å‚™å¿˜éŒ²ã§ã™ã€‚ # APTãƒ©ã‚¤ãƒ³ã®è¨å®š lenny% tail -2 /etc/apt/sources.list deb http://www.backports.org/debian lenny-backports main contrib non-free deb-src http://www.backports.org/debian lenny-backports main contrib non-free lenny% sudo aptitude update # ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®æº–å‚™ lenny% sudo aptitude install mysql-server-5.1 mysql-common/lenny-backports lenny% sudo aptitude install libssl-dev g++-4.1 libmysqlclient-dev #
heavenshell 2009/11/04
q4m

mysql
ãƒªãƒ³ã‚¯
MacPortsã®MySQLã«Q4Mã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹æ³•
çš†ã•ã‚“ã€ã“ã‚“ã°ã‚“ã¯ã€‚ç¬¹äº€ã§ã™ã€‚ æœ¬æ—¥ã¯ãƒ–ãƒã‚°ã‚’æ›¸ããŸã‚ã«ç’°å¢ƒã‚’ã¤ãã£ã¦ã„ã‚‹ã¨ãã«ã€é–“é•ãˆã¦MacPortã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚‚ã®ã‚’å‰Šé™¤ã—ã¦ã—ã¾ã„ã¾ã—ãŸï¼›ï¼› æ‚²ã—ã•ã¨ã‚€ãªã—ã•ã¨æˆ¦ã„ãªãŒã‚‰ã‚‚æœ¬æ—¥ã®ãƒ–ãƒã‚°ã‚’ãŠå±Šã‘ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ â€»ãã®ãŸã‚ã€å†…å®¹ã¯ã¡ã‚‡ã£ã¨å°‘ãªã‚ã«ãªã£ã¦ã„ã¾ã™ã€‚ã”ã‚ã‚“ãªã•ã„ ä»Šå¹´ã®PHPã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã§ã‚‚Q4Mã®ç™ºè¡¨ãŒã‚ã‚Šã€ã„ã¤ã‹ä½¿ã†æ—¥ãŒæ¥ã‚‹ã ã‚ã†ã¨æ€ã„ã€ å€‹äººçš„ã«ã‚‚ã¨ã¦ã‚‚èˆˆå‘³ãŒã‚ã£ãŸã®ã§å®Ÿéš›ã«ä½¿ã£ã¦ã¿ãŸã„ããªã‚Šã¾ã—ãŸã€‚ Q4MÂ (QueueÂ forÂ MySQL)Â ã¯Â MySQLÂ 5.1Â ã®ãƒ—ãƒ©ã‚¬ãƒ–ãƒ«ãƒ»ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦å‹•ä½œã™ã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã§ã‚ã‚Šã€å …ç‰¢ãƒ»é«˜é€Ÿãƒ»æŸ”è»Ÿã§ã‚ã‚‹ã‚ˆã†è¨è¨ˆã•ã‚Œã¦ã„ã¾ã™ã€‚(è»¢è¼‰ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸ æ—©é€Ÿã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’ã¨æ€ã£ãŸã®ã§ã™ãŒã€ä¸Šè¨˜ã®ã“ã¨ã‚‚ã‚ã‚Šã€ä»Šå›žã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã®ã¿ã®ç´¹ä»‹ã§ã™ã€‚ ç‰¹ã«MacPortsã§MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒ¼ãƒ«ã—ã¦ã„ã¦ã€ãã®M
heavenshell 2009/10/14
mac

q4m
ãƒªãƒ³ã‚¯
YappoLogs: Q4Mã‚’MacPortsã®MySQLç’°å¢ƒã«å…¥ã‚Œã‚‹æ–¹æ³•
Q4Mã‚’MacPortsã®MySQLç’°å¢ƒã«å…¥ã‚Œã‚‹æ–¹æ³• macportsã§mysqlå…¥ã‚Œã‚‹ã¨ /opt/local/lib/mysql5/mysql ã¨ã‹ã„ã†ç‹¬å‰µçš„ãªæ‰€ã«ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒå…¥ã‚‹ã®ã§ã€ãã®ã¾ã‚“ã¾ã®Q4Mã®configureã˜ã‚ƒ./configureã™ã‚‰ä¸Šæ‰‹ãå‹•ã‹ãªã„ã—ã€ã‚°ã‚°ã£ã¦ã‚‚è‰¯ãã‚ã‹ã‚‰ãªã„ã®ã§ã¦ã£ã¨ã‚Šæ—©ãconfigure.inã‚’æ›¸ãæ›ãˆãŸã‚ˆã€‚ ãƒ‘ãƒƒãƒã¯http://gist.github.com/94339ã‹ã‚‰ å®Ÿè¡Œä»¤ã¨ã‹ã¯ä¸‹è¨˜ã®é€šã‚Šã€‚ $ patch < ../for-macports.patch $ autoconf # include ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’è¿½åŠ ã™ã‚‹ã®ãŒå¿…è¦ $ CPPFLAGS=-I/opt/local/include ./configure --with-mysql=/opt/local/var/macports/sources/rsync.macports.
heavenshell 2009/09/22
mysql

q4m

mac
ãƒªãƒ³ã‚¯
æ£šã‹ã‚‰ãƒ‘ãƒ«ãƒãƒ£ã‚®
$ sudo ln -s /opt/local/lib/mysql5/bin/mysql_config /usr/local/bin/mysql_config $ sudo su - # cd /var/root/.cpan # cd build/DBD-mysql-XXXXXXXX # perl Makefile.PL \ --cflags=-I/opt/local/include/mysql5/mysql \ --libs="-L/opt/local/lib -L/opt/local/lib/mysql5/mysql -lmysqlclient -L/opt/local/lib -lz -lm -L/opt/local/lib -lssl -lcrypto" # make # make install
heavenshell 2008/12/26
MacBook ã« Q4M ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«

mac

q4m
ãƒªãƒ³ã‚¯
æ£šã‹ã‚‰ãƒ‘ãƒ«ãƒãƒ£ã‚®
$queue = new Net_Q4M(); $queue->connect('mysql://user:pass@localhost:3306/database'); $row = $queue->dequeue('my_queue'); if (process_row($row)) { $queue->end(); } else { $queue->abort(); } $queue->disconnect(); dequeue()ã‚’å‘¼ã¶ã¨ã‚ãƒ¥ãƒ¼ã®ãƒ¬ã‚³ãƒ¼ãƒ‰æƒ…å ±ãŒè¿”ã‚Šã¾ã™ã€‚ å†…éƒ¨çš„ã«ã¯queue_wait()ã‚’ç™ºè¡Œã—ã¦ã„ã‚‹ã®ã§ã€å–å¾—ã—ãŸã‚ãƒ¥ãƒ¼ã®å€¤ã¯ã“ã®æŽ¥ç¶šã®ã¿ãŒæ‰±ãˆã‚‹ã“ã¨ã«ãªã‚Šã¾ã™(OWNERãƒ¢ãƒ¼ãƒ‰)ã€‚ ã‚ãƒ¥ãƒ¼ã®å€¤ã¯é…åˆ—ã§è¿”ã‚‹ã®ã§é©å½“ã«å‡¦ç†ã—ã¾ã™(ä¸Šã®ã‚µãƒ³ãƒ—ãƒ«ã ã¨process_row()ã®ã¨ã“ã‚)ã€‚ å‡¦ç†ã«æˆåŠŸã—ãŸå ´åˆã¯end()ã‚’å‘¼ã¶ã“ã¨ã§ã‚ãƒ¥ãƒ¼ã‹ã‚‰å€¤ã‚’å‰Šé™¤ã—ã¾ã™ã€‚ é€†ã«å¤±æ•—ã—ãŸå ´
heavenshell 2008/12/26
PHP ã‹ã‚‰ Q4M ã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒª

php

q4m

openpear
ãƒªãƒ³ã‚¯
ãƒã‚¿ã•ã‚“ã®ãƒ–ãƒã‚° : Q4Mã®ãƒ“ãƒ«ãƒ‰(CentOS 5.2 ã¨ OSX)
Q4Mã®ã‚¢ã‚¤ãƒ‡ã‚£ã‚¢ãŒã¨ã¦ã‚‚é¢ç™½ãã†ãªã®ã§ã€ä½¿ã£ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ãŒã€ãƒ“ãƒ«ãƒ‰ã«è‰²ã€…ã¤ã¾ã¥ã„ãŸã®ã§ã€ãƒ¡ãƒ¢ã€‚ã‹ã‚Œã“ã‚Œ2é€±é–“ãã‚‰ã„å‰ã®ãƒã‚°ãªã®ã§ã€å¾®å¦™ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒé•ã£ã¦ãŸã‚‰ç”³ã—è¨³ãªã„ã§ã™ã€‚ CentOS 5.2 ã«å…¥ã‚Œã‚‹ CentOS ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã€ã“ã‚Œã«å…¥ã‚Œã‚‹ãƒã‚° æ—¢ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ã®MySQLã‚’ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã¨ã‚Šã‚ãˆãšã€ã‚ãƒ¬ã‚¤ã«ã—ã¦ãŠãã¾ã—ãŸã€‚ hata@local ~/local/rpms/mysql5> sudo yum remove mysql Resolving Dependencies --> Running transaction check ---> Package mysql.x86_64 0:5.0.45-7.el5 set to be erased --> Processing Dependency: libmysqlclient.so.15()(64b
heavenshell 2008/12/12
q4m
ãƒªãƒ³ã‚¯
ãƒã‚¿ã•ã‚“ã®ãƒ–ãƒã‚° : Q4Mã‚’PHP(PDO)ã§
Q4MãŒç„¡äº‹ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ããŸã®ã§ã€PHPã‹ã‚‰è§¦ã£ã¦ã¿ã‚‹ã€‚è©³ç´°ãªã“ã¨ã¯ä»Šåº¦æ›¸ãã€‚ã¨ã‚Šã‚ãˆãšè§¦ã‚Šã ã‘ã§ã‚‚ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾© drop table if exists hoge_queue; create table hoge_queue( id int not null, name varchar(25) not null ) engine=queue; ã“ã‚“ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ã‚¬ãƒ³ã‚¬ãƒ³å›žã—ã¦ã€ç›£è¦– $conn = new PDO('mysql:host=localhost; dbname=hogetest', 'user', 'password'); $wait = $conn->prepare('SELECT queue_wait("hoge_queue", 10)'); $abort = $conn->prepare('SELECT queue_abort()'); $e = $conn->pr
heavenshell 2008/12/11
php

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
heavenshell 2008/12/04
mysql

q4m
ãƒªãƒ³ã‚¯
1