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
tcpdump
Server load monitoring top iftop
Understanding server configuration
Nginx vs. h2o
Reference materials
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
我々はどのように冗長化を失敗したのか
Q) Why not use LVS? A) You’re right.
Reference materials
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”
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.