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
11k
1
Share
SHOWROOMの"最近"の負荷対策
Streaming Conference #4 @DeNA 登壇資料
shimizu-masaya
August 31, 2018
More Decks by shimizu-masaya
See All by shimizu-masaya
SHOWROOMのDB負荷に対するキャッシュ運用のカクカクシカジカ
otto0913
0
2.3k
SHOWROOMエンジニアの裏側
otto0913
0
620
SHOWROOMの泥臭い負荷対策
otto0913
1
2.2k
Other Decks in Programming
See All in Programming
今こそ押さえておきたい アマゾンウェブサービス(AWS)の データベースの基礎 おもクラ #6版
satoshi256kbyte
1
250
Angular Signal Forms
debug_mode
0
110
How Swift's Type System Guides AI Agents
koher
0
270
Don't Prompt Harder, Structure Better
kitasuke
0
770
セグメントとターゲットを意識するプロポーザルの書き方 〜採択の鍵は、誰に刺すかを見極めるマーケティング戦略にある〜
m3m0r7
PRO
0
550
瑠璃の宝石に学ぶ技術の声の聴き方 / 【劇場版】アニメから得た学びを発表会2026 #エンジニアニメ
mazrean
0
250
AWS re:Invent 2025の少し振り返り + DevOps AgentとBacklogを連携させてみた
satoshi256kbyte
3
160
t *testing.T は どこからやってくるの?
otakakot
1
660
CursorとClaudeCodeとCodexとOpenCodeを実際に比較してみた
terisuke
1
470
GNU Makeの使い方 / How to use GNU Make
kaityo256
PRO
16
5.6k
Server-Side Kotlin LT大会 vol.18 [Kotlin-lspの最新情報と Neovimのlsp設定例]
yasunori0418
1
150
Radical Imagining - LIFT 2025-2027 Policy Agenda
lift1998
0
370
Featured
See All Featured
Leveraging LLMs for student feedback in introductory data science courses - posit::conf(2025)
minecr
1
230
Code Reviewing Like a Champion
maltzj
528
40k
How To Stay Up To Date on Web Technology
chriscoyier
790
250k
Context Engineering - Making Every Token Count
addyosmani
9
830
The Cult of Friendly URLs
andyhume
79
6.8k
Ruling the World: When Life Gets Gamed
codingconduct
0
210
Paper Plane
katiecoart
PRO
1
49k
The AI Revolution Will Not Be Monopolized: How open-source beats economies of scale, even for LLMs
inesmontani
PRO
3
3.4k
Data-driven link building: lessons from a $708K investment (BrightonSEO talk)
szymonslowik
1
1k
Highjacked: Video Game Concept Design
rkendrick25
PRO
1
340
Color Theory Basics | Prateek | Gurzu
gurzu
0
290
The innovator’s Mindset - Leading Through an Era of Exponential Change - McGill University 2025
jdejongh
PRO
1
160
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