Mon, 29 Apr 2024 14:07:35 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/mysql-key-performance-indicators https://www.percona.com/blog/mysql-key-performance-indicators#respond Tue, 02 Apr 2024 09:00:29 +0000 https://www.percona.com/blog/?p=88829 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 and Management (PMM) is a popular choice among open source options for […]]]> https://www.percona.com/blog/mysql-key-performance-indicators/feed/ 0 88829 https://www.percona.com/blog/maximizing-performance-of-aws-rds-for-mysql-with-dedicated-log-volumes/ https://www.percona.com/blog/maximizing-performance-of-aws-rds-for-mysql-with-dedicated-log-volumes/#comments Mon, 11 Dec 2023 15:09:52 +0000 https://www.percona.com/blog/?p=92321 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 this discussion primarily targets MySQL instances, the principles are also relevant to […]]]> https://www.percona.com/blog/maximizing-performance-of-aws-rds-for-mysql-with-dedicated-log-volumes/feed/ 6 92321 https://www.percona.com/blog/mysql-interview-questions-wrong-answers-only/ https://www.percona.com/blog/mysql-interview-questions-wrong-answers-only/#comments Wed, 06 Dec 2023 16:51:03 +0000 https://www.percona.com/blog/?p=92274 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 usual MySQL database conversations and responses, which can appear “wrong” or “funny,” but there’s actually […]]]> https://www.percona.com/blog/mysql-interview-questions-wrong-answers-only/feed/ 3 92274 https://www.percona.com/blog/how-to-read-simplified-show-replica-status/ https://www.percona.com/blog/how-to-read-simplified-show-replica-status/#comments Wed, 20 Sep 2023 13:47:11 +0000 https://www.percona.com/blog/?p=90914 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 the binary log coordinates. I have seen confusion amongst new DBAs on which binary log file and […]]]> https://www.percona.com/blog/how-to-read-simplified-show-replica-status/feed/ 3 90914 https://www.percona.com/blog/how-to-alter-a-varchar-column-online-in-mysql-caveats-and-solutions/ https://www.percona.com/blog/how-to-alter-a-varchar-column-online-in-mysql-caveats-and-solutions/#respond Tue, 01 Aug 2023 13:51:56 +0000 https://www.percona.com/blog/?p=89687 This blog post explains the error Cannot change column type INPLACE for a VARCHAR column and offers solution to perform the ALTER operation.]]> https://www.percona.com/blog/how-to-alter-a-varchar-column-online-in-mysql-caveats-and-solutions/feed/ 0 89687 https://www.percona.com/blog/dont-auto-pt-online-schema-change-for-tables-with-foreign-keys/ https://www.percona.com/blog/dont-auto-pt-online-schema-change-for-tables-with-foreign-keys/#respond Wed, 12 Apr 2023 13:12:51 +0000 https://www.percona.com/blog/?p=86974 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 you’re a champion DBA, but I keep my distance from foreign […]]]> https://www.percona.com/blog/dont-auto-pt-online-schema-change-for-tables-with-foreign-keys/feed/ 0 86974 https://www.percona.com/blog/take-this-unique-quiz-about-duplicate-indexes-in-mysql-pt-duplicate-key-checker/ https://www.percona.com/blog/take-this-unique-quiz-about-duplicate-indexes-in-mysql-pt-duplicate-key-checker/#comments Tue, 11 Apr 2023 11:57:32 +0000 https://www.percona.com/blog/?p=86697 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 MySQL, it may not catch all duplicates.In this blog post, we’ll put ourselves to the test and see […]]]> https://www.percona.com/blog/take-this-unique-quiz-about-duplicate-indexes-in-mysql-pt-duplicate-key-checker/feed/ 1 86697 https://www.percona.com/blog/speed-up-your-large-table-drops-in-mysql/ https://www.percona.com/blog/speed-up-your-large-table-drops-in-mysql/#comments Wed, 07 Sep 2022 12:25:57 +0000 https://www.percona.com/blog/?p=82521 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 […]]]> https://www.percona.com/blog/speed-up-your-large-table-drops-in-mysql/feed/ 1 82521 https://www.percona.com/blog/pt-archiver-with-auto-increment-column https://www.percona.com/blog/pt-archiver-with-auto-increment-column#comments Tue, 19 Apr 2022 13:12:03 +0000 https://www.percona.com/blog/?p=80733 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 “The pt-archiver is not working as expected! It is skipping […]]]> https://www.percona.com/blog/pt-archiver-with-auto-increment-column/feed/ 3 80733