[B! tuning] hibomaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hiboma id:hiboma

tuningã«é–¢ã™ã‚‹hibomaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (37)

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

Etsukata blog: FreakOut DSP å…¥æœã‚µãƒ¼ãƒã® CPU ä½¿ç”¨çŽ‡ã‚’ 30% å‰Šæ¸›ã™ã‚‹ Performance Tuning
ã¯ã˜ã‚ã« å‹¤å‹™å…ˆã® FreakOut ç¤¾ã§ã¯ RTB ã§åºƒå‘Šæž ã‚’è²·ã„ä»˜ã‘ã‚‹ DSP ã®é–‹ç™ºãƒ»é‹ç”¨ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚RTB ã¨ã¯ã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆåºƒå‘Šã®ã‚¤ãƒ³ãƒ—ãƒ¬ãƒƒã‚·ãƒ§ãƒ³ãŒç”Ÿã˜ã‚‹æ¯Žã«ã€åºƒå‘Šæž ã®ç«¶äº‰å…¥æœã‚’è¡Œã†ä»•çµ„ã¿ã§ã™ã€‚ DSP ã¨ã¯ã€ RTB ã«ãŠã„ã¦ã€ç«¶äº‰å…¥æœã‚’ã™ã‚‹å´ã®ã‚·ã‚¹ãƒ†ãƒ ã«ãªã‚Šã¾ã™ã€‚åºƒå‘Šæž /åºƒå‘Šã‚’è¦‹ã¦ã„ã‚‹äºº ã«å¯¾ã—ã€æœ€é©ãªåºƒå‘Šã‚’ã€æœ€é©ãªã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§å±Šã‘ã‚‹æ©Ÿèƒ½ã‚’åºƒå‘Šä¸»ã«æä¾›ã™ã‚‹ä»•çµ„ã¿ã§ã™ã€‚ FreakOut DSP ã¯æœ€é©ãªåºƒå‘ŠæŽ¢ç´¢ãƒ»å…¥æœä¾¡æ ¼èª¿æ•´ã®ãŸã‚ã€éžå¸¸ã«å¤šãã®ãƒ‡ãƒ¼ã‚¿ã‚’å‚ç…§ã—ã€æ²¢å±±ã®æ¼”ç®—å‡¦ç†ã‚’è¡Œã„ã¾ã™ã€‚åºƒå‘Šã‚’è¦‹ã¦ã„ã‚‹äººãŒéŽåŽ»ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ãŸ Web ãƒšãƒ¼ã‚¸ã®æƒ…å ±ã‚„æ¤œç´¢ãƒ¯ãƒ¼ãƒ‰ã€ã•ã‚‰ã« åºƒå‘ŠãŒã‚¯ãƒªãƒƒã‚¯ã•ã‚Œã‚‹äºˆæ¸¬ç¢ºçŽ‡(éŽåŽ»ã®ãƒã‚°ã‹ã‚‰æ©Ÿæ¢°å¦ç¿’ã§ç®—å‡º) ãªã©ã‚’å‚ç…§ã—ã€å…¥æœä¾¡æ ¼ã‚’æ±ºå®šã™ã‚‹ã®ã§ã™ã€‚ãã®ãŸã‚ã€DSP ã§å…¥æœã‚’æ‹…å½“ã™ã‚‹ã‚µãƒ¼ãƒã¯ CPU ãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ãŠã‚Šã€å°æ•°ã‚‚æ•°ç™¾å°ã«åµ©ã‚“ã§ã„ã¾ã™ã€‚
hiboma 2015/07/16
tuning
ãƒªãƒ³ã‚¯
ISUCONã¦ã‚™å¦ãµã‚™ Webã‚¢ãƒ•ã‚šãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒã‚šãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‘ä¸Šã®ã‚³ãƒ„ å®Ÿè·µç·¨ å®Œå…¨ç‰ˆ
9. é™çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’ Reverse Proxy ã§é…ä¿¡ Reverse Proxy: ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã®æŽ¥ç¶šã‚’ å—ã‘ã€Applicationã‚µãƒ¼ãƒã«å‡¦ç†ã‚’ä¸ç¶™ã™ ã‚‹ã€‚ç”»åƒ,js,css ãªã©ã®é™çš„ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’è¿”ã™ å½¹å‰²ã‚‚ã‚ã‚‹ Application Server: ãƒ¦ãƒ¼ã‚¶ã‹ã‚‰ã®ãƒªã‚¯ã‚¨ã‚¹ ãƒˆã‚’å—ã‘ã¦é©åˆ‡ãªãƒšãƒ¼ã‚¸ã‚’æ§‹ç¯‰ãƒ»ãƒ¬ã‚¹ãƒãƒ³ ã‚¹ã‚’è¡Œã† 10. /etc/httpd/conf.d/isucon.conf <VirtualHost *:80> DocumentRoot /home/isu-user/isucon/webapp/public RewriteEngine on RewriteCond REQUEST_URI !^/favicon.ico$ RewriteCond REQUEST_URI !^/(img|css|js)/ RewriteRule /(.*)$ http://loc
hiboma 2014/08/22
covering index ã®ã‚ãŸã‚Šã®å›³ç¤ºãƒ“ãƒªãƒ†ã‚£ç´ æ•µ!

tuning
ãƒªãƒ³ã‚¯
Ruby on Rails on MySQL ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°å…¥é–€
Rails 3 ç³»+MySQL ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹å‘ã‘ã« 1. ã©ã®ã‚ˆã†ã«ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’æŽ¢ã™ã®ã‹ 2. ã©ã®ã‚ˆã†ãªè¨è¨ˆã‚’è¡Œãˆã°ã„ã„ã®ã‹ 3. Railsä¸Šã§ã©ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã‘ã°ã„ã„ã®ã‹ ã®3ç‚¹ã«çµžã£ã¦ã“ã®ãƒ—ãƒ¬ã‚¼ãƒ³ã‚’ã¿ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œãˆã‚‹ã‚ˆã†ã«è³‡æ–™ä½œæˆã‚’è¡Œã„ã¾ã—ãŸRead less
hiboma 2014/02/26
mysql

rails

tuning
ãƒªãƒ³ã‚¯
MySQLã®ãŸã‚ã®Linuxãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ’ãƒ³ãƒˆ | Yakst
Linuxã®MySQLã‚µãƒ¼ãƒã§æœ€ä½Žé™ã‚„ã£ã¦ãŠã‹ãªãã¦ã¯ãªã‚‰ãªã„ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã€ãƒ¡ãƒ¢ãƒªã€CPUã«é–¢ã™ã‚‹è¨å®šã®ãƒ¡ãƒ¢ã€‚ December 7, 2013 By Alexander Rubin æã‚‰ãã»ã¨ã‚“ã©ã®MySQL æœ¬ç•ªç’°å¢ƒã¯Linuxä¸Šã§å‹•ã„ã¦ã„ã‚‹ã“ã¨ã ã‚ã†ã€‚ãªã®ã§ã€MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ä¸Šã’ã‚‹ã®ã«æœ‰ç”¨ãªã€æœ€ã‚‚é‡è¦ãªLinuxã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã®ãƒ’ãƒ³ãƒˆã«ã¤ã„ã¦æ›¸ã“ã†ã¨æ±ºã‚ãŸã€‚ç‰¹ã«æ–°ã—ã„æƒ…å ±ã¯ãªãã¦ã€ã©ã‚Œã‚‚ã‚ˆãçŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã‚‚ã®ã§ã¯ã‚ã‚‹ãŒã€ãƒ–ãƒã‚°è¨˜äº‹ã«ã¾ã¨ã‚ã¦ã¿ã‚‹ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ext4 (ã¾ãŸã¯xfs) ã‚’noatimeã‚ªãƒ—ã‚·ãƒ§ãƒ³ä»˜ãã§ãƒžã‚¦ãƒ³ãƒˆ ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ©ã¯deadlineã‹noop # echo deadline >/sys/block/sda/queue/scheduler grub.confã«"elevator=deadline"ã‚’è¿½åŠ (è©³ç´°ã¯Linuxã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ©ã¨
hiboma 2013/12/11
NUMA ã¨ã‹ vm.swappiness ã¨ã‹ã¡ã‚‡ã†ã©è©±é¡Œã«ã€‚

mysql

tuning
ãƒªãƒ³ã‚¯
https://mail-archives.apache.org/mod_mbox/httpd-dev/201311.mbox/%[email protected]%3E
hiboma 2013/12/06
æ¡ä»¶ã„ã˜ã‚‹ã ã‘ã§ã“ã‚“ãªã«å¤‰ã‚ã‚‹ã®ã‹ãƒ¼

apache

tuning
ãƒªãƒ³ã‚¯
MySQL 5.6ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«å¾Œã«ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã¹ãé …ç›® | Yakst
MySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒžãƒãƒ¼ã‚¸ãƒ£ã®Morgan Tockeræ°ã«ã‚ˆã‚‹ã€MySQL 5.6ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸå¾Œã«ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã‹ã‚‰å¤‰æ›´ã—ãŸæ–¹ãŒã‚ˆã„ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®è§£èª¬ã€‚ æ•°ã€…ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã®æ”¹å–„ã«ã‚ˆã£ã¦ã€éŽåŽ»ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨æ¯”ã¹ã¦MySQL 5.6ã§ã¯è¨å®šã—ãªãã¦ã¯ãªã‚‰ãªã„å€¤ãŒã‹ãªã‚Šæ¸›ã£ãŸã€‚ã¨ã¯è¨€ãˆã€å¤‰æ›´ã™ã¹ãã‚‚ã®ã«ã¤ã„ã¦ã“ã“ã§æ›¸ã„ã¦ãŠããŸã„ã€‚ InnoDBã®è¨å®š innodb_buffer_pool_size - ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯128Mã€‚ã“ã‚Œã¯ã€ãƒ¡ãƒ¢ãƒªã«ãƒãƒ¼ãƒ‰ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ã¨ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãŸã‚ã«InnoDBãŒã©ã®ãã‚‰ã„ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã‹ã‚’æŒ‡å®šã™ã‚‹ã‚‚ã®ãªã®ã§ã€è¨å®šã™ã¹ãé‡è¦ãªå€¤ã ã€‚MySQLã®å°‚ç”¨ã‚µãƒ¼ãƒãªã‚‰ã€æè¼‰ã•ã‚Œã¦ã„ã‚‹ãƒ¡ãƒ¢ãƒªã®50%ã‹ã‚‰80%ãŒæŽ¨å¥¨ã•ã‚Œã‚‹è¨å®šå€¤ã ã€‚ä¾‹ãˆã°ã€64GBã®RAMã‚’æè¼‰ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒãªã‚‰ã€ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«ã¯50GBç¨‹åº¦ã«ã™ã¹ãã ã‚ã†ã€‚ innodb_log_file_size -
hiboma 2013/09/21
mysql

tuning
ãƒªãƒ³ã‚¯
PHP5.4 ã§ Zend OPcache ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å–ã£ã¦ã¿ãŸ
PHP5.5 ã‹ã‚‰æ¨™æº–ãƒãƒ³ãƒ‰ãƒ«ã•ã‚Œã‚‹ Zend OPcache ã‚’ PHP5.4 ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã¿ã¾ã—ãŸã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ç’°å¢ƒã¯ Vagrant ä¸Šã® CentOS6.4 ã§ã™ã€‚PHP ã¯ remi ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ã¾ã™ã€‚ $ php -v PHP 5.4.14 (cli) (built: Apr 11 2013 11:04:32) Copyright (c) 1997-2013 The PHP Group Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Techno logies Zend OPcache ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« remi ãƒªãƒã‚¸ãƒˆãƒªã«ã¯ Zend OPcache ã¯å˜åœ¨ã—ãªã„ã‚ˆã†ãªã®ã§ã€github ã‹ã‚‰ã‚½ãƒ¼ã‚¹ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ãƒ“ãƒ«ãƒ‰ã—ã¾ã—ãŸã€‚ æ‰‹é †ã¯ Zend OPcache ã® github ãƒšãƒ¼ã‚¸ã«è¨˜è¼‰
hiboma 2013/05/01
php

tuning
ãƒªãƒ³ã‚¯
Nginx Tuning For Best Performance - Codestance
For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx. Generally, properly configured nginx can handle up to 400,000 to 500,000 requests per second (clustered), most what i saw is 50,000 to 80,000 (non-clustered) requests per second and 30% CPU load, course, this was 2xIntel Xeon with HT enabled, but it can work without probl em on slower mach
hiboma 2013/05/01
tuning

nginx
ãƒªãƒ³ã‚¯
Apacheã§.htaccessã‚’ç„¡åŠ¹ã«ã™ã‚‹ã¨å ´åˆã«ã‚ˆã£ã¦ã¯ã‹ãªã‚Šæ—©ããªã‚‹ã‚ˆã¨ã„ã†ãŠè©±
äººé–“ã¨ã‚¦ã‚§ãƒ–ã®æœªæ¥ï¼ˆæ—§ï¼‰ ã€Œã‚¦ã‚§ãƒ–ã®æ´å²ã¯äººé¡žã®æ´å²ã®ç¹°ã‚Šè¿”ã—ã€ã¨ã„ã†è¦³ç‚¹ã‹ã‚‰è‰²ã€…å‹‰å¼·ã—ã¦ã„ã¾ã™ã€‚2014å¹´ã¾ã§ã®äººé–“ã¨ã‚¦ã‚§ãƒ–ã®æœªæ¥ã®æ—§ãƒ–ãƒã‚°ã§ã™ã€‚ Apacheã®é«˜é€ŸåŒ–ã®æ‰‹æ³•ã¨ã„ã†ã®ã¯ã€å¤šãã®ã‚µã‚¤ãƒˆã§ç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ãã®ã†ã¡ã®ä¸€ã¤ã¨ã—ã¦ã€.htaccessã‚’ç„¡åŠ¹ã«ã™ã‚‹ã¨ã„ã†è©±ãŒã‚ã‚Šã¾ã™ãŒã€å®Ÿã¯ã“ã‚Œã¯å ´åˆã«ã‚ˆã£ã¦ã¯éžå¸¸ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒå‘ä¸Šã—ã¾ã™ã€‚ãã‚ŒãŒä¸€ä½“ã©ã®ç¨‹åº¦ãªã®ã‹ã¨ã„ã†å®Ÿé¨“ã‚’ç°¡å˜ã«ã—ã¦ã¿ã¾ã—ãŸã€‚ ã¾ãšã¯Apacheã®è¨å®š å®Ÿé¨“ã§ä½¿ç”¨ã™ã‚‹preforkç‰ˆã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã¯ã“ã®ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ãƒ—ãƒã‚»ã‚¹ã®ç”Ÿæˆç ´æ£„ãŒç”Ÿã˜ãªã„ã‚ˆã†ãªè¨å®šã‚’ã—ã¦ã„ã‚‹ã®ã§ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¨ˆæ¸¬ç‰ã€è‰²ã€…ãªå®Ÿé¨“ã«æ±Žç”¨çš„ã«ä½¿ãˆã¦ãŠã™ã™ã‚ã§ã™ã€‚ ServerTokens Prod ServerRoot "/etc/httpd" PidFile run/httpd.pid Timeout 100 KeepAlive On
hiboma 2012/07/25
ã¨ã¦ã‚‚ã‚ˆã„æ¤œè¨¼

apache

linux

tuning
ãƒªãƒ³ã‚¯
500,000 requests/sec â€“ Modern HTTP servers are fast
A modern HTTP server running on somewhat recent hardware is capable of servicing a huge number of requests with very low latency. Hereâ€™s a plot showing requests per second vs. number of concurrent connections for the default index.html page included with nginx 1.0.14. With this particular hardware & software combination the server quickly reaches over 500,000 requests/sec and sustains that with gr
hiboma 2012/03/21
nginx

tuning
ãƒªãƒ³ã‚¯
GitHub - bnoordhuis/node-profiler: Access the V8 profiler from node.js
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
hiboma 2012/01/18
node.js

tuning
ãƒªãƒ³ã‚¯
Cè¨€èªžã«ãŠã‘ã‚‹æ–‡å—åˆ—é€£çµ â€” KaoriYa
Cè¨€èªžã§æ–‡å—åˆ—é€£çµã‚’è¡Œã†ã€‚ã¨ã¦ã‚‚ç°¡å˜ã«æ€ãˆã‚‹ã‘ã‚Œã©ã€å®Ÿã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¤ã„ã¦è€ƒãˆã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã‚“ã ã‚ˆã€ã¨ã„ã†ãŠè©±ã€‚ Cè¨€èªžã§2ã¤æ–‡å—åˆ—ã®é€£çµã—ã¦ã€1ã¤ã®æ–‡å—åˆ—ã«ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ (é–¢æ•°)ã‚’æ›¸ã‘ã‚‹ã§ã—ã‚‡ã†ã‹? ã¡ã‚‡ã£ã¨Cè¨€èªžã§ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å¦ã‚“ã ã“ã¨ãŒã‚ã‚Œã°ç°¡å˜ã§ã™ã‚ˆãã€‚è¦æ±‚ä»•æ§˜ã¨ã—ã¦ã¯2ã¤ã®å¼•æ•°aã¨bã‚’ã¨ã‚Šã€ã©ã¡ã‚‰ã‚‚NULã‚¿ãƒ¼ãƒŸãƒãƒ¼ãƒˆãªæ–‡å—åˆ—ã§ã€ãã®æ–‡å—åˆ—ã‚’ãƒ’ãƒ¼ãƒ—ã‹ã‚‰ç¢ºä¿ã—ãŸé ˜åŸŸã§é€£çµã—ã¦æˆ»ã‚Šå€¤ã¨ã—ã¦è¿”ã™ã€ã¨ã„ã†æ„Ÿã˜ã®å‹•ä½œã§ã™ã€‚ãƒ¨ãƒ¦ãƒ¼ã§ã™ãã€‚ã¡ã‚‡ã£ã¨æ›¸ã„ã¦ã¿ã¦ãã ã•ã„ã€‚ char* str_join(const char* a, const char* b) { char* p = malloc(strlen(a) + strlen(b) + 1); strcpy(p, a); strcat(p, b); return p; } ã“ã‚“ãªé¢¨ã«æ›¸ã„ã¦ã—ã¾ã£ãŸã‚ãªãŸã¯åŠç¬¬ç‚¹ã§ã™ã€‚å€‹äººçš„ã«ã¯å¤±æ ¼ã§ã™
hiboma 2012/01/17
"ã§ã™ãŒã“ã†ã„ã†è¦‹æ–¹ã‚’ã§ãã‚‹ã‹ã©ã†ã‹ã¨ã„ã†ã®ã¯ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®æŠ€é‡ã‚’è«–ã˜ã‚‹ä¸Šã§é‡è¦ã«ãªã£ã¦ãã‚‹ã‚‚ã®ãªã®ã§ã™ã€‚"

development

tuning
ãƒªãƒ³ã‚¯
ImageMagickã¨OpenMPã®ä»¶ - blog.nomadscafe.jp
ã€ŒPerlMagick ãŒ OpenMP æœ‰åŠ¹ã ã¨é«˜è² è·ã«ãªã‚‹ä»¶ :: drk7jpã€ã®ä»¶ ã©ã†ã‚„ã‚‰ã€Perlã«é™ã‚‰ãšãƒžãƒ«ãƒãƒ—ãƒã‚»ã‚¹ã§OpenMPãŒæœ‰åŠ¹ãªImageMagickã‚’å‹•ã‹ã™ã¨ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒæ‚ªããªã‚‹ã‚ˆã†ã§ã™ã€‚ Enabling OpenMP for most algorithms creates 8 threads (1 per core). If your process creates 8 threads thatâ€™s a total of 64 threads and that is a whole lot of contention and possible misuse of your processor cache. ã€ŒImageMagick â€¢ View topic - Multi Process Contention?ã€ã‚ˆã‚Š ã¨ã„ã†ã“ã¨ã§ã€small_light
hiboma 2012/01/04
linux

ImageMagick

perl

tuning
ãƒªãƒ³ã‚¯
hiphop php ã§PHPã‹ã‚‰ã‚¸ã‚§ãƒãƒ¬ãƒ¼ãƒˆã•ã‚ŒãŸC++ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã¿ã‚ˆã†ã€‚ - ãŠå‰ã®è¡€ã¯ä½•è‰²ã !! 4
PHP advent calendar ã§ã™ã€‚ ã‚¯ãƒªã‚¹ãƒžã‚¹éŽãŽã¾ã—ãŸã‘ã© 12/26æ—¥ã‚’ãŠé€ã‚Šã—ã¾ã™ã€‚(google docsã«åå‰æ›¸ãå¿˜ã‚Œã¦ã„ãŸã‚“ã ã‚ˆ) å‰å›ž 12/25æ—¥ã¯ã€@yoya ã•ã‚“ã®ã€ŒWindows ã§ PHP ã‚’ build ã™ã‚‹ã€ã§ã—ãŸã€‚ ä»Šå›žã¯ã€facebookã®äººãŒä½œã£ãŸ PHP ã‚’ C++ ã«å¤‰æ›ã—ã¦é«˜é€Ÿå‹•ä½œã•ã›ã‚‹ã¨ã„ã† hiphop php ãŒã‚¸ã‚§ãƒãƒ¬ãƒ¼ãƒˆã™ã‚‹ C++ ã®ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ C++ã¯åŽ³æ ¼ãªé™çš„åž‹ã¥ã‘ã®è¨€èªžã§ã™ãŒã€PHPã¯å‹•çš„åž‹ã¥ã‘ã®è¨€èªžã§ã™ã€‚ ã“ã‚Œã‚’ã©ã†ã‚„ã£ã¦ã€å¤‰æ›ã—ã¦ã„ã‚‹ã®ã‹ï¼Ÿã¨ã„ã†è©±ã§ã™ã€‚ éžå¸¸ã«é•·ãã€çœ ã„è©±ã«ãªã‚Šã¾ã™ãŒã€å¯ãªã„ã§èªã‚“ã§ã„ãŸã ã‘ãŸã‚‰å¬‰ã—ã„ã§ã™ã€‚ é–“é•ã„ãªã©ã‚ã‚Šã¾ã—ãŸã€ãœã²æ•™ãˆã¦ãã ã•ã„ã€‚ hiphop php ã‚’å…¥ã‚Œã‚ˆã†ã€‚ ãã‚‚ãã‚‚hiphop php ã‚’å…¥ã‚Œã‚‹ã®ã¯ã™ã”ãå¤§å¤‰ã§ã™ã€‚ Scientific Linux
hiboma 2011/12/26
php

tuning

c++
ãƒªãƒ³ã‚¯
å¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã€é‹å–¶ã®æœ€å‰ç·šã§å¾—ã‚‰ã‚ŒãŸãƒŽã‚¦ãƒã‚¦ã€€ï½žãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨é‹ç”¨ã€18ã®ãƒã‚¤ãƒ³ãƒˆï½ž
11æœˆ25æ—¥ã€ã€Œmobidec 2011ã€ã«ãŠã„ã¦ã‚³ãƒŠãƒŸãƒ‡ã‚¸ã‚¿ãƒ«ã‚¨ãƒ³ã‚¿ãƒ†ã‚¤ãƒ³ãƒ¡ãƒ³ãƒˆã®ã‚¹ã‚¿ã‚¸ã‚ªITã‚»ãƒ³ã‚¿ãƒ¼é•·ã§ã‚ã‚‹æ£å»¶å…‰å¼˜æ°ã«ã‚ˆã‚‹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€Œå¤§ãƒ’ãƒƒãƒˆSNS ã‚²ãƒ¼ãƒ ã€Žãƒ‰ãƒ©ã‚´ãƒ³ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã€ã‚’æ”¯ãˆã‚‹ã‚³ãƒŠãƒŸã®ã‚¯ãƒ©ã‚¦ãƒ‰æŠ€è¡“ã®æ´»ç”¨ã€ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ ãƒ‰ãƒ©ã‚´ãƒ³ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ã¯ã€GREEã§æä¾›ã•ã‚Œã¦ã„ã‚‹æºå¸¯é›»è©±å‘ã‘ã®ã‚«ãƒ¼ãƒ‰ã‚²ãƒ¼ãƒ ã‚¿ã‚¤ãƒ—ã®RPGã€‚ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã¯ã€ã‚¨ãƒªã‚¢ã”ã¨ã«ã‚ã‚‹è¤‡æ•°ã®ã‚¯ã‚¨ã‚¹ãƒˆã‚’ã‚¯ãƒªã‚¢ã—ã¦ã„ãã€ãƒ¢ãƒ³ã‚¹ã‚¿ãƒ¼ã‚«ãƒ¼ãƒ‰ã‚„ã€Œç§˜å®ã€ã‚’æ‰‹ã«å…¥ã‚Œã€ã•ã‚‰ã«ã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚«ãƒ¼ãƒ‰ã€ã‚’é›†ã‚ã¦ã„ãã¾ã™ã€‚ã¾ãŸã€ã»ã‹ã®ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã¨ãƒãƒˆãƒ«ã™ã‚‹ã“ã¨ã§ã‚‚ç§˜å®ã‚’å…¥æ‰‹ã§ãã‚‹ã¨ã„ã†SNSè¦ç´ ã‚‚å–ã‚Šå…¥ã‚Œã‚‰ã‚Œã¦ã„ã¾ã—ãŸã€‚2010å¹´9æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹å¾Œã€é †èª¿ã«ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼æ•°ã‚’ä¼¸ã°ã—ã€ç¾åœ¨ã§ã¯ç™»éŒ²äººæ•°ãŒ500ä¸‡äººã‚’è¶…ãˆã¦ã„ã¾ã™ã€‚ ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹å½“åˆã¯ç¤¾å†…ã§ã‚µãƒ¼ãƒã‚’æ§‹ç¯‰ã—ã€ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã«6å°ã®ã‚µãƒ¼ãƒã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã«3å°ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã€ãã—ã¦ãƒãƒ¼ãƒ‰ãƒ
hiboma 2011/12/21
tuning

php

mysql
ãƒªãƒ³ã‚¯
FlashCacheã§I/Oã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’è§£æ¶ˆã•ã›ã‚ˆã†
ãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã¯ã€2023å¹´10æœˆ1æ—¥ã«LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã«ãªã‚Šã¾ã—ãŸã€‚LINEãƒ¤ãƒ•ãƒ¼æ ªå¼ä¼šç¤¾ã®æ–°ã—ã„ãƒ–ãƒã‚°ã¯ã“ã¡ã‚‰ã§ã™ã€‚LINEãƒ¤ãƒ•ãƒ¼ Tech Blog ã¯ã˜ã‚ã« çš†æ§˜ã“ã‚“ã«ã¡ã¯ã€‚ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆã®çŸ¢æ¾¤ç¥å¸ã§ã™ã€‚ Yahoo! JAPANã«ã¦åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ãƒžãƒ«ãƒãƒšã‚¿ãƒã‚¤ãƒˆãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸é”ã¨ä»²è‰¯ãéŽã”ã—ã¦ã„ã‚‹ç§ãªã®ã§ã™ãŒã€ä»Šå›žã¯FlashCacheã‚’ç”¨ã„ãŸI/Oã®æœ€é©åŒ–ã«ã¤ã„ã¦æ¤œè¨¼ã—ãŸçµæžœã®ä¸€éƒ¨ã‚’çš†æ§˜ã«ã”ç´¹ä»‹ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ FlashCacheã¨ã¯ SSDè£½å“ãŒå®‰ä¾¡ã«èª¿é”ã§ãã‚‹ã‚ˆã†ã«ãªã£ãŸæ˜¨ä»Šã§ã‚ã£ã¦ã‚‚å¤§å®¹é‡ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’æ§‹ç¯‰ã™ã‚‹éš›ã¯HDDã«é ¼ã‚‰ã–ã‚‹ã‚’å¾—ãšã€ã•ã™ãŒã«ãƒ•ãƒ«SSDã§å¤§å®¹é‡ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’æ§‹ç¯‰ã—ã¦ã—ã¾ã†ã¨ã‚³ã‚¹ãƒˆéŽå¤šã§ç¾å®Ÿçš„ã§ã¯ãªã„ã¨åˆ¤æ–ã•ã‚Œã‚‹æ–¹ãŒå¤§åŠã‹ã¨æ€ã„ã¾ã™ã€‚ç¢ºã‹ã«SSDã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦I/Oæ€§èƒ½ãŒèª²é¡Œã ã£ãŸã‚·ã‚¹ãƒ†ãƒ ã‚’æ”¹å–„ã•ã‚ŒãŸäº‹ä¾‹ã¯ãŸãã•ã‚“ã‚ã‚‹ã‚‚ã®ã®ã€å¤§
hiboma 2011/12/20
tuning

facebook

kernel

linux
ãƒªãƒ³ã‚¯
INDEX FULL SCANã‚’ç‹™ã† - MySQL Casual Advent Calendar 2011 - SH2ã®æ—¥è¨˜
2011å¹´8æœˆã®kazeburoã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªã«å¯¾ã™ã‚‹è§£èª¬è¨˜äº‹ã§ã™ã€‚çµè«–ã‹ã‚‰è¨€ã†ã¨kazeburoã•ã‚“ã®æ¡ˆã«è³›æˆãªã®ã§ã™ãŒã€æœ¬æ—¥ã¯ã©ã†ã—ã¦ãã†ãªã£ãŸã®ã‹ã¨ã„ã†ã¨ã“ã‚ã‚’ç¢ºèªã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚æœ¬è¨˜äº‹ã¯MySQL Casual Advent Calendar 2011ã®17æ—¥ç›®ã®ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚16æ—¥ç›®ã¯akira1908jpã•ã‚“ã§ã—ãŸã€‚ å½“æ™‚ã®å†…å®¹ã‚’è¦šãˆã¦ã„ãªã„æ–¹ã¯ã€å…ˆã«kazeburoã•ã‚“ã®ã‚¨ãƒ³ãƒˆãƒªã‚’ã”ä¸€èªãã ã•ã„ã€‚ã¾ãŸã€ãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ãŒGitHubã«å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã®ã§ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«å†ç¾è©¦é¨“ã‚’ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ã€‚ Covering Index ã¨ self-join ã¨ MySQL - blog.nomadscafe.jp kazeburo's gist: 1150842 - Gist å•é¡Œã®SQLã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã«ã¯ã€MySQLãŒã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«å¯¾ã—ã¦ã©ã®ã‚ˆã†ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‹ã¨ã„ã†ç‚¹ã«ã¤
hiboma 2011/12/19
mysql

tuning
ãƒªãƒ³ã‚¯
ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’åˆ‡ã£ãŸã»ã†ãŒã„ã‚¤ã‚«ï¼Ÿ ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã—ã¦ã¿ãŸ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ï¼(æŒ¨æ‹¶) ã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯ MySQL Casual Advent Calendar 2011 ã®18æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ æ˜”ã€å°‚ã‚‰ PostgreSQL ã‚’ä½¿ã£ã¦ã„ãŸé ƒã€MySQL ã®ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã£ã¦ç°¡å˜ã«æ€§èƒ½ä¸ŠãŒã‚‹ã—ã¿ãŸã„ã ã—ç¾¨ã¾ã—ã„ãªã‚ã€ã¨æ€ã£ã¦ã„ã¾ã—ãŸã€‚ãã®ãŸã‚ã€1å¹´ã»ã©å‰ã‹ã‚‰æ¥å‹™ã§ MySQL ã‚’ä½¿ã†ã‚ˆã†ã«ãªã£ã¦ã‚‚ã€ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯å½“ç„¶ã®ã”ã¨ãæœ‰åŠ¹ã«ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ ã¨ã“ã‚ãŒå…ˆæ—¥ DSASé–‹ç™ºè€…ã®éƒ¨å±‹:ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯åˆ‡ã£ãŸã»ã†ãŒã„ã„ã‚“ã˜ã‚ƒãªã‚¤ã‚«ï¼Ÿ ã¨ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’èªã¿ã¾ã—ã¦ã€ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒã‚¯ã‚’ç²å¾—ã™ã‚‹ã¨ã®ã“ã¨ã€‚ã“ã‚Œã¯ã¡ã‚‡ã£ã¨æ¤œè¨¼ã—ã¦ã¿ãªã‘ã‚Œã°ãªã‚‹ã¾ã„ã€ã¨ã„ã†ã“ã¨ã§ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’ã—ã¦ã¿ã¾ã—ãŸã€‚ ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯çµæžœ çµæžœã¯åˆ¥ãƒšãƒ¼ã‚¸ã«ã¾ã¨ã‚ã¾ã—ãŸ benchmark script ã¨ my.cnf ã–ã£ãã‚Šã¨èª¬æ˜Žã—ã¾ã™ã¨ã€ å¹³å‡ 260 byte/è¡Œã€1
hiboma 2011/12/19
mysql

tuning
ãƒªãƒ³ã‚¯
RENAME TABLEã§ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ãªé‹ç”¨ @mysql-casual#15 - blog.nekokak.org
ã‚„ãã€‚å¯æ„›ã„ã‚¢ã‚¤ã‚³ãƒ³ã§ãŠé¦´æŸ“ã¿ã®@nekokakã ã‚ˆã€‚ mysql-casualã¨ã‹è¨€ã£ã¦ã‚‹ã‘ã©ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ãªè¨˜äº‹ãŒ@oinumeã•ã‚“ãã‚‰ã„ã—ã‹ãªã„ã‚ˆãã€‚ ãƒ‰ãƒ³å¼•ãã ã'`,ï½¤('âˆ€`) '`,ï½¤ ã¨ã„ã†ã“ã¨ã§ã‚¬ã‚¯ãƒ³ã¨æ•·å±…ã‚’ä¸‹ã’ã‚ˆã†ã£ã¦æ„Ÿã˜ã§è¶…çµ¶ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ãªè©±ã‚’ã—ã¦ã¿ã‚ˆã†ã¨æ€ã†ã‚“ã ã€‚ ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«é‹ç”¨ã—ã¦ã„ã‚‹ã¨ã€ã€Œã‚ã‚Œãªã‚“ã‹ã“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¾ã˜ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ãŠãŠã™ãŽãï¼Ÿã€ ã¨ã‹ã‚ã‚‹ã‚ã‚‹ã§ã™ã‚ˆãã€‚ ãã“ã§ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«countã—ã¦è¦‹ã‚‹ã‚ã‘ã§ã™ã€‚ InnoDBã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãªã®ã«ãã‚Œã‚‚msaterã«å¯¾ã—ã¦ã€‚ ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã§ã™ãã€‚ mysql> select count(*) from accesslog; +----------+ | count(*) | +----------+ | 11676738 | +----------+ 1 row in set (1 min 36.99 sec)1åˆ†åŠãã‚‰ã„ã‹ã‹
hiboma 2011/12/15
('âˆ€`)

mysql

tuning
ãƒªãƒ³ã‚¯
Apache ã®ä¸¦åˆ—æ•°ã‚’ CPU ã‚³ã‚¢æ•°ã«å¿œã˜ã¦æ±ºå®šã™ã‚‹ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
KLab Advent Calendar 2011 ã€ŒDSAS for Social ã‚’æ”¯ãˆã‚‹æŠ€è¡“ã€ã®10æ—¥ç›®ã§ã™ã€‚ æ˜¨æ—¥ã®è¨˜äº‹ ã§ã¯ä¸¦åˆ—æ•°ã‚’è¨å®šã™ã‚‹åŸºæœ¬çš„ãªæ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã—ãŸã€‚ ä»Šæ—¥ã¯å®Ÿéš›ã« DSAS for Social ã§åˆ©ç”¨ã—ã¦ã„ã‚‹è¨å®šæ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ èƒŒæ™¯ å®Ÿéš›ã®ä¸¦åˆ—æ•°ã®è¨å®šã¯ãƒžã‚·ãƒ³ã®CPUã‚¹ãƒšãƒƒã‚¯ã‚„ã‚¢ãƒ—ãƒªã®ç‰¹æ€§(ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚¿ã‚¤ãƒ ã® ä½•å‰²ã‚’Webã‚µãƒ¼ãƒãƒ¼ã®CPUã‚’ä½¿ã†å‡¦ç†ãŒå ã‚ã¦ã„ã‚‹ã‹)ã«å¿œã˜ã¦è¨å®šã™ã‚‹ã®ã§ã™ãŒã€ DSAS for Social ã§ã¯ã‚¢ãƒ—ãƒªã®è² è·ã«å¿œã˜ã¦æŸ”è»Ÿã«Webã‚µãƒ¼ãƒãƒ¼ã‚’ è¿½åŠ ãƒ»å‰Šé™¤ã™ã‚‹ã®ã§ã€CPUã‚¹ãƒšãƒƒã‚¯ãŒä¸€å®šã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ å…·ä½“çš„ã«è¨€ãˆã°ã€ Core2 ä¸–ä»£ã®4ã‚³ã‚¢ã‚µãƒ¼ãƒãƒ¼ã¨ã€Core i7ä¸–ä»£ã®4ã‚³ã‚¢8ã‚¹ãƒ¬ãƒƒãƒ‰ ã‚µãƒ¼ãƒãƒ¼ãŒ Web ã‚µãƒ¼ãƒãƒ¼ã¨ã—ã¦åˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã§ã‚‚ã€Webã‚µãƒ¼ãƒãƒ¼ã”ã¨ã«é•ã†è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã‚’ç”¨æ„ã—ãŸãã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ãªã‚“ã¨ã‹ã§ããªã„
hiboma 2011/12/15
`getconf _NPROCESSORS_ONLN`

apache

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