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
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
React Native에 현대적인 빌드 도구 더하기: Rollipop 구현기
leegeunhyeok
0
180
Event is what happens
moro
2
4.1k
Vue.jsで作る空間解析アプリとCapacitorプラグインのData Bridge
hal_spidernight
1
170
Optunaを作ったときにやりたかったこと、その後 (2026/10/16, Optuna Meetup #3)
iwiwi
4
1.5k
Web3Dライブラリを作ってVue Custom Rendererの仕組みを理解しよう / lets learn vue custom renderer by making 3d library
drumath2237
1
130
Kawaiicon: Kubernetes, it's no longer cool, but let's secure it anyway!
barnbarn
0
130
graphql-ruby を Spinel で速くしようとした話
mtsmfm
0
140
オーケストレーション記述言語 Katari
yukikurage
0
250
Claude Code ハーネスDeep Dive – 君はどこまで制御する? -
takateeen_knj
6
5.1k
Python Lambdaにおけるテストしやすい設計とAI支援の活用 / Designing Testable Python Lambda Functions with AI
kitano_yuichi
1
310
学びを記事・スライド・Xへ高速展開する― AI-assisted Learning Loopで回すコンテンツ生成術
ochtum
0
200
Rails初心者がパスキーを実装してみて大変だったこと
ktombow
0
160
Featured
See All Featured
We Have a Design System, Now What?
morganepeng
55
8.4k
Exploring the relationship between traditional SERPs and Gen AI search
raygrieselhuber
PRO
4
4.4k
The Curious Case for Waylosing
cassininazir
1
610
How to Align SEO within the Product Triangle To Get Buy-In & Support - #RIMC
aleyda
2
1.9k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
56
3.5k
Unsuck your backbone
ammeep
672
58k
Bridging the Design Gap: How Collaborative Modelling removes blockers to flow between stakeholders and teams @FastFlow conf
baasie
0
760
BBQ
matthewcrist
90
10k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
659
62k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
133
20k
Code Review Best Practice
trishagee
74
20k
How to audit for AI Accessibility on your Front & Back End
davetheseo
0
630
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 ɾ৬छΛ͑ͨܨ͕Γ͕ڧݻʹ ɾձࣾΛ͑ͯܨ͕͍͍ͬͯ͡Όͳ͍ʂ ɹɹˠԆઢ্Ͱొஃͷػձʹʂ ɾࣄ৬ָ͘͠ͳΔ ɹɹˠۀҎ֎ͷίϛϡχέʔγϣϯ૿͑ɺ ɹɹɹൣғ֎ͷۀͷ߅ݮΔ Φεεϝ͍ͨ͜͠ͱ
Έͳ͞Μͥͻ ύʔτφʔΛ ݟ͚ͭͯ
ྑ͍νʔϜ"Λ ߏஙͯ͠
ΤϯδχΞϦϯάͰ ղܾͰ͖Δ͜ͱΛ ૿͍͖ͯ͠·͠ΐ͏ʂ
͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ