by Brijesh Chauhan | Dec 20, 2023 | Insight for DBAs, MySQL
The InnoDB buffer pool acts as a powerhouse for MySQL, caching frequently accessed data and index pages in memory to accelerate query performance. In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to...
by Mani Paluru | Dec 13, 2023 | Insight for DBAs, MySQL
Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the system’s stability and performance. MySQL 8 introduces Error Log Filtering as a mechanism to fine-tune the error log, allowing...
by Larry Xia | Dec 12, 2023 | Insight for DBAs, MySQL, Percona Software
In Percona Managed Services, we manage Percona for MySQL, Community MySQL, and MariaDB. Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’s...
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 this...
by Totel | Dec 8, 2023 | Insight for DBAs, MySQL, Percona Software
In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived. Let us...
by Mohit Joshi | Dec 7, 2023 | Insight for DBAs, MySQL, Percona Software
Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of...
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 Patrick Birch | Nov 8, 2023 | MySQL, Percona Software
With the release of Percona XtraBackup 8.0.34-39, Percona XtraBackup (PXB) allows a backup on server version 8.0.35 and higher. We have removed the server version check because the MySQL 8.0 series has transitioned to bug fixes. A feature change in the MySQL 8.0...
by David Stokes | Nov 6, 2023 | Insight for DBAs, Insight for Developers, MySQL
Oracle recently made their quarterly releases with MySQL 8.0.35 and MySQL 8.2. This blog post is a quick look at the release notes to see what these new versions bring to the community. You’ll want to keep an eye on the deprecations in particular because some...
by Przemysław Malkowski | Nov 1, 2023 | Insight for DBAs, MariaDB, MySQL, Percona Software
Sometimes, there is a need to update the table and index statistics manually using the ANALYZE TABLE command. Without going further into the reasons for such a need, I wanted to refresh this subject in terms of overhead related to running the command on production...
by Fernando Mattera | Oct 31, 2023 | Insight for DBAs, MySQL, Percona Services
Hello friends, In Managed Services, we have the opportunity to see different technologies and various topologies, which makes the work fascinating and challenging at the same time. This time, I’m going to tell you about a particular case: a client with a...
by Sveta Smirnova | Oct 17, 2023 | Insight for DBAs, MySQL
This blog post discusses using the CLONE INSTANCE command with the safety option DATA DIRECTORY when you do not have enough disk space to store two datasets. In my previous blog post on the CLONE INSTANCE command, The MySQL Clone Plugin Is Not Your Backup, I...
by Jinyou Ma | Oct 13, 2023 | Insight for DBAs, MySQL
Visual Studio Code (VS) supports memory dump debugging via C/C++ extension: https://code.visualstudio.com/docs/cpp/cpp-debug#_memory-dump-debugging. When MySQL generates a core file, the VS code simplifies the process of debugging. This blog will discuss how to debug...
by Gaurav Pareek | Oct 13, 2023 | Insight for DBAs, MySQL
by Juan Arruti | Oct 12, 2023 | Cloud, Monitoring, MySQL
In this blog post, we’ll review how to run Linux profilers such as perf and produce flame graphs on Kubernetes environments. Flame graphs are a graphical representation of function calls. It shows which code paths are more busy on the CPU in given samples. They...
by Uday Rajarapu | Oct 11, 2023 | Insight for DBAs, MySQL
This blog post discusses roles in MySQL 8.0, which are named collections of privileges. Like user accounts, roles can have privileges granted and revoked as required. Typically, we have multiple users with the same set of privileges. Previously, the only way to grant...
by Ananias Tsalouchidis | Oct 10, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Performing an operation is always challenging when dealing with K8s. When on-prem or DBaaS like RDS or Cloud SQL, it is relatively straightforward to apply a change. You can perform a DIRECT ALTER, use a tool such as pt-osc, or even, for certain cases where async...
by Sveta Smirnova | Oct 4, 2023 | Insight for Developers, MySQL, Percona Software, PostgreSQL
Percona Toolkit 3.5.5 was released on October 3, 2023. This blog post covers the main changes in this release. pt-online-schema-change improvements After nibble hook This was contributed by Marcelo HP Ferreira at https://github.com/percona/percona-toolkit/pull/645....
by Brian Sumpter | Oct 3, 2023 | Insight for DBAs, Insight for Developers, MySQL
Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we...
by Bhuvanes Waran | Sep 29, 2023 | Insight for DBAs, MySQL
As a DBA, one of the very frequent tasks is to stop/start MySQL service for batching or some other activities. Before stopping MySQL, we may need to check if there are any active connections; if there are, we may need to kill all those. Generally, we use pt-kill to...
