- 22
- 11 566
K V
India
Приєднався 23 сер 2013
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-diff
By 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.
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-diff
By 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.
Переглядів: 30
Відео
MySQL Replication Basics - Part 3 Replica Lag
Переглядів 7514 днів тому
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 tips Learn how to keep your replicas in sync and ensure high availability! #MySQL #Replication #DatabasePerformance #MySQLTips #HighAvailability #DatabaseAdmin #MySQLTutorial #TechPodcast
MySQL Replication Basics - Part 2 binary logs and more
Переглядів 7321 день тому
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
MySQL Replication Basics - Part 1 Introduction
Переглядів 13921 день тому
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 (Repl...
AI tools - technology and kids
Переглядів 3721 день тому
In this video, we explore how AI tools like ChatGPT and Gemini are shaping the future of kids' education. While these technologies can enhance learning, it's crucial to avoid the pressure of "keeping up" and pushing kids into tech too early. We'll discuss how to balance AI use with creativity, critical thinking, and traditional learning to help children thrive in both the digital world and the ...
Duplicate indexes in MySQL and more
Переглядів 56Місяць тому
In this video, we dive into the topic of duplicate and redundant indexes in MySQL. Duplicate indexes, often unintentional, can degrade performance by taking up extra storage and increasing the workload on the query optimizer. We’ll explain the differences between duplicate and redundant indexes, highlight the performance impact, and share best practices for identifying and removing them. Optimi...
MySQL performance low hanging fruits
Переглядів 50Місяць тому
This is a podcast helping you gaining the best MySQL performance with minimal efforts by concentrating on specific points noted. This podcast will include configuration, performance and the most common problem scenarios that you can relate, examine and implement to improve the MySQL performance. Refer: kedar.nitty-witty.com/blog/the-low-hanging-fruits-of-mysql-percona-live-community-2022
MySQL Debugging checklist
Переглядів 31Місяць тому
This podcast will discuss the MySQL Debugging Checklist, which outlines steps and tasks crucial for identifying and resolving MySQL issues. It aims to provide you with the guideline of what-to-look-for and where without missing points. Reference: kedar.nitty-witty.com/blog/what-do-you-need-to-debug-mysql-issues-a-checklist
MySQL Change Buffer
Переглядів 135Місяць тому
MySQL Change Buffer - A discussion and FAQ Reference: kedar.nitty-witty.com/blog/mysql-change-buffer-what-when-and-faq
How to Save Costs by MySQL Upgrade | RDS
Переглядів 10910 місяців тому
#AWS #RDS has been kind enough to provide the extended support for the £MySQL 5.7 though that comes to an additional price which is almost 2 to 3x. £Upgrade to MySQL 8 is Inevitable. The cost of staying on older version is not only about Performance and Security. It includes real $$$. If you need help upgrading: kedar@nitty-witty.com
MySQL Replication, GTID, SSL Encryption
Переглядів 213Рік тому
MySQL Replication, GTID, SSL Encryption
Create a compound key with auto_increment in phpMyAdmin gui with MariaDB
Переглядів 26Рік тому
Create a compound key with auto_increment in phpMyAdmin gui with MariaDB
Install specific version percona server mysql on Ubuntu
Переглядів 337Рік тому
Install specific version percona server mysql on Ubuntu
Encryption with Percona Server for MySQL - Percona Virtual Tech Days
Переглядів 151Рік тому
Encryption with Percona Server for MySQL - Percona Virtual Tech Days
Restore single MySQL table from Xtrabackup
Переглядів 241Рік тому
Restore single MySQL table from Xtrabackup
Haan Bhai Haan meme (Vicks Advertize)
Переглядів 6 тис.7 років тому
Haan Bhai Haan meme (Vicks Advertize)
mysqldumpsplitter - extract or split mysql database / table from mysqldump
Переглядів 3,6 тис.9 років тому
mysqldumpsplitter - extract or split mysql database / table from mysqldump
Thanks for discussing about percona tools. It's really useful in real time world.
Thank you for tips to improving mysql performance.
Please cover topics related to high availability for databases like replication best practises
This is excellent with the presentation
Nice!
Pretty nice tutorial Thanks, another tips and trick can be found here : ua-cam.com/video/OsYzb3AQGQE/v-deo.html