Change Is Inevitable
  • Home
  • MySQL Podcast
    • MySQL Podcast (Spotify)
    • MySQL Podcast (Youtube)
  • MySQL
    • MySQL-Articles
    • AWS RDS
    • Percona Xtradb Cluster
    • MariaDB
    • Galera Cluster
    • ProxySQL
    • MySQL-Scripts
    • MySQL tools
    • MySQL Resources
  • Technical
    • QA-Testing
  • General
    • binary-to-decimal
    • Fermat’s Theorem
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright
Change Is Inevitable

Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects

  • Home
  • MySQL Podcast
    • MySQL Podcast (Spotify)
    • MySQL Podcast (Youtube)
  • MySQL
    • MySQL-Articles
    • AWS RDS
    • Percona Xtradb Cluster
    • MariaDB
    • Galera Cluster
    • ProxySQL
    • MySQL-Scripts
    • MySQL tools
    • MySQL Resources
  • Technical
    • QA-Testing
  • General
    • binary-to-decimal
    • Fermat’s Theorem
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright

MySQL Podcast

MySQL Partitioning and Archiving #podcast #mysqltutorials
The What of MySQL Archiving #podcast #mysqltutorials
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-archival

Whether you're a DBA, developer, or performance enthusiast, this guide will help you keep your MySQL databases lean and fast!

📖 Read the full blog: https://kedar.nitty-witty.com/blog/mysql-data-archiving-basics-considerations-mistakes-best-practices
🔔 Subscribe for more MySQL tips and deep dives!
💬 Got questions? Drop them in the comments!

#MySQL #DataArchival #DatabasePerformance #ptarchiver #ptonlineschemachange #MySQLTuning #DBA #Percona #Partitioning
MySQL Archiving Basics – considerations, mistakes, best practices
Recently I got asked about choosing between #ProxySQL versions. Best way to go about it is review the features and compare them. I reviewed ProxySQL documentation and release notes to prepare a summary.
Here is the quick 10 minutes podcast discussion for you to have a quick review.
I strongly recommend reviewing Official Documentation and Release Notes before making any decisions.
Author: https://kedar.nitty-witty.com/blog
References:
1. https://github.com/sysown/proxysql/releases
2. https://proxysql.com/documentation/

#MySQL #ProxySQL #databaseconcepts #MySQLPodcast #podcast
Choosing ProxySQL Versions
MySQL tool for online schema change #podcast #technology #databasesolutions
A podcast on MySQL debugging techniques #debugging #podcast #mysql #learning
MySQL #podcast best practices and learnings #mysqldb #databaseperformance
MySQL Best practices discussions #podcast #learning #onthego #databaseperformance
#MySQL performance basics #podcast #tutrial
Load More… Subscribe
Change Is Inevitable
Designed & Developed by Code Supply Co.
Go to mobile version