[B! perl][ä¸¦åˆ—å‡¦ç†] BigFatCatã®ãƒ

BigFatCat id:BigFatCat

perlã¨ä¸¦åˆ—å‡¦ç†ã«é–¢ã™ã‚‹BigFatCatã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

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

ç¬¬22å›žã€€Coroã‚’ä½¿ã£ãŸã‚„ã•ã—ã„ã‚¯ãƒãƒ¼ãƒ©ã®ä½œã‚Šæ–¹ï¼ˆ3ï¼‰ | gihyo.jp
ï¼ˆ1ï¼‰ã¯ã“ã¡ã‚‰ã€ï¼ˆâ 2ï¼‰ã¯ã“ã¡ã‚‰ã‹ã‚‰ã€‚ ä¸¦åˆ—ãƒ»åˆ†æ•£å‡¦ç†ã®ãŸã‚ã®ã‚¯ãƒãƒ¼ãƒ© ã‚ã‚‹ç¨‹åº¦å¤§è¦æ¨¡ãªã‚¯ãƒãƒ¼ãƒ©ã‚’ä½œã‚‹å ´åˆã¯ã€ä¸€å®šæ™‚é–“å†…ã«ãªã‚‹ã¹ãå¤šãã®URLã‹ã‚‰åŠ¹çŽ‡çš„ã«ãƒ‡ãƒ¼ã‚¿ã‚’åŽé›†ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚æŽ¥ç¶šå…ˆã®ãƒ›ã‚¹ãƒˆã”ã¨ã«åŒæ™‚æŽ¥ç¶šæ•°ã‚„ã‚¦ã‚§ã‚¤ãƒˆãªã©ã®é…æ…®ã‚’ã—ã¤ã¤ã€å…¨ä½“ã¨ã—ã¦ã¯å¤§é‡ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’åŒæ™‚ã«å‡¦ç†ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã®ãŸã‚ã®ã‚¯ãƒãƒ¼ãƒ©ã€å®šæœŸçš„ã«åŒã˜URLã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹å¿…è¦ãŒã‚ã‚‹æ›´æ–°ãƒã‚§ãƒƒã‚¯ã‚„ãƒ•ã‚£ãƒ¼ãƒ‰ã‚¢ã‚°ãƒªã‚²ãƒ¼ã‚¿ãªã©ã¯ã€ç‰¹ã«è©²å½“ã™ã‚‹ã§ã—ã‚‡ã†ã€‚ Perlã§é«˜æ€§èƒ½ãªã‚¯ãƒãƒ¼ãƒ©ã‚’æ›¸ãå ´åˆã®é¸æŠžè‚¢ã¯2ã¤ã‚ã‚Šã¾ã™ã€‚ä¸€ã¤ã¯forkã«ã‚ˆã‚‹ãƒžãƒ«ãƒãƒ—ãƒã‚»ã‚¹ã«ã‚ˆã‚‹ã‚‚ã®ã§ã€Parallel::ForkManagerã‚„Paralell::Preforkã‚’ä½¿ã†ã‚±ãƒ¼ã‚¹ã‚„ã€ã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼ã®ãŸã‚ã®ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’ä½¿ã£ãŸãƒ¯ãƒ¼ã‚«ãŒã“ã‚Œã«è©²å½“ã—ã¾ã™ã€‚ã‚‚ã†ä¸€ã¤ã¯AnyEventã‚„Coroã‚’ä½¿ã£ãŸI/Oå¤šé‡åŒ–ã«ã‚ˆã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã§ã™ã€‚ç†è€…ãŒå¥½
BigFatCat 2013/12/25
"AnyEventã¨Coroã®é•ã„" "Coroã‚’ä½¿ã†ã¨è¤‡é›‘ãªéžåŒæœŸå‡¦ç†ã‚’ï¼Œã„ã‚ã‚†ã‚‹ã€Œã‚³ãƒ¼ãƒ«ãƒãƒƒã‚¯åœ°ç„ã€ã«é™¥ã‚‹ã“ã¨ãªãã‚·ãƒ³ãƒ—ãƒ«ã«è¨˜è¿°ã§ãã¾ã™ã€‚"

ä¸¦åˆ—å‡¦ç†

perl

fork
ãƒªãƒ³ã‚¯
Async::Queueã‚’ãƒªãƒªãƒ¼ã‚¹ - DebugIto's diary
Perlãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«Async::Queueã‚’ãƒªãƒªãƒ¼ã‚¹ã—ãŸã€‚ http://search.cpan.org/perldoc?Async%3A%3AQueue ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ã€ã‚ã‚‰ã‹ã˜ã‚ç™»éŒ²ã—ãŸéžåŒæœŸå‡¦ç†ã‚’ç«‹ã¦ç¶šã‘ã«å®Ÿè¡Œã™ã‚‹éš›ã«ã€å®Ÿè¡Œä¸¦åˆ—åº¦ã«åˆ¶é™ã‚’ã‹ã‘ã¦FIFOå®Ÿè¡Œã—ã¦ãã‚Œã‚‹ã€ã¨ã„ã†ã‚‚ã®ã€‚ ã¶ã£ã¡ã‚ƒã‘ãŸè©±ã€async.jsã®queueã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã¨åŒã˜ã€‚(åŒã˜APIã‚’åˆ‡ã£ã¦ã‚ã‚‹) ä»¥ä¸‹ã€ä½¿ç”¨ä¾‹ã€‚ use strict; use warnings; use AnyEvent; use AnyEvent::HTTP; use Async::Queue; my $q = Async::Queue->new(concurrency => 3, worker => sub { my ($url, $callback) = @_; print STDERR "Start $url\n"; http_ge
BigFatCat 2012/11/12
perl

async

ä¸¦åˆ—å‡¦ç†
ãƒªãƒ³ã‚¯
ã€Perlã€‘Parallel::ForkManagerãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ä¸¦åˆ—å‡¦ç†ãŒä¾¿åˆ©éŽãŽã¦ç”Ÿãã¦ã„ã‚‹ã®ãŒè¾›ã„ - oranie's blog
ã¨ã‚ã‚‹DBã‚’åˆ©ç”¨ã—ãŸãƒãƒƒãƒå‡¦ç†ã‚’ã‚„ã‚‰ã›ã‚ˆã†ã¨ã—ãŸæ™‚ã« #ã‚¹ã‚¯ãƒªãƒ—ãƒˆã®ä¸€éƒ¨åˆ† my @list1 = (é©å½“ãªãƒªã‚¹ãƒˆãã®1); my @list2 = (é©å½“ãªãƒªã‚¹ãƒˆãã®2); foreach my $value1 (@list1){ foreach my $value2(@list2){ #DBã«æŽ¥ç¶šã—ã¦ã€ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ä»¶æ•°countã™ã‚‹â†’ #ãã®çµæžœã‚’åˆ¥ãƒ†ãƒ¼ãƒ–ãƒ«ã«UPDATEã™ã‚‹SQLå®Ÿè¡Œå‡¦ç†; } }ã¨ã„ã†ã¾ã‚ã€foreachã§ã‚°ãƒ«ã‚°ãƒ«ã‚°ãƒ«ã‚°ãƒ«å›žã™ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æ›¸ã„ãŸã‚“ã§ã™ãã€‚ ã§ã€ã¾ãã“ã‚ŒãŒã‚¯ã‚½é‡ã‹ã£ãŸã‚“ã§ã™ãã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã¯å…¨éƒ¨ãƒ¡ãƒ¢ãƒªä¸Šã«è¼‰ã£ã¦ã„ã‚‹ã‚“ã§ã™ãŒã€ 10GBï¼ˆ1å„„ãƒ¬ã‚³ãƒ¼ãƒ‰ãã‚‰ã„ï¼‰ãã‚‰ã„ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã§é †ç•ªã«$value1,$value2ã®å¤‰æ•°ã‚’æ¡ä»¶ã«ä½¿ã£ã¦COUNT()ã‚’ä½¿ç”¨ã—ãŸ SELECTæ–‡ã‚’æŠ•ã’ã‚‹ã®ã§ã€ä¸€ã¤ã®SQLæŠ•ã’ãŸã‚‰DBå´ã®CPUã‚³ã‚¢ãŒ100%ã«ãªã£ã¦ã—
BigFatCat 2011/06/05
sql

DB

perl

ä¸¦åˆ—å‡¦ç†

cpan

benchmark
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

perlã¨ä¸¦åˆ—å‡¦ç†ã«é–¢ã™ã‚‹BigFatCatã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

perlã¨ä¸¦åˆ—å‡¦ç†ã«é–¢ã™ã‚‹BigFatCatã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ç¬¬22å›žã€€Coroã‚’ä½¿ã£ãŸã‚„ã•ã—ã„ã‚¯ãƒ­ãƒ¼ãƒ©ã®ä½œã‚Šæ–¹ï¼ˆ3ï¼‰ | gihyo.jp

Async::Queueã‚’ãƒªãƒªãƒ¼ã‚¹ - DebugIto's diary

ã€Perlã€‘Parallel::ForkManagerãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ä¸¦åˆ—å‡¦ç†ãŒä¾¿åˆ©éŽãŽã¦ç”Ÿãã¦ã„ã‚‹ã®ãŒè¾›ã„ - oranie's blog

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (6)

perlã¨ä¸¦åˆ—å‡¦ç†ã«é–¢ã™ã‚‹BigFatCatã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (3)

ç¬¬22å›žã€€Coroã‚’ä½¿ã£ãŸã‚„ã•ã—ã„ã‚¯ãƒãƒ¼ãƒ©ã®ä½œã‚Šæ–¹ï¼ˆ3ï¼‰ | gihyo.jp

ã€Perlã€‘Parallel::ForkManagerãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ä¸¦åˆ—å‡¦ç†ãŒä¾¿åˆ©éŽãŽã¦ç”Ÿãã¦ã„ã‚‹ã®ãŒè¾›ã„ - oranie's blog

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬1é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´11æœˆï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹