Deep Dive MySQL

Deep Dive MySQL

By Kedar VaijanapurkarTechnology
Download on the App Store

All Deep Dive MySQL episodes

  • Useful scripts for MySQL in Percona Toolkit

    In this episode, we explore several key tools within the Percona Toolkit that every database administrator and developer should know. From zero-downtime schema modifications to performance optimization and replication management, we cover essential tools that can improve your MySQL database management process.Key topics covered include: Zero-downtime schema changes with pt-online-schema-change Performance diagnostics and optimization with pt-mysql-summary, pt-summary, pt-kill, pt-query-digest, pt-duplicate-key-checker Replication management and data integrity with pt-slave-restart, pt-table-checksum, pt-table-sync Configuration management with pt-config-diffBy the end of the episode, you'll have a clear understanding of how these tools work together to enhance efficiency, performance, and reliability when managing MySQL databases.


    18 min
  • MySQL Replication Basics - Part 3 Replica Lag

    In this episode, we cover the essentials of MySQL replication lag: - What causes replica lag and how to detect it - Best practices to minimize lag - Remedies and troubleshooting tipsLearn how to keep your replicas in sync and ensure high availability!#MySQL #Replication #DatabasePerformance #MySQLTips #HighAvailability #DatabaseAdmin #MySQLTutorial #TechPodcast


    22 min
  • MySQL Replication Basics - Part 2 binary logs and more

    Tune in to get a deeper understanding of how binary and relay logs are critical to MySQL replication. Whether you're optimizing replication performance or troubleshooting replication issues, this episode will equip you with the knowledge to take control of your MySQL replication environment.

    #MySQL #Replication #BinaryLogs #RelayLogs #Database #DBA #TechPodcast #MySQLReplication

    11 min
  • MySQL Replication Basics - Part 1

    Welcome to the MySQL Replication Basics podcast, where we take a deep dive into one of the most essential features of MySQL for achieving high availability and scalability in your database environments.


    Introduction to MySQL Replication

    * What is MySQL Replication?

    * Overview of replication concepts

    * Why Use MySQL Replication?

    * Key Terminology in MySQL Replication

    Master (Primary)

    Slave (Replica)

    Binary Log (binlog)

    Relay Log

    I/O Thread

    SQL Thread

    Replication Filters (database and table level replication filters)

    18 min
  • Low Hanging Fruits of MySQL Performance

    MySQL is one of the top used database system and with highly active community. Though without proper configuration you may not squeeze the most out of it.
    This will be a talk about the low hanging fruits to get the best outcome preferably in a short time or with small efforts. This will include configuration, performance and the most common problem scenarios that you can relate, examine and implement.

    25 min
  • Duplicate Indexes in MySQL and more

    In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at hand.

    Reference: https://kedar.nitty-witty.com/blog/podcast-duplicate-indexes-in-mysql

    16 min
  • MySQL Change Buffer - A discussion and FAQ

    In the world of database management, efficiency is key. MySQL’s change buffer is a powerful feature that helps optimize how secondary index changes are managed. The idea of introducing a change buffer is an amazing solution for enhancing MySQL performance. Let’s explore the change buffer, how it works, and when you might want to enable or disable it.Reference: https://kedar.nitty-witty.com/blog/mysql-change-buffer-what-when-and-faq

    24 min