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

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

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
AIと新時代を切り拓く。これからのSREとメルカリIBISの挑戦
Avatar for ktykogm 0gm
1
2.7k
Agile Leadership Summit Keynote 2026
Avatar for seki at druby.org m_seki
1
640
クレジットカード決済基盤を支えるSRE - 厳格な監査とSRE運用の両立 (SRE Kaigi 2026)
Avatar for capytan capytan
6
2.8k
小さく始めるBCP ― 多プロダクト環境で始める最初の一歩
Avatar for kekke-n kekke_n
1
450
日本の85%が使う公共SaaSは、どう育ったのか
Avatar for たけだ taketakekaho
1
230
Oracle Base Database Service 技術詳細
Avatar for oracle4engineer oracle4engineer
PRO
15
93k
M&A 後の統合をどう進めるか ─ ナレッジワーク × Poetics が実践した組織とシステムの融合
Avatar for KNOWLEDGE WORK / 株式会社ナレッジワーク kworkdev
PRO
1
470
Digitization部 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
1
6.8k
10Xにおける品質保証活動の全体像と改善 #no_more_wait_for_test
Avatar for nihonbuson nihonbuson
PRO
2
310
CDK対応したAWS DevOps Agentを試そう_20260201
Avatar for モブエンジニア（Masaki Okuda） masakiokuda
1
340
配列に見る bash と zsh の違い
Avatar for kazzpapa3 kazzpapa3
3
160
usermode linux without MMU - fosdem2026 kernel devroom
Avatar for Hajime Tazaki thehajime
0
240

Featured

See All Featured
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
Avatar for Vitaly Friedman smashingmag
254
22k
Ecommerce SEO: The Keys for Success Now & Beyond - #SERPConf2024
Avatar for Aleyda Solis aleyda
1
1.8k
Self-Hosted WebAssembly Runtime for Runtime-Neutral Checkpoint/Restore in Edge–Cloud Continuum
Avatar for Yuki Nakata chikuwait chikuwait
0
330
Let's Do A Bunch of Simple Stuff to Make Websites Faster
Avatar for Chris Coyier chriscoyier
508
140k
Heart Work Chapter 1 - Part 1
Avatar for Lake Fama lfama
PRO
5
35k
From Legacy to Launchpad: Building Startup-Ready Communities
Avatar for Dug Song dugsong
0
140
Marketing Yourself as an Engineer | Alaka | Gurzu
Avatar for Gurzu gurzu
0
130
A brief & incomplete history of 
UX Design for the World Wide Web: 1989–2019
Avatar for Jason CranfordTeague jct
1
300
JAMstack: Web Apps at Ludicrous Speed - All Things Open 2022
Avatar for David Neal reverentgeek
1
350
HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy
Avatar for Ines Montani inesmontani
PRO
0
220
How to Ace a Technical Interview
Avatar for Jacob Kaplan-Moss jacobian
281
24k
[RailsConf 2023 Opening Keynote] The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
31
9.9k

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Λ࡞͍ͬͯΔͱઃܭ্ͷબ୒Λແ਺ʹഭΒΕΔ ҰͭҰͭߟ͑ͳ͕Β࣮૷͍ͯ͘͠ͷ͕୉ޣຯ ࠓ೔࿩ͨ͠෦෼ͷ࣮૷Λ͢Δ͜ͱ͕٤ۓͷ໨ඪʂ