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

hiboma id:hiboma

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

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

MySQLã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã«é–¢ã™ã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°Tips | Yakst
MySQLãŒç¢ºä¿ã™ã‚‹å„ç¨®ãƒ¡ãƒ¢ãƒªã«é–¢ã™ã‚‹ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®æ¦‚è¦ã‹ã‚‰ã€ãã‚Œã‚‰ãŒã©ã®ã‚ˆã†ã«å‰²ã‚Šå½“ã¦ã‚‰ã‚Œã‚‹ã®ã‹ã‚’çŸ¥ã‚‹ãŸã‚ã®æ§˜ã€…ãªæ‰‹æ³•ã¾ã§ã€Perconaã®ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒè©³ã—ãè§£èª¬ã™ã‚‹ã€‚ January 24, 2014 By Nilnandan Joshi ã€ŒMySQLã‚µãƒ¼ãƒã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã€ã«é–¢é€£ã™ã‚‹ãƒˆãƒ”ãƒƒã‚¯ã‚¹ã‚’æ›¸ã„ãŸãƒ–ãƒã‚°è¨˜äº‹ã¯æ—¢ã«ãŸãã•ã‚“ã‚ã‚‹ã«ã‚‚é–¢ã‚ã‚‰ãšã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢é€£ã®å•é¡Œã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã§æ··ä¹±ã—ãªã‹ã£ãŸäººã¯ã„ãªã„ã ã‚ã†ã€‚Perconaã‚µãƒãƒ¼ãƒˆã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ã€é«˜è² è·ã®ã‚µãƒ¼ãƒã«é–¢ã™ã‚‹ã“ã¨ã‚„ã€ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡é«˜é¨°ã§OOM killerãŒç™ºå‹•ã—ã¦MySQLã‚µãƒ¼ãƒãŒåœæ¢ã—ãŸã“ã¨ã€ã‚ã‚‹ã„ã¯ã€ŒMySQLãŒã©ã†ã—ã¦ã“ã‚“ãªã«ãƒ¡ãƒ¢ãƒªã‚’é£Ÿã†ã®ã‹åˆ†ã‹ã‚‰ãªã„ã€‚ã©ã†ã‚„ã£ãŸã‚‰ä½•ã«ãƒ¡ãƒ¢ãƒªãŒä½¿ã‚ã‚Œã¦ã‚‹ã‹åˆ†ã‹ã‚‹ã‚“ã ï¼ŸåŠ©ã‘ã¦ãã‚Œï¼ã€ã¨è¨€ã£ãŸå•é¡Œã‚’æ•°å¤šãè¦‹ã¦ã„ã‚‹ã€‚ MySQLã®ãƒ¡ãƒ¢ãƒªä½¿ç”¨é‡ã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚‹æ–¹æ³•ã¯ãŸã
hiboma 2014/01/30
mysql

yonda
ãƒªãƒ³ã‚¯
æœ€è¿‘ã®CPUã§ã¯ä¹±æ•°ç”ŸæˆãŒã¯ã‚„ã„è©±
Ivy Bridgeä»¥é™ã®CPUã§ã¯CPUå†…ã«ä¹±æ•°ç”Ÿæˆå™¨ãŒå«ã¾ã‚Œã¦ã„ã¾ã™ã€‚ãã‚Œã«å¯¾å¿œã—ãŸæœ€è¿‘ã®rngdã‚’ã¤ã‹ã†ã¨ãã‚Œãªã‚Šã«ä¹±æ•°ç”ŸæˆãŒé€Ÿãã¦ã—ã‚ã‚ã›ã«ãªã‚Œã¾ã™ã€‚ linuxã§ã¯ä¹±æ•°ã‚’å–å¾—ã™ã‚‹ãŸã‚ã« /dev/random ã¨ /dev/urandom ã®2ç¨®é¡žã®ãƒ‡ãƒã‚¤ã‚¹ãŒã‚ã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œã®èª¬æ˜Žã¯ man 4 random ã«ã¿ã£ã¡ã‚Šæ›¸ã„ã¦ã‚ã‚Šã¾ã™ãŒã€ã‹ã„ã¤ã¾ã‚“ã§è¨€ã†ã¨: random: ã‚«ãƒ¼ãƒãƒ«ãŒã‚ã¤ã‚ã¦ããŸãƒŽã‚¤ã‚ºã‚’å…ƒã«å“è³ªã®é«˜ã„ç–‘ä¼¼ä¹±æ•°ã‚’ç”Ÿæˆã—ã¾ã™ã€‚ãƒŽã‚¤ã‚ºãŒä¸è¶³ã™ã‚‹ã¨blockã—ã¾ã™ã€‚ urandom: ã‚«ãƒ¼ãƒãƒ«ãŒã‚ã¤ã‚ã¦ããŸãƒŽã‚¤ã‚ºã‚’å…ƒã«ãã“ãã“ã®å“è³ªã®ç–‘ä¼¼ä¹±æ•°ã‚’ç”Ÿæˆã—ã¾ã™ã€‚å“è³ªã¯ãã“ãã“ã§ã™ãŒblockã—ãªã„ã®ã§é€Ÿã„ã§ã™ã€‚ ãŸã‚ã—ã«cat /dev/random ã¨ã‹ã™ã‚‹ã¨1kã¨ã‹4kãã‚‰ã„ä¹±æ•°ãŒå‡ºåŠ›ã•ã‚Œã¦æ¢ã¾ã£ã¦ã—ã¾ã†ã€‚ã“ã‚Œã§ã¯å‰²ã¨è¶³ã‚Šãªã„ã®ã§é¸æŠžè‚¢ãŒ2ç¨®é¡žã€‚1ï¼‰ å“è³ªã‚’ã‚ãã‚‰ã‚ã¦u
hiboma 2013/12/11
cpu

yonda
ãƒªãƒ³ã‚¯
æ¥½ã—ã„ãƒˆãƒ³ãƒãƒ«ã®æŽ˜ã‚Šæ–¹(ã‚ªãƒ—ã‚·ãƒ§ãƒ³: -L, -R, -f, -N -g)
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ï¼ KMC ã®é”æ³•å°‘å¥³nona7(nonamea774) ã§ã™. æœ€è¿‘ã¯ã‚¯ãƒƒã‚ãƒ¼ã‚’å¢—ã‚„ã—ã¦éŽã”ã—ã¦ã„ã¾ã™. ã“ã®è¨˜äº‹ã¯KMCã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼2013ã®9æ—¥ç›®ã®è¨˜äº‹ã§ã™. æ˜¨æ—¥ã®è¨˜äº‹ã¯possumã•ã‚“ã®æŒ‡ç´‹ã®è©±ã§ã—ãŸ. ã•ã‚‰ã«ã“ã®è¨˜äº‹ã¯, KMCã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼2013ã®ã‚µãƒ–ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã§ã‚ã‚‹SSHã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼2013ã®2æ—¥ç›®ã®è¨˜äº‹ã§ã‚‚ã‚ã‚Šã¾ã™. æ—¥é ƒSSHã«è¦ªã—ã‚“ã§ã„ã‚‹éƒ¨å“¡ã«ã‚ˆã‚‹ã€SSHã®åŸºç¤ŽçŸ¥è˜ã€ãƒ„ãƒ¼ãƒ«ã€Tipsç‰ã‚’ç´¹ä»‹ã—ã¦å‚ã‚Šã¾ã™ã®ã§ã€åˆå¿ƒè€…ã®æ–¹ã‹ã‚‰ä¸Šç´šè€…ã®æ–¹ã¾ã§ã”ç¬‘è¦§ã„ãŸã ã‘ã‚Œã°å¹¸ã„ã§ã™. KMCã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼9æ—¥ç›®, SSHã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼2æ—¥ç›®ã®ä»Šå›žã¯, æ¥½ã—ã„ãƒˆãƒ³ãƒãƒ«ã®æŽ˜ã‚Šæ–¹ã«ã¤ã„ã¦ã®ãŠè©±ã‚’ã—ã¾ã™. ãƒˆãƒ³ãƒãƒ«æŽ˜ã£ã¦ã‚ã£ã¡ã“ã£ã¡(Lã‚ªãƒ—ã‚·ãƒ§ãƒ³) ä¾‹ãˆã° ã®ã‚ˆã†ãª, ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆå´ã‹ã‚‰ã¯SSH ã‚µãƒ¼ãƒã—ã‹è¦‹ãˆãªã, SSH ã‚µ
hiboma 2013/12/10
ssh

yonda
ãƒªãƒ³ã‚¯
ZendOpcacheã¨APCuã§ã¯ã˜ã‚ã‚‹ãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹PHP - pixiv engineering blog
å…ˆæœˆæœ«ã‹ã‚‰ä¸€é€±é–“ã»ã©æ—…ã«å‡ºã¦ã„ãŸbokkoã§ã™ã€‚ä»Šå›žã¯pixivã§ã®PHPã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã«é–¢ã™ã‚‹å–ã‚Šçµ„ã¿ã®ä¸€éƒ¨ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ pixivã¨PHP pixivã§ã¯Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºã§ä¸»ã«PHPã‚’åˆ©ç”¨ã—ã¦ãŠã‚Šã€ä»Šã®ã¨ã“ã‚PHP5.3ã¨PHP5.4ã§å‹•ã„ã¦ã„ã‚‹ç’°å¢ƒãŒæ··åœ¨ã—ã¦ã„ã‚‹çŠ¶æ…‹ã§ã™ãŒã€ã“ã‚Œã‚’PHP5.5åŒ–ã™ã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆãŒé€²è¡Œä¸ã§ã™ã€‚ ã‚ªãƒšã‚³ãƒ¼ãƒ‰ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ãƒ¦ãƒ¼ã‚¶ã‚ãƒ£ãƒƒã‚·ãƒ¥ã«ã‚ˆã‚‹PHPã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é«˜é€ŸåŒ– pixivã®ã‚ˆã†ãªPVã®å¤šã„Webã‚µã‚¤ãƒˆ(2013å¹´10æœˆç¾åœ¨ã§38å„„/æœˆ)ã‚’PHPã§é‹ç”¨ã™ã‚‹å ´åˆã€ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã„ã†è¦³ç‚¹ã§ã¯ã‚‚ã¡ã‚ã‚“ã®ã“ã¨ã€é‹ç”¨ã«ã‹ã‹ã‚‹ã‚³ã‚¹ãƒˆã®é¢ã§ã‚‚ APCã‚„ZendOpcacheãŒæä¾›ã—ã¦ã„ã‚‹ã‚ˆã†ãªã‚ªãƒšã‚³ãƒ¼ãƒ‰ã‚ãƒ£ãƒƒã‚·ãƒ¥æ©Ÿèƒ½ã¯å¿…é ˆã¨è¨€ãˆã¾ã™ã€‚ ã‚µãƒ¼ãƒã‚¹ãƒšãƒƒã‚¯ãŒé«˜ã„ãƒžã‚·ãƒ³(CPUã‚³ã‚¢æ•°ãŒ16ã¨ã‹24)ã‚’ä½¿ã£ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã‚‚ã‚ã‚Šã¾ã™
hiboma 2013/10/23
php

yonda
ãƒªãƒ³ã‚¯
FAQ: InnoDB extended secondary keys
MySQL 5.6 introduced a new feature called extended secondary keys. We get a lot of questions about it and find that most of them come from a few incorrect assumption. In this post I'll try to get rid of the confusion once and for all. Famous last words... here goes: Q1: Do I need to do anything to enable extended secondary keys? No, nothing at all. It's on by default and I can't see any sensible r
hiboma 2013/10/23
mysql

yonda
ãƒªãƒ³ã‚¯
Island Life - mmap
About å—ã®å³¶ã®ãƒ—ãƒã‚°ãƒ©ãƒžã€‚ ãŸã¾ã«å½¹è€…ã€‚ Practical Schemeã®ä¸»ã€‚ WiLiKi:Shiro æœ€è¿‘ã®ã‚¨ãƒ³ãƒˆãƒª ç±³å›½ã®å¤§å¦é€²å¦ç„¡é™cxré«˜æ ¡å—é¨“DefenseæŒ¯ã‚Šè¿”ã£ã¦ã¿ã‚‹ã¨2019å¹´ã¯è‰²ã€…å¦ã‚“ã§æ¥½...è¦šãˆã‚‹ã‚ˆã‚Šå¿˜ã‚Œã‚‹æ–¹ãŒé›£ã—ã„(ã“ã¨ã‚‚ã‚ã‚‹)çœ¼é¡ã®ã¤ã‚‹ã¨3Dãƒ—ãƒªãƒ³ã‚¿Iris Klein Acting ClassSAG-AFTRA conservatory: Voice Actingå‰µä½œæ´»å‹•ã£ã¦è‡ªåˆ†ã‚’æ™’ã‘å‡ºã•ãã°ãªã‚‰ãªã„ã¨...More... æœ€è¿‘ã®ã‚³ãƒ¡ãƒ³ãƒˆ Emma SugarRush on CLtL2 (2024/12/25)shiro on æ³ã‚’å–ã‚‹ã¨æ™‚é–“ãŒé€ŸãéŽãŽã‚‹ã®ã¯ã€æ–°ã—ã„ã“ã¨ã«æŒ‘æˆ¦ã—ãªã„ã‹ã‚‰? (2023/03/14)1357 on æ³ã‚’å–ã‚‹ã¨æ™‚é–“ãŒé€ŸãéŽãŽã‚‹ã®ã¯ã€æ–°ã—ã„ã“ã¨ã«æŒ‘æˆ¦ã—ãªã„ã‹ã‚‰? (2023/03/01)ãƒ™ã‚¢ãƒˆãƒªãƒ¼ãƒã‚§ on ãƒã‚¤ãƒãƒã‚¤ãƒãƒã‚¤ãƒ
hiboma 2013/10/11
yonda
ãƒªãƒ³ã‚¯
ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®åœ§ç¸®æ–¹æ³•
åœ§ç¸®ãƒ¬ãƒ™ãƒ«2ã¨3ã§ã¯ã€bzip2ã‚ˆã‚Šãšã£ã¨çŸã„æ‰€è¦æ™‚é–“ã§é«˜ã„åœ§ç¸®çŽ‡ãŒå¾—ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚èˆˆå‘³æ·±ã„ã®ã¯ãƒ¬ãƒ™ãƒ«4ã§ã€æ‰€è¦æ™‚é–“ãŒå¤§ããå¢—ãˆãŸã®ã«åœ§ç¸®çŽ‡ãŒä¸‹ãŒã£ã¦ã„ã¾ã™ã€‚xzã¯ãƒ¬ãƒ™ãƒ«4ã‹ã‚‰LZæ³•ã®ä¸€è‡´æ–‡å—åˆ—ã‚’æŽ¢ã™ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ãŒå¤‰ã‚ã‚‹ã®ã§ã€ã“ã‚ŒãŒè£ç›®ã«å‡ºã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ bzip2ã‚ˆã‚Š2å‰²ä»¥ä¸Šé«˜ã„åœ§ç¸®çŽ‡ãŒå¾—ã‚‰ã‚Œã‚‹ãƒ¬ãƒ™ãƒ«7ä»¥ä¸Šã§ã¯ã€æ‰€è¦æ™‚é–“ã¯5å€ä»¥ä¸Šã«ãªã‚Šã¾ã™ã€‚ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã®åœ§ç¸®æ–¹å¼ãŒæ··ã–ã‚‹ã®ã¯ä½•ã‹ã¨é¢å€’ãªã®ã§ã€5å€ã®æ‰€è¦æ™‚é–“ã§ã“ã®ç¨‹åº¦ã®åœ§ç¸®çŽ‡ã®å·®ã§ã¯xzã«å¤‰æ›´ã™ã‚‹æ°—ã«ã¯ãªã‚Œãªã„ã§ã™ã€‚ åœ§ç¸®çŽ‡ã¯ãã†ã§ã‚‚ãªã„ã§ã™ãŒã€xzã®ä¼¸å¼µé€Ÿåº¦ã®é€Ÿã•ã¯ã¨ã¦ã‚‚é…åŠ›çš„ã§ã™ã€‚ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®åœ§ç¸®çŽ‡ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä¼¸å¼µã™ã‚‹ã®ã«ã€bzip2ãŒ1åˆ†22ç§’ã‹ã‹ã‚‹ã®ã«å¯¾ã—ã¦xzã¯25ç§’ã—ã‹æŽ›ã‹ã‚Šã¾ã›ã‚“ã€‚ãƒã‚°ã‚’é›†è¨ˆã™ã‚‹ã¨ãã«ä¼¸å¼µé€Ÿåº¦ãŒ3å€è¿‘ãé€Ÿã„ã®ã¯ã¨ã¦ã‚‚æœ‰åˆ©ã§ã™ã€‚ ã‚‚ã—åœ§ç¸®æ–¹æ³•ã‚’æ±ºã‚ç›´ã›ã‚‹ãªã‚‰xzã«ã™ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚é©å®œãƒ¬ãƒ™ãƒ«ã‚’èª¿ç¯€ã—ã¦bzi
hiboma 2013/10/11
yonda
ãƒªãƒ³ã‚¯
MySQL 5.6ã«ãŠã‘ã‚‹å¤§é‡ãƒ‡ãƒ¼ã‚¿ãƒãƒ¼ãƒ‰æ™‚ã®è€ƒæ…®ç‚¹ - SH2ã®æ—¥è¨˜
ã”ç¸ãŒã‚ã£ã¦AWS User Group - Japanã«ãŠèª˜ã„ã„ãŸã ãã€10æœˆ4æ—¥ã«ç¬¬18å›ž AWS User Group - Japan æ±äº¬å‹‰å¼·ä¼šã§ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é‹å–¶ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€Œç§‹ã®DBç¥ã‚Šã€ã¨ã„ã†ã“ã¨ã§ã€MySQLã«é™ã‚‰ãšã•ã¾ã–ã¾ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹è©±é¡ŒãŒå–ã‚Šæ‰±ã‚ã‚Œã¦ã„ã¾ã—ãŸã€‚ãã®ä¸ã§ã‚‚Redshiftã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ãŒè¤‡æ•°ã‚ã‚Šã€æ³¨ç›®åº¦ã®é«˜ã•ãŒä¼ºãˆã¾ã—ãŸã€‚ã‚¯ãƒ©ã‚¹ãƒ¡ã‚½ãƒƒãƒ‰ã•ã‚“ã€EnterpriseZineã•ã‚“ãŒå‹‰å¼·ä¼šã®æ§˜åã‚’è©³ã—ããƒ¬ãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã¾ã™ã€‚ ç¬¬18å›ž AWS User Group - Japan æ±äº¬å‹‰å¼·ä¼š ã«å‚åŠ ã—ã¦ããŸ #jawsug ï½œ Developers.IO JAWS-UGæ±äº¬å‹‰å¼·ä¼šã§æ¿ƒã‚†ãƒ¼ã„ã€Œç§‹ã®DBç¥ã‚Šã€ï¼šä¼æ¥ã®ITãƒ»çµŒå–¶ãƒ»ãƒ“ã‚¸ãƒã‚¹ã‚’ã¤ãªãæƒ…å ±ã‚µã‚¤ãƒˆ EnterpriseZine (E
hiboma 2013/10/07
mysql

yonda
ãƒªãƒ³ã‚¯
Fluentdã€Amazon Redshiftã¨Tableauã‚’ç”¨ã„ãŸã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ãªãƒ‡ãƒ¼ã‚¿å¯è¦–åŒ– | SmartNewsé–‹ç™ºè€…ãƒ–ãƒã‚°
ã‚´ã‚¯ãƒæ”¹ã‚ã€ã‚¹ãƒžãƒ¼ãƒˆãƒ‹ãƒ¥ãƒ¼ã‚¹æ ªå¼ä¼šç¤¾ã®å¤§å¹³ã§ã™ã€‚ å··é–“ã§ã¯ã€Œbigdataã€ã®æ´»ç”¨ãŒå«ã°ã‚Œã¦ä¹…ã—ã„ã§ã™ãŒã€å¼Šç¤¾ã¯ã¾ã ã¾ã å°ã•ã„è¦æ¨¡ã®ã‚¹ã‚¿ãƒ¼ãƒˆã‚¢ãƒƒãƒ—ã®ãŸã‚å°‘ãªãã¨ã‚‚ãƒ‡ãƒ¼ã‚¿ã‚µã‚¤ã‚ºã¨ã—ã¦hugeãªdataã®æ´»ç”¨ãŒè¡Œãˆã‚‹ç’°å¢ƒã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã§ã‚ã‚Œã°ãƒ‡ãƒ¼ã‚¿ã®æ´»ç”¨ã«å¯¾ã™ã‚‹è¦æ±‚ãŒä½Žã„ã‹ã€ã¨ã„ã†ã¨ãã†ã§ã‚‚ç„¡ãã€ã‚µãƒ¼ãƒ“ã‚¹ã‚µã‚¤ãƒ‰ã§ã‚‚è‡ªç„¶è¨€èªžå‡¦ç†ã‚„æ©Ÿæ¢°å¦ç¿’ã‚’ä¸å¿ƒã¨ã—ãŸãƒ‡ãƒ¼ã‚¿è§£æžå‡¦ç†ãŒã‚µãƒ¼ãƒ“ã‚¹ã®ç”Ÿå‘½ç·šã¨ãªã£ã¦ã„ã¾ã™ã—ã€ã‚µãƒ¼ãƒ“ã‚¹ã®è£å´ã§ã‚‚æˆ¦ç•¥ã‚’ç«‹ã¦ã‚‹ä¸Šã§åŠ¹æžœæ¸¬å®šã‚„è«¸ã€…ã®ãƒ‡ãƒ¼ã‚¿ã®åˆ†æžã¯éžå¸¸ã«é‡è¦ãªä½ç½®ã‚’å ã‚ã¦ã„ã¾ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ä¸»ã«ã‚µãƒ¼ãƒ“ã‚¹ã®è£å´ã§æ±‚ã‚ã‚‰ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿è§£æžã«ãŠã„ã¦ã€ã„ã‹ã«ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’è§£æžã™ã‚‹ã‹ã€ã®ä¸€ä¾‹ã¨ã—ã¦ã€æŽ²é¡Œã®ã‚ˆã†ãªçµ„ã¿åˆã‚ã›ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿å¯è¦–åŒ–ã®äº‹ä¾‹ã‚’ç°¡å˜ã«ã§ã™ãŒã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿è§£æžåŸºç›¤ã‚’ä½œã‚‹å´ã®è¦–ç‚¹ã‹ã‚‰ã™ã‚‹ã¨ã€ã‚·ã‚¹ãƒ†ãƒ ã¨ã—ã¦æ±‚ã‚ã‚‰ã‚Œã‚‹è¦ä»¶ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã ã¨ç†è§£ã—ã¦ã„ã¾
hiboma 2013/10/04
yonda
ãƒªãƒ³ã‚¯
[Jenkins] DNS MultiCast ã‚’åœæ¢ã™ã‚‹æ–¹æ³•
ãªãœã‹Jenkinsã‚’èµ·å‹•ã•ã›ãŸã‚‰ãƒ‘ã‚±ãƒƒãƒˆãƒã‚¹ãŒå¤šç™ºã—ã¾ãã£ãŸã®ã‚’ç„¡ç†ã‚„ã‚Šç›´ã—ãŸè©± ãã£ã‹ã‘ã¯ã“ã¡ã‚‰ã®è¨˜äº‹ã€‚ (Jenkins ã«ã¯ Auto-discovering ã¨ã„ã†æ©Ÿèƒ½ãŒã‚ã‚‹ãã†ã§ã™ã€‚) Jenkins ãŒåŽŸå› ã§ç¤¾å†…ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãŒé‡ãŸããªã‚‹ã¨ã„ã†ç¾è±¡ãŒèµ·ã“ã£ã¦ã„ãŸãŸã‚å¯¾å¿œã™ã‚‹ã“ã¨ã«ãªã‚Šã€ è‰²ã€…æ‰‹ã“ãšã£ãŸã®ã§ãƒ¡ãƒ¢ã‚’æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ï¼ˆâ€»çµè«–ã ã‘çŸ¥ã‚ŠãŸã„æ–¹ã¯ä¸‹ã®ã»ã†ã ã‘è¦‹ã‚Œã° OK ã§ã™ã€‚ï¼‰ Jenkins ã‚·ã‚¹ãƒ†ãƒ ã®è¨å®šã¨ã‚Šã‚ãˆãšã€ã‚·ã‚¹ãƒ†ãƒ ã®è¨å®šç”»é¢ã«ã¯ãªã•ãã†â€¦ PC ã®è¨å®šã§ãƒ–ãƒãƒƒã‚¯ã™ã‚‹ã‚ˆã†ã«ã§ããªã„ã‹è©¦ã—ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ãƒ‘ã‚±ãƒƒãƒˆãƒ•ã‚£ãƒ«ã‚¿ãƒ¼iptables Windows ã§ Jenkins ã‚’å‹•ã‹ã—ã¦ã„ã‚‹ã®ã§ã€iptables ã¯ä½¿ãˆãªã„ã€‚ netsh routing ipnetsh routing ip add filter ï½žã§ã€ãƒ•ã‚£ãƒ«ã‚¿ãƒ¼ã‹ã‘ã‚‰ã‚Œã‚‹ã¨ã„ã†æƒ…å ±ã‚’è¦‹ã¤
hiboma 2013/09/24
jenkins

yonda
ãƒªãƒ³ã‚¯
DMM inside
ãªã›ã‚™DMMã‹ã‚™web3ã«å‚å…¥ã—ãŸã®ã‹ã€‚Seamoon Protocolã‹ã‚™ç›®æŒ‡ã™æ–°ãŸãªã‚¨ãƒ³ã‚¿ãƒ¡ä½“é¨“ã®æœªæ¥ã¨ã¯
hiboma 2013/09/24
linux

kernel

yonda
ãƒªãƒ³ã‚¯
çŸ¥ã‚‰ã‚Œã–ã‚‹innodb_flush_methodã®å€¤
innodb_flush_methodã®å€¤ã¨ã„ãˆã°ã€fdatasync(æš—é»™ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ)ã‹O_DIRECTãã‚‰ã„ã—ã‹çŸ¥ã‚‰ãªã‹ã£ãŸè¨³ã ãŒã€O_DSYNCã‚„O_DIRECT_NO_FSYNC(5.6.7ã‹ã‚‰)ã‚‚ã‚ã£ãŸã‚Šã€Percona Serverã«ã¯ALL_O_DIRECTãªã‚“ã¦ã‚‚ã®ãŒã‚ã£ãŸã‚Šã™ã‚‹ã€‚ â‡’http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_flush_method â‡’http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_flush_method â‡’http://www.percona.com/doc/percona-server/5.1/scalability/innodb_io.
hiboma 2013/09/11
mysql

yonda
ãƒªãƒ³ã‚¯
mod_cacheã¨Varyãƒ˜ãƒƒãƒ€ - ãƒ€ãƒ¡äººé–“ã‚ªãƒ³ãƒ©ã‚¤ãƒ³
mod_cahceã§ç”»åƒã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ã‚‹å ´åˆã¯ç”»åƒã«"Vary: User-Agent"ã¤ã‘ãªã„ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã¨ã„ã†è©± ã¯ã„ å¤–éƒ¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã§ç”»åƒã‚’ç®¡ç†ã—ã¦ã¦ã€è¡¨ç¤ºæ™‚ã«æ¯Žå›žãã®å¤–éƒ¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã«å–ã‚Šã«ã„ã‹ãªãã¦æ¸ˆã‚€ã‚ˆã†ã«ãƒ•ãƒãƒ³ãƒˆå´ã§ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¨ãã¨ã„ã†ã®ã¯ã‚ˆãã‚ã‚‹è©±(?)ã ã¨æ€ã„ã¾ã™ã€‚ ä¾‹ãˆã°apacheã®è¨å®šã§ RewriteEngine on RewriteRule ^/images/(.+)$ http://external.storage.dameninngenn.com/images/$1 [P,L] <IfModule mod_cache.c> CacheRoot /dev/shm/mod_cache CacheEnable disk /images # ... </IfModule>ã¿ãŸã„ã«ã—ã¦ãŠãã¨ /images/hoge.jpg ã«ãƒªã‚¯ã‚¨ã‚¹ãƒˆããŸå ´åˆã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã‚Œã¦
hiboma 2013/09/09
linux

apache

yonda
ãƒªãƒ³ã‚¯
åˆ†åˆ¥ã®ã‚ã‚‹Rubyãƒ¢ãƒ³ã‚ãƒ¼ãƒ‘ãƒƒãƒãƒ£ãƒ¼ã«ãªã‚‹ãŸã‚ã«
Rubyã®ã‚¯ãƒ©ã‚¹ã¯ã‚ªãƒ¼ãƒ—ãƒ³ã§ã™ã€‚ã¤ã¾ã‚ŠRubyã®ãƒ¦ãƒ¼ã‚¶ãŒæ—¢å˜ã®ã‚¯ãƒ©ã‚¹ã‚’é–‹ã„ã¦è‡ªç”±ã«å®Ÿè£…ã‚’å¼„ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã§ã™ã€‚çµ„ã¿è¾¼ã¿ã‚¯ãƒ©ã‚¹ã¨ã¦ãã®ä¾‹å¤–ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ æ—¢å˜ã®ã‚¯ãƒ©ã‚¹ã‚’é–‹ã„ã¦ãƒ¡ã‚½ãƒƒãƒ‰ã‚’è¿½åŠ ã—ãŸã‚Šå†å®šç¾©ã—ãŸã‚Šã™ã‚‹ã“ã¨ã‚’ã€æ¥ç•Œç”¨èªžã§ã€Œãƒ¢ãƒ³ã‚ãƒ¼ãƒ‘ãƒƒãƒã€ã¨ã„ã„ã¾ã™ã€‚ãƒ¢ãƒ³ã‚ãƒ¼ãƒ‘ãƒƒãƒã¨ã„ã†èªžã«ã¯æ˜Žã‚‰ã‹ã«æ‰¹åˆ¤çš„ãƒ»è»½è”‘çš„ãƒ‹ãƒ¥ã‚¢ãƒ³ã‚¹ãŒå«ã¾ã‚Œã¦ã„ã¾ã™ãŒã€å¤šãã®Rubyistã¯ãã‚Œã«ã²ã‚‹ã‚€ã“ã¨ç„¡ãè‰¯ããƒ¢ãƒ³ã‚ãƒ¼ãƒ‘ãƒƒãƒã—ã¾ã™ã€‚ä½•ã—ã‚ãƒ‰ã‚¢ã¯ã„ã¤ã‚‚é–‹ã„ã¦ã‚‹ã‚“ã§ã™ã‹ã‚‰ãã‡ã€‚ ã‚‹ã³ãŠã®ãƒ¢ãƒ³ã‚ãƒ¼ãƒ‘ãƒƒãƒ ãƒ¢ãƒ³ã‚ãƒ¼ãƒ‘ãƒƒãƒãƒ£ãƒ¼ã€Œã‚‹ã³ãŠã€ã¯ã€è£½ä½œä¸ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§å¤šæ¬¡å…ƒé…åˆ—ã®è¦ç´ ã«é »ç¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹å¿…è¦ãŒç”Ÿã˜ã¾ã—ãŸã€‚ã“ã‚Œã«ã¯é€šå¸¸ã€Array#[]ã¾ãŸã¯#atã‚’ä½¿ã£ã¦æ¬¡ã®ã‚ˆã†ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¾ã™ã€‚ irb> arr = [[1, 2, 3], [4, 5, 6], [7, 8, 9]] irb> arr[1][2] => 6 irb> a
hiboma 2013/08/30
ruby

yonda
ãƒªãƒ³ã‚¯
MySQL ibdata1ãŒè‚¥å¤§åŒ–ã™ã‚‹ç†ç”±(è¨˜äº‹ã®æ„è¨³) | Ore no homepage
æ¯Žæ—¥æš‘ã„â€¦ã€‚ã¨ã„ã†ã‹è’¸ã—æš‘ã„ã€‚ä½•å¹´ã‹å‰ã«ãƒ™ãƒˆãƒŠãƒ ã¨ã‚«ãƒ³ãƒœã‚¸ã‚¢ã‚’ãƒãƒƒã‚¯ãƒ‘ãƒƒã‚«ãƒ¼æ—…è¡Œã—ãŸã¨ãã‚’æ€ã„å‡ºã™ã€‚æ—¥æœ¬ã®æ°—å€™ãŒäºœç†±å¸¯ã£ã¦ã‹æ±å—ã‚¢ã‚¸ã‚¢ã£ã½ããªã£ã¦ããŸã‚ˆã†ãªâ€¦æ˜”ã¯ã“ã‚“ãªé »ç¹ã«ã‚²ãƒ©ãƒªè±ªé›¨ã¨ã‹é™ã‚‰ãªã‹ã£ãŸã‚ˆããƒ¼ï¼Ÿæ¸©æš–åŒ–ã£ã¦ã‚„ã¤ï¼Ÿæ—¥æœ¬ã®æ¤ç”Ÿã¨ã‹å¤‰ã‚ã‚‹ã‚“ã˜ã‚ƒããƒ¼ã®ã‹ãªâ€¦ã€‚ ãˆãƒ¼ã¨ã€ãŠã‚ŒãŒã‚ˆãè¦‹ã¦ã„ã‚‹æŠ€è¡“ãƒ–ãƒã‚°ã®ä¸€ã¤ã«Perconaç¤¾ã®MySQL Performance BlogãŒã‚ã‚‹ã€‚ãã®ãƒ–ãƒã‚°ã«å…ˆæ—¥ã€ã€ŒWhy is the ibdata1 file continuously growing in MySQL?ã€ã¨ã„ã†è¨˜äº‹ãŒæŠ•ç¨¿ã•ã‚ŒãŸã€‚å†…å®¹ã¯InnoDBã®ibdata1ã®è‚¥å¤§åŒ–ã¨ãã®è§£æ¶ˆæ–¹æ³•ã«é–¢ã™ã‚‹ã‚‚ã®ã€‚ibdata1ã®è‚¥å¤§åŒ–ã‚’è§£æ¶ˆã™ã‚‹æ‰‹æ®µã¯ã€ãƒ€ãƒ³ãƒ—ã‚’ã¨ã£ã¦DBã‚’ä½œã‚Šç›´ã—ã¦ã‚ã’ãªã„ã¨æ²»ã‚‰ãªã„ã¨ã„ã†ã“ã¨ã¯å¤šãã®InnoDBãƒ¦ãƒ¼ã‚¶ãŒçŸ¥ã£ã¦ã„ã‚‹ã“ã¨ã ã¨æ€ã†ã‘ã©ã€ãŠã‚Œã‚‚InnoDBã‚’è§¦ã‚Šå§‹ã‚ãŸã“ã‚ã¯ã€ã€Œæ°—
hiboma 2013/08/29
mysql

yonda
ãƒªãƒ³ã‚¯
mysqladminã®å°ãƒã‚¿
mysqladminãªã‚“ã¦åŸºæœ¬çš„ã«shutdownã®æ™‚ã—ã‹ä½¿ã‚ãªã„ã‚“ã§ã™ãŒã€ã¾ã‚è‰²ã€…SQLã§ã‚„ã‚‹æ™‚ã¨ã®ãƒžãƒƒãƒ”ãƒ³ã‚°ã¨ã‹ã€‚ å–ã‚Šæ•¢ãˆãš5.6.13ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ â‡’Â http://dev.mysql.com/doc/refman/5.6/en/mysqladmin.html mysqladmin createã€€â‡’ã€€CREATE DATABASEã«åŒã˜ã€‚ mysqladmin debugã€€â‡’ã€€SQLã§ã¯ã§ããªã„ã€‚ã‚¨ãƒ©ãƒ¼ãƒã‚°ã«ãƒ‡ãƒãƒƒã‚°æƒ…å ±ã‚’å‡ºåŠ›ã™ã‚‹ã€‚ mysqladmin dropã€€â‡’ã€€DROP DATABASEã«åŒã˜ã€‚ mysqladmin extended-statusã€€â‡’ã€€SHOW GLOBAL STATUSã«åŒã˜ã€‚ mysqladmin flush-hostsã€€â‡’ã€€FLUSH HOSTSã«åŒã˜ã€‚ mysqladmin flush-logsã€€â‡’ã€€FLUSH LOGSã«åŒã˜ã€‚ãƒã‚°ç¨®åˆ¥ã¯è¨å®šã§ããª
hiboma 2013/08/29
yonda

mysql
ãƒªãƒ³ã‚¯
pull request ã‚’åˆ©ç”¨ã—ãŸé–‹ç™ºãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼
pull request ã‚’åˆ©ç”¨ã—ãŸé–‹ç™ºãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼ã®è©±ã—ã§ã™ãŒã€ã‚ã‚“ã¾ã‚Šãƒ—ãƒ«ãƒªã®è©±ã—ã—ã¦ãªã„ã—ã€ã‚³ãƒ¼ãƒ‰ãƒ¬ãƒ“ãƒ¥ãƒ¼çš„ãªãŠè©±ã—ãŒå¤šã„ã§ã™â€¦ã€‚
hiboma 2013/08/28
imo

yonda
ãƒªãƒ³ã‚¯
ã€Œãƒç”³ Excelã€å•é¡Œ
hiboma 2013/08/21
yonda
ãƒªãƒ³ã‚¯
ã€MySQLã€‘AUTO_INCREMENTã®å€¤ãŒæˆ»ã‚‹ï¼ InnoDBã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒ†ãƒ¼ãƒ–ãƒ« at softelãƒ¡ãƒ¢
MySQLã‚µãƒ¼ãƒãƒ¼å†èµ·å‹•ã®å ´åˆ ã¾ãšã“ã‚Œã€‚ ã‚µãƒ¼ãƒãƒ¼ãŒå†èµ·å‹•ã™ã‚‹ã¨ã€auto_incrementã®å€¤ãŒ select max(id)+1 ã«ãªã£ã¦ã—ã¾ã†ã€‚ InnoDB ã¯ã€ai_col ã‚’åã¥ã‘ãŸ AUTO_INCREMENT ã‚«ãƒ©ãƒ ã‚’å«ã‚€ãƒ†ãƒ¼ãƒ–ãƒ« T ã«è‡ªå‹•ã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆ ã‚«ã‚¦ãƒ³ã‚¿ã‚’åˆæœŸåŒ–ã™ã‚‹ç‚ºã«ã€æ¬¡ã®ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã‚’åˆ©ç”¨ã—ã¾ã™:ã‚µãƒ¼ãƒã®èµ·å‹•ã®å¾Œã§ã€ãƒ†ãƒ¼ãƒ–ãƒ« T ã¸ã®æœ€åˆã®æŒ¿å…¥ã‚’ã™ã‚‹ç‚ºã«ã€InnoDB ã¯ã“ã®ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã¨åŒç‰ãªç‰©ã‚’å®Ÿè¡Œã—ã¾ã™: SELECT MAX(ai_col) FROM T FOR UPDATE; ï¼ˆä¸ç•¥ï¼‰ InnoDB ã¯ã‚µãƒ¼ãƒãŒèµ·å‹•ã—ã¦ã„ã‚‹é™ã‚Šã€ãƒ¡ãƒ¢ãƒªå†…ã®è‡ªå‹•ã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆ ã‚«ã‚¦ãƒ³ã‚¿ã‚’åˆ©ç”¨ã—ã¾ã™ã€‚ã‚µãƒ¼ãƒãŒåœæ¢ã—å†èµ·å‹•ã—ãŸæ™‚ã€å…ˆã»ã©èª¬æ˜ŽãŒã‚ã£ãŸã‚ˆã†ã«ã€InnoDB ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®æœ€åˆã® INSERT ã«å¯¾ã™ã‚‹å„ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚«ã‚¦ãƒ³ã‚¿ã‚’å†åˆæœŸåŒ–ã—ã¾ã™ã€‚ http:/
hiboma 2013/08/02
yonda
ãƒªãƒ³ã‚¯
RSpec Performance Turning
ç¤¾å†…ã®RSpecå‹‰å¼·ä¼šã§ä½¿ã£ãŸè³‡æ–™ã§ã™ http://sue445.hatena blog.com/entry/2013/07/30/235502Read less
hiboma 2013/07/31
ruby

yonda
ãƒªãƒ³ã‚¯
1