Tag: MySQL
5 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.
-
SQL vs NoSQL: Choosing Between PostgreSQL, MySQL, MongoDB and Redis
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: Data Types, JSON, Locking, Replication and 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.
-
Node.js Database Integration: MongoDB, PostgreSQL, and MySQL
Connect Node.js to MongoDB (Mongoose), PostgreSQL (pg, Sequelize), and MySQL (mysql2): connection pools, CRUD, transactions, REST examples, indexes.