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
put_the_image_in_the_rdb_advantages_and_disadva...
Search
Sponsored
·
Your Podcast. Everywhere. Effortlessly.
Share. Educate. Inspire. Entertain. You do you. We'll handle the rest.
→
mamy1326
August 08, 2017
Programming
1.2k
1
Share
put_the_image_in_the_rdb_advantages_and_disadvantages
PHP BLT #8 で発表したスライドです
mamy1326
August 08, 2017
More Decks by mamy1326
See All by mamy1326
PHPer が知るべき MySQL クエリチューニング/What PHPers Need to Know about MySQL Query Tuning
mamy1326
18
7.9k
戦って品質保証を勝ち取る/Fight_for_quality_assurance
mamy1326
2
910
MySQLでGROUP BY と ORDER BY を同時に使いたくなったら/If_you_want_to_use_GROUP_BY_and_ORDER_BY_at_the_same_time_in_mysql
mamy1326
4
6.3k
初めてのMySQLパフォーマンスチューニングーデータベースは怖くない!/mysql-performance-tuning-basics-in-db-study-chugoku-chiho
mamy1326
8
2.9k
アウトプットを継続するためにやる10箇条-吉祥寺.pm-/10_things_practicing_to_continue_output-in_kichijoji.pm
mamy1326
4
2.4k
MySQLパフォーマンスチューニングの基本ー実際のトラブルシュートから my.cnf までー/MySQL_Performance_Tuning_Basics_in_OSC_Niigata
mamy1326
2
3.8k
アウトプットを継続するためにやっている 10 のこと/10_things_practicing_to_continue_output
mamy1326
21
9.7k
アプリケーションエンジニアが知るべきDNSの基本/Basics_of_DNS_that_application_engineers_should_know
mamy1326
113
47k
dns-penetration-problem-why-can-not-i-say-penetration-kichijojipm15
mamy1326
5
3.7k
Other Decks in Programming
See All in Programming
AI-DLC Deep Dive
yuukiyo
9
4.5k
How Swift's Type System Guides AI Agents
koher
0
290
Kingdom of the Machine
yui_knk
2
630
ハンズオンで学ぶクラウドネイティブ
tatsukiminami
0
130
Coding at the Speed of Thought: The New Era of Symfony Docker
dunglas
0
5k
実践CRDT
tamadeveloper
0
580
10年分の技術的負債、完済へ ― Claude Code主導のAI駆動開発でスポーツブルを丸ごとリプレイスした話
takuya_houshima
0
2.6k
forteeの改修から振り返るPHPerKaigi 2026
muno92
PRO
3
290
Surviving Black Friday: 329 billion requests with Falcon!
ioquatix
0
570
検索設計から 推論設計への重心移動と Recall-First Retrieval
po3rin
2
770
アーキテクチャモダナイゼーションとは何か
nwiizo
19
5.3k
Liberating Ruby's Parser from Lexer Hacks
ydah
2
1.8k
Featured
See All Featured
Exploring anti-patterns in Rails
aemeredith
3
320
BBQ
matthewcrist
89
10k
A designer walks into a library…
pauljervisheath
211
24k
AI in Enterprises - Java and Open Source to the Rescue
ivargrimstad
0
1.2k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
162
16k
The Cost Of JavaScript in 2023
addyosmani
55
9.8k
Avoiding the “Bad Training, Faster” Trap in the Age of AI
tmiket
0
130
SERP Conf. Vienna - Web Accessibility: Optimizing for Inclusivity and SEO
sarafernandez
2
1.4k
The Power of CSS Pseudo Elements
geoffreycrofte
82
6.2k
The Spectacular Lies of Maps
axbom
PRO
1
710
Dealing with People You Can't Stand - Big Design 2015
cassininazir
367
27k
Leveraging Curiosity to Care for An Aging Population
cassininazir
1
220
Transcript
ը૾Λ3%#ʹ ΩϟοΩϟϑϑ͢Δ ϝϦοτσϝϦοτ *OOPWBUPS+BQBO*OD ·Έͳ͓͖ !NBNZ "VH!1)1#-5
ۙگ
ۙگ - ࠷ۙPHPॻ͍ͯ·ͤΜʂ - builderscon Ͱ ɹొஃ & ϘϥϯςΟΞελοϑ ɹɹ͖ͯ͠·ͨ͠
ͱ͜ΖͰ Έͳ͞Μ
ը૾Λ3%#ʹ ΩϟοΩϟϑϑ Ҋ݅
ܦݧͨ͜͠ͱ ͋Γ·͔͢ʁ ڍख✋
͋Γ·͢ʂ
ͭΒ͍
Ͱ ඞཁͳ࣌ ͋Δ͔͠Εͳ͍
Զ͕ࢮΜͩΒʜ ͋ͷൿଂͷը૾ ϑΥϧμΛʜ
আͯ͠ʜ ͓͔ʜͶʜ ŰƄŦŕ@ ʯ㲃 @
Ͱ҆৺ ͓ๅը૾ %#ͷதͳΒͶ
͑ʁ ͦΕͰ͍͍ͷʁ
͍͍Θ͚ Ͷ͐ͩΖ͏
ͱ͍͏Θ͚Ͱ ϝϦοτσϝϦοτʂ
ൃ ⾣UFSBUBJMͰ͑ͨ IUUQTUFSBUBJMDPNRVFTUJPOT
ൃ ⾣ϕετΞϯαʔʹͳͬͨ
ൃ ⾣5XJUUFSʹߘͨ͠
ൃ ⾣ΊͬͪΌΓ্͕ͬͨ
ൃ ⾣·ͱΊͨ IUUQTUPHFUUFSDPNMJ
ϝϦοτ ▶︎ τϥϯβΫγϣϯͷԸܙ ▶︎ ҉߸ԽͱηΩϡϦςΟ ▶︎ όοΫΞοϓͷूੑ ▶︎ ࠪʢཤྺʣͷ౷߹తͳ࣮
ɹτϥϯβΫγϣϯͷԸܙ ⾣ΞοϓϩʔυޙͷࣦഊෆՄආ ɹˠSPMMCBDLͰҰൃͰͳ͔ͬͨ͜ͱʹ ϑΝϯτϜϑΝΠϧͷ ࢭʹͳΔ
ɹ҉߸ԽͱηΩϡϦςΟ ⾣Χϧςͷఴը૾ͳͲ ɹˠඇৗʹηϯγςΟϒͳը૾ ҉߸ԽɾηΩϡΞʹ औΓѻ͏
ɹόοΫΞοϓͷूੑ ⾣%#όοΫΞοϓ͚ͩͰ ɹˠը૾όοΫΞοϓ͞ΕΔ ͔͠͠4ͷొͰ ϝϦοτແ͘ͳͬͨ
ɹࠪ ཤྺ ͷ౷߹తͳ࣮ ⾣ը૾ͷߋ৽ཤྺΛऔΓ͍ͨ ɹˠόʔδϣϯཧ͍ͨ͠ ύϑΥʔϚϯεΛ٘ਜ਼ʹͯ͠ ࣮͍ͨ͠ͳΒ0,
σϝϦοτ ▶︎ ύϑΥʔϚϯεԼ ▶︎ DBͷετϨʔδѹഭ ▶︎ ωοτϫʔΫΛѹഭ ▶︎ ը૾ΛDB͔Βׂ࣌ͷฐ ▶︎
ϝϯςφϯεੑͷԼ ▶︎Ωϟογϡ͠ʹ͍͘
ɹύϑΥʔϚϯεԼ ⾣ը૾σʔλΛϨίʔυʹؚΉ ɹˠσʔλྔ૿Ճ38͕͘ ύϑΥʔϚϯεԼΛ ཁ্͕݅ճΔ߹ͷΈ
ɹ%#ͷετϨʔδѹഭ ⾣ఆΛ͑ͨσʔλ૿Ճ ɹˠཁ݅Ճ αϜωΠϧɺผͷը૾Ճ ͪΐͬͱͨ͠Ճ͕ কདྷతʹετϨʔδΛѹഭ
ɹωοτϫʔΫΛѹഭ ⾣ը૾Λ%#͔Βऔಘ ɹˠωοτϫʔΫѹഭ XFC%#ؒ ͕ͪൃੜ͠ Ϩεϙϯε͕Լ
ɹը૾Λ%#͔Βׂ࣌ͷฐ ⾣੩తϑΝΠϧΛઐ༻αʔόʔ ɹˠશϨίʔυҠߦɺύεใՃ ؆୯ʹׂɺҠಈͰ͖ͣ σʔλྔ࣍ୈͰ͕͔͔࣌ؒΔ
ɹϝϯςφϯεੑͷԼ ⾣ը૾ߋ৽Ξοϓͨ͠ΒऴΘΓ ɹˠ%#ͩͱϓϩάϥϜɺ42-Λ௨͢ Կஈ֊ ༨ܭͳखॱΛ౿Ή
ɹΩϟογϡ͠ʹ͍͘ ⾣%#อଘͷը૾Λʜ ɹˠΩϟογϡͤ͞ΔΈ͕ඞཁ ӡ༻ޮɺอकੑ͕Լ
ɹ·ͱΊ ⾣ಛघͳཁ݅ͷ߹ʹ͏ ɹɹˠָ͔ͩΒ҆қʹಥͬࠐ·ͳ͍ ⾣ύϑΥʔϚϯεɾίετ ɹͱͷτϨʔυΦϑ ɹɹˠ։ൃɺӡ༻ίετΛਂ͘ߟྀ ⾣ઃܭɾ࣮Λ͔ͬ͠Γܭը ɹɹˠޙͰࠔΔ͜ͱ͕͘͢͝ଟ͍ ⾣3%#ͷຊདྷͷΛߟྀ ɹɹˠϦϨʔγϣφϧσʔλϕʔεͬͯͳΜ͚ͩͬʁ
ɹ·ͱΊ ⾣ಛघͳཁ݅ͷ߹ʹ͏ ɹɹˠָ͔ͩΒ҆қʹಥͬࠐ·ͳ͍ ⾣ύϑΥʔϚϯεɾίετ ɹͱͷτϨʔυΦϑ ɹɹˠ։ൃɺӡ༻ίετΛਂ͘ߟྀ ⾣ઃܭɾ࣮Λ͔ͬ͠Γܭը ɹɹˠޙͰࠔΔ͜ͱ͕͘͢͝ଟ͍ ⾣3%#ͷຊདྷͷΛߟྀ ɹɹˠϦϨʔγϣφϧσʔλϕʔεͬͯͳΜ͚ͩͬʁ
ɹ·ͱΊ ⾣ಛघͳཁ݅ͷ߹ʹ͏ ɹɹˠָ͔ͩΒ҆қʹಥͬࠐ·ͳ͍ ⾣ύϑΥʔϚϯεɾίετ ɹͱͷτϨʔυΦϑ ɹɹˠ։ൃɺӡ༻ίετΛਂ͘ߟྀ ⾣ઃܭɾ࣮Λ͔ͬ͠Γܭը ɹɹˠޙͰࠔΔ͜ͱ͕͘͢͝ଟ͍ ⾣3%#ͷຊདྷͷΛߟྀ ɹɹˠϦϨʔγϣφϧσʔλϕʔεͬͯͳΜ͚ͩͬʁ
ɹ·ͱΊ ⾣ಛघͳཁ݅ͷ߹ʹ͏ ɹɹˠָ͔ͩΒ҆қʹಥͬࠐ·ͳ͍ ⾣ύϑΥʔϚϯεɾίετ ɹͱͷτϨʔυΦϑ ɹɹˠ։ൃɺӡ༻ίετΛਂ͘ߟྀ ⾣ઃܭɾ࣮Λ͔ͬ͠Γܭը ɹɹˠޙͰࠔΔ͜ͱ͕͘͢͝ଟ͍ ⾣3%#ͷຊདྷͷΛߟྀ ɹɹˠϦϨʔγϣφϧσʔλϕʔεͬͯͳΜ͚ͩͬʁ
σʔλͷण໋ ΞϓϦΑΓ͍ͧ
͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ