Introducing dbsafe: Know Before You ALTER
A tool that analyzes MySQL schema changes before you run them
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
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.