Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

YAPC::Tokyo 2019 Log Friendly DB Design

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for fisto fisto
January 26, 2019
Programming
2.8k
1

YAPC::Tokyo 2019 Log Friendly DB Design

ログにやさしいDB設計

Avatar for fisto

fisto

January 26, 2019

Other Decks in Programming

See All in Programming
更なる可用性を求めて、5年間運用したKotlinのアプリケーションをGoでリプレイスする話
Avatar for Kensuke Taguchi ken_tunc
0
470
半永久的に提供し続けられるプライベートクラウドを目指して ― 利用者の認知負荷を抑えるAPI抽象化とハードウェア世代交代の基盤設計
Avatar for Tomofumi Kondo tomokon
0
470
Are APIs Still Relevant in the AI Era?
Avatar for Antoine Bluchet soyuka
0
450
re:Inventに行く前に知っておきたい現地参加のノウハウ
Avatar for nokomoro3 nokomoro3
0
400
APNsからLive Activityを開始する話
Avatar for Ryotaro Onoue yumnumm
0
160
setup-vp GitLab対応の裏側
Avatar for Naoki Haba naokihaba
0
160
個人開発者よ、Honoを使え（おじさんver）
Avatar for tanahiro2010 tanahiro2010
2
210
カツオ、ご期待ください
Avatar for saku_totomi suneo3476
0
160
コードで差別化できない時代の ソフトウェアエンジニアリング / Software Engineering in an Era Where Code Doesn’t Differentiate
Avatar for Naoki Kishida kishida
2
140
Embedded Swiftで作る自作USBデバイス によるiOSデバイスの自動テスト / iOSDC Japan 2026 glassfiber
Avatar for glassfiber glassfiber
0
320
【加筆修正版】Laravel のアプリケーションをどこにデプロイするか #phpcon_ehime
Avatar for akase244 akase244
0
150
Agents on Rails - Rails at Scale 2026
Avatar for Irina Nazarova irinanazarova
0
530

Featured

See All Featured
How People are Using Generative and Agentic AI to Supercharge Their Products, Projects, Services and Value Streams Today
Avatar for Helen Beal helenjbeal
2
360
Documentation Writing (for coders)
Avatar for Carmen Chung carmenintech
77
5.6k
[Rails World 2026] Durable orchestration on Rails: from continuation to workflow
Avatar for Vladimir Dementyev palkan
1
690
Google's AI Overviews - The New Search
Avatar for Barry Adams badams
0
1.6k
Building the Perfect Custom Keyboard
Avatar for Naoto Takai takai
2
900
Connecting the Dots Between Site Speed, User Experience & Your Business [WebExpo 2025]
Avatar for Tammy Everts tammyeverts
11
1.1k
ReactJS: Keep Simple. Everything can be a component!
Avatar for Pedro Nauck pedronauck
666
130k
The AI Revolution Will Not Be Monopolized: How open-source beats economies of scale, even for LLMs
Avatar for Ines Montani inesmontani
PRO
3
3.8k
エンジニアに許された特別な時間の終わり
Avatar for watany watany
109
250k
We Analyzed 250 Million AI Search Results: Here's What I Found
Avatar for Josh Blyskal joshbly
2
2k
Building Experiences: Design Systems, User Experience, and Full Site Editing
Avatar for Michelle Schulp Hunt marktimemedia
1
620
Ethics towards AI in product and experience design
Avatar for Skipper Chong Warson skipperchong
2
420

Transcript

  1. ϩάʹ΍͍͞͠%#ઃܭ @fist0 2019.01.26 YAPC::Tokyo 2019

  2. 2019.01.26 :"1$5PLZP 2 ࣗݾ঺հ )/;͌͢ͱ +PCαʔόαΠυΤϯδχΞ *%pTUpTUP ೥͸ͣͬͱHPMBOHॻ͍ͯͨ ೥͸4DBMBॻ͘ػӡ 4DBMB೥ੜ

  3. 2019.01.26 :"1$5PLZP 3 ࢲͱ1FSM ͸͡Ίͯͷ:"1$͕:"1$"TJB5PLZP ৽ଔͰೖࣾͨ͠ͷ͕1FSMͷձࣾ ৽ଔݚमͰ1FSM ഑ଐ͞Εͯ࠷ॳͷϓϩμΫτ΋1FSM

  4. 2019.01.26 :"1$5PLZP αʔϏεӡ༻ͯ͠·͔͢ʁ

  5. 2019.01.26 :"1$5PLZP ϩάݟͯ·͔͢ʁ

  6. 2019.01.26 :"1$5PLZP 6 ӡ༻ͱϩά ʁʁʁʮϩάʹ͸αʔϏεͷେ੾ͳ͜ͱ͕͢΂ͯ٧·ͬͯΔΜͩΑʯ ʁʁʁʮͰ΋ɺ΄ͱΜͲͷਓ͸ͦΕʹؾ͔ͮͳ͍Μͩʜʯ ਆ༷ɺ෹༷ɺϩά༷

  7. 2019.01.26 :"1$5PLZP ใԸँಙ

  8. 2019.01.26 :"1$5PLZP ϩά

  9. 2019.01.26 :"1$5PLZP 9 ϩά ͍Ζ͍Ζ͋Δ ΞΫηεϩά )551αʔό FYOHJOY BQBDIF ͷϩά

    ΞϓϦϩά 8FCΞϓϦέʔγϣϯ FY1FSM 1)1 3VCZ ͷϩά %#ϩά %# FY.Z42- 1PTUHSF42- ͷϩά

  10. 2019.01.26 :"1$5PLZP 10 ͳͥඞཁ͔ʁ αʔϏεʹԿ͕ى͖ͨͷ͔஌ΔͨΊ w σʔλ෼ੳ w ໰͍߹Θͤͷࣄ࣮֬ೝ w

    ো֐ͷݪҼڀ໌ w ো֐ͷࣗಈݕ஌

  11. 2019.01.26 :"1$5PLZP 11 ϩάͷཁ݅ ੔߹ੑ ΞΫηεϩάʹ͸ϩά͕͋Δ͚ͲΞϓϦϩάʹϩά͕ͳ͍ͱ͔ ໢ཏੑ 8FCΞϓϦ಺ͷಛघͳ৚݅෼ذͰΞϓϦϩά͕࿙Εͯͨͱ͔ ௥੻༰қੑ ΞΫηεϩάͱΞϓϦϩάΛඥ෇͚Δखஈ͕ͳ͘೔࣌Ͱඥ෇͚Δ͔͠ͳ͍ͱ͔

    ௐࠪͷͨΊʹΞΫηεϩάΛߴස౓Ͱݟʹߦ͔ͳ͍ͱ͍͚ͳ͍ͱ͔

  12. 2019.01.26 :"1$5PLZP 'JO5FDI

  13. 2019.01.26 :"1$5PLZP 13 ͱ͋ΔԾ૝௨՟ΞϓϦͷ։ൃ Ϣʔβͷࢿ࢈͸αʔόͰ؅ཧ͢Δߏ੒ %#ʹอଘ͞ΕΔσʔλͷ੔߹ੑ͕࠷༏ઌ αʔϏε͕ࢭ·ΔҎ্ʹσʔλͷෆ੔߹͕ා͍ Ճ͑ͯɺۚ༥γεςϜͱͯ͠ূ੻ΛٻΊΒΕΔ ϩά͸ͱͯ΋େࣄ

  14. 2019.01.26 :"1$5PLZP 14 ͱ͋ΔԾ૝௨՟ΞϓϦͷαʔόαΠυ αʔόαΠυ͸("&(PΛબ୒͕ͯͬͭ͠ΓΫϥ΢υ 4UBDL%SJWFSΛ࢖͑͹ϩάͷ੔߹ੑʹ͍ͭͯ͸͋·Γ৺഑ͳ͠ ৺഑ͳͷ͸໢ཏੑͱ௥੻༰қੑ

  15. 2019.01.26 :"1$5PLZP %#ઃܭ

  16. 2019.01.26 :"1$5PLZP 16 ߟ͑Δ͜ͱ ঢ়ଶΛ࣋ͬͨσʔλΛ%#ͰͲ͏ѻ͏͔ ঢ়ଶͷมԽΛϩάʹͲ͏ه࿥͢Δ͔ ྫɿϢʔβͷ೔ຊԁ࢒ߴɺຊਓ֬ೝεςʔλεɺϢʔβొ࿥৘ใ

  17. 2019.01.26 :"1$5PLZP 17 ঢ়ଶͷมԽͱϩά Α͋͘ΔྫɿΞΧ΢ϯτͷ৐ͬऔΓʢෆਖ਼ϩάΠϯʴ*%1BTTมߋʣ Ϣʔβ৘ใͷมߋཤྺΛௐࠪ͠ͳ͚Ε͹ͳΒͳ͍ Ϣʔβ৘ใͷมߋ͕Ͳ͔͜ͷϩάʹ࢒͍ͬͯͳ͚Ε͹ͳΒͳ͍

  18. 2019.01.26 :"1$5PLZP 18 ։ൃݱ৔ͷ%#ઃܭ΍͍͖ͬͯ

  19. 2019.01.26 :"1$5PLZP 19 Ϣʔβͷ೔ຊԁ࢒ߴ ೔ຊԁ࢒ߴ͸શϢʔβ͕ਓͭ࣋ͭ ࠷৽ͷԁ࢒ߴ͸Ϣʔβʹදࣔ͢Δ ೔ຊԁ࢒ߴ͸ೖۚɺग़ۚɺԾ૝௨՟ചങ͕ൃੜ͢ΔͱมԽ͢Δ

  20. 2019.01.26 :"1$5PLZP 20 Ϣʔβͷ೔ຊԁ࢒ߴͷઃܭᶃ VTFS JE 1,  VTFSOBNF 

    VTFS@CBMBODF VTFS@JE 1,  BNPVOU VQEBUFE@BU Ϣʔβͷ࢒ߴͷཤྺʢ࢒ߴͷਪҠʣΛ؅ཧը໘ʹද͍ࣔͨ͠ͱ͖ ˠ࢒ߴมߋʹؔΘΔΤϯυϙΠϯτ΁ͷΞΫηεϩάΛࢀর͢Δʁ

  21. 2019.01.26 :"1$5PLZP 21 Ϣʔβͷ೔ຊԁ࢒ߴͷઃܭᶄ VTFS JE 1,  VTFSOBNF 

    VTFS@CBMBODF JE 1,  VTFS@JE BNPVOU DSFBUFE@BU ߋ৽࣌͸มԽޙͷ৽͍͠࢒ߴΛ*/4&35ͯ͠ɺ࠷৽ͷ࢒ߴΛऔΔͱ͖͸ SELECT ~ WHERE user_id = hoge ORDER BY created_at LIMIT 1

  22. 2019.01.26 :"1$5PLZP 22 Ϣʔβͷ೔ຊԁ࢒ߴͷઃܭᶄ աڈͷ࢒ߴͷϨίʔυ͕େྔʹͰ͖ͯύϑΥʔϚϯε͸΍΍ݒ೦͕ͩ ؅ཧը໘ʹඞཁͳσʔλ͸อଘͰ͖͍ͯΔͷͰѱ͘͸ͳͦ͞͏ ଞ௨՟ͷ࢒ߴ΋VTFS@CBMBODFςʔϒϧͰ؅ཧ͢Δ͜ͱʹͳͬͨΒʁ

  23. 2019.01.26 :"1$5PLZP 23 Ϣʔβͷ࢒ߴ ࢒ߴ͸શϢʔβ͕௨՟ʹ͖ͭਓͭ࣋ͭ ௨՟ͷछผ͸ɺ+1:ɺ#5$ɺ&5)ͳͲ ࠷৽ͷ֤࢒ߴ͸Ϣʔβʹදࣔ͢Δ ࢒ߴ͸ೖۚɺग़ۚɺԾ૝௨՟ചങ͕ൃੜ͢ΔͱมԽ͢Δ

  24. 2019.01.26 :"1$5PLZP 24 Ϣʔβ࢒ߴͷઃܭᶃ VTFS JE 1,  VTFSOBNF 

    VTFS@CBMBODF VTFS@JE 1,  KQZ@BNPVOU CUD@BNPVOU VQEBUFE@BU ߋ৽࣌͸৽͍͠࢒ߴͰ61%"5& ௨՟ͷछผ͕૿͑Δͨͼʹ"-5&3จΛଧͭͷ͔ʁʢଧͪͨ͘ͳ͍'ʣ

  25. 2019.01.26 :"1$5PLZP 25 Ϣʔβ࢒ߴͷઃܭᶄ VTFS JE 1,  VTFSOBNF 

    VTFS@CBMBODF VTFS@JE 1,  DVSSFODZ@JE BNPVOU VQEBUFE@BU ೔ຊԁ࢒ߴͷͱ͖ͱಉ༷ʹɺ Ϣʔβͷ࢒ߴͷཤྺʢ࢒ߴͷਪҠʣΛ؅ཧը໘ʹද͍ࣔͨ͠

  26. 2019.01.26 :"1$5PLZP 26 Ϣʔβ࢒ߴͷઃܭᶅ VTFS JE 1,  VTFSOBNF 

    VTFS@CBMBODF JE 1,  VTFS@JE DVSSFODZ@JE BNPVOU DSFBUFE@BU ߋ৽࣌͸มԽޙͷ৽͍͠࢒ߴΛ*/4&35 Ͱ͸ɺϢʔβͷ࠷৽ͷ࢒ߴΛऔΔͱ͖͸ʜʁ

  27. 2019.01.26 :"1$5PLZP 27 Ϣʔβ࢒ߴͷઃܭᶅ Ϣʔβͷ࠷৽ͷ࢒ߴΛ௨՟ࢦఆͰऔಘ͍ͨ͠ͱ͖ SELECT ~ WHERE user_id =

    hoge AND currency_id = jpy ORDER BY created_at LIMIT 1 Ϣʔβͷ࠷৽ͷ࢒ߴΛશ௨՟छผͰऔಘ͍ͨ͠ͱ͖ ˠΫΤϦͰ͍͘ͳΒαϒΫΤϦ஍ࠈ ˠ্ͷΫΤϦΛ௨՟छผ͝ͱʹ࣮ߦ

  28. 2019.01.26 :"1$5PLZP 28 Ϣʔβ࢒ߴͷઃܭᶆ VTFS JE 1,  VTFSOBNF 

    VTFS@CBMBODF VTFS@JE 1,  DVSSFODZ@JE 1,  BNPVOU VQEBUFE@BU VTFS@CBMBODFʹ61%"5&ͷΫΤϦΛ࣮ߦ͢Δͱ͖ VTFS@CBMBODF@MPHʹ΄΅ಉ౳ͷϨίʔυΛ*/4&35͢Δ VTFS@CBMBODF@MPH JE 1,  VTFS@JE DVSSFODZ@JE BNPVOU VQEBUFE@BU ෳ߹1,

  29. 2019.01.26 :"1$5PLZP 29 Ϣʔβ࢒ߴͷઃܭᶆ Ϣʔβͷ࠷৽ͷ࢒ߴΛ௨՟ࢦఆͰऔಘ͍ͨ͠ͱ͖ SELECT * FROM user_balance WHERE

    user_id = hoge AND currency_id = jpy Ϣʔβͷ࠷৽ͷ࢒ߴΛશ௨՟छผͰऔಘ͍ͨ͠ͱ͖ SELECT * FROM user_balance WHERE user_id = hoge ؅ཧը໘ͰཤྺΛऔಘ͍ͨ͠ͱ͖ʢ௨՟ࢦఆʣ SELECT * FROM user_balance_log WHERE user_id = hoge AND currency_id = jpy

  30. 2019.01.26 :"1$5PLZP 30 ϩάςʔϒϧͷ෼཭ αʔϏεͰར༻͢ΔςʔϒϧͱϩάςʔϒϧΛ෼཭ͨ͠ σʔλมߋͷཤྺΛ֬ೝ͢ΔͨΊʹΞΫηεϩάࢀর͸ͭΒ͍ ΞΫηεϩά͸جຊͰ͔͍͠ݕࡧʹ΋͕͔͔࣌ؒΔ %#ϩάΛݟʹߦ͘ͷ΋ӡ༻తʹָͰ͸ͳ͍

  31. 2019.01.26 :"1$5PLZP 31 ϩάςʔϒϧͷಋೖํ਑ ϨίʔυΛߋ৽͢Δςʔϒϧ͸Ұ཯ϩάςʔϒϧΛ࡞Δํ਑ʹͨ͠ ঢ়ଶͷมԽΛؚΊσʔλͷมߋ͕શ෦ςʔϒϧʹ࢒Δ ˠશ෦࢒Δɻ໢ཏੑͷ޲্ ˠςʔϒϧʹ࢒ΔͷͰௐࠪ͠΍͍͢ɻ௥੻༰қੑͷ޲্

  32. 2019.01.26 :"1$5PLZP 32 ϩάςʔϒϧͷઃܭ

  33. 2019.01.26 :"1$5PLZP 33 ϝΠϯςʔϒϧͷΧϥϜ໊ʹॏෳ͠ͳ໋໊͍ IPHF JE 1,  IPHF VQEBUFE@BU

    IPHF@MPH MPH@JE 1,  JE IPHF VQEBUFE@BU MPHHFE@BU ϩάςʔϒϧͷ໋໊نଇɺڞ௨ΧϥϜ໊͸౷ҰͰ͖ΔΑ͏ʹ

  34. 2019.01.26 :"1$5PLZP 34 Ϩίʔυ࡟আ΁ͷରԠ IPHF JE 1,  IPHF VQEBUFE@BU

    IPHF@MPH MPH@JE 1,  JE IPHF VQEBUFE@BU MPHHFE@BU IPHFͷϨίʔυΛ࡟আͨ͠ͱ͖IPHF@MPHʹͲΜͳϨίʔυ͕ೖΕ͹Α͍͔

  35. 2019.01.26 :"1$5PLZP 35 Ϩίʔυ࡟আϑϥάͷ௥Ճ IPHF JE 1,  IPHF VQEBUFE@BU

    JT@EFMFUFE IPHF@MPH MPH@JE 1,  JE IPHF VQEBUFE@BU MPHHFE@BU JT@EFMFUF@MPH ෺ཧ࡟আ૝ఆ͕ͩɺສ͕Ұͷ࿦ཧ࡟আʹ΋ରԠͰ͖ΔΑ͏ʹϑϥάΛ໋໊

  36. 2019.01.26 :"1$5PLZP 36 ϩάςʔϒϧͷ࠷ऴઃܭ IPHF JE 1,  IPHF VQEBUFE@BU

    IPHF@MPH MPH@JE 1,  JE IPHF VQEBUFE@BU MPHHFE@BU JT@EFMFUF@MPH

  37. 2019.01.26 :"1$5PLZP 37 ࠷ऴઃܭͷײ૝ ϝϦοτ ΍Γ͍ͨ͜ͱʹରͯ͠ΫΤϦ͕ૉ௚ʹͳΔ มߋཤྺʹ͍ͭͯߟ͑ͳͯ͘Α͍ ෺ཧ࡟আ࿦ཧ࡟আͰ೰·ͳͯ͘Α͍ σϝϦοτ ࡞੒ߋ৽࡟আܥΫΤϦͰ࣮ߦΫΤϦ͕Ұͭ૿͑ΔʢཁτϥϯβΫγϣϯʣ

    ϩάςʔϒϧʹϨίʔυ͕ͲΜͲΜཷ·͍ͬͯ͘

  38. 2019.01.26 :"1$5PLZP 38 ϩάςʔϒϧංେԽ໰୊ ϩάςʔϒϧʹϨίʔυ͕ͲΜͲΜཷ·͍ͬͯ͘ ˠ%#Λຊ൪༻ͱϩάςʔϒϧ༻Ͱ෼͚Δʁ ˠύʔςΟγϣχϯάͯ͠ఆظతʹຊ൪%#͔ΒऔΓग़͢ʁ

  39. 2019.01.26 :"1$5PLZP 39 ϩάςʔϒϧ༻ʹ%#෼ׂ͢Δ͔ʁ ӡ༻Λߟ͑ͨΒ%#෼ׂͨ͘͠ͳΔ ͔͠͠ϩάςʔϒϧʹ͸τϥϯβΫγϣϯඞਢ ˠ෼ׂ͢Δͱ෼ࢄτϥϯβΫγϣϯ໰୊͕ݦࡏԽ 4QBOOFSͷಉҰϓϩδΣΫτͰΠϯελϯε෼͚Δͷ͕Αͦ͞͏ʁ .Z42-ͳΒૉ௚ʹύʔςΟγϣχϯά͢Δͷ͕Αͦ͞͏

  40. 2019.01.26 :"1$5PLZP 40 %BUBTUPSF΋ซ༻͍ͯ͘͠ελΠϧ ֎෦"1*͔ΒԾ૝௨՟Ձ֨Λऔಘͯ͠อଘ͢Δ औಘස౓͸ۃΊͯ୹͍ ʙඵʹճ ͷͰϨίʔυ਺΋๲େ .Z42-ͳΒ%#෼ׂ͢ΔPS%BUBTUPSF͕Αͦ͞͏

  41. 2019.01.26 :"1$5PLZP 41 ࠓ೔఻͔͑ͨͬͨ͜ͱ

  42. 2019.01.26 :"1$5PLZP 42 ࠓ೔఻͔͑ͨͬͨ͜ͱ ϩάςʔϒϧΛ༻ҙ͢ΔઃܭͲ͏ʁ ϩάʹ΍ͯ͘͞͠ӡ༻ͷ؍఺͔ΒݟΔͱྑ͍ͱߟ͍͑ͯΔ ݱঢ়ɺ͜ΕҎ্ͷઃܭΛࢥ͍͔ͭͳ͔ͬͨ ͜ͷ৔ΛआΓͯઃܭϨϏϡʔ͕͍ͨ͠ Έͳ͞·ͷ͝ҙݟΛ͓଴͍ͪͯ͠·͢

  43. 2019.01.26 :"1$5PLZP 5IBOLT