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.3k
SHOWROOMエンジニアの裏側
otto0913
0
610
SHOWROOMの泥臭い負荷対策
otto0913
1
2.1k
Other Decks in Programming
See All in Programming
猫と暮らす Google Nest Cam生活🐈 / WebRTC with Google Nest Cam
yutailang0119
0
110
AIプログラマーDevinは PHPerの夢を見るか?
shinyasaita
1
210
Node-RED を(HTTP で)つなげる MCP サーバーを作ってみた
highu
0
120
『自分のデータだけ見せたい!』を叶える──Laravel × Casbin で複雑権限をスッキリ解きほぐす 25 分
akitotsukahara
2
630
Is Xcode slowly dying out in 2025?
uetyo
1
260
ISUCON研修おかわり会 講義スライド
arfes0e2b3c
1
430
LINEヤフー データグループ紹介
lycorp_recruit_jp
1
2.4k
AIともっと楽するE2Eテスト
myohei
0
360
AI時代のソフトウェア開発を考える(2025/07版) / Agentic Software Engineering Findy 2025-07 Edition
twada
PRO
77
25k
Hypervel - A Coroutine Framework for Laravel Artisans
albertcht
1
110
AIエージェントはこう育てる - GitHub Copilot Agentとチームの共進化サイクル
koboriakira
0
510
第9回 情シス転職ミートアップ 株式会社IVRy(アイブリー)の紹介
ivry_presentationmaterials
1
280
Featured
See All Featured
Agile that works and the tools we love
rasmusluckow
329
21k
Learning to Love Humans: Emotional Interface Design
aarron
273
40k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
357
30k
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
20
1.3k
A designer walks into a library…
pauljervisheath
207
24k
Building Better People: How to give real-time feedback that sticks.
wjessup
367
19k
What’s in a name? Adding method to the madness
productmarketing
PRO
23
3.5k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
31
2.4k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
29
2.7k
Imperfection Machines: The Place of Print at Facebook
scottboms
267
13k
Music & Morning Musume
bryan
46
6.6k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
45
7.5k
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