Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
データベースロギングの多様性
Search
tychy
April 04, 2022
Technology
0
290
データベースロギングの多様性
tychy
April 04, 2022
Tweet
Share
More Decks by tychy
See All by tychy
Goの標準ライブラリに学ぶジェネリクス
tychy
0
780
Other Decks in Technology
See All in Technology
fukabori.fm 出張版: 売上高617億円と高稼働率を陰で支えた社内ツール開発のあれこれ話 / 20250704 Yoshimasa Iwase & Tomoo Morikawa
shift_evolve
PRO
2
8k
MUITにおける開発プロセスモダナイズの取り組みと開発生産性可視化の取り組みについて / Modernize the Development Process and Visualize Development Productivity at MUIT
muit
2
17k
United airlines®️ USA Contact Numbers: Complete 2025 Support Guide
unitedflyhelp
0
330
DatabricksにOLTPデータベース『Lakebase』がやってきた!
inoutk
0
120
OSSのSNSツール「Misskey」をさわってみよう(右下ワイプで私のOSCの20年を振り返ります) / 20250705-osc2025-do
akkiesoft
0
170
敢えて生成AIを使わないマネジメント業務
kzkmaeda
2
460
Contributing to Rails? Start with the Gems You Already Use
yahonda
2
100
インフラ寄りSREの生存戦略
sansantech
PRO
5
1.6k
Reach American Airlines®️ Instantly: 19 Calling Methods for Fast Support in the USA
flyamerican
1
170
FOSS4G 2025 KANSAI QGISで点群データをいろいろしてみた
kou_kita
0
400
IPA&AWSダブル全冠が明かす、人生を変えた勉強法のすべて
iwamot
PRO
2
170
オーティファイ会社紹介資料 / Autify Company Deck
autifyhq
10
130k
Featured
See All Featured
Making the Leap to Tech Lead
cromwellryan
134
9.4k
BBQ
matthewcrist
89
9.7k
Unsuck your backbone
ammeep
671
58k
A designer walks into a library…
pauljervisheath
207
24k
Being A Developer After 40
akosma
90
590k
Writing Fast Ruby
sferik
628
62k
RailsConf 2023
tenderlove
30
1.1k
The Power of CSS Pseudo Elements
geoffreycrofte
77
5.9k
Statistics for Hackers
jakevdp
799
220k
Visualization
eitanlees
146
16k
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
194
16k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
31
2.4k
Transcript
σʔλϕʔεϩΪϯάͷଟ༷ੑ ࢁాཾ ϝϯλʔɹ͞Μ
2 όοΫάϥϯυ ɾCίϯύΠϥͷ։ൃ ɾedk2ΛͬͯPXEBoot͢ΔUEFIΞϓϦͷ։ൃ ϥϘϢʔεͰͷςʔϚ σʔλϕʔεͷετϨʔδɺϩΪϯάपΓΛࣗ࡞ ࠓಛʹߏมߋΛͲ͏ϩΪϯά͢Δ͔ʹ͍ͭͯ ුಈখपΓಈ͖·͢ʂ (16byteΞϥΠϯਏ… ࣗݾհ
ӬଓԽͱ 3 ࠓӬଓԽΛத৺ʹ τϥϯβΫγϣϯॲཧதʹ ϝϞϦͷΠϯσοΫεͷมߋ ίϛοτ͢Δͱ͖ͷϩΪϯά ͕ϝΠϯʹͳΔ
ӬଓԽʹ·ͭΘΔઃܭͷଟ༷ੑ 4 ӬଓԽͷ͚ͩͰ༷ʑͳଟ༷ੑ͕͋Δʂ BufferཧɺCheckpointingʹଟ༷ੑ
B-Treeͷߏมߋ 5 INSERT͢Δͱߏมߋ͢Δέʔε͕͋Δ ߏมߋΛͲ͏ѻ͏ͷ͔ʹ࣮ଟ༷ੑ͕͋ΔˠNextPage ςʔϒϧຊମPrimaryKeyͷIndexͱ࣮ͯ͠ UPDATE·ͰΑ͍͕ɺINSERT͕͍͠ˠ
ߏมߋͱฒߦੑ 6 Ϩίʔυมߋʹߏมߋ͕͏ͱ ߏมߋʹରͯ͠ґଘ͕ؔൃੜ͢Δ T2ͷϩάΛॻ͖͑ͯDҠಈ T1ΛROLLBACK͍ͨ͠ͱ͖… T1͚ͩΛROLLBACKͤͯ͞T2Λੜ͖ΒͤΔͷ͕͍͠ T2ΛϩʔϧόοΫ͢Δ OR
Ҋ1 ߏมߋͨ͠෦Λഉଞ͢Δ 7 ߏมߋ͕ى͖ͨ෦Λഉଞ (Pros) T2ʹӨڹͤͣʹT1ROLLBACKͰ͖Δ (Cons) ߏมߋͷൣғ͕͍ͱύϑΥʔϚϯε͕ʹͳΔ ߏมߋͷROLLBACKΛ࿈ͤͨ͘͞ͳ͍߹ ex)
root
Ҋ2ɹߏมߋͷΈΛه͢ΔτϥϯβΫγϣϯ 8 ߏมߋͷΈΛߦ͏τϥϯβΫγϣϯS1Λ࡞Δ T1ΛROLLBACKͯ͠ߏมߋ(S1)Δ S1͕֬ఆͨ͠ΒT2֬ఆͯ͠ྑ͍ʂ ϙΠϯτ:
·ͱΊ 9 DBMSΛ࡞͍ͬͯΔͱઃܭ্ͷબΛແʹഭΒΕΔ ҰͭҰͭߟ͑ͳ͕Β࣮͍ͯ͘͠ͷ͕ޣຯ ࠓͨ͠෦ͷ࣮Λ͢Δ͜ͱ͕٤ۓͷඪʂ