[B! ã‚ã‚ŠãŒã¨ã†] harumaki_netã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

harumaki_net id:harumaki_net

ã‚ã‚ŠãŒã¨ã†ã«é–¢ã™ã‚‹harumaki_netã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (21)

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

Studying HTTP
RFC(Request For Comments) 2616ã‚’ã¯ã˜ã‚ã¨ã—ãŸã€HTTP(Hypertext Transfer Protocol)ã«é–¢ã™ã‚‹æ–‡çŒ®ãªã©ã‚’ç´¹ä»‹ã—ã€HTTPã‚„WWW(World Wide Web)ã«é–¢é€£ã™ã‚‹æŠ€è¡“ã«ã¤ã„ã¦ã®çŸ¥è˜ã‚’æ·±ã‚ã‚‹ãŸã‚ã®ã‚µã‚¤ãƒˆã§ã™ã€‚About [Studying HTTP] å½“ã‚µã‚¤ãƒˆã¯ã€RFC 2616ã‚’ã¯ã˜ã‚ã¨ã—ãŸã€HTTPã«é–¢ã™ã‚‹æ–‡çŒ®ãªã©ã‚’ç´¹ä»‹ã—ã€HTTPã‚„WWWã«é–¢é€£ã™ã‚‹æŠ€è¡“ã«ã¤ã„ã¦ã®çŸ¥è˜ã‚’æ·±ã‚ã‚‹ãŸã‚ã®ã‚µã‚¤ãƒˆã§ã™ã€‚ å½“ã‚µã‚¤ãƒˆã‚’åˆã‚ã¦ã”åˆ©ç”¨ã«ãªã‚‹æ–¹ã¯ã€Studying HTTP : Helpã‚’ãŠèªã¿ã„ãŸã ãã€è¨˜è¿°ã®å†…å®¹ã«ã”åŒæ„ã®ä¸Šã€ã”åˆ©ç”¨ä¸‹ã•ã„ã€‚ 2014.11.26 æ›´æ–° å½“ã‚µã‚¤ãƒˆã¸ã®ã”é€£çµ¡ã¯ã€ç¾åœ¨ãƒ¡ãƒ¼ãƒ«ã®ã¿ã¨ãªã£ã¦ãŠã‚Šã¾ã™ã€‚ Main Contents HTTP Status Code HTTP/1.1ä»•æ§˜æ›¸ãªã©ã§å®šç¾©ã•ã‚Œã¦ã„ã‚‹HTTPã‚¹ãƒ†ãƒ¼ã‚¿
harumaki_net 2015/02/13
http

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
è„±åˆå¿ƒè€…ã‚’ç›®æŒ‡ã™ãªã‚‰çŸ¥ã£ã¦ãŠããŸã„ä¾¿åˆ©ãªVimã‚³ãƒžãƒ³ãƒ‰25é¸ (Vimmerãƒ¬ãƒ™ãƒ«è¨ºæ–ä»˜ã) - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã¯ã˜ã‚ã«: Vimãªã‚‰ã§ã¯ã®ä¾¿åˆ©æ©Ÿèƒ½ã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã‚ˆã†ï¼ ã‹ã‚Œã“ã‚Œæ•°å¹´å‰ã€åƒ•ãŒVim(ã¨ã„ã†ã‹ã€ãŸã¶ã‚“Vi)ã¨åˆå¯¾é¢ã—ãŸã¨ãã¯ã€ã€Œãªã‚“ã¦ä½¿ã„ã«ãã„ã‚¨ãƒ‡ã‚£ã‚¿ãªã‚“ã ï¼ï¼ã€ã¨æœ€æ‚ªã®å°è±¡ã§ã—ãŸã€‚ ã—ã‹ã—ã€å‘¨ã‚Šã®ãƒ—ãƒã‚°ãƒ©ãƒžã‚„ãƒãƒƒãƒˆä¸Šã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŸã¡ã¯ã¿ã‚“ãªã€ŒVimä¾¿åˆ©ï¼ã€ã€ŒVimæœ€é«˜ï¼ã€ã¨è¨€ã„ã¾ã™ã€‚ ãªã®ã§ãã®è¨€è‘‰ã‚’ä¿¡ã˜ã€åƒ•ã‚‚æœ€æ‚ªã®å°è±¡ã ã£ãŸVimã¨ã‚‚ã†ä¸€åº¦æ£é¢ã‹ã‚‰å‘ãåˆã†ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ãã—ã¦ã€æœˆæ—¥ãŒéŽãŽãƒ»ãƒ»ãƒ»åƒ•ã‚‚ã„ã¤ã—ã‹ã€ŒVimä¾¿åˆ©ï¼ã€ã€ŒVimæœ€é«˜ï¼ã€ã¨å«ã¶ã‚ˆã†ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸï¼ï¼ ã“ã‚Œã£ã¦æ´—è„³ï¼Ÿ ã„ã‚„ã„ã‚„ã€æ´—è„³ã˜ã‚ƒã‚ã‚Šã¾ã›ã‚“w Vimã«
harumaki_net 2014/06/12
ä¸ç´šVimmer ã ã£ãŸï¼ã‘ã©11ãƒã‚¤ãƒ³ãƒˆãªã‚“ã§åˆç´šã«æ¯›ãŒç”ŸãˆãŸãƒ¬ãƒ™ãƒ«â€¦orz

vim

ã¾ã¨ã‚

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
ã€å€‹äººãƒ¡ãƒ¢ã€‘CentOSç’°å¢ƒã«ç™»éŒ²ã™ã‚‹yumãƒªãƒã‚¸ãƒˆãƒª - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
harumaki_net 2014/04/14
ãƒªãƒã‚¸ãƒˆãƒªä¸€è¦§ä½œã‚‰ãªãã‚ƒã€ã¨æ€ã£ã¦ã„ãŸã®ã§ã€è¶…åŠ©ã‹ã‚Šã¾ã™

yum

ã¾ã¨ã‚

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
Apacheãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°: MaxClientsã«è¨å®šã§ãã‚‹ä¸Šé™å€¤ã‚’è¨ˆç®—ã™ã‚‹ - (DxD)âˆž
Day by Day Infinity â€“ Webãªæ—¥ã€…(HTML/XHTML/CSS/JavaScript/PHP/CMS) Apacheã®MPMã®è¨å®šã«ãŠã„ã¦ã€MaxClientsã«è¨å®šã§ãã‚‹ä¸Šé™å€¤ã‚’è¨ˆç®—ã™ã‚‹ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œæˆã—ã¾ã—ãŸã€‚ å‚è€ƒã«ã•ã›ã¦ã„ãŸã ã„ãŸã®ã¯ä»¥ä¸‹ã®ãƒšãƒ¼ã‚¸ã§ã™ã€‚ æ¸›ã‚Šç¶šã‘ã‚‹ãƒ¡ãƒ¢ãƒªæ®‹é‡ï¼ æžœãŸã—ã¦ãã®åŽŸå› ã¯!? Linux ã®ãƒ—ãƒã‚»ã‚¹ãŒ Copy on Write ã§å…±æœ‰ã—ã¦ã„ã‚‹ãƒ¡ãƒ¢ãƒªã®ã‚µã‚¤ã‚ºã‚’èª¿ã¹ã‚‹ apacheã®MaxClientsã®é©æ£å€¤èª¿ã¹ãŸ apacheã®MaxClientã‚’ç®—å‡ºã™ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œã£ãŸ PHPã ã¨PHPã‚’å°Žå…¥ã—ã¦ã„ãªã„ç’°å¢ƒã§å›°ã‚‹ã®ã§ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã¨ã—ã¦æ›¸ãã¾ã—ãŸã€‚ get_max_clients.sh #!/bin/bash _PIDS=(`pgrep httpd`) _PROC_COUNT=${#_PIDS[@]} _MEMORY_T
harumaki_net 2013/10/09
apache

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
AWSç‰¹é›† ã®è¨˜äº‹ä¸€è¦§ | DevelopersIO
Amazon ãŒæ‰€æœ‰ã™ã‚‹ AWS Systems Manager ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®ä¸€è¦§ã‚’ AWS CLI ã§å–å¾—ã—ã¦çœºã‚ã¦ã¿ãŸ
harumaki_net 2013/09/26
åŠ©ã‹ã‚Šã¾ã™ï¼ï¼

AWS

ã¾ã¨ã‚

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
AWS News Blog
Amazon SageMaker Geospatial Capabilities Now Generally Available with Security Updates and More Use Case Samples At AWS re:Invent 2022, we previewed Amazon SageMaker geospatial capabilities, allowing data scientists and machine learning (ML) engineers to build, train, and deploy ML models using geospatial data. Geospatial ML with Amazon SageMaker supports access to readily available geospatial dat
harumaki_net 2013/06/14
ã“ã‚Œã¯é‡è¦ã€‚

AWS

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
ä»Šæ—¥ã‹ã‚‰æ¥å‹™ã§ä½¿ãˆã‚‹17ã®é‹ç”¨ç³»Linuxãƒ„ãƒ¼ãƒ«ã€ãã—ã¦å††ç’°ã®ç†
é‹ç”¨ç³»ãƒ„ãƒ¼ãƒ«ã®ã¤ã‚‚ã‚ŠãŒã€æ–°äººã•ã‚“ã«ä¼ãˆãŸã„ã€Œå††ç’°ã®ç†ã€è³‡æ–™ã«ãªã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ â€œqpstudy 2013.04â€ã® @zembutsu LT ç™ºè¡¨è³‡æ–™ã§ã™ ã€Žqpstudyï¼“å‘¨å¹´è¨˜å¿µLTå¤§ä¼šã€€ã€œæ–°äººã•ã‚“ã€æ¥ç•Œã«ã‚ˆã†ã“ãï¼ã€œ with ãƒ“ãƒ¼ãƒ«ã€ http://www.zusaar.com/event/613004ï¿½ å…±æœ‰ã—ãŸã‹ã£ãŸäº‹ ãƒ»2013å¹´ã€é€™ã„å¯„ã‚‹æ··æ²Œãƒ»ã‚¬ãƒ©ã‚±ãƒ¼ã¯è¡°é€€ã—ã¾ã—ãŸ ãƒ»åŸºæœ¬ã‚³ãƒžãƒ³ãƒ‰ã®é€£æºã¯å¿…é ˆ ãƒ»æ™‚ç³»åˆ—ãƒªã‚½ãƒ¼ã‚¹ç›£è¦–ãŒéµ ãƒ»ä»²é–“é”ã¨å”åŠ›ã™ã‚‹å¿ƒã‚‚å¤§åˆ‡Read less
harumaki_net 2013/04/15
ãƒã‚¿ã‚‚å«ã‚ã¦ã™ã°ã‚‰ã—ã„ã‚¹ãƒ©ã‚¤ãƒ‰ã€‚ã“ã‚“ãªãƒ—ãƒ¬ã‚¼ãƒ³ãŒã§ãã‚‹ã‚ˆã†ã«ç§ã¯ãªã‚ŠãŸã„ï½—

é‹ç”¨

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› - NAVER ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
harumaki_net 2013/02/27
PHP

MySQL

ã¾ã¨ã‚

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
æ£è¦è¡¨ç¾ã‚’ã‚ã‹ã‚Šã‚„ã™ãè¦–è¦šåŒ–ã—ã¦ãã‚Œã‚‹ã€ŽREGEXPERã€ | 100SHIKI
ãŠã£ã¨ã€ã“ã‚Œã¯ä¾¿åˆ©ã‹ã‚‚ã€‚ REGEXPERã‚’ä½¿ãˆã°ã€JavaScriptã®æ£è¦è¡¨ç¾ã‚’ã‚ã‹ã‚Šã‚„ã™ãè¡¨ç¾ã—ã¦ãã‚Œã‚‹ã€‚ ä¸€è¦‹ã€é›£è§£ãªæ£è¦è¡¨ç¾ã ãŒã€ã“ã‚Œã‚’é€šã—ã¦ã‚‚è¦‹ã‚‹ã¨ã€Œãªã‚‹ã»ã©ã€ã“ã®æ–‡å—ã¨ã“ã®æ–‡å—ã«ã¯ã•ã‚Œã¾ã‚Œã¦ã„ã¦ã€ã“ã®é–“ã¯ä½•ã®æ–‡å—ã§ã‚‚è‰¯ã„ã®ã ãªã€ã¨ã„ã£ãŸã“ã¨ãŒã‚ã‹ã‚‹ã‚ˆã†ã«ãªã‚‹ã€‚ ä»–ã®äººã®ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã„ã¦ã€Œï¼Ÿã€ã¨ãªã£ãŸã¨ãã«è©¦ã—ã¦ã¿ã¦ã‚‚ã„ã„ã‹ã‚‚ã§ã™ãªã€‚
harumaki_net 2013/01/04
ã™ã°ã‚‰ã—ã„ï¼

webã‚µãƒ¼ãƒ“ã‚¹

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¨"FLUSH TABLES WITH READ LOCK"ã«ã¤ã„ã¦ - jitsu102's blog
MySQLã§æ•´åˆæ€§ã®ã‚ã‚‹ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–å¾—ã™ã‚‹ã®ã«ã€ "FLUSH TABLES WITH READ LOCK"ã§ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å‡¦ç†(mysqldumpã‚„ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆ) "UNLOCK TABLES"ã§ãƒãƒƒã‚¯è§£é™¤ ã¿ãŸã„ãªã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å®Ÿè¡Œã—ã¦ã„ãŸãŒã€"FLUSH TABLES WITH READ LOCK"ã£ã¦å¿…ãšæ•°ãƒŸãƒªç§’ã¿ãŸã„ãªãƒ¬ãƒ™ãƒ«ã§ãƒãƒƒã‚¯ã§ãã‚‹ã®ã‹ãªã¨ç–‘å•ã«æ€ã£ãŸã€‚ çµæ§‹æ™‚é–“ã®ã‹ã‹ã‚‹ã‚¯ã‚¨ãƒªãŒå‡¦ç†ã•ã‚Œã¦ã„ãŸã‚Šã™ã‚‹ã¨ã€ã™ãã«ãƒãƒƒã‚¯ã§ããªã„ã‚“ã§ã¯ãªã„ã‹ã¨æ€ã£ãŸã€‚ ã¡ã‚‡ã£ã¨èª¿ã¹ã¦ã¿ã‚‹ã¨ã€ã‚„ã¯ã‚Šã™ãã«ãƒãƒƒã‚¯ã•ã‚Œãªã„å¯èƒ½æ€§ã‚‚ã‚ã‚‹ã‚ˆã†ã ã€‚*1 FLUSH TABLES WITH READ LOCKã®é€Ÿåº¦ã«ã¤ã„ã¦ ã¨ã„ã†ã“ã¨ã§ã€"FLUSH TABLES WITH READ LOCK"å¾Œã«ã€ä»¥ä¸‹ã®ã‚ˆã†ãªç¢ºèªå‡¦ç†ã‚’è¿½åŠ ã—ãŸã€‚ "SHOW PROCESSLIST"ã‚’å®Ÿè¡Œã—ã¦ã€"FLUS
harumaki_net 2012/08/24
mysql

ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
YOLP(åœ°å›³) - Yahoo!ãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯
Yahoo! Open Local Platformï¼ˆYOLPï¼‰ã¯ã€Yahoo!ãƒžãƒƒãƒ—ãŒãƒ‡ãƒ™ãƒãƒƒãƒ‘ãƒ¼å‘ã‘ã«æä¾›ã™ã‚‹åœ°å›³ãƒ»åœ°åŸŸæƒ…å ±ã®APIãƒ»SDKã§ã™ã€‚ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã®åˆ¶ä½œã¯ã‚‚ã¡ã‚ã‚“ã€ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³å‘ã‘ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºã«ãŠã„ã¦ã‚‚ã€å¤šå½©ãªåœ°å›³è¡¨ç¤ºã€åº—èˆ—ãƒ»æ–½è¨æ¤œç´¢ã€ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã€ãƒ«ãƒ¼ãƒˆæ¤œç´¢ã€æ¨™é«˜ãƒ‡ãƒ¼ã‚¿å–å¾—ãªã©ã®è±Šå¯Œãªæ©Ÿèƒ½ã‚’ã”æ´»ç”¨ã„ãŸã ã‘ã¾ã™ã€‚ ãŠçŸ¥ã‚‰ã› åœ°å›³ãƒ»åœ°åŸŸæƒ…å ±ã®æ¤œç´¢ Yahoo!ãƒãƒ¼ã‚«ãƒ«ã‚µãƒ¼ãƒAPI å…¨å›½ã®åº—èˆ—ã€ã‚¤ãƒ™ãƒ³ãƒˆã€ã‚¯ãƒã‚³ãƒŸæƒ…å ±ãªã©ã®åœ°åŸŸãƒ»æ‹ ç‚¹æƒ…å ±ã‚’æ¤œç´¢ã§ãã¾ã™ã€‚ Yahoo!ã‚¸ã‚ªã‚³ãƒ¼ãƒ€API ä½æ‰€ã‚’ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã¨ã—ã¦æ¤œç´¢ã—ã€ãã®ä½ç½®æƒ…å ±ã‚’æä¾›ã—ã¾ã™ã€‚ Yahoo!ãƒªãƒãƒ¼ã‚¹ã‚¸ã‚ªã‚³ãƒ¼ãƒ€API æŒ‡å®šã®åœ°ç‚¹ã®ä½æ‰€æƒ…å ±ã‚’å–å¾—ã™ã‚‹æ©Ÿèƒ½ã‚’æä¾›ã—ã¾ã™ã€‚ ãã®ä»–ã®ä¾¿åˆ©ãƒ„ãƒ¼ãƒ« æ°—è±¡æƒ…å ±API æŒ‡å®šã—ãŸç·¯åº¦çµŒåº¦ã®é™æ°´å¼·åº¦å®Ÿæ¸¬å€¤ã¨äºˆæ¸¬å€¤ã‚’å–å¾—ã§ãã¾ã™ã€‚ éƒµä¾¿ç•ªå·æ¤œç´¢API éƒµä¾¿ç•ªå·ã‚’æŒ‡å®šã—ã¦ã€ä½ç½®
harumaki_net 2012/08/10
API

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
SQLã§å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’ä¸€æ°—ã«ä½œã‚‹ã§ã”ã–ã‚‹(MySQLç·¨) @ t100ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è„±å‡ºä½œæˆ¦
è‡ªåˆ†ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è„³ã‚’ãƒ—ãƒã‚°ãƒ©ãƒ ã«ã—ã¦ã€ã„ã¤ã‹ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‹ã‚‰è„±å‡ºã—ã¦ã‚„ã‚‹ãžã£ï¼ã¨ã‹å¤¢è¦‹ãªãŒã‚‰ã€æ—¥ã€…ãƒ—ãƒã‚°ãƒ©ãƒ ä½œã£ã¦ã„ã ç™¾é‡Ž è²´åš ã®æ—¥è¨˜ã§ã™ï¼ä»Šã¯ã€å±‹å·ã€Žç™¾è”µã€‚ã€ã¨ã—ã¦ã€Silverlightãƒ»WPFã‚’è¿½è·¡ä¸ã§ã™ï¼ (2007/09/30) é–‹ç™ºã‚’ã—ã¦ã„ã¦ã€å¤§é‡ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ãŒæ¬²ã—ã„ãªãƒ¼ã¨ã„ã†ã“ã¨ãŒæ™‚ã€…ã‚ã‚Šã¾ã™ã€‚ å…ˆæ—¥ã®ã€ã€ŒMySQLã® using temporary; using filesort ãŒä½•æ•…é…ã„ã®ã‹ã€ã®å†…å®¹ã‚‚ã€å®Ÿéš›ã«æ¤œè¨¼ã—ã¦ã¿ã‚‹ã«ã¯ã€sort_buffer_size ã‚’è¶…ãˆã‚‹é‡ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ ã—ã‹ã—ã€ã“ã‚ŒãŒæ„å¤–ã¨é¢å€’ãã•ã„ã£ ä½¿ã„æ…£ã‚ŒãŸã‚¹ã‚¯ãƒªãƒ—ãƒˆè¨€èªžã§ã€ãƒãƒ§ãƒãƒ§ã‚¤ã¨ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ãã®ã‚‚OKãªã®ã§ã™ãŒã€ã§ã‚‚ã‚„ã£ã±ã‚Šé¢å€’ãã•ã„ã£ ï¼ˆã§ã™ã‚ˆãï¼Ÿï¼‰ ã¨ã„ã†ã“ã¨ã§ã€ä»Šå›žã¯SQLã ã‘ã§å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’ä½œã‚‹æ–¹æ³•ã‚’è€ƒãˆã¦è¦‹ã¾ã™ã€‚ ã¨ã„ã£ã¦ã‚‚ã€ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã§ãƒ«ãƒ¼ãƒ—ã¨
harumaki_net 2012/08/03
MySQL

ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
ã‚¯ãƒªã‚¢ãƒã‚ªã®å£ã‚³ãƒŸã£ã¦ä¿¡ã˜ã¦ã„ã„ï¼ŸåŠ¹æžœã¯ç¢ºå®Ÿãªã®ï¼Ÿ | æ„›ã¨å°ç”º
ã‚¯ãƒªã‚¢ãƒã‚ªã®ç‰¹å¾´ ç„¡æ·»åŠ ãƒ»ç„¡ç€è‰²ã ã‹ã‚‰è‚ŒãŒå¼±ã„äººã§ã‚‚å®‰å¿ƒ ãƒ¯ã‚ã‚¬ã‚„å«Œãªè‡ã„ã®åŽŸå› ã¨ãªã‚‹èŒã‚’æ®ºèŒãƒ»æ¶ˆæ¯’ ãŠå¾—ãªå®šæœŸã‚³ãƒ¼ã‚¹ã¯ã€è³¼å…¥ç¸›ã‚Šãªã—ï¼ã„ã¤ã§ã‚‚è§£ç´„å¯èƒ½ ä½“è‡ã®æ‚©ã¿ã¯è€è‹¥ç”·å¥³å•ã‚ãšå…±é€šã®æ‚©ã¿ã§ã™ãŒã€ä»–äººã«ã¯ç›¸è«‡ã—ã«ãã„ã®ã§1äººã§æ‚©ã‚“ã§ã„ã‚‹äººãŒå¤šã„ã‚“ã§ã™ã€‚ ä½“è‡ã£ã¦ã€è‡ªåˆ†ã§ãƒ‹ã‚ªã‚¤ãŒæ°—ã«ãªã£ãŸæ™‚ã¯ã€ä»–ã®äººã¯ã‚‚ã£ã¨ã‚¯ã‚µã‚¤ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã‚‚ã—ã‚ãªãŸãŒã€è‡ªåˆ†ã§ãƒ¯ã‚ã‚¬ã‹ã‚‚â€¦ã¨æ€ã†ã®ã§ã‚ã‚Œã°ã€å‘¨ã‚Šã®äººã¯ã‚ãªãŸã®ãƒ‹ã‚ªã‚¤ã«æ°—ã¥ã„ã¦ã„ã‚‹ã‹ã‚‚â€¦ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã€ãã‚“ãªãƒ¯ã‚ã‚¬è‡ã‚„è¶³ã®ãƒ‹ã‚ªã‚¤ãªã©ã€ã‚¤ãƒ¤ãƒ¼ãªä½“è‡å…¨èˆ¬ã‚’10ç§’ã§ã‚«ãƒƒãƒˆã—ã¦ãã‚Œã‚‹ã‚“ã§ã™ã€‚ ã‚¯ãƒªã‚¢ãƒã‚ªã®åŠ¹æžœã‚„å£ã‚³ãƒŸã‚’èª¿æŸ»ã—ã¾ã—ãŸã®ã§å¾¹åº•è§£èª¬ã—ã¾ã™ã€‚ è³¼å…¥æ™‚ã«ç‰¹å…¸ãŒä»˜ã„ã¦ãã‚‹ã®ã§ãŠå¾— å…¬å¼ã‚µã‚¤ãƒˆã¯ã‚³ãƒãƒ© â€»ç‰¹å…¸ã¯æ¯Žæœˆå¤‰ã‚ã‚‹ã®ã§å…¬å¼ã‚µã‚¤ãƒˆã§ã”ç¢ºèªãã ã•ã„ ã‚¯ãƒªã‚¢ãƒã‚ªã¯ã©ã‚“ãªäººã«ãŠã™ã™ã‚ï¼Ÿ ã‚¯ãƒªã‚¢ãƒã‚ªã®æ®ºèŒçŽ‡ã¯ã€ãªã‚“ã¨99.999%ï¼ä½“è‡ã®æ‚©ã¿ã‚’è§£æ¶ˆã—ã¦ãã‚Œã‚‹ã‚¯ãƒª
harumaki_net 2012/07/24
ãªã‚“ã¨ã„ã†ã‹ã€ã¾ã¨ã‚ã®æ®¿å ‚ã«ã—ãŸã„ã€‚

MySQL

ã¾ã¨ã‚

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
æ¼¢(ã‚ªãƒˆã‚³)ã®ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿é“: MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•
ã¡ã‚‡ã£ã¨ã‚ãƒ£ãƒƒãƒâˆ’ãªã‚¿ã‚¤ãƒˆãƒ«ã‚’ã¤ã‘ã¦ã—ã¾ã£ãŸãŒã€ä»Šæ—¥ã¯ç‹¬æ–ã¨åè¦‹ã§MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹æ–¹æ³•ã‚’10å€‹ç´¹ä»‹ã—ã‚ˆã†ã€‚MySQLã‚µãƒ¼ãƒã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã¨ãã‚„åˆæœŸå°Žå…¥ã™ã‚‹å ´åˆãªã©ã«å‚è€ƒã«ã—ã¦ã‚‚ã‚‰ã„ãŸã„ã€‚ 1. ãƒãƒƒãƒ•ã‚¡ã‚’å¢—ã‚„ã™ã€ã¾ãŸã¯æ¸›ã‚‰ã™ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºæœ¬ä¸ã®åŸºæœ¬ã§ã‚ã‚‹ãŒã€é©åˆ‡ãªãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚ºã‚’è¨å®šã™ã‚‹ã“ã¨ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦ã§ã‚ã‚‹ã€‚ä¸»ãªãƒãƒƒãƒ•ã‚¡ã¯æ¬¡ã®é€šã‚Šã€‚ innodb_buffer_pool_sizeãƒ»ãƒ»ãƒ»InnoDBã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ç©ºããƒ¡ãƒ¢ãƒªã®7ã€œ8å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹æœ€ã‚‚é‡è¦ãªãƒãƒƒãƒ•ã‚¡ã§ã‚ã‚‹ã€‚ä½™è«‡ã ãŒã€å®Ÿéš›ã«ã¯ã“ã“ã§å‰²ã‚Šå½“ã¦ãŸå€¤ã®5ã€œ10%ãã‚‰ã„ã‚’å¤šã‚ã«ãƒ¡ãƒ¢ãƒªã‚’ä½¿ã†ã®ã§æ³¨æ„ãŒå¿…è¦ã ã€‚ key_buffer_sizeãƒ»ãƒ»ãƒ»MyISAMã ã‘ã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€ç©ºããƒ¡ãƒ¢ãƒªã®3å‰²ç¨‹åº¦ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã„ã„ã€‚æ®‹ã‚Šã¯ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ç”¨ã«æ®‹ã—ã¦ãŠã“ã†ã€‚ sort_buffer_
harumaki_net 2012/06/21
MySQL

é«˜é€ŸåŒ–

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
JdbcRunner - æ±Žç”¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«
https://dbstudy.info/jdbcrunner/ ã«ç§»è»¢ã—ã¾ã—ãŸã€‚ ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ã«æˆ»ã‚‹ Overview JdbcRunnerã¯å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¯¾è±¡ã¨ã—ãŸè² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’å®šç¾©ã—ã¦å¤šé‡å®Ÿè¡Œã—ã€ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã¨ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚¿ã‚¤ãƒ ã‚’æ¸¬å®šã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã¾ãŸã€JdbcRunnerã«ã¯Oracleã€MySQLã€PostgreSQLã‚’å¯¾è±¡ã¨ã—ãŸä»¥ä¸‹ã®ãƒ†ã‚¹ãƒˆã‚ãƒƒãƒˆãŒä»˜å±žã—ã¦ãŠã‚Šã€ ãƒ¦ãƒ¼ã‚¶ãŒç‹¬è‡ªã«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½œæˆã™ã‚‹ä»¥å¤–ã«ã€ã“ã‚Œã‚‰ã‚’ç”¨ã„ãŸè² è·ãƒ†ã‚¹ãƒˆã‚’è¡Œã†ã“ã¨ã‚‚å¯èƒ½ã¨ãªã£ã¦ã„ã¾ã™ã€‚ Tiny SysBench - SysBench OLTPãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®ç§»æ¤ç‰ˆ Tiny TPC-B - TPC-Bã®ç°¡æ˜“å®Ÿè£… Tiny TPC-C - TPC-Cã®ç°¡æ˜“å®Ÿè£… Download JdbcRunnerã¯ã€Vectorã‚½ãƒ•ãƒˆãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚
harumaki_net 2012/06/19
MySQL

ã‚ã¨ã§èªã‚€

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
harumaki_net 2012/06/18
linux

ã‚µãƒ¼ãƒç®¡ç†

ã“ã‚Œã¯ã™ã”ã„

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
SSHåŠ›ã‚’ã¤ã‘ã‚ˆã†
2. ã‚‚ãã˜ â–º ãŠã•ã‚‰ã„ â–º ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ(ssh/scp)ã®è©± ãƒãƒ¼ãƒˆè»¢é€ã®è©± å¤šæ®µssh ãã®ä»–ã®è»¢é€ã®è©±ãƒ»ä»–ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ â–º ã‚µãƒ¼ãƒ(sshd)ã®è©± â–º ã¡ã‚‡ã£ã¨ã—ãŸç–‘å• â–º ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®è©± â–º ã¾ã¨ã‚ 2 / 62 5. RFC RFC 4250 The Secure Shell (SSH) Protocol Assigned Numbers RFC 4251 The Secure Shell (SSH) Protocol Architecture RFC 4252 The Secure Shell (SSH) Authentication Protocol RFC 4253 The Secure Shell (SSH) Transport Layer Protocol RFC 4254 The Secure Shell (SSH) Connection Protocol RF
harumaki_net 2012/05/30
ãªã‚“ã¨ã„ã†ã‹ã€1ã‹ã‚‰å‡ºç›´ã—ã¦SSHåŠ›ã‚’é›ãˆã¾ã™ã€‚

SSH

Linux

ãŠå½¹ç«‹ã¡

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
Muninã®ã‚°ãƒ©ãƒ•ã‚’CGIãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ç”Ÿæˆã—ã¦è² è·è»½æ¸›ã™ã‚‹æ–¹æ³•(munin-cgi-graph) | Pocketstudio.jp log3
munin-cgi-graph ã®å°Žå…¥æ–¹æ³•ã‚’ã¾ã¨ã‚ã¾ã—ãŸã€‚ â—†ç®¡ç†å°æ•°ãŒå¢—ãˆãŸã‚‰ã€ã‚°ãƒ©ãƒ•ã®å‹•çš„ç”Ÿæˆã§è² è·è»½æ¸› æ±Žç”¨ãƒªã‚½ãƒ¼ã‚¹ãƒ»ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã® Munin ã€‚ç›£è¦–å¯¾è±¡ãƒŽãƒ¼ãƒ‰ã‚’å¢—ã‚„ã—ã¦ã„ãã¨çªãå½“ãŸã‚‹ã®ãŒã€è² è·å¯¾ç–ã§ã™ã€‚Munin ã¯å„ç¨®ã®ãƒªã‚½ãƒ¼ã‚¹ã‚’ã‚°ãƒ©ãƒ•ã§è¡¨ç¤ºã™ã‚‹ç‚ºã«ã€5åˆ†ã«1å›žç”»åƒã‚’ç”Ÿæˆã—ã¾ã™ã€‚ç®¡ç†å°æ•°ãŒ1å°ã§ã‚ã‚Œã°ã€1åº¦ã«ç”Ÿæˆã•ã‚Œã‚‹ç”»åƒã¯ç´„40ç¨‹åº¦ã§ã™ï¼ˆæ¨™æº–çš„ãªRHELã§è‡ªå‹•èªè˜ã•ã‚Œã‚‹ãƒ—ãƒ©ã‚°ã‚¤ãƒ³æ•°ã€ã‹ã¤ã€â€™by dayâ€™ ã®ã¿ã€‚å®Ÿéš›ã«ã¯ã€â€™by weekâ€™ â€˜by monthâ€™ â€˜by yearâ€™ã®ç”»åƒç”Ÿæˆã‚‚é‡ãªã‚‹ã¨ã€å€ã®ç”»åƒã‚’ç”Ÿæˆã™ã‚‹äº‹ã«ãªã‚Šã¾ã™ï¼‰ã€‚ Munin ç®¡ç†ãƒŽãƒ¼ãƒ‰ãŒï¼‘å°ã§ã‚ã‚Œã°ã€40å€‹ã® PNG å½¢å¼ã®ç”»åƒï¼ˆã‚°ãƒ©ãƒ•ï¼‰ã‚’ç”Ÿæˆã™ã‚‹ã“ã¨ã¯ã€ä»Šæ—¥æ—¥ã•ã»ã©ã‚µãƒ¼ãƒãƒ»ãƒžã‚·ãƒ³ã®è² è·ã«ã¯ãªã‚Šã¾ã›ã‚“ã€‚ã§ã™ãŒã€ç®¡ç†å¯¾è±¡ãŒ10å°ã«ãªã‚Œã°ã€1åº¦ã«ç”Ÿæˆã•ã‚Œã‚‹ã‚°ãƒ©ãƒ•ã¯ç´„400å€‹ã€‚100ã§ã‚ã‚Œã°ã€ç´„40
harumaki_net 2012/03/21
ã‚µãƒ¼ãƒ

ã‚¤ãƒ³ãƒ•ãƒ©

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
Node.js ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ« | Node ãƒ“ã‚®ãƒŠãƒ¼ã‚ºãƒ–ãƒƒã‚¯
æœ¬æ›¸ã«ã¤ã„ã¦ æœ¬æ›¸ã¯ã€Node.jsã§ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºã‚’å§‹ã‚ã‚ˆã†ã¨ã™ã‚‹çš†ã•ã‚“ã«ã€ â€é«˜åº¦ãªâ€JavaScriptã«ã¤ã„ã¦çŸ¥ã‚‹ã¹ãã‚ã‚‰ã‚†ã‚‹ã“ã¨ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã‚ˆãã‚ã‚‹â€Hello Worldâ€ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã®ã€ã¯ã‚‹ã‹ä¸Šã‚’ã„ãã‚‚ã®ã§ã™ã€‚ ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ è²´æ–¹ãŒèªã‚“ã§ã„ã‚‹ã®ã¯ã€æœ¬æ›¸ã®ã„ã‚ã‚†ã‚‹æœ€çµ‚ç‰ˆã¨ãªã‚Šã¾ã™ã€‚ ã¤ã¾ã‚Šæœ¬æ›¸ã¯ã€é–“é•ã„ãŒè¦‹ã¤ã‹ã£ãŸå ´åˆã‚„ã€ Node.jsã®æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ãŠãˆã‚‹å¤‰æ›´ç‚¹ã‚’åæ˜ ã™ã‚‹æ™‚ã®ã¿ã€æ”¹è¨‚ã•ã‚Œã¾ã™ã€‚ æœ€çµ‚æ›´æ–°æ—¥ã¯2012å¹´2æœˆ12æ—¥ã§ã™ã€‚ æœ¬æ›¸å†…ã®ã‚³ãƒ¼ãƒ‰ã®ã‚µãƒ³ãƒ—ãƒ«ã¯ã€Node.jsã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³0.6.10ã§ãƒ†ã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ ã‚¿ãƒ¼ã‚²ãƒƒãƒˆèªè€… æœ¬æ›¸ã¯ã€Rubyã€Pythonã€PHPã€Javaã®ã‚ˆã†ãªã€å°‘ãªãã¨ã‚‚ã²ã¨ã¤ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘è¨€èªžã‚’ç†è§£ã—ã¦ãŠã‚Šã€ JavaScriptã«ã¤ã„ã¦ã¯ã‚ã¾ã‚ŠçµŒé¨“ãŒãªãã€Node.jsã«ã¤ã„ã¦ã¯å…¨ãçµŒé¨“ãŒãªã„ã¨ã„ã†ã€ è‘—è€…ã¨åŒã˜ã‚ˆã†ãªãƒãƒƒ
harumaki_net 2012/03/10
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

*ãŠå½¹ç«‹ã¡

ã‚ã¨ã§èªã‚€

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
ã€è¨˜äº‹ç´¹ä»‹ã€‘ã€Ž100å††ã‚·ãƒ§ãƒƒãƒ—ã€ã§ã„ã„ã‚“ã§ã™ï¼æ ¼å®‰åŽç´ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
harumaki_net 2012/02/12
ç”Ÿæ´»

ãŠå½¹ç«‹ã¡

ã¾ã¨ã‚

ã‚ã‚ŠãŒã¨ã†
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸