dbsafe in the Cloud: Safe Schema Changes on AWS Aurora and RDS
TLS connections, Aurora topology detection, and why gh-ost needs extra work here
SELECT * FROM performance
EXPLAIN ANALYZE
OPTIMIZE TABLE
Database Performance Blog
Running as many queries as possible, as fast as possible
Deep dives into MySQL and PostgreSQL performance tuning, query optimization, monitoring, and real-world database operations.
Scroll to explore
// LATEST POSTS
Recent Insights
View all posts
Before the Index, Before the Schema: MySQL Makes Three Promises
And understanding them changes how you work
Foreign Keys and Schema Changes: The Constraint You Didn't Plan For
What dbsafe surfaces when your tables have referential constraints
ON DELETE CASCADE: The Foreign Key Change MySQL Doesn't Log
Invisible to the binlog, the audit plugin, and triggers. All at once.
Always Have an Exit Strategy: dbsafe Automatic Rollback Plans
Before you ALTER, know exactly how to undo it
When MySQL Rebuilds Your Table: Understanding COPY Algorithm DDL
The most dangerous ALTER TABLE operations and how to survive them
Zero-Downtime Schema Changes with MySQL 8.0 INSTANT DDL
Add and drop columns without rebuilding the table
Introducing dbsafe: Know Before You ALTER
A tool that analyzes MySQL schema changes before you run them
How to Test ProxySQL Read/Write Split with sysbench
Getting Accurate Results with Percona XtraDB Cluster
Finding 'Abbey Road' When Users Type 'beatles abbey rd' - Fuzzy and Semantic Search in PostgreSQL
The DBA's Guide to Music Matching - pg_trgm and pgvector with 100K Spotify Albums
Supercharge PMM Query Analytics: Using Redash to Optimize Database Performance
Customize QAN, Analyze Query Performance, and Unlock ClickHouse Data with Redash Integration
Smart Alerting: Dynamic Thresholds
Combating Alert Fatigue
Monitoring MySQL with Coroot
First impressions
Contention in MySQL InnoDB
Useful info from the semaphores section
// WHY RENDIMENT
Performance knowledge, accessible to all
Available for everyone
Natural language should be the main language. Explanations that don't sound like scientific papers.
Native speaker
An assistant that understands databases. Familiarity with a query execution plan should not be a prerequisite.
For the community
Community is everything. It's what makes this tech strong. Let's give back.
// TOPICS COVERED
The tools of the trade
Topics I write about most, from engines to observability.