Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
SHOWROOMの"最近"の負荷対策
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
2k
SHOWROOMエンジニアの裏側
otto0913
0
470
SHOWROOMの泥臭い負荷対策
otto0913
1
2k
Other Decks in Programming
See All in Programming
WindowsコンテナDojo:第2回 Windowsコンテナアプリのビルド、公開、デプロイ
oniak3ibm
PRO
0
130
tfcon2022_Web3Dひとめぐり.pdf
emadurandal
0
560
microCMS × Shopifyで、ECサイトがリニューアル後急成長した話
microcms
0
440
Android Architecture Design With Koin
agiuliani
0
200
Kueue入門/Kueue Introduction
bells17
0
500
The future of trust stores in Python
sethmlarson
0
180
職場にPythonistaを増やす方法
soogie
0
170
Explore Java 17 and beyond
josepaumard
3
600
型パラメータが使えるようになったのでLINQを実装してみた
makki_d
2
500
Get Ready for Jakarta EE 10
ivargrimstad
0
1.7k
Jakarta EE 10 is Coming Your Way
ivargrimstad
0
1.6k
クリエイティブ系のウェブサイト制作で役立つCSS技法 / CSS for develop creative website
clockmaker
2
1.1k
Featured
See All Featured
Building Adaptive Systems
keathley
25
1.1k
Why You Should Never Use an ORM
jnunemaker
PRO
47
5.5k
Robots, Beer and Maslow
schacon
152
7.1k
The Most Common Mistakes in Cover Letters
jrick
PRO
4
24k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
15
900
Practical Orchestrator
shlominoach
178
8.6k
Navigating Team Friction
lara
175
11k
Faster Mobile Websites
deanohume
294
28k
The Straight Up "How To Draw Better" Workshop
denniskardys
225
120k
JazzCon 2018 Closing Keynote - Leadership for the Reluctant Leader
reverentgeek
172
8.3k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
237
19k
Bootstrapping a Software Product
garrettdimon
294
110k
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