MySQL Archiving Basics - considerations, mistakes, best practices

https://is1-ssl.mzstatic.com/image/thumb/Podcasts211/v4/ad/21/06/ad2106d9-9331-517e-2153-1636f9f23893/mza_12774369936108477586.jpg/600x600bb.jpg

Deep Dive MySQL

Kedar Vaijanapurkar

16 episodes

1 week ago

Welcome to Deep Dive MySQL — your podcast for MySQL and related technologies! Whether you're starting out or an experienced DBA, even managers handling DBAs this podcast will help you understand the basics and concepts of MySQL. We explore MySQL specific topics in depth, covering replication, high availability, backups, performance tuning, Group Replication, and more. Gain practical insights, tips, and real-world techniques to strengthen your MySQL skills. Subscribe now and join the community of MySQL professionals and enthusiasts! Youtube: https://www.youtube.com/@mysqlz Thanks, K

Technology

RSS

All content for Deep Dive MySQL is the property of Kedar Vaijanapurkar and is served directly from their servers with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.

Technology

https://d3t3ozftmdmh3i.cloudfront.net/staging/podcast_uploaded_nologo/42453084/42453084-1731666974616-8a74a56e4e89d.jpg

MySQL Archiving Basics - considerations, mistakes, best practices

Deep Dive MySQL

12 minutes 56 seconds

6 months ago

MySQL Archiving Basics - considerations, mistakes, best practices

In this video, we dive into data archival in MySQL — what it is, why it's important, and how you can archive old data without impacting performance or risking data loss.We'll cover: ✅ Why archiving is essential for performance & cost✅ When and what data to archive✅ Methods like partitioning, pt-archiver, and pt-online-schema-change✅ Best practices to follow and common pitfalls to avoid✅ How to reclaim disk space post-archivalWhether you're a DBA, developer, or performance enthusiast, this guide will help you keep your MySQL databases lean and fast!📖 Read the full blog

🔔 Subscribe for more MySQL tips and deep dives!💬 Got questions? Drop them in the comments!#MySQL #DataArchival #DatabasePerformance #ptarchiver #ptonlineschemachange #MySQLTuning #DBA #Percona #Partitioning