Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
what-you-did-with-non-engineers-to-solve-with-e...
Search
Sponsored
·
Ship Features Fearlessly
Turn features on and off without deploys. Used by thousands of Ruby developers.
→
mamy1326
June 23, 2018
Programming
460
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
what-you-did-with-non-engineers-to-solve-with-engineering-infra-half-year-offline-event
2018年6月23日(土)、インフラ勉強会 半年記念オフライン企画で発表したLTの内容です。
mamy1326
June 23, 2018
More Decks by mamy1326
See All by mamy1326
PHPer が知るべき MySQL クエリチューニング/What PHPers Need to Know about MySQL Query Tuning
mamy1326
18
8.3k
戦って品質保証を勝ち取る/Fight_for_quality_assurance
mamy1326
2
950
MySQLでGROUP BY と ORDER BY を同時に使いたくなったら/If_you_want_to_use_GROUP_BY_and_ORDER_BY_at_the_same_time_in_mysql
mamy1326
4
6.4k
初めてのMySQLパフォーマンスチューニングーデータベースは怖くない!/mysql-performance-tuning-basics-in-db-study-chugoku-chiho
mamy1326
8
3k
アウトプットを継続するためにやる10箇条-吉祥寺.pm-/10_things_practicing_to_continue_output-in_kichijoji.pm
mamy1326
4
2.4k
MySQLパフォーマンスチューニングの基本ー実際のトラブルシュートから my.cnf までー/MySQL_Performance_Tuning_Basics_in_OSC_Niigata
mamy1326
2
3.8k
アウトプットを継続するためにやっている 10 のこと/10_things_practicing_to_continue_output
mamy1326
21
9.7k
アプリケーションエンジニアが知るべきDNSの基本/Basics_of_DNS_that_application_engineers_should_know
mamy1326
113
48k
dns-penetration-problem-why-can-not-i-say-penetration-kichijojipm15
mamy1326
5
4.1k
Other Decks in Programming
See All in Programming
[DroidKnights 2026] Workflow AX: From Auto-Documented Policies to E2E Testing
raeminkang
0
500
Vue.jsで作る空間解析アプリとCapacitorプラグインのData Bridge
hal_spidernight
1
160
Seven New Principles of Software Engineering
yegor256
0
440
コーディング自動化の次へ。人の介入をゼロにするファクトリーとサポートAIによる実践
timakin
5
5.1k
React Native에 현대적인 빌드 도구 더하기: Rollipop 구현기
leegeunhyeok
0
180
AI駆動開発4年目の現在地(『あなたはFDEになるべきか?』イベント資料)
kumaiu
0
130
自作Discord音声botをLambda MicroVMsに移行した話 / Migrating My Discord Voice Bot to Lambda MicroVMs
akihisaikeda
1
250
AI時代のTerminal環境を UNIX哲学で設計・運用する
yasunori0418
1
340
3回つくってわかった、 定期実行ジョブ基盤の本質情報
takai
4
3.6k
當我們開始不讀 Code - AI Agent 時代,Code Review 與 Clean Code 還剩下什麼?
jame2408
1
360
Lambda durable functionsでHuman in the Loopを楽に…楽に……
har1101
2
260
社内AIエージェント「Askワンバン」における コストチューニングの取り組み
t0yohei
0
150
Featured
See All Featured
The Art of Delivering Value - GDevCon NA Keynote
reverentgeek
16
2.2k
Docker and Python
trallard
47
4.2k
Taking LLMs out of the black box: A practical guide to human-in-the-loop distillation
inesmontani
PRO
3
2.5k
The Psychology of Web Performance [Beyond Tellerrand 2023]
tammyeverts
49
3.6k
The Pragmatic Product Professional
lauravandoore
37
7.5k
WENDY [Excerpt]
tessaabrams
14
40k
エンジニアに許された特別な時間の終わり
watany
109
250k
Leading Effective Engineering Teams in the AI Era
addyosmani
9
2.8k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
287
14k
Effective software design: The role of men in debugging patriarchy in IT @ Voxxed Days AMS
baasie
1
600
StorybookのUI Testing Handbookを読んだ
zakiyama
31
7k
Thoughts on Productivity
jonyablonski
76
5.4k
Transcript
ΤϯδχΞϦϯά Ͱղܾ͢ΔͨΊʹ ඇΤϯδχΞͱ Ұॹʹͬͨ͜ͱ ·Έͳ͓͖ !NBNZ +VOΠϯϑϥษڧձ!ه೦ΦϑϥΠϯاը
ࣗݾհ Name ɿ·Έͳ͓͖ Twitterɿ@mamy1326ʢ·Έʔʣ - WebΤϯδχΞɺPHPer - 2017 MySQL͕झຯ -
2018 DNSͱωοτϫʔΫ͕झຯ
͓ͯ ͏Β
ຊ ࣋ͪؼͬͯ ͍ͨͩ͘͜ͱ
ඇΤϯδχΞͱ าΈدΔ
าΈدΔ͜ͱ ͦΕ͕νʔϜ
͓͢Δ͜ͱ ▶︎ ͡Ίʹ ▶︎ ޓ͍ʹ๊͑Δ՝ͱΈ ▶︎ ͬͨ͜ͱᶃʙᶆ ▶︎ ݁Ռ ▶︎
มΘͬͨ͜ͱɺΦεεϝ͍ͨ͜͠ͱ
͓͢Δ͜ͱ ▶︎ ͡Ίʹ ▶︎ ޓ͍ʹ๊͑Δ՝ͱΈ ▶︎ ͬͨ͜ͱᶃʙᶆ ▶︎ ݁Ռ ▶︎
มΘͬͨ͜ͱɺΦεεϝ͍ͨ͜͠ͱ
⾣ΤϯδχΞϦϯάͰղܾ͢Δʹ ɾεςʔΫϗϧμʔͱࢹ࠲Λڞ༗ ɹɹˠಛʹσΟϨΫλʔ ɾޓ͍ͷٕज़Λຖ-5͋͠͏ ૬ޓཧղΛਂΊॏͳΓΛ͛Δ ͡Ίʹ
͓͢Δ͜ͱ ▶︎ ͡Ίʹ ▶︎ ޓ͍ʹ๊͑Δ՝ͱΈ ▶︎ ͬͨ͜ͱᶃʙᶆ ▶︎ ݁Ռ ▶︎
มΘͬͨ͜ͱɺΦεεϝ͍ͨ͜͠ͱ
⾣σΟϨΫλʔͷ՝ͱΈ ɾΤϯδχΞ͕࡞ۀݟੵ ɾΫϥΠΞϯτͱΤϯδχΞͷཱͪ ɾ͔͠͠σΟϨΫλʔΤϯδχΞͰͳ͍ ݟੵଥʁ ͦΜͳʹେมͳ࡞ۀʁ ޓ͍ʹ๊͑Δ՝ͱΈ
⾣ΤϯδχΞͷ՝ͱΈ ɾσΟϨΫγϣϯͬͯԿ͢Ε͍͍ͷʁ ɾϦʔμʔγοϓͬͯ۩ମతʹͳΜͩΖ͏ ɾΫϥΠΞϯτͷલ໘ʹཱ͍ͬͯͳ͍ ɹɹˠཁ݅ΛऔΓ͜΅͢໘͕ ΫϥΠΞϯτରԠ͍͖ͭͤΓ ޓ͍ʹ๊͑Δ՝ͱΈ
ڞ௨ͷࢥ͍ɻ ɹʰޓ͍ͷۀΛ ɹɹͪΌΜͱΓ͍ͨʂʱ
͓͢Δ͜ͱ ▶︎ ͡Ίʹ ▶︎ ޓ͍ʹ๊͑Δ՝ͱΈ ▶︎ ͬͨ͜ͱᶃʙᶆ ▶︎ ݁Ռ ▶︎
มΘͬͨ͜ͱɺΦεεϝ͍ͨ͜͠ͱ
⾣૬ஊͨ͠ ɾϦʔυσΟϨΫλʔͱϥϯν ɾޓ͍ͷΓ͍ͨ͜ͱ͕Θ͔ͬͨ ɾ൴ʹʮॳֶˠख़࿅ʹʯڭҭܦݧ͕͋ͬͨ ՝ਤॻΛܾΊͨ ͬͨ͜ͱᶃ
⾣՝ਤॻ ͬͨ͜ͱᶃ ৬छ ՝ਤॻ બఆཧ༝ ΤϯδχΞ ؒ%/4جૅߨ࠲ %/4Λ͡ΊΑ͏ ωοτϫʔΫͷجૅ͕ࣝͳ͍ ͜ͱ͕Έͩͬͨ
ˍ ӡӦࢹͰσΟϨΫλʔ %/4ใΛཉ͍ͯͨ͠ σΟϨΫλʔ εϞʔϧϦʔμʔγοϓ ΤϯδχΞϦϯά ɹɹɹɹ৫ͷট Ϧʔμʔγοϓ৫࡞Γʹ՝ ͕͋ͬͨ ˍ ΤϯδχΞ͕Ϧʔμʔ৫ܗ ͷࢹΛཉ͍ͯͨ͠
⾣ຖ-5͋ͬͨ͠ ɾ՝ਤॻΛʮઈରʹ͔ܽͣ͞ʯຖಡΉ ɹɹˠຖʢܧଓͰ͖Δઈົͳ࣌ؒʣ ɾಡΜͩ༰ΛFTBʹ·ͱΊΔ ɾ૬ख͕ཧղͰ͖ΔΑ͏ʹ-5͋͠͏ ɹɹˠޓ͍ʹײΛަɺ࣭ٙԠΛ͢Δ ࣗݾֶशͱ૬ޓཧղ͕࢝·ͬͨ ͬͨ͜ͱᶄ
⾣ϲ݄ܧଓ͢Δ ɾటਲ͠Α͏͕ମௐѱ͔Ζ͏͕ඞֶͣश ɹɹˠ-5ۀͷ߹Λߟ͑ͯՄೳͳݶΓ ɾॕֶश͢Δ ɾͱʹ͔͘श׳ʹ͢Δ ɹɹˠֶͼ͕ήʔϜײ֮ʹͳΓɺΓͨ͘ͳΔ ʑָ͘͠ͳ͍ͬͯ͘ ͬͨ͜ͱᶅ
⾣݄ʹͷ,15 ɾܧଓͨ͜͠ͱʹΑΔ,FFQ ɹɹˠಘΒΕͨ͜ͱɺมΘͬͨ͜ͱ ɾͬͯΈͯײͨ͡1SPCMFN ɾͱʹ͔͘ϙδςΟϒʹ5SZ ϲ݄લͱҧ͏ࣗͷൃݟ ͬͨ͜ͱᶆ
͓͢Δ͜ͱ ▶︎ ͡Ίʹ ▶︎ ޓ͍ʹ๊͑Δ՝ͱΈ ▶︎ ͬͨ͜ͱᶃʙᶆ ▶︎ ݁Ռ ▶︎
มΘͬͨ͜ͱɺΦεεϝ͍ͨ͜͠ͱ
⾣ωοτϫʔΫͷجૅ͕ʹ͍ͭͨ ɾ5$1*1ͷཧղ͕ਂ·ͬͨ ɹɹˠ֓ཁΛֶͼɺ-5͢ΔʹࢸͬͨʢϚαΧϦΒͬͨX ɾ%/4ͷجૅ͕Θ͔Γɺۀʹཱͬͨ ɹɹˠτʔΫΛ͢ΔʹࢸΓɺΠϯϑϥษڧձͰొஃ ɾσΟϨΫλʔ͕5$1*1ͱ%/4Λཧղ ͦΜͳʹ͔͔Δʁ͔ΒʮͳΔ΄Ͳ͔͔Δʯ ݁Ռ
⾣Ϧʔμʔγοϓͷࢹ࠲্͕͕ͬͨ ɾجຊతͳࢹ্ ɾνʔϜͱ৫ͷΛ࠶ೝࣝ ɾςΫχΧϧσΟϨΫλʔͱͯ͠ͷֶͼ ɹɹˠΫϥΠΞϯτͷ՝ղܾҙ্ࣝ ৫ʹର͢Δࢹ࠲ͷڞ༗ ݁Ռ
⾣θϩඵࢥߟ͕ʹ͍ͭͨ ɾ-5ͷޙʹؒɺθϩඵࢥߟΛ࣮ફ ɾࢥߟͷ্ ɹɹˠ՝ׂɺৼΓฦΓ͕త֬ʹ ɾ.5(Ͱͷൃݴ্ ɹɹˠࢥߟ͕ͬ͢ͱܗʹͳΓɺݴ༿ʹͳΓ͍͢ ࣌ؒΛޮతʹ͑ΔΑ͏ʹ ݁Ռ
͓͢Δ͜ͱ ▶︎ ͡Ίʹ ▶︎ ޓ͍ʹ๊͑Δ՝ͱΈ ▶︎ ͬͨ͜ͱᶃʙᶆ ▶︎ ݁Ռ ▶︎
มΘͬͨ͜ͱɺΦεεϝ͍ͨ͜͠ͱ
⾣ڵຯΛ࣋ͭਓ͕૿͑ͨ ɾใʹॻ͍ͯΈͨ ɹɹˠڌʢ౦ژɾԬʣɺ৬छΛ͑ͯʹͳͬͯͨ ɾࣾษڧձ͕ΑΓೝ͞Εͨ ɹɹˠશମࠂ͞Εͳ͍ษڧձ͕ଟ͔ͬͨͷ͕มΘΓ࢝Ίͨ ɾԣల։͕࢝·ͬͨ ৫શମͷఈ্͛ʹܨ͕ͬͨ มΘͬͨ͜ͱ
⾣ࢹ࠲͕ڞ༗Ͱ͖ΔΑ͏ʹͳͬͨ ɾΤϯδχΞͷ࡞ۀͷཧղ ɹɹˠݟੵΓΛղઆ͠ͳ͍͍ͯ͘໘͕૿͑ͨ ɾσΟϨΫλʔͷۀͷཧղ ɹɹˠΫϥΠΞϯτͷڮ͠Λੵۃతʹ࣮ࢪ͢ΔΑ͏ʹ ɾϦʔμʔγοϓɺϚωδϝϯτΛҙࣝ ৫ͷ՝ΛΑΓҙࣝ͢ΔΑ͏ʹ มΘͬͨ͜ͱ
⾣૬ޮՌ ɾཧղ͠߹͑Δʢ৬छΛӽ͑ͯʣ ɾϙδςΟϒͳධՁʢධՁ໘ஊʣ ɾԣల։Ͱ͖Δࢿྉʢڭҭ༻ʣ ɾίϛϡχέʔγϣϯʢ໌Β͔ʹ૿Ճʣ ɾֶश͕श׳Խʢຊʹຖʣ มΘͬͨ͜ͱ
⾣૬ޮՌ ɾֶशͷήʔϜԽʢָ͍͠ʂʣ ɾઌʑͷܭըʢܭըʹ߹Θͤͯʣ ɾੜ׆श׳ͷվળʢֶश࣌ؒͷҙࣝʣ ɾҰੴOௗʢָ͍͠ʂʣ ɾFUDʜ มΘͬͨ͜ͱ
⾣ύʔτφʔΛݟ͚ͭΑ͏ʂ ɾΈͷڞ༗Ͱ૬ޓཧղ ɹɹˠΠϯϓοτͱΞτϓοτͷ܁Γฦ͠ɹʴɹϓϨθϯྗ61 ɾ৬छΛ͑ͨܨ͕Γ͕ڧݻʹ ɾձࣾΛ͑ͯܨ͕͍͍ͬͯ͡Όͳ͍ʂ ɹɹˠԆઢ্Ͱొஃͷػձʹʂ ɾࣄ৬ָ͘͠ͳΔ ɹɹˠۀҎ֎ͷίϛϡχέʔγϣϯ૿͑ɺ ɹɹɹൣғ֎ͷۀͷ߅ݮΔ Φεεϝ͍ͨ͜͠ͱ
Έͳ͞Μͥͻ ύʔτφʔΛ ݟ͚ͭͯ
ྑ͍νʔϜ"Λ ߏஙͯ͠
ΤϯδχΞϦϯάͰ ղܾͰ͖Δ͜ͱΛ ૿͍͖ͯ͠·͠ΐ͏ʂ
͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ