Looking back at the final day of “YAPC::Asia Tokyo 2015”.

ISUCONの勝ち方

How to proceed with tuning

Understanding the problem Profiling Knowing what’s happening in the web application

You also need to get used to reading profiling results

matsuu/kataribe Nginx/Apache Log Profiler

MySQL SlowLog analysis Query execution frequency and count

Application profiling

• For Node.js, this maybe? ➔ Debugging & Profiling Node.js

Use tools for each programming language strace

• strace コマンドの使い方をまとめてみた - sonots:blog

tcpdump

Server load monitoring top iftop

Understanding server configuration

Nginx vs. h2o

Reference materials

• h2o/h2o
• Kazuho's Weblog: なぜ今、新しいHTTPサーバが必要なのか - H2O について勉強会で話したこと

MySQL offset becomes slow when the number of records increases

Reference materials

• 【MySQL】大量データで LIMIT と OFFSET を使うと遅い - pospomeのプログラミング日記
• YappoLogs: なぜ SQL_CALC_FOUND_ROWS や LIMIT OFFSET のページングが良く無いのか

Let’s use Covering Index.

Reference materials

• MySQLでインデックスを使って高速化するならCovering Indexが使えそう - (ﾟ∀ﾟ)o彡 sasata299's blog

---

我々はどのように冗長化を失敗したのか

Q) Why not use LVS? A) You’re right.

Reference materials

• Linux Virtual Server - Wikipedia

---

MySQLで2億件のシリアルデータと格闘したチューニングの話

TL;DR

It’s difficult to handle large amounts of data with limited server resources

---

データ分析基盤を支える技術

TL;DR

• Stop building data analytics platforms
• Leave it to cloud vendors
• Use cloud vendors for what you want to achieve

“Want to have Hadoop in-house? Don’t do it!”

---

【特別企画】YAPCあるある（仮）

CONBU

“A group of network engineers who build conference networks and provide internet connectivity at venues where large conferences and study groups are held”

• CONBU - COnference Network BUilders :: ホーム

Impression

I learned about CONBU for the first time. Thank you for building the network within the YAPC venue.

And thank you to everyone involved in organizing YAPC.

---

HTTP2 時代の Web

• Slides: HTTP2 時代の Web - web over http2

Personal notes

• Regarding Browser Cache, 75% of people use it up in 48h.
• Infrastructure implementation is in a transitional period

---

Lightning Talks Day 2

MySQL 5.7 has many traps, so secret sauce configuration files are desperately needed.

---

クロージング

---

Summary

I was able to get good inspiration by participating in an event where over 2000 engineers gathered. Thank you to all the organizing members!

Just being able to pick up keywords for technical topics I wasn’t tracking or understanding was a harvest. It’s impossible to follow everything, so I want to narrow down to necessary things and catch up from here.

That’s all from the Gemba.