database
PostgreSQL vs MySQL: Finding the Right Fit for Your OLTP Workloads
·686 words·4 mins
A comprehensive comparison of PostgreSQL and MySQL for OLTP scenarios, exploring their fundamental architectural differences in secondary index handling and MVCC implementation, with practical insights on when to choose each database.
Tackling Performance Degradation in Sharded MySQL Tables: Understanding the Root Cause and Solutions
·1712 words·9 mins
A comprehensive guide to understanding why MySQL queries slow down over time in sharded environments, exploring the underlying causes of storage fragmentation and MVCC-related issues, and providing practical solutions using table rebuilding techniques with OPTIMIZE TABLE for maintaining optimal database performance.