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
September 10, 2018
Programming
0
550
SHOWROOMエンジニアの裏側
BIT VALLEY 2018 SHOWROOM紹介資料
https://sbv.connpass.com/event/95341/
shimizu-masaya
September 10, 2018
Tweet
Share
More Decks by shimizu-masaya
See All by shimizu-masaya
SHOWROOMのDB負荷に対するキャッシュ運用のカクカクシカジカ
otto0913
0
2.2k
SHOWROOMの"最近"の負荷対策
otto0913
1
11k
SHOWROOMの泥臭い負荷対策
otto0913
1
2.1k
Other Decks in Programming
See All in Programming
DMMプラットフォームがTiDB Cloudを採用した背景
pospome
8
4k
OpenAPIを中心に考えるAPI開発入門 / Introduction to API Development with a Focus on OpenAPI
seike460
PRO
2
170
PostmanでAPIの動作確認が楽になった話
h455h1
0
170
使ってみよう Azure AI Document Intelligence
kosmosebi
2
300
効率化に挑戦してみたらモバイル開発が少し快適になった話
ryunakayama
0
130
1BRC--Nerd Sniping the Java Community
gunnarmorling
0
340
try! Swift Tokyo 2024 参加報告 / try! Swift Tokyo 2024 Report
hironytic
0
200
Snowflakeで眠ったデータを起こそう!
estie
0
110
Ruby GitHub Packages
bkuhlmann
0
630
HUIT新歓2024「競技プログラミング、やってみませんか?」
slephy2784
1
270
サイコロで理解する統計的仮説検定の考え方
tatamiya
4
910
FigmaとPHPで作る1ミリたりとも表示崩れしない最強の帳票印刷ソリューション
ttskch
43
19k
Featured
See All Featured
Faster Mobile Websites
deanohume
299
30k
Building a Modern Day E-commerce SEO Strategy
aleyda
17
6.4k
Atom: Resistance is Futile
akmur
259
25k
CSS Pre-Processors: Stylus, Less & Sass
bermonpainter
352
28k
Fireside Chat
paigeccino
21
2.6k
The Straight Up "How To Draw Better" Workshop
denniskardys
227
130k
[RailsConf 2023] Rails as a piece of cake
palkan
23
3.9k
Stop Working from a Prison Cell
hatefulcrawdad
266
19k
The Invisible Side of Design
smashingmag
294
49k
5 minutes of I Can Smell Your CMS
philhawksworth
199
19k
Documentation Writing (for coders)
carmenintech
60
3.9k
What's new in Ruby 2.0
geeforr
337
31k
Transcript
4)08300.ΤϯδχΞͷཪଆ 4)08300.5FDI4UVEJP ࢤਫཧ࠸
ࣗݾհ ࢤਫཧ࠸ ͠Έͣ·͞ ུྺ ֶੜ࣌ιϑτΣΞֶΛઐ߈ %F/"ͷΤϯδχΞαϚʔΠϯλʔϯࢀՃ %F/"ʹೖࣾɺ৽نιʔγϟϧήʔϜͷ։ൃӡ༻ʹैࣄ 4)08300.ʹग़ ͖ͳݴ༿
ʮδμϯϥϧͷΑ͏ͳඒ͠͞ͳ͍͔Βɺ͕ͨͩΉ͠ΌΒʹؤுΔ͚ͩ͞ʯ CZ1BWFM/FEWⒿE ʮటषͪ͘ΌͩΊͰ͔͢ʁʯCZ4BSJOB4PEB
None
4)08300.ͱ ୭ͰແྉͰϥΠϒ৴ˍࢹௌ͕ Ͱ͖ΔϥΠϒ৴αʔϏε
4)08300.ͱ ϦΞϧλΠϜͷίϛϡχέʔγϣϯʹΑΓ ੜ·ΕΔྔͷߴ͍ͭͳ͕Γ͕ 4)08300.ͷັྗ Ϊϑτ Ξόλʔ
ഔମن ˔ྦྷܭμϯϩʔυສ%- ˔ձһొສʹٴͿنͰٸத ˔௨ࢉϧʔϜ Ҏ্
4)08300.ͷେಛ ϦΞϧλΠϜͷަྲྀ ࢹௌऀͷՄࢹԽ ετʔϦʔग़ ϦΞϧλΠϜͷަྲྀͰੜ·ΕΔڧ͍ྟײҰମײ͕ɺ ϑΝϯͷߴ͍ྔΛੜΈग़͠·͢ɻ ࢹௌऀΛΞόλʔίϝϯτͰՄࢹԽ͢Δ͜ͱͰɺ ϦΞϧͳࢀՃײΛ࣮ݱɻ ৴ऀ͕ઓ͢ΔΦʔσΟγϣϯͷଘࡏ͕ϦΞϧυϥϚΛੜΈɺ ϑΝϯͷڧ͍ײҠೖΛଅ͠·͢ɻ
ࡶࢽ ܝࡌ ΦʔσΟγϣϯ $. ग़ԋ ΦʔσΟγϣϯ ΦʔσΟγϣϯ
4)08300.ͷେಛ ϦΞϧλΠϜͷަྲྀ ࢹௌऀͷՄࢹԽ ετʔϦʔग़ ͭͷཁૉ͕ αΠΫϧͱͳΓ ྔͷߴ͍ͭͳ͕ΓΛ ੜΈग़͢
Ԡԉͱʁ ৴ऀɿເΛ͔ͳ͍͑ͨਓ ΞΠςϜΛΪϑςΟϯά ˓˓ͪΌΜ͕Ұ൪ՄѪ͍Α͒ ࠓ৴͓ർΕ༷ʔ ίϝϯτͷૹ৴ ເΛ͔ͳ͍͑ͨͱࢥ͏ਓ͕ͨͪɺԾ ۭؒͰϥΠϒ৴Λߦ͍Ϣʔβʔ ϑΝ ϯ
͔ΒͷίϝϯτΪϑςΟϯάΛड ͚औΔ͜ͱ͕Ͱ͖·͢ɻ ԠԉԽ͞Εͯ݅ୡͷఆ ϥϯΫ͚͕͞Ε·͢ɻ
ΤϯδχΞϦϯάͰྗΛ͍Ε͍ͯΔͱ͜Ζ
ΤϯδχΞϦϯάͰྗΛೖΕ͍ͯΔͱ͜Ζ ϙΠϯτ⁞ ԋऀͱࢹௌऀͷίϛϡχέʔγϣϯ͕ औΓ͍͢͜ͱ 4)08300.)-4ΑΓҰൠతʹԆͷ গͳ͍35.1ʹΑΔࢹௌαϙʔτ͍ͯ͠Δ ίϛϡχέʔγϣϯΛॏࢹ͍ͨ͠ͷͰߴը࣭Α ΓԆʹॏ͖Λஔ͍͍ͯΔ Ԇ৴
ΤϯδχΞϦϯάͰྗΛೖΕ͍ͯΔͱ͜Ζ ϙΠϯτ ԋऀ͕τϥϒϧͳ҆͘৺ͯ͠৴Ͱ͖Δ͜ͱ ෛՙରࡦ w Φʔτεέʔϧ͕ؒʹ߹Θͳ͍͜ͱ͕༧ظ ͞ΕΔ߹खಈ૿ઃ w ԆͰͳ͍͍ͯ͘߹$%/Λ׆༻ ͨ͠৴
w %#ͷΫΤϦνϡʔχϯάʹΑΔεϩ ΫΤϦͷ໓ w .FNDBDIFEΛར༻ͨ͠Ωϟογϡઓུ w 2.ʹΑΔඇಉظॲཧ ৴αʔόʔ 8&#αʔόʔ
ඒഽϑΟϧλ͕ΑΓࣗΛඒ͘͠৴Ͱ͖ΔͷͰɺ ৴ϋʔυϧ͕Լ͕Δ͔͠Εͳ͍Ծઆͷͱɺ zͬͯΈͨzϕʔεͰ։ൃϑΟʔυόοΫରԠ Λܦ݄ͯʹϦϦʔε ΤϯδχΞϦϯάͰྗΛೖΕ͍ͯΔͱ͜Ζ ϙΠϯτ ΤϯδχΞൃ৴ɺΤϯδχΞओಋͷ৽ػೳ։ൃ 4)08300.7BMVFT ߦಈࢦ ˙*NBHJOBUJPOࢥ͍Γͱଞऀͷ૾ྗ
˙*TTVFղ͖͍͘ͱԾઆͷઃܭ ˙&⒎PSUྗʹཪΒͤͳ͍ ඒഽػೳ
ӡ༻ମ੍
ӡ༻ମ੍ %JSFDUPS %FTJHOFS "QQ4FSWFS&OHJOFFS 8FC'SPOU&OHJOFFS J04&OHJOFFS "OESPJE&OHJOFFS *OGSBTUSVDUVSF&OHJOOFS 2VBMJUZ"TTVSBODF&OHJOFFS $VTUPNFS4VQQPSU
7JSUVBMࣄۀ Πϯϑϥɺ࣭ཧɺΧελϚʔαϙʔτ%F/"ʹۀ ҕୗɻओʹTMBDLͰίϛϡχέʔγϣϯΛͱΔ͕ඞཁʹ Ԡͯ͡ԟ๚.5(Λ͢Δɻ57ձٞʹΑΔఆྫ.5(࣮ࢪɻ
4)08300.ͷ։ൃ ͨͩͷ࡞ۀऀʹͳΒͳ͍ ҙࢥΛ࣋ͬͯϓϩδΣΫτʹࢀՃ͢Δ ΤϯδχΞϝϯόʔൃҊͷػೳଟ࣮͋Γ λεΫཧ +*3" ʑͷίϛϡχέʔγϣϯ 4MBDL ϥϯνɾҿΈձ ձٞମ
ि࣍ͷϓϩμΫτఆྫ ि࣍ͷΤϯδχΞఆྫ ֤ϓϩδΣΫτຖͷఆྫ
ྗ͕ϑΣΞʹ ใΘΕΔࣾձΛΔ ͋ΒΏΔਓ͕ۉʹνϟϯεΛಘͯɺͨ͡ྗྔʹԠͯ͡ใΘΕɺເ͕͍ͬͯ͘ɻ ͦΜͳɺެฏͰԹ͔͍ੈͷதΛΔ͜ͱ͕ɺ 4)08300.ͷϛογϣϯͰ͋ΓɺଘࡏҙٛͰ͢ɻ ͜Ε͔Βզʑ4)08300.ɺʮΤϯλʔςΠϝϯτʯΛثʹͯ͠ɺ ҰͭҰͭண࣮ʹɺ໋Λݒ͚ͯɺٿ্ʹଘࡏ͢Δػձ֨ࠩΛແ͍͖ͯ͘͠·͢ɻ