bongoDev

Loading...

Empowering technology learners worldwide with professional online live trainings. Transform your IT career with expert-led courses.

Facebook Instagram LinkedIn Github

Company

About Us
Careers
Blog
Events

Legal

Privacy Policy
Refund Policy
Terms and Conditions

Contact us

[email protected]
01757258398 01978367094 01576641348
01757258398

Our office

Flat 5/A, Shimanto Plaza, Plot #26/D, Main Road-03, Section #11, Mirpur, Dhaka 1216

© 2026 bongoDev. All rights reserved. | ই-ট্রেড লাইসেন্স: TRADEDNCC/015304/2024

Courses Job Success

Blog Events Free Assessment Login

bongoDev | MySQL Locks, Metadata Locks & Performance Schema - Database Reliability Pro

TopicDatabase Reliability Pro

01Database Reliability Mental Model: Correctness, Durability, Availability & RecoverabilityPreview
02Choose the Right Data System: Relational, Key-Value, Document & Distributed Trade-offs
03Transactions & ACID: The Business Correctness Boundary
04Isolation Levels & Concurrency Anomalies
05MVCC, Row Versions & Visibility
06Locks, Blocking & Deadlocks
07Database Connections: Lifecycle, Limits & Failure Modes
08Connection Pooling: Sizing, Backpressure & Pooler Architecture
09SQL Request Lifecycle: Parse → Plan → Execute → Commit
10Indexes: Reliability, Selectivity & Write Trade-offs
11Query Plans & EXPLAIN: Read the Work, Not Just the SQL
12Statistics, Cardinality Estimates & Plan Stability
13CPU, Memory, Buffer Cache & Working Set
14Storage I/O, WAL/Redo, fsync & Commit Latency
15Checkpoints, Vacuum/Purge, Compaction & Background Maintenance
16Constraints & Data Integrity as Reliability Controls
17Schema Evolution: Backward Compatibility & Mixed Versions
18Zero-Downtime Database Migrations: Expand → Migrate → Contract
19Replication Mental Model: Durability, Read Scale & Recovery
20Synchronous vs Asynchronous Replication & Commit Trade-offs
21Leader Election, Promotion, Failover & Fencing
22Read Replicas, Staleness & Read-After-Write Guarantees
23Backup Strategy: Logical, Physical, Snapshot & Log-Based
24Point-in-Time Recovery: Base Backup + Transaction Log
25Restore Validation: A Backup Is Not Proven Until Restored
26RPO, RTO & Database Recovery Tiering
27Multi-AZ High Availability & Failure-Domain Design
28Regional Disaster Recovery: Standby, Replication & Failback
29Multi-Region Consistency, Quorums & Latency Trade-offs
30Partitioning & Sharding: Scale Without Losing Operability
31Hotspots, Skew & Monotonic Key Failure Modes
32Primary Keys, IDs & Data Locality
33PostgreSQL Reliability Operations: Processes, WAL & Catalog Evidence
34PostgreSQL VACUUM, Autovacuum, Bloat & Transaction Age
35PostgreSQL Locks, Wait Events & Long Transactions
36PostgreSQL Streaming Replication, Slots & PITR
37MySQL/InnoDB Reliability: Redo, Undo, Buffer Pool & Transactions
38MySQL Replication, GTIDs, Lag & Failover
39MySQL Locks, Metadata Locks & Performance Schema
40Managed Database Reliability on AWS, Azure & GCP
41Database Proxies & Poolers: PgBouncer, Managed Proxies & Trade-offs
42Database Observability: Golden Signals, Waits & Business Correlation
43Slow Query Engineering: Detect → Explain → Fix → Regress-Test
44Database Capacity Planning: Throughput, Concurrency, Headroom & Growth
45Database Saturation & Overload Protection
46Cache + Database Reliability: Protect the Source of Truth
47Queues & Write Buffering: Smoothing Database Load Safely
48Database Retry Safety, Idempotency & Transaction Boundaries
49ORM Reliability: N+1 Queries, Hidden Transactions & Connection Leaks
50Data Corruption & Integrity Incident Response
51Database Security: Authentication, Authorization, TLS & Least Privilege
52Secrets, Credential Rotation, Certificates & Database Identity
53Maintenance, Patching & Minor-Version Upgrades
54Major Database Upgrades & Compatibility Strategy
55Database Change Management: DDL, Config, Indexes & Risk Gates
56Running Databases on Kubernetes: Stateful Reliability Trade-offs
57NoSQL Reliability: Key-Value & Document Database Patterns
58Consensus, Quorum & Split-Brain Fundamentals for Database Engineers
59Database SLOs & Reliability Alerts
60Database Incident Triage: First 5 / 15 / 30 Minutes
61Connection Exhaustion & Pool Storm Incident
62Lock Storm & Deadlock Incident
63Replication Lag & Replica Failure Incident
64Storage Full, WAL/Redo Growth & Runaway Disk Incident
65Failover Incident: Promotion, Client Reconnect & Recovery Validation
66Database Performance Testing: Realistic Workloads & Safe Benchmarks
67Database Load Shedding, Prioritization & Graceful Degradation
68Transactional Outbox, Inbox & Reliable Database-to-Event Handoffs
69Saga & Compensation Patterns for Cross-System Transactions
70Database Ownership, Service Catalog & Operational Readiness
71Database Reliability Review & Production Readiness Checklist
72Lab: Connection Pool Storm During Kubernetes Autoscaling
73Lab: Bad Migration, Metadata Lock & Production Recovery
74Lab: Primary Failure, Promotion, Stale Reads & Failback
75Lab: Logical Corruption, PITR & Business Reconciliation
76Database Reliability Troubleshooting Playbook
77Database Command & Evidence Playbook: PostgreSQL, MySQL & Linux
78Database Reliability Pro Cheatsheet

Englishবাংলা

Knowledge Hub/Database Reliability Pro/MySQL Locks, Metadata Locks & Performance Schema

Database Reliability Pro

Paid lesson · Advanced · 54 min read

MySQL Locks, Metadata Locks & Performance Schema

Diagnose MySQL contention including DML locks, metadata locks and statement waits.

This lesson is locked

This lesson is part of the paid course.

View free previews

PreviousMySQL Replication, GTIDs, Lag & FailoverLocked NextManaged Database Reliability on AWS, Azure & GCPLocked

Discount price

৳ 320.00৳ 120.00Save ৳ 200.00