[B! isucon] W53SAã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

W53SA id:W53SA

isuconã«é–¢ã™ã‚‹W53SAã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (8)

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

isucon10.md
isucon10.md å†èµ·å‹•è©¦é¨“ã§è½ã¡ã¦ã„ãŸä»¶ã®èª¿æŸ» - NaruseJun ç†ç”± apparmorã®ãƒãƒªã‚·ãƒ¼(mysql-serverãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã«å…¥ã£ã¦ã‚‹/etc/apparmor.d/usr.sbin.mysqld)ãŒç”Ÿãã¦ã„ã¦ã€systemdãŒmariadbã®èµ·å‹•ã‚’æ¤œçŸ¥ã§ãã¦ãŠã‚‰ãšã€systemctl stopç›¸å½“ã®å‡¦ç†ãŒã‹ã‹ã£ãŸãŸã‚ã€‚ ç–‘å•1: mariadbã«å…¥ã‚Œæ›¿ãˆãŸã¨ãã«to-hutohuãŒaa-remove-unknownã§ãƒãƒªã‚·ãƒ¼ã‚’æ¶ˆã—ãŸã®ã§ã¯ï¼Ÿ ã“ã‚Œã¯ãã‚‚ãã‚‚æ’ä¹…å¯¾å¿œã§ã¯ãªã‹ã£ãŸã€‚ /etc/apparmor.d/usr.sbin.mysqldã¯mariadbã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«ç©ºã«ãªã£ã¦ã„ã‚‹ã€‚ ãŒã€ãƒªãƒ–ãƒ¼ãƒˆæ™‚ã«ã¯mysql-serverãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ç”±æ¥ã®apparmorãƒãƒªã‚·ãƒ¼ãŒé©ç”¨ã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†çµŒé¨“ãŒã‚ã£ãŸ Ubuntuã§mysql-serverã‚’mariadb-se
W53SA 2020/09/15
isucon

AppArmor
ãƒªãƒ³ã‚¯
GitHub - tkuchiki/alp: Access Log Profiler
$ alp --help alp is the access log profiler for LTSV, JSON, Pcap, and others. Usage: alp [flags] alp [command] Available Commands: completion Generate the autocompletion script for the specified shell count Count by log entries diff Show the difference between the two profile results help Help about any command json Profile the logs for JSON ltsv Profile the logs for LTSV pcap Profile the HTTP req
W53SA 2020/09/15
nginx

isucon
ãƒªãƒ³ã‚¯
ISUCON9 äºˆé¸ã‚’å…¨ä½“1ä½ã§çªç ´ã—ã¾ã—ãŸ
9æœˆ8æ—¥(æ—¥)ã«é–‹å‚¬ã•ã‚ŒãŸ ISUCON9 äºˆé¸ã®2æ—¥ç›®ã«1äººãƒãƒ¼ãƒ ã€Œ nil ã€ã¨ã—ã¦å‚åŠ ã—ã€å…¨ä½“1ä½ã¨ãªã‚Šæœ¬é¸å‡ºå ´ãŒæ±ºã¾ã‚Šã¾ã—ãŸã€‚ æœ€çµ‚ã‚¹ã‚³ã‚¢ã¯ 52,440 ï½²ï½½ï½ºï½²ï¾ (ãƒ™ã‚¹ãƒˆã‚¹ã‚³ã‚¢ã¯ 53,460 ï½²ï½½ï½ºï½²ï¾) ã§ã—ãŸã€‚ ã“ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã¯ä¸»ã«å‚åŠ ã™ã‚‹ã¾ã§ã«ã‚„ã£ã¦ããŸã“ã¨ã¨ã€å½“æ—¥ã‚„ã£ãŸã“ã¨ã«ã¤ã„ã¦æ›¸ã“ã†ã¨æ€ã„ã¾ã™ã€‚ å‚åŠ ã™ã‚‹ã¾ã§ã«ã‚„ã£ã¦ããŸã“ã¨# ç·´ç¿’ (åŽ»å¹´)# ISUCON ã«ã¯åŽ»å¹´ã® ISUCON8 ã§åˆã‚ã¦å‚åŠ ã—ã€ä»Šå¹´ã§2å›žç›®ã§ã™ã€‚ åŽ»å¹´ã¯ ISUCON8 ã«å‘ã‘ã¦æ¯Žé€±ã®ã‚ˆã†ã«éŽåŽ»å•ã®ç·´ç¿’ã‚’ã—ã¦ã„ã¾ã—ãŸã€‚ 1å¹´ä»¥ä¸Šå‰ã®è¨˜æ†¶ã§ã¯ã‚ã‚Šã¾ã™ãŒã€ä»Šå¹´ã¯ã‚ã¾ã‚Šç·´ç¿’ã™ã‚‹ã“ã¨ãŒã§ããªã‹ã£ãŸã®ã§ã€ã“ã®çµŒé¨“ã‚„çŸ¥æµãŒä»Šå›žã®å„ªå‹ã«ã‚‚å½±éŸ¿ã—ãŸã¨è€ƒãˆã¦ã„ã¾ã™ã€‚ ç·´ç¿’ (ç›´å‰)# ä»Šå¹´ã¯ä»–ã®ã“ã¨ã§å¿™ã—ã ISUCON ã®ç·´ç¿’ã‚’ã™ã‚‹æ™‚é–“ãŒç¢ºä¿ã§ãã¾ã›ã‚“ã§ã—ãŸã€‚ ãã®ãŸã‚ç·´ç¿’ã§ããŸã®ã¯5æ—¥(æœ¨)ã‹ã‚‰å‰æ—¥
W53SA 2020/09/07
isucon
ãƒªãƒ³ã‚¯
ISUCON å¤æœŸè¬›ç¿’ 2020 ã‚’é–‹å‚¬ã—ã¾ã—ãŸï¼ˆè³‡æ–™ã¨å‹•ç”»ã‚ã‚Šï¼‰ : ISUCONå…¬å¼Blog
ISUCONã«ã¤ã„ã¦ã®ç†è§£ã€å•é¡Œã®è§£ãæ–¹ã«ã¤ã„ã¦æ·±ãå¦ã¶ã“ã¨ãŒã§ãã‚‹ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¤ãƒ™ãƒ³ãƒˆã€ŒISUCON å¤æœŸè¬›ç¿’ 2020ã€ã‚’é–‹å‚¬ã—ã¾ã—ãŸã€‚ å½“æ—¥ã¯ã€ISUCON9å„ªå‹ã®ç™½é‡‘å‹•ç‰©åœ’ã®ãƒ¡ãƒ³ãƒãƒ¼ã§ã‚ã‚ŠISUCON10ã®å‡ºé¡Œè€…ã§ã‚‚ã‚ã‚‹ @rosylilly ã•ã‚“ã«è¬›å¸«ã‚’ã—ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ã©ã‚“ãªå•é¡Œã‚’ã©ã®ã‚ˆã†ã«è§£ãã¹ãã‹ã¨ã„ã†è¦–ç‚¹ã§ã¯ãªãã€Œ8æ™‚é–“ã§å‡ºæ¥ã‚‹ã“ã¨ã¯å°‘ãªã„ã€ã¨ã„ã†å‰æã«ç«‹ã¡ã€äº‹å‰ã®æº–å‚™ã—ã¦ãŠãã¹ãã‚‚ã®ã‚„å¿ƒæ§‹ãˆã«ã¤ã„ã¦æ•™ãˆã¦ã„ãŸã ãã¾ã—ãŸã€‚ãœã²å‚è€ƒã«ã—ã¦ã„ãŸã ã„ã¦ã€ISUCONæœ¬é¸å‡ºå ´ã‚’ç›®æŒ‡ã—ã¦ãã ã•ã„ï¼
W53SA 2020/07/14
isucon
ãƒªãƒ³ã‚¯
ISUCON7æœ¬æˆ¦ã§Bigintã‚’æ®ºã—ãŸã‹ã£ãŸè©± - (/^^)/âŒ’â—~*$ a(){ a|a& };a
æ³¨æ„ï¼šã“ã®ãƒ–ãƒã‚°ã§ã¯Goè¨€èªžã®Bigint(å¤šå€é•·æ•´æ•°)ã«ã¤ã„ã¦è§¦ã‚Œã¦ã„ã¾ã™ 12/6 è¿½è¨˜ï¼šæ®ºã›ã¾ã—ãŸ ã“ã‚“ã«ã¡ã¯ã€‚ ISUCON7æœ¬æˆ¦ã«ã€Œç™¾ä¸‡å††ãƒ‰ãƒªãƒ–ãƒ³ã€ã®ä¸€å“¡ã¨ã—ã¦å‚åŠ ã—ã¾ã—ãŸã€‚ ãƒ¡ãƒ³ãƒãƒ¼ã¯åƒ•ã¨, @nakario, @aokabi ã®ä¸‰äººã§,äºŒäººã¯ã‚µãƒ¼ã‚¯ãƒ«ã®ãƒ¡ãƒ³ãƒãƒ¼ã§ã™ã€‚ é›†ä¸ã®ã‚ã¾ã‚Šç¾Žå‘³ã—ã„ãŠæ˜¼ã®ã‚¯ãƒƒã‚ãƒ¼ã¨çˆç²ã¯é€ƒã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ çµæžœã¯ã‚¿ã‚¤ãƒˆãƒ«ã®é€šã‚Šã§ã‚ã‚Šã€ç«¶æŠ€æ™‚é–“å†…ã§ã¯ãƒãƒƒã‚¯ã¨ãªã£ã¦ã„ãŸ Bigint ã‚’æ®ºã™ã“ã¨ãŒå‡ºæ¥ãšã€ æ‚”ã—ã‹ã£ãŸã®ã§Bigintå‘¨ã‚Šã§è©¦è¡ŒéŒ¯èª¤ã‚’ã—ãŸçµæžœã«ã¤ã„ã¦è¿°ã¹ã¾ã™ã€‚ å…·ä½“çš„ã«ã¯ã€Bigintã¨__float128ã«ã¤ã„ã¦è¿°ã¹ã¾ã™ã€‚ ä»Šå›žã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã®æ¸¬å®šã¨ç™ºè¦‹ã¯ @nakario ãŒçŽ‡å…ˆã—ã¦ã‚„ã£ã¦ãã‚Œã¾ã—ãŸã€‚ åƒ•ã®æ”¹å–„æ‹…å½“ç®‡æ‰€ã¯ãã‚Œã«ã‚ˆã‚Šåˆ¤æ˜Žã—ãŸãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã®ä¸€ã¤ ã€ŒBigint ã®10é€²ä¸Šä½15æ¡ã®å–å¾—ã€ ã§ã—ãŸã€‚ åˆæœŸå®Ÿè£… åˆæœŸ
$ISUCON7æœ¬æˆ¦ã§Bigintã‚’æ®ºã—ãŸã‹ã£ãŸè©± - (/^^)/âŒ’â—~*$ a(){ a|a& };a$
W53SA 2017/12/06
isucon

go
ãƒªãƒ³ã‚¯
ISUCON7 äºˆé¸çªç ´ã—ãŸ (ç™½é‡‘å‹•ç‰©åœ’) #isucon - diary.sorah
7 å›žç›®ã® ISUCONã€ãªã‚“ã¨ã‹ 2 æ—¥é€šã—ã®æž ã§äºˆé¸é€šéŽã§ãã¦æœ¬å½“ã«è‰¯ã‹ã£ãŸã€‚ ä»Šå›žã‚‚ @mirakui, @rosylilly ã¨ä¸€ç·’ã«ç™½é‡‘å‹•ç‰©åœ’ã¨ã—ã¦å‚åŠ ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ã‚®ãƒªã‚®ãƒªã®é›†åˆãªãŒã‚‰äºˆå®šã‚ˆã‚Šé–‹å§‹ãŒé…ã‚ŒãŸã®ã§ã€ã‚¢ãƒ‹ãƒ¡ã‚’ 2 æœ¬è¦‹ã¾ã—ãŸã€‚çµåŸŽå‹å¥ˆã¯å‹‡è€…ã§ã‚ã‚‹ -é·²å°¾é ˆç¾Žã®ç« - #2 ã¯ãƒãƒ¼ãƒ ãƒ“ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã®è©±ã§æ™¯æ°—ãŒè‰¯ã‹ã£ãŸ [ç‹¬è‡ªç ”ç©¶] ã—ã€ãã®å¾Œã‚‚ something æ™¯æ°—ãŒè‰¯ã„ç‰©ã¨ã„ã†ã“ã¨ã§ Fate/Apocrypha #16 ã‚‚è¦‹ãŸã‘ã©ã“ã‚Œã‚‚æ™¯æ°—ãŒè‰¯ã‹ã£ãŸã§ã™ã€‚ã‚¢ã‚¹ãƒˆãƒ«ãƒ•ã‚©ç§æœã€‚ ã¨ã„ã†ã‚ã‘ã§ã€ç™½é‡‘å‹•ç‰©åœ’ã®æ‰‹ã®å†…ã‚’å…¬é–‹ã—ã¾ã™ã€‚ãƒ™ã‚¹ãƒˆã‚¹ã‚³ã‚¢ã¯ 34 ä¸‡ã»ã©ã§å¯¾ã—ãŸã“ã¨ãªã„ã‘ã©â€¦ã€‚ä¸Šä½é™£ã®ã‚¹ã‚³ã‚¢ã³ã³ã‚‹ã€‚ å®Ÿè£… https://github.com/shirokanezoo/isucon7q Ruby + Goâ€¦ ã«ã™ã‚‹ç›®è«–è¦‹ãŒæœ€çµ‚çš„ã« Ruby ã®ã¿ã§ã™ã€‚ãƒ™ã‚¹ãƒˆ 346
W53SA 2017/10/23
isucon

Ruby
ãƒªãƒ³ã‚¯
ISUCON6 æœ¬é¸å•é¡Œã®è§£èª¬ã¨è¬›è©• : ISUCONå…¬å¼Blog
ISUCON6æœ¬é¸ã®å‡ºé¡Œã‚’æ‹…å½“ã—ã¾ã—ãŸ@edvakfã§ã™ã€‚ æ—¢ã«1é€±é–“ä»¥ä¸ŠçµŒéŽã—ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€ISUCON6ä¸»å‚¬è€…ãŠã‚ˆã³å‚åŠ è€…ã®çš†ã•ã¾ã€ã”å”åŠ›ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ã“ã®ç´ æ™´ã‚‰ã—ã„ã‚¤ãƒ™ãƒ³ãƒˆãŒä»Šå¹´ã‚‚é–‹å‚¬ã•ã‚ŒãŸã®ã¯é–¢ã‚ã£ã¦ãã ã•ã£ãŸå…¨å“¡ã®ãŠã‹ã’ã§ã™ã€‚ ç‰¹ã«åèª‰é‹å–¶ã¨ã—ã¦äºˆé¸çµ‚äº†å¾Œã«å‚åŠ ã—ã¦ã„ãŸã ã„ãŸmatsuuã•ã‚“ã«ã¯å¤§å¤‰ãªã”å°½åŠ›ã‚’ã„ãŸã ãã€æ„Ÿè¬ã®è¨€è‘‰ã‚’å°½ãã—ã¦ã‚‚è¶³ã‚Šã¾ã›ã‚“ã€‚ ã•ã¦ã€æ—¢ã«Twitterã§ã¯å‘¨çŸ¥ã—ã¦ã„ã¾ã™ãŒã€ISUCON6æœ¬é¸å•é¡Œã®ãƒªãƒã‚¸ãƒˆãƒªã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ https://github.com/isucon/isucon6-final åˆã‚ã›ã¦ã€ISUCON6è£è©±Nightã®é–‹å‚¬ã‚‚æ±ºå®šã—ã¦ã„ã¾ã™ã®ã§ã€ã‚‚ã£ã¨ä½™éŸ»ã‚’æ¥½ã—ã¿ãŸã„ã¨ã„ã†æ–¹ã¯ã”å‚åŠ ä¸‹ã•ã„ã€‚ http://connpass.com/event/43742/ â€»ã“ã¡ã‚‰ã®ã‚¤ãƒ™ãƒ³ãƒˆã¯Amazonã‚¦ã‚£ãƒƒã‚·ãƒ¥ãƒªã‚¹ãƒˆã‹ã‚‰ãƒ—ãƒ¬ã‚¼ãƒ³
W53SA 2016/11/01
ISUCON

isucon6
ãƒªãƒ³ã‚¯
ISUCON6äºˆé¸ã‚’ãƒˆãƒƒãƒ—é€šéŽã—ã¾ã—ãŸ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
@methane ã§ã™ã€‚ã€Œã“ã®æŠ€è¡“éƒ¨ã«ã¯å•é¡ŒãŒã‚ã‚‹ï¼ã€ã¨ã„ã†ãƒãƒ¼ãƒ åã§ @kizkoh (ã‚¤ãƒ³ãƒ•ãƒ©æ‹…å½“), @mecha_g3 (ã‚¢ãƒ—ãƒªæ‹…å½“) ã¨ã¨ã‚‚ã« ISUCON 6 ã«å‚æˆ¦ã—ã€äºˆé¸ã‚’ãƒˆãƒƒãƒ—ã‚¹ã‚³ã‚¢ã§é€šéŽã—ã¾ã—ãŸã€‚ æ’ä¾‹ã®ãµã‚Šã‹ãˆã‚Šè¨˜äº‹ã‚’æ›¸ãã¾ã™ã€‚ ãµã‚Šã‹ãˆã‚Š æ®‹å¿µãªãŒã‚‰ã‚¹ã‚³ã‚¢ã¯è¨˜éŒ²ã—ã¦ãªã„ã®ã§ã™ãŒã€æ™‚ç³»åˆ—é †ã«ã‚„ã£ãŸã“ã¨ã‚’ã¾ã¨ã‚ã¾ã™ã€‚ ã‚¢ãƒ—ãƒªã®ã‚³ãƒ¼ãƒ‰ã¯ methane/isu6q-app ã§å…¬é–‹ã—ã¦ã„ã‚‹ã®ã§ã€èˆˆå‘³ãŒã‚ã‚‹æ–¹ã¯ã‚³ãƒ¼ãƒ‰ã‚’ç¢ºèªã—ã¦ãã ã•ã„ã€‚ strings.Replacer ã‚’ä½¿ã† ä½¿ç”¨è¨€èªžã¯æœ€åˆã‹ã‚‰ Go ã¨æ±ºã‚ã¦ã„ãŸã®ã§ã™ãŒã€Goã®åˆæœŸå®Ÿè£…ã¯é…ã™ãŽã¦ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã§æœ€åˆã‹ã‚‰ã‚¹ã‚³ã‚¢ç„¡ã—ã§ã—ãŸã€‚ top ã§ã‚¢ãƒ—ãƒªã®CPUãŒæ”¯é…çš„ãªã®ã¯ã™ãåˆ¤ã‚Šã¾ã—ãŸã—ã€ã‚³ãƒ¼ãƒ‰ã‚’èªã‚ã°ãªã«ãŒé…ã„ã®ã‹ã‚‚ä¸€ç™ºã§åˆ¤ã‚Šã¾ã—ãŸã€‚ãã‚“ãªã«é•·ããªã„ã®ã§é–¢æ•°å…¨ä½“ã‚’å¼µã‚Šã¾ã™ã€‚ func htmlify(w http.R
W53SA 2016/09/21
isucon

golang
ãƒªãƒ³ã‚¯
1