Tag: SQL
7 posts
-
MySQL Under the Hood: InnoDB Buffer Pool, MVCC Isolation, the Optimizer and Binlog Replication
Deep MySQL guide: InnoDB buffer pool and WAL, MVCC and isolation, cost-based optimizer, binlog replication, plus indexing, partitioning, and production.
-
PostgreSQL Query Optimization Guide | EXPLAIN· Indexes
Find slow PostgreSQL queries with pg_stat_statements and EXPLAIN ANALYZE, then fix them with the right indexes, VACUUM, PgBouncer and postgresql.conf tuning.
-
SQL vs NoSQL Database Guide | MySQL· PostgreSQL
A comparison of SQL and NoSQL databases covering data models, consistency guarantees, and when to choose each.
-
Reading MySQL EXPLAIN: Index Design, Statistics and Slow Query Fixes
How to read MySQL EXPLAIN and EXPLAIN ANALYZE output, design composite and covering indexes, refresh statistics with ANALYZE TABLE and histograms, and diagnose the queries that still ignore your index.
-
PostgreSQL vs MySQL | Deep Comparison | When to Use Each
PostgreSQL or MySQL? Compare data types, JSON, full-text search, locking, indexes, replication and extensions to decide which one fits your workload.
-
PostgreSQL vs MySQL: Schema, Transactions, Queries and Operations
PostgreSQL vs MySQL compared for schema flexibility, ACID, SQL features, replication, and ops—plus Node.js–friendly criteria to pick the right RDBMS.
-
Speeding Up Slow SQL: Index Design, Reading EXPLAIN, N+1 Queries, Joins and Subqueries
How B-Tree indexes work, how to order composite index columns, how to read EXPLAIN, why an existing index sometimes goes unused (functions, leading wildcards, OR, type conversion), fixing N+1 queries, and a find-fix-measure workflow for MySQL and PostgreSQL.