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

aki77 id:aki77

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

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

Q4Mã‚’ç°¡å˜ã«å°Žå…¥ã™ã‚‹æ–¹æ³• for MySQL 5.6 - blog.nomadscafe.jp
ä»¥å‰ã€ã€ŒQ4Mã‚’ç°¡å˜ã«å°Žå…¥ã™ã‚‹æ–¹æ³• - MySQL Casual Advent Calendar 2011ã€ã§ç´¹ä»‹ã—ãŸQ4Må°‚ç”¨MySQLã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®MySQL5.6å¯¾å¿œç‰ˆã‚’ä½œã‚Šã¾ã—ãŸã€‚ kamipoå…ˆç”Ÿã«ã‚ˆã‚‹ã¨ã€ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã‚’ã‚ã¨ã‹ã‚‰ãƒ“ãƒ«ãƒ‰ã—ã¦MySQLã«è¿½åŠ ã™ã‚‹äº‹ã¯æŽ¨å¥¨ã•ã‚Œã¦ã„ãªã„ã¨ã®ã“ã¨ãªã®ã§ã€Q4Mã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’MySQLã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ãƒ„ãƒªãƒ¼ã«ã‚³ãƒ”ãƒ¼ã—ã¦ã‹ã‚‰ä¸€ç·’ã«ãƒ“ãƒ«ãƒ‰ã—ã¾ã™ã€‚ã“ã‚Œã¯åŒã˜ãkamipoå…ˆç”Ÿã®mysql-buildã‚’å‚è€ƒã«ã•ã›ã¦é ‚ãã¾ã—ãŸã€‚ #!/bin/sh set -e MYVER=5.6.15 Q4MVER=0.9.11 CDIR=$(cd $(dirname $0) && pwd) cd /usr/local/src if [ -f $CDIR/mysql-$MYVER.tar.gz ]; then cp $CDIR/mysql-$MYVER.t
aki77 2014/01/30
q4m

mysql
ãƒªãƒ³ã‚¯
Q4Mã‚’ç°¡å˜ã«å°Žå…¥ã™ã‚‹æ–¹æ³• - MySQL Casual Advent Calendar 2011 - blog.nomadscafe.jp
xai cronã¨ãƒã‚¿ãŒè¢«ã£ãŸã‚ˆã†ã ã‘ã©æ°—ã«ã—ãªã„ï¼žï¼œ livedoorã§Operations Engineerã‚„ã£ã¦ã‚‹kazeburoã Yoã€‚æœ€è¿‘livedoorã‹ã‚‰ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹åŒ–ã•ã‚ŒãŸ3å„„ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç®¡ç†ã—ã¦ã‚‹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ŒSTFã€ã§ã‚‚ä½¿ã£ã¦ã‚‹Message Queueã®Q4Mã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã‚’ç´¹ä»‹ã™ã‚‹ã‚ˆï¼ã€€ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã ã‘ï¼ çŸ¥ã£ã¦ã‚‹äººã‚‚å¤šã„ã¨æ€ã†ã‘ã©Q4Mã¯kazuhoã•ã‚“ã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚ŒãŸMySQLã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦å®Ÿè£…ã•ã‚Œã¦ã‚‹Message Queueã€‚livedoorã§ã¯ã‚‚ã¡ã‚ã‚“ã€mixiã‚„DeNAã‚’ã¯ã˜ã‚ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ å„ç¤¾ã§ã‚‚ä½¿ã‚ã‚Œã¦ã„ã‚‹ã€‚ Message Queueã®èª¬æ˜Žã‚„ä½¿ã„æ–¹ã¯DIS_COMMENTã§ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ãƒ•ãƒ«ã®çŒ«ç¥žæ§˜ãŒæ›¸ã„ã¦ã‚‹ã®ã§å‚è€ƒã«ãªã‚‹ãï¼ Perl Hackers Hub ç¬¬10å›žã€€ã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼ã§å¾Œå›žã—å¤§ä½œæˆ¦â€•Th
aki77 2011/12/04
q4m
ãƒªãƒ³ã‚¯
CentOS 5.2 MySQL 5.1.44ã«Q4Mã‚’å…¥ã‚Œã‚‹ - ã‚¤ãƒŽãƒ™ãƒ¼ãƒˆãªéžæ—¥å¸¸
Q4Mã¯ã‚µã‚¤ãƒœã‚¦ã‚ºãƒ©ãƒœã®å¥¥ ä¸€ç©‚æ°ãŒé–‹ç™ºã—ãŸã€MySQLã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ä½¿ç”¨ã§ãã‚‹ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚ãƒ¥ãƒ¼ã§ã™ã€‚è©³ç´°ã«ã¤ã„ã¦ã¯ä»¥ä¸‹ã®ã‚¦ãƒŽã‚¦ãƒ©ãƒœã•ã‚“ã®è¨˜äº‹ãŒå‚è€ƒã«ãªã‚Šã¾ã™ã®ã§ã€ã“ã¡ã‚‰ã‚’ã”è¦§ãã ã•ã„ã€‚ Q4Mã‚’è§¦ã£ã¦ã¿ã‚‹ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã®å‰ææ¡ä»¶ã¨ã—ã¦ã€MySQLã®ã‚½ãƒ¼ã‚¹ãŒconfigureã¾ã§é€šã£ã¦ã„ã‚‹ã“ã¨ãŒå‰æã«ãªã‚Šã¾ã™ã€‚ã§ãªã„ã¨ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒå‡ºã¾ã™ã€‚ã“ã¡ã‚‰ã¯ã€MySQL + Q4M ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€€ãƒãƒžãƒªã©ã“ã‚ã¾ã¨ã‚ã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§--with-mysqlã®æŒ‡å®šãŒé–“é•ã£ã¦ã„ã‚‹æ™‚ã¨åŒã˜ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¾ã™ã€‚ã“ã‚Œã¯apacheã¨phpã®é–¢ä¿‚ã¨åŒã˜ã§å…ˆã«apacheã®configureã‚’é€šã—ã¦ãŠãã¨ã„ã†å¥´ã§ã™ãã€‚*1ã“ã“ã§ã¯éŽåŽ»ã‚¨ãƒ³ãƒˆãƒªãƒ¼CentOS 5.2 MySQL 5.1.44ã«Spiderã‚’å…¥ã‚Œã‚‹ã§MySQL 5.1.44ã®ã‚½ãƒ¼ã‚¹ãŒconfigureã¾ã§é€šã£ã¦ã„ã‚‹å‰æã§ã™ã€‚ error
aki77 2010/08/18
mysql

q4m

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

q4m

mysql

mac
ãƒªãƒ³ã‚¯
ãƒã‚¿ã•ã‚“ã®ãƒ–ãƒã‚°(å¾©åˆ»ç‰ˆ) : 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 ã„ãã¤ã‹è³ªå•ãŒã‚ã£ãŸã‚‚ã®ã¯ã€åˆ¥é€”æ›¸ãã¾ã™
aki77 2009/09/13
php

symfony

q4m

flare
ãƒªãƒ³ã‚¯
Data::Model::Driver::Queue::Q4M - Yappo::ã‚¿ãƒ¯ã‚·
Q4Må–ã‚Šæ‰±ã†æ‰€ã‚’ Queue::Q4M ä½¿ã£ã¦æ¥½ã—ã‚ˆã†ã¨æ€ã£ãŸã®ã ãŒã€Queue::Q4M ã¯ãã‚Œå˜ä½“ã§ä½¿ã‚ãªã„ã¨queue_abortã¨ã‹å‘¼ã³ã¾ãã‚Šãã†ãªå®Ÿè£…ã ã£ãŸã®ã§ã€å…¨éƒ¨è‡ªåˆ†ã§ãƒãƒ³ãƒ‰ãƒªãƒ³ã‚°ã—ãŸã£ãŸã€‚ use Data::Model::Driver::Queue::Q4M; my $driver = Data::Model::Driver::Queue::Q4M->new( dsn => 'dbi:mysql:database=test', username => '', password => '', timeout => 60, # queue_wait timeout ); { package MyQueue; use base 'Data::Model::Extend::Queue::Q4M'; use Data::Model::Schema; base_driver $dr
aki77 2009/06/14
q4m

perl
ãƒªãƒ³ã‚¯
Q4M - Tutorial
A Q4M table represents a single queue. A row of a Q4M table represents a single message. To create a message queue, use CREATE TABLE statement with the engine name ``queue''. mysql> CREATE TABLE my_queue (v1 int not null, v2 varchar(255)) ENGINE=queue; If you need to route messages to more than one subscriber, create table for each of them. You can create any number of Q4M tables. To send a messag
aki77 2009/06/14
q4m

tutorial
ãƒªãƒ³ã‚¯
Net_Q4M - openpear
Summary Provides interface to Q4M(Queue for MySQL). http://q4m.31tools.com/ License The MIT License http://opensource.org/licenses/mit-license.html Usage $queue = new Net_Q4M(); $queue->connect('mysql://user:pass@localhost:3306/database'); $row = $queue->dequeue('my_queue'); //$row = $queue->dequeue('my_queue', 5); // set timeout to 5 seconds //$row = $queue->dequeue('my_queue', 'my_queue2', 'my_
aki77 2009/06/13
php

q4m

openpear
ãƒªãƒ³ã‚¯
æ£šã‹ã‚‰ãƒ‘ãƒ«ãƒãƒ£ã‚®
$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()ã‚’å‘¼ã¶ã“ã¨ã§ã‚ãƒ¥ãƒ¼ã‹ã‚‰å€¤ã‚’å‰Šé™¤ã—ã¾ã™ã€‚ é€†ã«å¤±æ•—ã—ãŸå ´
aki77 2009/06/13
openpear/Net_Q4M

q4m

php

openpear
ãƒªãƒ³ã‚¯
http://labs.cybozu.co.jp/blog/kazuhoatwork/2009/04/q4m_presentation_slides_at_mys.php
aki77 2009/05/01
q4m

mysql
ãƒªãƒ³ã‚¯
https://labs.cybozu.co.jp/blog/kazuho/archives/2009/04/mysql_conference_expo_2009.php
aki77 2009/05/01
mysql

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.
aki77 2009/04/14
mac

q4m
ãƒªãƒ³ã‚¯
æ£šã‹ã‚‰ãƒ‘ãƒ«ãƒãƒ£ã‚®
â€¦ã®ã§ã€ãã®ãƒ¡ãƒ¢æ›¸ãã€‚ http://q4m.31tools.com/ MySQL5.1ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ 5.1ç³»ã¯ã¾ã develã«ã—ã‹ãªã„ã®ã§ã€5.0ç³»ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ã‚‹å ´åˆã¯deactivateã™ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åˆæœŸåŒ–ã¨ã‹ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã®è¨å®šã¨ã‹è‡ªå‹•èµ·å‹•ã¨ã‹ã®è«¸ã€…ã¯å‰²æ„›ã€‚ $ cd /ur/local/src $ wget http://q4m.31tools.com/dist/q4m-0.8.3.tar.gz $ tar -zxf q4m-0.8.3.tar.gz $ cd q4m-0.8.3 $ ./configure --prefix=/opt/local/lib/mysql5/mysql --includedir=/opt/local/include ... checking for mysql source code... configure: error: "no m
aki77 2009/03/31
ã€ŽMacBookã«Q4Mã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸ ã€

q4m

mysql

mac
ãƒªãƒ³ã‚¯
centos5ã€Q4Mã‚’ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ãŸè¨˜éŒ² - <s>gnarl,</s>æŠ€è¡“ãƒ¡ãƒ¢â€â€™<marquee><textarea>ï¿¥
æ³¨æ„ Q4M0.8.4+MySQL5.1.32ã®ãã¿ã‚ã‚ã›ã ã¨ãƒã‚°ãŒã‚ã‚‹ã£ã½ã„ã§ã™ã€‚ãƒã‚¤ãƒŠãƒªãƒã‚°ç„¡åŠ¹ã«ã—ãªã„ã¨ã„ã‘ã¾ã›ã‚“ã€‚ ç’°å¢ƒ CentOS5 å…¬å¼ã‚µã‚¤ãƒˆã‹ã‚‰è½ã¨ã—ã¦ããŸ MySQL 5.1.32ã®rhel5ç”¨rpmã§ã‚¤ãƒ³ã‚¹ã‚³ã—ãŸMySQL Q4Mã¯0.8.4 å‚è€ƒã‚µã‚¤ãƒˆ http://castor.s26.xrea.com/blog/tech/tech00015.htmlãŒå¤§å¤‰å‚è€ƒã«ãªã‚Šã¾ã—ãŸã€‚ãªã‹ã£ãŸã‚‰ç„¡ç†ã ã£ãŸã€‚ ã‚„ã‚Šã‹ãŸ çµè«–ã¨ã—ã¦ã¯ã€configureã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ã“ã†ã€‚ CPPFLAGS=`mysql_config --cflags` LDFLAGS=`mysql_config --libs` ./configure --prefix=/usr --with-mysql=/usr/src/redhat/SOURCES/mysql-5.1.32 --includedir=/us
aki77 2009/03/31
centos

q4m

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

q4m

scalability

db
ãƒªãƒ³ã‚¯
Shibuya.pmã§ã—ã‚ƒã¹ã£ã¦ãã¾ã—ãŸ - æœ€é€Ÿè»¢è·ç ”ç©¶ä¼š
é…ããªã£ãŸã‘ã©è³‡æ–™ã€ã¨ã€å‹•ç”»ã€‚æœ€è¿‘ã®ãŠä»•äº‹ã«ã¤ã„ã¦è©±ã—ã¾ã—ãŸã€‚ http://svn.coderepos.org/share/docs/mala/20081127-shibuyapm10-lt/index.html http://svn.coderepos.org/share/docs/mala/20081127-shibuyapm10-lt/main.txt è»¢è·ã¨ã‹é€€è·ã¨ã‹ä½•ã®ã“ã¨ã ã‹è‰¯ãåˆ†ã‹ã‚‰ãªã„ã€‚
aki77 2008/12/13
ldr

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
aki77 2008/12/08
q4m

php
ãƒªãƒ³ã‚¯
ãƒã‚¿ã•ã‚“ã®ãƒ–ãƒã‚° : 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
aki77 2008/12/08
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
aki77 2008/12/05
q4m

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

mysql

performance

scalability

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