Understanding MVCC in MySQL and PostgreSQL

MVCC (Multi-Version Concurrency Control) is a technique used in MySQL and PostgreSQL to manage concurrent access to the database. In this article, we will explore how MVCC works in MySQL and PostgreSQL and its benefits for developers and users.

June 5, 2024 · 4 min · 844 words · Bá Tới

A Comparison of Data Storage on Disk in PostgreSQL and MySQL

Explore how data is stored on disk in PostgreSQL and MySQL, two popular database management systems. Learn about their storage architecture, file structure, and data access optimization to understand the differences and similarities between the two systems.

March 24, 2024 · 5 min · 864 words · Bá Tới