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

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

Avatar for tychy tychy
April 04, 2022
Technology
0
300

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

Avatar for tychy

tychy

April 04, 2022
Tweet

More Decks by tychy

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

Other Decks in Technology

See All in Technology
Master Dataグループ紹介資料
Avatar for Sansan, Inc. sansan33
PRO
1
4.2k
Oracle Database@Google Cloud：サービス概要のご紹介
Avatar for oracle4engineer oracle4engineer
PRO
1
820
[Data & AI Summit '25 Fall] AIでデータ活用を進化させる！Google Cloudで作るデータ活用の未来
Avatar for kirimaru kirimaru
0
4.2k
なぜ あなたはそんなに re:Invent に行くのか？
Avatar for Kazuki Miura miu_crescent
PRO
0
250
Oracle Database@Azure：サービス概要のご紹介
Avatar for oracle4engineer oracle4engineer
PRO
3
260
AWS re:Invent2025最新動向まとめ（NRIグループre:Cap 2025）
Avatar for KoheiGamo gamogamo
0
150
Cloud WAN MCP Serverから考える新しいネットワーク運用 / 20251228 Masaki Okuda
Avatar for SHIFT EVOLVE shift_evolve
PRO
0
130
RALGO : AIを組織に組み込む方法 -アルゴリズム中心組織設計- #RSGT2026 / RALGO: How to Integrate AI into an Organization – Algorithm-Centric Organizational Design
Avatar for kyonmm kyonmm
PRO
3
630
わが10年の叡智をぶつけたカオスなクラウドインフラが、なくなるということ。
Avatar for Hisashi SOGA sogaoh
PRO
1
200
ソフトウェアエンジニアとAIエンジニアの役割分担についてのある事例
Avatar for KNOWLEDGE WORK / 株式会社ナレッジワーク kworkdev
PRO
1
360
フルカイテン株式会社 エンジニア向け採用資料
Avatar for FULL KAITEN fullkaiten
0
10k
Sansan Engineering Unit 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
1
3.6k

Featured

See All Featured
Designing for Timeless Needs
Avatar for Cassini Nazir cassininazir
0
110
Discover your Explorer Soul
Avatar for Emna emna__ayadi
2
1k
Odyssey Design
Avatar for Ryan Kendrick rkendrick25
PRO
0
450
Money Talks: Using Revenue to Get Sh*t Done
Avatar for Nikki Halliwell nikkihalliwell
0
130
jQuery: Nuts, Bolts and Bling
Avatar for Doug Neiner dougneiner
65
8.3k
Product Roadmaps are Hard
Avatar for C. Todd Lombardo iamctodd
PRO
55
12k
SEO in 2025: How to Prepare for the Future of Search
Avatar for Michael King ipullrank
3
3.3k
SEO for Brand Visibility & Recognition
Avatar for Aleyda Solis aleyda
0
4.1k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
Avatar for Michelle Schulp Hunt marktimemedia
31
2.6k
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
234
18k
Ruling the World: When Life Gets Gamed
Avatar for Sebastian Deterding codingconduct
0
120
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
Avatar for Eileen M. Uchitelle eileencodes
26
3.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Λ࡞͍ͬͯΔͱઃܭ্ͷબ୒Λແ਺ʹഭΒΕΔ ҰͭҰͭߟ͑ͳ͕Β࣮૷͍ͯ͘͠ͷ͕୉ޣຯ ࠓ೔࿩ͨ͠෦෼ͷ࣮૷Λ͢Δ͜ͱ͕٤ۓͷ໨ඪʂ