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
September 10, 2018
Programming
0
470
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
2k
SHOWROOMの"最近"の負荷対策
otto0913
1
11k
SHOWROOMの泥臭い負荷対策
otto0913
1
2k
Other Decks in Programming
See All in Programming
LOWYAの信頼性向上とNew Relic
kazumax55
4
290
質とスピード(2022春版、質疑応答用資料付き) / Quality and Speed 2022 Spring Edition
twada
PRO
27
17k
書籍『良いコード/悪いコードで学ぶ設計入門』でエンジニアリングの当たり前を変える
minodriven
3
990
あなたの会社の古いシステム、なんとかしませんか?~システム刷新から考えるDX化への道筋とバリエーション~/webinar20220420-systems
grapecity_dev
0
120
Develop your CI tools
xgouchet
2
180
Jetpack DataStore
djain2405
1
170
You CANt teach an old dog new tricks
michaelbukachi
0
110
heyにおけるSREの大切さ~マルチプロダクト運用の「楽しさ」と「難しさ」および今後の展望~
fufuhu
3
1.3k
dbtとBigQueryで始めるData Vault入門
kazk1018
0
160
C言語でメモリ管理を考えた話
hkawai
0
180
近況PHP / PHP in now a days
uzulla
3
980
From Java 11 to 17 and beyond
josepaumard
0
280
Featured
See All Featured
XXLCSS - How to scale CSS and keep your sanity
sugarenia
236
1M
Automating Front-end Workflow
addyosmani
1351
200k
The Invisible Customer
myddelton
110
11k
The Straight Up "How To Draw Better" Workshop
denniskardys
225
120k
jQuery: Nuts, Bolts and Bling
dougneiner
56
6.4k
Helping Users Find Their Own Way: Creating Modern Search Experiences
danielanewman
7
1k
ParisWeb 2013: Learning to Love: Crash Course in Emotional UX Design
dotmariusz
100
5.9k
Debugging Ruby Performance
tmm1
65
10k
A better future with KSS
kneath
225
15k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
498
130k
A Philosophy of Restraint
colly
192
14k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
237
19k
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.ɺʮΤϯλʔςΠϝϯτʯΛثʹͯ͠ɺ ҰͭҰͭண࣮ʹɺ໋Λݒ͚ͯɺٿ্ʹଘࡏ͢Δػձ֨ࠩΛແ͍͖ͯ͘͠·͢ɻ