Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
SHOWROOMの"最近"の負荷対策
Search
shimizu-masaya
August 31, 2018
Programming
1
11k
SHOWROOMの"最近"の負荷対策
Streaming Conference #4 @DeNA 登壇資料
shimizu-masaya
August 31, 2018
Tweet
Share
More Decks by shimizu-masaya
See All by shimizu-masaya
SHOWROOMのDB負荷に対するキャッシュ運用のカクカクシカジカ
otto0913
0
2.2k
SHOWROOMエンジニアの裏側
otto0913
0
560
SHOWROOMの泥臭い負荷対策
otto0913
1
2.1k
Other Decks in Programming
See All in Programming
APIのない大学ログインWebサービスをWKWebViewとJavaScriptでアプリ化した話
akidon0000
1
330
Terraformテスト入門
msato
0
520
CSC307 Lecture 07
javiergs
PRO
0
220
Android開発者のための Kotlin Multiplatform入門
ntaro
0
190
Rubyのパフォーマンスプロファイリングの改善 / Enhancing performance profiling for Ruby
osyoyu
1
410
SRE チーム立ち上げ前に考えたこと・取り組んだこと / Considerations and Preparations Before Establishing an SRE Team
mackey0225
3
320
Async Await: Mastering Python's Time-Bending Tricks - EuroPython2024
yanbo
1
290
君たちはどうコードをレビューする (される) か / 大吉祥寺.pm
utgwkk
15
8.5k
Mastering Developer Experience: A Roadmap for Success 【開発生産性Conference 2024】
findyinc
1
380
CSC307 Lecture 12
javiergs
PRO
0
220
Product Management LT会_クアンド新家
shinshin
0
210
AHC035解説
terryu16
0
710
Featured
See All Featured
Principles of Awesome APIs and How to Build Them.
keavy
124
16k
Stop Working from a Prison Cell
hatefulcrawdad
266
20k
5 minutes of I Can Smell Your CMS
philhawksworth
200
19k
Being A Developer After 40
akosma
72
580k
The Brand Is Dead. Long Live the Brand.
mthomps
52
36k
Web Components: a chance to create the future
zenorocha
307
41k
Designing the Hi-DPI Web
ddemaree
276
34k
A Tale of Four Properties
chriscoyier
155
22k
Happy Clients
brianwarren
94
6.5k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
226
52k
Rails Girls Zürich Keynote
gr2m
93
13k
A Philosophy of Restraint
colly
200
16k
Transcript
4)08300.5FDI4UVEJP SHOWROOMͷ”࠷ۙͷ”ෛՙରࡦ ࢤਫཧ࠸ 4USFBNJOH$POGFSFODF
ࣗݾհ wࢤਫཧ࠸ wࣾྺ w %F/"৽ଔೖࣾ w 4)08300.ग़ w࠷ۙͷ׆ಈ w ݄ͷࢀՃͨ͠ΞΠυϧΠϕϯτ݅
ϑΣε ϥΠϒެԋ ެԋ w ϑοταϧେձग़ճ %F/"ճ 4)08300.ճ w 4)*#6:"#*57"--&: w δίνϡʔ ࣄނҙ ͳ4)08300.ӡ༻
4)08300.ͱʁ wओʹԋऀ͕ࣗࣗͷσόΠεͰετϦʔ ϛϯά৴͢ΔΞϓϦέʔγϣϯ wԋऀૉਓ͔Βࠃຽత༗໊ਓɺόʔνϟ ϧ·Ͱ෯͘ଘࡏ ‣ ετϦʔϛϯά৴ͷࣝͷͳ͍༗໊ਓ͕ ‣ ҰਓͰ৴ΛελʔτͰ͖Δ wϥΠϒ&$͡Ί·ͨ͠
ࠓ͢͜ͱ w w લճͷొஃʢ4)08300.ͷటष͍ෛՙରࡦʣͰ͋Ε͚ͩͨ͠ͷʹؔΘΒͣɺ Ͱճτϥϒϧ͕ൃੜ wલఏ w 4)08300.ίϛϡχέʔγϣϯॏࢹͷͨΊɺԆ৴Λॏࢹ w 35.1ͱ)-4ʹΑΔ৴Λαϙʔτ
w ΦʔτεέʔϧͰؒʹ߹Θͳ͍ٸܹͳෛՙͱฃಆத w 8FSM "NPO .Z42- ʜ
ͳΜͰճτϥϒϧ ى͔ͨ͜͠ʁ
ͦΕͧΕݪҼ͕ҧ͍·͢ ݴ͍༁
τϥϒϧճ wࣄલใ͔Βաڈ࠷େڃͷϦΫΤετΛ༧ w࠷େڃͷܯռঢ়ଶͰͪߏ͑Δաڈ࠷େͷ૿Ճ෯ͰΦʔτεέʔϧ͕ ؒʹ߹Θͣʹ৴ো wػ͍ͯͨ͠ΤϯδχΞ͕खಈͰ૿ઃͯ͠ڧͰऩଋ
τϥϒϧճ w࡞ۀ࿙Ε wΦʔτεέʔϧʹΑΓऑͰऩଋ
͏ʙΜ
$%/৴͡Ί·ͨ͠ wͳΜͰࠓ·ͰΒͳ͔ͬͨͷ͔ʁ w ίϛϡχέʔγϣϯʹࢧো͕ग़ͳ͍Α͏ʹͳΔ͘ԆΛ͍ͨ͘͠ wຊʹίϛϡχέʔγϣϯʹࢧোͰΔͷ͔ʁ w ίϛϡχέʔγϣϯͷແ͍৴ w ਓ͕ଟ͗ͯ͢ίϛϡχέʔγϣϯཱ͕͠ͳ͍৴ Ԇͷࢫຯͷബ͍৴ͰτϥΠʂ
ͪΐͬͱٕज़తͳ w4)08300.ͷ༷ w 8&#αʔόʔ35.1 )-4 )-4 $%/ ͷ63-ΛҙͷΈ߹ΘͤͰΫϥ ΠΞϯτʹฦ͢͜ͱ͕Ͱ͖Δɻ w
ΫϥΠΞϯτΞϓϦ35.1 )-4ͷετϦʔϜΛ࠶ੜ͢Δ͕ɺαʔόʔ͔Β ยํ͔͠ฦ͞Εͳ͍߹ɺͦͷετϦʔϜΛ࠶ੜ͢Δ w৽͍͠ෛՙରࡦ wΫϥΠΞϯτʹ)-4 $%/ ͚ͩΛฦͯ͠$%/ͰෛՙΛΦϑϩʔυ ͤ͞Δ࡞ઓ
τϥϒϧճ w$%/৴ͷΈʹ͕͋ΓɺΦϦδϯαʔόʔ͕μϯ wػ͍ͯͨ͠ΤϯδχΞͰαʔόʔͷमਖ਼Λͯ͠ۓٸϦϦʔε wࣗମͷऩଋ·Ͱʹ
ʂ
ճͷτϥϒϧͷল wࣄલͷ֬ೝ͕͔ͬͨ w ͬͱෛՙΛݟࠐΜͩෛՙࢼݧ w৴αʔόʔམͪͳ͍ͱࢥ͍ࠐΜͰ͍ͨ w αʔόʔμϯ͠·͢ w μϯͤ͞ͳ͍Α͏ʹ͢Δ͜ͱͱಉ͘͡Β͍ɺμϯͨ࣌͠ͷରࡦΛߟ͓͑ͯ͘ ͖
࠷ۙͷ4)08300. wཧը໘͔Β৴63-ͷઃఆมߋͰ͖ΔػೳΛϦϦʔε wͷ͋ͬͨ$%/৴Λमਖ਼ CZ%F/"Πϯϑϥ wෛՙͷߴͦ͏ͳ৴ੵۃతʹ$%/৴ wԆͳ)-4Λׇத
ࠓ͔͋ͬͪʔʔʔʔʔ ճͷτϥϒϧ w%#αʔόʔͷෛՙཁҼʹΑΓ8&#αʔόʔͷԠো w Ұͭͷ৴ͷେنϦΫΤετूதͰͳ͘ɺେنͳϦΫΤετ͕ෳͷ ৴Ͱൃੜ͢Δύλʔϯ wෛՙରࡦͷઓ͍·ͩ·ͩ͜Ε͔Βͩʂ 8&# %# ৴αʔόʔ
$%/
·ͱΊ w4)08300.ͷߴτϥϑΟοΫ৴ʹର͢Δ࠷ۙͷෛՙରࡦΛհ w టष͞Λগ͠٫ w ͳΜͰԆ͕ඞཁ͔ࠓҰߟ͑Δ w αʔόʔμϯ͢Δͷͱ৺ಘΔ w μϯͨ͠߹ͷ෮چͪΌΜͱݕ౼͓ͯ͘͠
4)08300.ͷߴτϥϑΟοΫ͍ͯ͞Έ͍ͨਓʂ ϑοταϧ͍ͨ͠ਓʂ ืूͯ͠·͢ɻ IUUQTXXXXBOUFEMZDPNDPNQBOJFTTIPXSPPNMJWFQSPKFDUT