https://kaigionrails.org/2024/talks/osyoyu/
Linuxã«ã¼ãã«ãã©ã¡ã¼ã¿ã®ãã¥ã¼ãã³ã°ï¼è¨è¨ 0.ç®ç ãã«ã¼ãã«ãã©ã¡ã¼ã¿ã®ãã¥ã¼ãã³ã°ããä¿®å¾ããç®çã¯ããµã¼ãã®ç¹æ§ãç解ããããããã«åã£ãã«ã¼ãã«ãã©ã¡ã¼ã¿ã®ãã¥ã¼ãã³ã°ãããã¨ã§ãªã½ã¼ã¹ã®æå¹æ´»ç¨ãã§ããããã«ãªããã¨ãç®çã¨ããç§å人ã®çµé¨ãå ã«ããè¦è§£ã以ä¸ã®è¨äºã«æ²è¼ãã¾ãã 1.æåã« ãµã¼ãã«ã¯ãããããå¿ è¦ãªãªã½ã¼ã¹ç¹æ§ããããããã«åãããã«ã¼ãã«ãã©ã¡ã¼ã¿ã®ãã¥ã¼ãã³ã°ãå¿ è¦ã¨ãªãã¾ãã ä¸ã®ä¸ã®æµãã¯ãªã³ãã¬ããã¯ã©ã¦ãã«ç§»è¡ãã¦ã¯ããã®ã§ãã«ã¼ãã«ãã©ã¡ã¼ã¿ã®ãã¥ã¼ãã³ã°ããã¹ã±ã¼ã«ã¢ãããªãã¹ã±ã¼ã«ã¢ã¦ããããªãã®å¯¾å¿ããã¹ããªã®ã§ãããã ã§ãããã«ã¼ãã«ãã©ã¡ã¼ã¿ã®ãã¥ã¼ãã³ã°ãç¥ããªãã¨ã©ã¡ããé¸æãã¹ãããç解ããããã¨æãã¾ãã®ã§è»½çã«ã¯åºæ¥ãã¾ããã(å¾ ã¡è¡åçè«ããããªãã¨ããã¾ããã) ã¾ããæè¿ã®Linuxã¯ããã©ã«ãå¤ã大ãããªã£ã¦
static, benchmarking, tuning: sar, perf-tools, bcc/BPF: bpftrace, BPF book: Images license: creative commons Attribution-ShareAlike 4.0. This page links to various Linux performance material I've created, including the tools maps on the right. These use a large font size to suit slide decks. You can also print them out for your office wall. They show: Linux observability tools, Linux static perfor
One Billion Row Challenge in Golang - From 95s to 1.96s Renato Pereira Mar 18, 2024 Introduction The One Billion Row Challenge (1BRC) is quite simple: the task is developing a program capable of read a file with 1 billion lines, aggregating the information contained in each line, and print a report with the result. Each line within the file contains a weather station name and a temperature reading
ã¯ããã« MySQL(InnoDB)ã§SQLã®ããã©ã¼ãã³ã¹ãã¥ã¼ãã³ã°ãããã¨ãã«å½¹ã«ç«ã¤ç¥èãã¨ãã»ã³ã¹ã¨ãã¦ã¾ã¨ãã¾ãããçµå(JOIN)ãB-treeã¤ã³ããã¯ã¹ã®æ¢ç´¢ã®ä»çµã¿ãå®è¡è¨ç»ã®åºæ¬çãªè¦æ¹ãç´¹ä»ãã¾ãã æ³å®ããèªè ã¯ãSQLã®ããã©ã¼ãã³ã¹ãæ¹åããå¿ è¦ããããå®è¡è¨ç»ãã¿ã¦ããã¾ãã¡ãã³ã¨æ¥ãªãæ¹ã§ããã¤ã³ããã¯ã¹ã®ä½æã®çµé¨ããè¤åã¤ã³ããã¯ã¹ãã«ã¼ãã£ããªãã£ã®ç¥èããããã¨ãåæã«ãã¦ãã¾ããç®æ¨ã¯ãå®è¡è¨ç»ã®å 容ãããåãããªãèªè ããå®è¡è¨ç»ãã¿ãã ãã§ã¯ã¨ãªãå®è¡ãããæ§åãã¤ã¡ã¼ã¸ã§ããèªä¿¡ãæã£ã¦ã¯ã¨ãªã®æ¹åã«ããããã¨ãã§ããããã«ãããã¨ã§ãã ã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã¯InnoDBãåæã¨ãã¦ãã¾ããã¾ããã¤ã³ããã¯ã¹ã¯B-treeã¤ã³ããã¯ã¹ãæ³å®ãã¦ãã¾ããå ¨ææ¤ç´¢ã®è»¢ç½®ã¤ã³ããã¯ã¹ã空éæ¤ç´¢ã®R-treeã¤ã³ããã¯ã¹ã«ã¤ãã¦ã¯è§¦ãã¾ããã ã¤ã³
# åèè³æ - https://speakerdeck.com/hanhan1978/purohuairawoshi-tutaphpapurikesiyongai-shan-falsekan-suo - https://speakerdeck.com/hanhan1978/web-applicatâ¦
DB ã¤ã³ããã¯ã¹ã®åºç¤ç¥èããå³ããããã使ã£ã¦æ´çãã¾ãã ãã® Book ã¯ãæè¨ãããã¾ãã«ãã¦ãããªçåãèªå解決ã§ããããã«ãªããã¨ãç®æãã¾ãã ãã©ããªã¤ã³ããã¯ã¹ä½ãã°ãããã ã£ãï¼ã ããªãã§ä½ãããã¡ãã ããªãã ã£ãï¼ã ããã®å ´åã¤ã³ããã¯ã¹ã£ã¦å¹ãã£ãï¼ã ãã¤ã³ããã¯ã¹ã§ã©ããããéããªãã®ï¼ã ãã®æ¬ã¯çè ã®ç解ã«é£åãã¦è¿½è¨ä¿®æ£ãããå¯è½æ§ãããã¾ãã
ããã«ã¡ã¯ããµã¼ãã¹éçºé¨ã®èå¼ (@a_bicky) ã§ãã çªç¶ã§ãããRDBMS ã®æ¢åã®ãã¼ãã«ãè¦ã¦ã¿ãããä½ã§ãããªã«ã¤ã³ããã¯ã¹ã ãããªã®ï¼ãã¿ãããªçµé¨ã¯ããã¾ãããï¼ä¸è¦ãªã¤ã³ããã¯ã¹ã¯å®¹éãå§è¿«ããããæ¿å ¥ãé ããªã£ããã¨è¯ããã¨ãããã¾ããã ãããªããã§ãä»åã¯ã¬ã³ã¼ããæ¤ç´¢ããããã«å¿ è¦ãªã¤ã³ããã¯ã¹ã®åºç¤ç¥èã¨ãããè¦ãããä¸é©åãªã¤ã³ããã¯ã¹ã«ã¤ãã¦è§£èª¬ãã¾ããã¯ãã¯ãããã§ã¯ Rails ã®ãã¼ã¿ãã¼ã¹ã¨ãã¦ä¸»ã« MySQL 5.6ãMySQL ã®ã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã¨ãã¦ä¸»ã« InnoDB ã使ã£ã¦ããã®ã§ãMySQL 5.6 ã® InnoDB ã«ã¤ãã¦è§£èª¬ãã¾ãã InnoDB ã®ã¤ã³ããã¯ã¹ã«é¢ããåºç¤ç¥è ã¤ã³ããã¯ã¹ã®æ§é (B+ æ¨) InnoDB ã§ã¯ B+ æ¨ã使ããã¦ãã¾ããB+ æ¨ã¯æ¬¡ã®ãããªç¹å¾´ãæã£ãæ¨æ§é ã§ãã 次æ°ã b ã¨ããã¨ã
ãã¼ã¿ãµã¤ã¨ã³ãã£ã¹ãã®çããã次ã®ãããªæ§è½åé¡ã«ã§ãã£ããã¨ãªãã§ãããããããã¼ã¿ã®å å·¥å¦çãé ãããã¤ã³ã¹ã¿ã³ã¹ã¿ã¤ããä¸ãããéããªããªãã£ãããæ©æ¢°å¦ç¿ã®å¦ç¿ãé ããããGPUãå¢ãããããéããªããªãã£ãããããã£ãã¨ãã«ã©ãããã°ããã説æãã¾ãã
åºæ ç§ã®ä»äºã¯ãDBã¨ã³ã¸ãã¢ã§ããã¨ãã£ã¦ãå¥ã«æãã§ãã¼ã¿ãã¼ã¹ã®ä¸çã¸ããããã§ã¯ãªããå½åãç§ã¯ãã®åéãé¢ç½ãããã¾ããã§ããããWebç³»ã¯è±å½¢ããã¼ã¿ãã¼ã¹ã¯æ¥é°ãã¨ããè¨èãåããã¦ãã¾ãããä»ã§ãåããã¦ããããããã¾ããã ã§ããããã°ãããã¼ã¿ãã¼ã¹ã触ã£ã¦ãããã¡ã«ãç§ã¯ãã®ä¸çã«ã¨ã¦ãèå³æ·±ããã¼ããå¤ããããã¨ãç¥ãã¾ããããªããã£ã¨æ©ãæ°ã¥ããªãã£ãã®ããå¾æãããã¨ãããã§ãã ãã¡ãããèªåã®ä¸æãæ大ã®åå ã§ããããã®ä¸çã«è¶³ãè¸ã¿å ¥ããå½æãå çããå°ãã®æ¸ã¨ãªãå ¥éæ¸ããªãã£ããã¨ãäºå®ã§ãã ä»ã§ãããã¤ãã«ã¨ä»°ããããã°ã©ãã®ããã®SQL 第2çããæ°å ¥ç¤¾å¡ã«ã¯æ·å± ãé«ããã¾ãã (2015å¹´2æ追è¨ï¼ãã®å¾ãèªåã§ç¬¬4çã訳åºã§ããã®ã ããã 人çã¯ä½ããããåãããªããã®ã§ã)ã ããã§ãã§ãããã®ãµã¤ãã®ç®çã¯ããã¼ã¿ãã¼ã¹ã®ä¸çã«è¶³ãè¸ã¿
ãã®ãµã¤ãã§ã¯ãSQL ãé«éåããããã®ã¡ãã£ã¨ããããã©ã¼ãã³ã¹ã»ãã¥ã¼ãã³ã°ã®æè¡ãç´¹ä»ãã¾ããã¨è¨ã£ã¦ãããããã°ã©ãã®ããã®SQLã第2çãã®åã売ããã»ã¨ãã©ãªã®ã§ããã®æ¬ãèªãã§ããã ããã°ãæ¬ç¨¿ãèªãå¿ è¦ã¯ããã¾ããã æåã«ãããã©ã¼ãã³ã¹ã»ãã¥ã¼ãã³ã°ã«é¢ããå ¨ä½ã®æ¹éãè¿°ã¹ã¦ããã¨ãããã¯ããã«ããã¯ï¼ä¸çªé ãã¨ããï¼ãæ¹åãããã¨ã§ããå½ããåã§ãããæ¢ã«ååéãå¦çããã£ã¨éãããã¨ããã§ãã·ã¹ãã å ¨ä½ã®ããã©ã¼ãã³ã¹ã«ã¯å½±é¿ãã¾ãããå¾ã£ã¦ãå¦çãé ããã¨æããããæåã«ãããã¨ã¯ãSQL ãã¢ããªã®æ¹ä¿®ã§ã¯ãªãããã©ããé ãã®ããã調æ»ãããã¨ã§ãããããªããã¦ãã£ã½ãã§æ¹åãã¯ããã¦ãå¹æã¯åºã¾ãããå»è ãæ£è ã診ãã¨ãæåã«ãããã¨ãæ¤æ»ã§ããã®ã¨åãã§ããç å ãä½ã§ããããçªãæ¢ãã¦ããã§ãªãã¨ãæ£ããå¦æ¹ã¯ã§ããªãã®ã§ãã ãã®åºæ¬ãæ¿ç¥ãã¦ããã ãã
ã¯ããã« XTechã°ã«ã¼ã Advent Calendar 2021ã®16æ¥ç®ã¯ãiXITæ ªå¼ä¼ç¤¾ ã¨ã³ã¸ãã¢ã®è¦åããéããã¾ãã æè¿ããã£ã¦ãããã®ã¯é³æ¥½ç³»Vtuberã§ããVIRTUAFREAKè¯ãã£ãâ¦ã qiita.com æ¬é¡ ãã¼ã«ãªã©ãå°å ¥ããªãã¦ãSlowQueryã解æã§ããæ©è½ãMySQLã«ã¯åå¨ããã®ã§ãä»åã¯ãã®ä¸é¨ãç´¹ä»ãã¾ãã ã¡ãªã¿ã«ç§ãéçºãã¦ãããµã¼ãã¹ã®MySQLãã¼ã¸ã§ã³ã¯5.6ã§ãã 1. mysqldumpslow ä¸è¨ã§è¨ãã¨ã¹ãã¼ã¯ã¨ãªã¼ãã°ãã¡ã¤ã«ã解æãã¦å 容ã®ãµããªã¼ãåºåãã¦ãããæ©è½ã§ãã åæã¨ãã¦ã¹ãã¼ã¯ã¨ãªã¼ãã°ãåºåãã¦ããå¿ è¦ãããã¾ãã 使ãæ¹ ã³ãã³ã â»åè¨å®è¡æéãé·ãé ã«10件ã®SQLãåºåãã mysqldumpslow -s at -t 10 /opt/fio1/slog/sp-prd-db1-slow.
ä¸è¬ã¦ã¼ã¶ã¼åãã®å¤§è¦æ¨¡ãªWebãµã¤ãããã¢ãã³Webä¸ã§åä½ããWebã¢ããªã±ã¼ã·ã§ã³ãéå¶ããå ´åãCDNãªã©ã®ãã£ãã·ã³ã°ãµã¼ãã¹ã«ãã£ã¦éçã³ã³ãã³ãããã£ãã·ã¥ãããã¨ã極ãã¦éè¦ã§ãã ããããããããµã¼ãã¹ã¯ãé常ã«è¤éã§åããã«ãããã®ã§ãã 幸ããIETFï¼Internet Engineering Task Forceï¼ã®HTTPã¯ã¼ãã³ã°ã°ã«ã¼ãããã®ç¶æ³ãæ¹åãã¹ããHTTPã®æ°æ¨æºçå®ã«åãçµãã§ãã¾ãã æè¿ãåã¯ã¼ãã³ã°ã°ã«ã¼ãã§ã¯ããã£ãã·ã³ã°ã®ãããã°ã¨ãã£ãã·ã¥è¨å®ã®ç®¡çã容æã«ãããã¨ãç®çã¨ãããHTTPãããã«é¢ãã2ã¤ã®æ°æ¨æºæ¡ã®çºè¡¨ã«åãã¦æ´»çºãªåããããã¾ããã ãã®ãã¨ãä½ãæå³ããã©ã®ããã«æ©è½ããã®ããããã¦Webå¶ä½ã«æºããéçºè å ¨ã¦ããªã注ç®ãã¹ããªã®ãã«ã¤ãã¦è¦ã¦ããã¾ãã æ°æ¨æº ãã®è¨äºã§åãä¸ããæ¨æºæ¡ã¯ä»¥ä¸ã®2ã¤ã§ãã Ca
é称 #ISUCONæ¬ ãèè æ§ãããæµè´ããã ãã¾ããããããã¨ããããã¾ãã gihyo.jp ææ ãã®æ¸ç±ãè¨ã£ã¦ããã®ããããã¾ãããã¾ã£ããã®åå¿è ã»åå¦è ã«ã¯é£ããæ¬ããããã¾ãããç§ã®æ触ã§ã¯ãWebãµã¤ãã®ããã°ã©ã ä½æãæ¹ä¿®ãæ§ç¯ãéç¨ãªã©ã«æºãã£ãããWebãµã¤ãã®ããã©ã¼ãã³ã¹ã®åé¡ã«åãåã£ããã¨ããã人ã対象èªè ã ã¨æãã¾ãããè·ç¨®ã§ããã°ããã¯ã¨ã³ãã¨ã³ã¸ãã¢ãã¤ã³ãã©ã¨ã³ã¸ãã¢ãSREãªã©ã§ããããã¡ãããããã£ãè·ç¨®ãç®æãã¦ããæ¹ããç´ç²ã«ISUCONã«ææ¦ããããããã©ã¼ãã³ã¹ãã¥ã¼ãã³ã°ã«èå³ããããã¨ãã£ãæ¹ãå«ã¾ãã¾ãã ãã®æ¬ã¯ç¹å®ã®åé¡ã«å¯¾ããç´æ¥çãªçãã§ã¯ãªããããã©ã¼ãã³ã¹ãã¥ã¼ãã³ã°ã®èãæ¹ãæãã¦ãããå 容ã«ãªã£ã¦ãã¾ãããã®æ¬ãåèã«å®éã«æãåããã¦å®è·µããã®ãè¯ãã§ããããç¾å®ã®Webãµã¤ãããã¥ã¼ãã³ã°ããã§ãããã§ãããã
ããã«ã¡ã¯ã@igsr5 ã§ããæ®æ®µã¯ããé«å°ã®æ å ±ç§ã«éããªãããWantedly, Inc. ã§é·æã¤ã³ã¿ã¼ã³ããã¦ãã¾ããèå³é åã¯ããã³ãã»ããã¯ã¨ã³ããã¤ã³ãã©ã§ãæè¿ã¯æ¥åã§ãã£ã±ãGoãæ¸ãã¦ãã¾ããä»åã¯Goã®ããã©ã¼ãã³ã¹ãã¥ã¼ãã³ã°ã®è©±ã§ãã 対象èªè aws-sdk-go(aws-sdk-go-v2)[1] 㧠s3 ãã¦ã³ãã¼ãå¦çã®ããã©ã¼ãã³ã¹æ¹åãè¡ããã人 Go[2] ã® io ããã±ã¼ã¸ã®è©±ã«èå³ããã人 ããã¯ã¨ã³ãã®ããã©ã¼ãã³ã¹æ¹åã«èå³ããã人 TL;DR å é¨ã§ s3 ãã¦ã³ãã¼ããè¡ãããããã¯ã¨ã³ãAPI ãªã©ãèããã¨ãã // 1. Downloader ã®ä½æ downloader := s3manager.NewDownloader(sess, func(d *s3manager.Downloader) { // + ããã追å d.
ããã³ãã¨ã³ã/Node.js ã¨ã³ã¸ãã¢ã® mizchi ã§ããplaid ã§ã¯æ°ããåæã¨ã³ã¸ã³ã®ããã³ãã¨ã³ãå´ã®æè¡çãªä»æ§ãèãããããããå®è£ ããããã¦ãã¾ãã趣å³ã¨ãã¦ç¤¾å ã®ä»ã®ãããã¯ãã®ããã©ã¼ãã³ã¹ãåæã«æ¸¬ã£ã¦ãè²¼ãä»ãã¦ãããã¨ãããã¾ãã plaid ã®ã¨ã³ã¸ãã¢çµç¹ã«ã¯ãçµãã¨ããå¶åº¦ããã£ã¦ãã¡ã¤ã³ã¨ãªããããã¯ã以å¤ã«ãããã®ãã¼ãã§ä¼ç¤¾æ¨ªæã§æ´»åããã°ã«ã¼ããã
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}