Upgrade to Pro — share decks privately, control downloads, hide ads and more …

データベースロギングの多様性

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for tychy tychy
April 04, 2022
Technology
0
310

 データベースロギングの多様性

Avatar for tychy

tychy

April 04, 2022
Tweet

More Decks by tychy

See All by tychy
Goの標準ライブラリに学ぶジェネリクス
Avatar for tychy tychy
0
810

Other Decks in Technology

See All in Technology
茨城の思い出を振り返る ～CDKのセキュリティを添えて～ / 20260201 Mitsutoshi Matsuo
Avatar for SHIFT EVOLVE shift_evolve
PRO
1
340
OWASP Top 10:2025 リリースと 少しの日本語化にまつわる裏話
Avatar for Riotaro OKADA okdt
PRO
3
820
Oracle Cloud Observability and Management Platform - OCI 運用監視サービス概要 -
Avatar for oracle4engineer oracle4engineer
PRO
2
14k
22nd ACRi Webinar - NTT Kawahara-san's slide
Avatar for Nao Sumikawa nao_sumikawa
0
100
AI駆動開発を事業のコアに置く
Avatar for 鬼澤輔 tasukuonizawa
1
270
Frontier Agents (Kiro autonomous agent / AWS Security Agent / AWS DevOps Agent) の紹介
Avatar for msysh msysh
3
180
データの整合性を保ちたいだけなんだ
Avatar for ShoheiMitani shoheimitani
8
3.2k
Oracle AI Database 移行・アップグレード勉強会 - RAT活用編
Avatar for oracle4engineer oracle4engineer
PRO
0
100
モダンUIでフルサーバーレスなAIエージェントをAmplifyとCDKでサクッとデプロイしよう
Avatar for みのるん minorun365
4
220
Digitization部 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
1
6.8k
SREが向き合う大規模リアーキテクチャ 〜信頼性とアジリティの両立〜
Avatar for Kuniaki Moriya zepprix
0
460
AWS Network Firewall Proxyを触ってみた
Avatar for nagisa_53 nagisa53
1
240

Featured

See All Featured
Faster Mobile Websites
Avatar for Dean Hume deanohume
310
31k
WCS-LA-2024
Avatar for Leonardo Collado-Torres lcolladotor
0
450
30 Presentation Tips
Avatar for Ian Lurie portentint
PRO
1
220
Design in an AI World
Avatar for tapps tapps
0
140
Optimising Largest Contentful Paint
Avatar for Harry Roberts csswizardry
37
3.6k
Odyssey Design
Avatar for Ryan Kendrick rkendrick25
PRO
1
500
Un-Boring Meetings
Avatar for Sebastian Deterding codingconduct
0
200
The Language of Interfaces
Avatar for Des Traynor destraynor
162
26k
Stop Working from a Prison Cell
Avatar for Chris Michel hatefulcrawdad
273
21k
Improving Core Web Vitals using Speculation Rules API
Avatar for Sergey Chernyshev sergeychernyshev
21
1.4k
Primal Persuasion: How to Engage the Brain for Learning That Lasts
Avatar for Mike Taylor tmiket
0
250
SEO Brein meetup: CTRL+C is not how to scale international SEO
Avatar for Linda Hogenes lindahogenes
0
2.3k

Transcript

  1.  σʔλϕʔεϩΪϯάͷଟ༷ੑ ࢁాཾ ϝϯλʔɹ੕໺͞Μ

  2. 2 όοΫάϥ΢ϯυ ɾCίϯύΠϥͷ։ൃ ɾedk2Λ࢖ͬͯPXEBoot͢ΔUEFIΞϓϦͷ։ൃ ϥϘϢʔεͰͷςʔϚ σʔλϕʔεͷετϨʔδɺϩΪϯάपΓΛࣗ࡞ ࠓ೔͸ಛʹߏ଄มߋΛͲ͏ϩΪϯά͢Δ͔ʹ͍ͭͯ ුಈখ਺఺पΓ΋ಈ͖·͢ʂ (16byteΞϥΠϯਏ… ࣗݾ঺հ

  3. ӬଓԽͱ͸ 3 ࠓ೔͸ӬଓԽΛத৺ʹ τϥϯβΫγϣϯॲཧதʹ͸ ϝϞϦ಺ͷΠϯσοΫεͷมߋ ίϛοτ͢Δͱ͖ͷϩΪϯά ͕ϝΠϯʹͳΔ

  4. ӬଓԽʹ·ͭΘΔઃܭͷଟ༷ੑ 4 ӬଓԽͷ࿩୊͚ͩͰ΋༷ʑͳଟ༷ੑ͕͋Δʂ Buffer؅ཧɺCheckpointingʹ΋ଟ༷ੑ

  5. B-Treeͷߏ଄มߋ 5 INSERT͢Δͱߏ଄มߋ͢Δέʔε͕͋Δ ߏ଄มߋΛͲ͏ѻ͏ͷ͔ʹ΋࣮͸ଟ༷ੑ͕͋ΔˠNextPage ςʔϒϧຊମ΋PrimaryKeyͷIndexͱ࣮ͯ͠૷ UPDATE·Ͱ͸Α͍͕ɺINSERT͕೉͍͠ˠ

  6. ߏ଄มߋͱฒߦੑ 6 Ϩίʔυมߋʹߏ଄มߋ͕൐͏ͱ ߏ଄มߋʹରͯ͠ґଘؔ܎͕ൃੜ͢Δ T2ͷϩάΛॻ͖׵͑ͯD΋Ҡಈ T1ΛROLLBACK͍ͨ͠ͱ͖… T1͚ͩΛROLLBACKͤͯ͞T2Λੜ͖࢒ΒͤΔͷ͕೉͍͠ T2ΛϩʔϧόοΫ͢Δ OR

  7. Ҋ1 ߏ଄มߋͨ͠෦෼Λഉଞ͢Δ 7 ߏ଄มߋ͕ى͖ͨ෦෼Λഉଞ (Pros) T2ʹӨڹͤͣʹT1ROLLBACKͰ͖Δ (Cons) ߏ଄มߋͷൣғ͕޿͍ͱύϑΥʔϚϯε͕໰୊ʹͳΔ ߏ଄มߋͷROLLBACKΛ࿈࠯ͤͨ͘͞ͳ͍৔߹ ex)

    root

  8. Ҋ2ɹߏ଄มߋͷΈΛه࿥͢ΔτϥϯβΫγϣϯ 8 ߏ଄มߋͷΈΛߦ͏τϥϯβΫγϣϯS1Λ࡞Δ T1ΛROLLBACKͯ͠΋ߏ଄มߋ(S1)͸࢒Δ S1͕֬ఆͨ͠ΒT2΋֬ఆͯ͠ྑ͍ʂ ϙΠϯτ:

  9. ·ͱΊ 9 DBMSΛ࡞͍ͬͯΔͱઃܭ্ͷબ୒Λແ਺ʹഭΒΕΔ ҰͭҰͭߟ͑ͳ͕Β࣮૷͍ͯ͘͠ͷ͕୉ޣຯ ࠓ೔࿩ͨ͠෦෼ͷ࣮૷Λ͢Δ͜ͱ͕٤ۓͷ໨ඪʂ