Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
データベースロギングの多様性
Search
Sponsored
·
Your Podcast. Everywhere. Effortlessly.
Share. Educate. Inspire. Entertain. You do you. We'll handle the rest.
→
tychy
April 04, 2022
Technology
350
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
データベースロギングの多様性
tychy
April 04, 2022
Transcript
9 slides
σʔλϕʔεϩΪϯάͷଟ༷ੑ ࢁాཾ ϝϯλʔɹ͞Μ
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Λ࡞͍ͬͯΔͱઃܭ্ͷબΛແʹഭΒΕΔ ҰͭҰͭߟ͑ͳ͕Β࣮͍ͯ͘͠ͷ͕ޣຯ ࠓͨ͠෦ͷ࣮Λ͢Δ͜ͱ͕٤ۓͷඪʂ
More Decks by tychy
See All by tychy
Goの標準ライブラリに学ぶジェネリクス
tychy
0
840
Other Decks in Technology
See All in Technology
エンタープライズ事業未経験のデータ屋、 AI時代にN回撃沈する.pdf
ryoskdara_
0
160
gradle-best-practices 使ってみた
mikanichinose
0
170
2026-11-11 Tamachi.sre#7 PaCにインフラリソースの命を救われました。 / PaC saves the infra resource life
masasuzu
1
210
常時稼働エージェントの作り方(Claude公式ブログを資料化)
minorun365
PRO
17
28k
業務の傍らで進める改善ループエンジニアリング
bengo4com
1
210
Claude Codeで新規事業を伸ばせるか? Zennの試行錯誤の記録
wadayusuke
2
240
「任されビリティ」で引き受けて「よしなりてぃ」に頼らず任せる / Accept tasks with "makasarebility" and hand them over without relying on "yoshinarily"
pauli
1
840
cdkdがどんだけ早いか、実際に動かして見てみよう
smt7174
1
130
文書画像からの情報抽出を行うエージェントを、軌跡の正解データ無しで作れるか
sansantech
PRO
2
220
変更差分を読むために環境を整備しよう
pipepasta
1
480
アラートを見直していたら営業組織への理解にちょっとだけ繋がった話
z63d
1
210
LLM 基盤と kagent v0 を全部 k8s に入れてみた / Deploy both LLM and kagent v0 in k8s
kota2and3kan
0
240
Featured
See All Featured
Prompt Engineering for Job Search
mfonobong
0
590
Balancing Empowerment & Direction
lara
6
1.4k
Navigating Team Friction
lara
192
16k
Leveraging Curiosity to Care for An Aging Population
cassininazir
1
570
Odyssey Design
rkendrick25
PRO
3
960
Java REST API Framework Comparison - PWX 2021
mraible
34
9.8k
The innovator’s Mindset - Leading Through an Era of Exponential Change - McGill University 2025
jdejongh
PRO
1
400
Speed Design
sergeychernyshev
33
2.2k
Why Our Code Smells
bkeepers
PRO
340
58k
The untapped power of vector embeddings
frankvandijk
2
2k
The browser strikes back
jonoalderson
0
2k
The Hidden Cost of Media on the Web [PixelPalooza 2025]
tammyeverts
2
580