by Kedar Vaijanapurkar | Apr 2, 2024 | Insight for DBAs, Monitoring, MySQL, Percona Software
This blog was originally published in June of 2023 and updated in April of 2024.As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring... by Kedar Vaijanapurkar | Dec 11, 2023 | Cloud, Insight for DBAs, MySQL
A quick configuration change may do the trick in improving the performance of your AWS RDS for MySQL instance. Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. While... by Kedar Vaijanapurkar | Dec 6, 2023 | Insight for DBAs, MySQL
During an interview or while having general discussions, I have found some funny responses that can be easily classified as “Wrong Answers,” but at times, they’re thought-provoking or involve a deep meaning within. This blog is regarding some of the... by Kedar Vaijanapurkar | Sep 20, 2023 | Insight for DBAs, MySQL
As a MySQL database administrator, you’re likely familiar with the SHOW REPLICA STATUS command. It is an important command for monitoring the replication status on your MySQL replicas. However, its output can be overwhelming for beginners, especially regarding... by Kedar Vaijanapurkar | Aug 1, 2023 | Insight for DBAs, MySQL
In the world of database management, ALTER TABLE operations are a crucial part of modifying database structures. MySQL, a popular database management system, offers online operations since version 5.6, providing a convenient way to perform these alterations without... by Kedar Vaijanapurkar | Apr 12, 2023 | Insight for DBAs, MySQL, Percona Software
During the early stages of my career, I was captivated by the theories and concepts surrounding foreign keys and how they empowered us to maintain data integrity. However, in practical application, I have found them to be quite challenging to manage. I am sure... by Kedar Vaijanapurkar | Apr 11, 2023 | Insight for DBAs, MySQL, Percona Software
Indexes are crucial for optimizing query execution times in databases, but having an excessive number of indexes, or redundant ones, can negatively impact performance. While pt-duplicate-key-checker is the go-to tool for identifying duplicate or redundant indexes in... by Kedar Vaijanapurkar | Sep 7, 2022 | Insight for DBAs, MySQL
A large table is a pain for many reasons as long as it is in a system. And as if that’s not enough, it is also a difficult task to get rid of it. In this post, we will understand why it is a pain to do this operation and what we can do about it. It will be like... by Kedar Vaijanapurkar | Apr 19, 2022 | MySQL
As a best practice before dropping a large table in MySQL, pt-archiver can be used to delete all the records in batches. This helps to avoid a situation where your server may get stalled under certain circumstances.I recently read a comment from a user saying...