Tag: #mysql
Writing on GPUs, LLMs, MLOps, Kubernetes — and mindset · 21 posts
Transaction Isolation Levels and the Anomalies You Actually Hit — Where the Standard Definition Diverges from the Implementation
A walkthrough of the four transaction isolation levels and of dirty read, non-repeatable read, and phantom read — but one that does not stop at the textbook table. Using real SQL sessions, it shows why the Read Committed
2026-07-26 · 14 min read #database#postgresql#transaction#isolation-level#mysqlDiagnosing and Preventing Deadlocks — How to Pin Down the Two Queries from the Log
A step-by-step guide to what you should look at when you hit a deadlock detected error. How to interpret the PostgreSQL deadlock report and the SHOW ENGINE INNODB STATUS output of MySQL line by line so you can pin down w
2026-07-26 · 16 min read #database#postgresql#deadlock#locking#mysqlWhy the Index You Created Is Not Being Used — The Cases Where the Optimizer Is Right and You Are Wrong
A cause-by-cause breakdown of why a Seq Scan stays in the query plan even after you create an index. Low selectivity making the optimizer ignore it on purpose, a function or arithmetic on the column making the condition
2026-07-26 · 14 min read #database#postgresql#index#query-optimization#mysqlThe Version After MySQL 9.7 Is 26.7 — How MySQL and MariaDB Tidied Up Their Release Models in Spring 2026
On April 21, 2026, MySQL 9.7.0 shipped as GA, opening a new LTS line for the first time in almost two years since 8.4 — and that same month, Extended Support for MySQL 8.0 ended, dropping it into Sustaining Support. Then
2026-07-16 · 20 min read #mysql#mariadb#database#versioning#devopsOnline Schema Changes on Large Tables — gh-ost, pt-online-schema-change, and Native Online DDL
Run an ALTER against a table with hundreds of millions of rows and your service can grind to a halt. This post walks through the limits of MySQL native Online DDL, how trigger-based pt-online-schema-change and binlog-bas
2026-06-16 · 21 min read #database#mysql#postgresql#migration#gh-ostDatabase Engines 2026 Deep-Dive — Postgres Won the API, ClickHouse and DuckDB Won Analytics
PostgreSQL 17/18, MySQL 9, MariaDB 12, SQLite + libSQL + Turso, DuckDB 1.x, ClickHouse, StarRocks, Doris, Druid, Pinot, TiDB, CockroachDB 25, YugabyteDB, Cassandra 5, ScyllaDB, Aerospike, Neon, Supabase, PlanetScale, Xat
2026-05-16 · 17 min read #database#postgresql#mysql#clickhouse#duckdbDB Index Master Guide 2025: B-Tree, Hash, GIN, BRIN, Composite Indexes, Query Plan Analysis
Everything about DB indexes. B-Tree internals, comparison of Hash/GIN/GiST/BRIN, composite index design, covering/partial/expression indexes, reading EXPLAIN ANALYZE, 10 reasons an index is skipped, real-world tuning cas
2026-04-15 · 10 min read #database#indexing#btree#hash#ginDatabase Query Optimizer Complete Guide 2025: Volcano, Cascades, Cost-Based, Cardinality Estimation — PostgreSQL/MySQL In-Depth Analysis
A single SQL statement can turn into hundreds of different execution plans. From Volcano to Cascades, how cost-based optimizers work, the pitfalls of cardinality estimation, and the internals of PostgreSQL and MySQL — a
2026-04-15 · 24 min read #database#query-optimizer#volcano#cascades#cost-basedCDC (Change Data Capture) Complete Guide 2025: Debezium, Kafka, Data Sync, Outbox Pattern
Everything about CDC — how it works (WAL/binlog based), Debezium architecture, PostgreSQL Logical Replication, MySQL binlog, Outbox Pattern, data warehouse sync, Kafka integration, migration, common pitfalls.
2026-04-15 · 11 min read #cdc#debezium#kafka#postgresql#mysqlKubernetes Database Deep Dive 2025: Operator Patterns, HA Configuration, Backup/Recovery, Performance Tuning
K8s DB operations deep dive! CloudNativePG vs Percona Operator comparison, Primary-Replica automatic Failover, pgBackRest/Velero backup, WAL archiving, Connection Pooling (PgBouncer), resource tuning (CPU/Memory/IOPS), A
2026-04-13 · 20 min read #kubernetes#database#operator#cloudnativepg#perconaRunning Databases on K8s -- Complete Guide to CNPG, Percona, Vitess, and Helm Charts
A comprehensive overview of running databases in Kubernetes environments. We compare CloudNativePG, Percona Operator, Vitess, and major Helm charts, and share practical operational know-how.
2026-04-11 · 15 min read #database#kubernetes#cnpg#postgresql#mysqlRunning Databases on Kubernetes Complete Guide: StatefulSet, Operators, Backup and Recovery
Everything about running DBs on K8s! StatefulSet vs Deployment, PV/PVC/StorageClass, DB Operators (CloudNativePG/Percona/MongoDB), Backup/Recovery (Velero/pgBackRest), Monitoring (PMM), HA/Failover, Performance Tuning, P
2026-03-24 · 17 min read #kubernetes#database#statefulset#operator#postgresqlDatabase Performance Tuning Complete Guide: Query Optimization, Index Strategy, Connection Pool Management
Everything about DB performance tuning! EXPLAIN ANALYZE interpretation, index design (B-Tree/GIN/BRIN), slow query analysis, connection pooling (HikariCP/PgBouncer), N+1 resolution, partitioning, read replicas, query cac
2026-03-24 · 22 min read #database#performance#tuning#indexing#query-optimizationSQL Mastery 2025: Developer Interview SQL — From JOINs to Window Functions and Query Optimization
Everything about SQL interviews! 7 types of JOINs, Window Functions (ROWNUMBER/RANK/LAG/LEAD), Subquery vs CTE, Index internals (B-Tree/Hash/GIN), EXPLAIN ANALYZE, Transaction Isolation Levels, and 30 practice problems.
2026-03-23 · 30 min read #sql#database#join#window-function#indexingDatabase Complete Comparison 2025: PostgreSQL vs MySQL vs MongoDB vs Redis — Selection Guide
Everything about database selection in 2025! PostgreSQL (JSONB+pgvector), MySQL (HeatWave ML), MongoDB (Atlas Vector Search), Redis (Stack/Search) — architecture, performance benchmarks, cost comparison, use-case selecti
2026-03-23 · 29 min read #database#postgresql#mysql#mongodb#redisSpring Boot Database Connection Complete Guide: JPA, HikariCP, Transactions, QueryDSL, Multi-DB
Complete guide to Spring Boot database integration — JPA/Hibernate configuration, HikariCP connection pool optimization, transaction management, QueryDSL, multi-datasource, R2DBC, and slow query logging.
2026-03-17 · 10 min read #spring-boot#jpa#hikaricp#querydsl#transactionSpring Boot Flyway Complete Guide: Database Migration Strategy and Production Patterns
Complete guide to database migration with Flyway in Spring Boot — versioning strategy, multi-environment configuration, test strategies, Java-based migrations, and production deployment patterns.
2026-03-17 · 11 min read #spring-boot#flyway#db-migration#jpa#postgresqlMySQL Query Optimization Practical Guide: From EXPLAIN Analysis to Index Design and Slow Query Tuning
A comprehensive guide covering MySQL EXPLAIN/EXPLAIN ANALYZE output interpretation, B-Tree/Hash/Full-text index types, composite index design (leftmost prefix rule, covering index), query rewriting patterns (subquery to
2026-03-11 · 17 min read #database#mysql#query-optimization#explain#index-tuningMySQL 8.4 InnoDB Cluster Operations and Query Optimization Handbook
A practical operations handbook covering MySQL 8.4 InnoDB Cluster setup, Group Replication operations, query optimization, index strategies, slow query analysis, and disaster recovery.
2026-03-05 · 17 min read #database#mysql#innodb-cluster#2026-03SQL Practical Cheatsheet — Complete Reference for Everyday Commands
From SELECT, UPDATE, INSERT, DELETE to subqueries, window functions, CTEs, index strategies, and execution plan analysis. All the SQL patterns you use daily in one place. Copy and use right away.
2026-03-02 · 36 min read #database#sql#mysql#postgresql#select