by Arunjith Aravindan | May 13, 2024 | Insight for DBAs, MySQL, Percona Software
Table modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach provides insights into the process of altering tables online in a controlled manner, ensuring uninterrupted... by Arunjith Aravindan | Apr 2, 2024 | Insight for DBAs, MySQL, Percona Software
This blog was originally published in January 2023 and was updated in April 2024.MySQL index is a data structure used to optimize the performance of database queries at the expense of additional writes and storage space to keep the index data structure up to date. It... by Arunjith Aravindan | Jan 4, 2024 | Insight for DBAs, MySQL, Security
Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. This blog discusses general tablespaces and explores their functionalities, benefits, and practical usage, along with... by Arunjith Aravindan | Sep 12, 2023 | Insight for DBAs, MySQL
The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. With the release of MySQL 8, a notable enhancement was introduced to the auto-increment counter. Compared to MySQL 5.7, this... by Arunjith Aravindan | Aug 9, 2023 | Insight for DBAs, MySQL
MySQL 8 brought a significant architectural transformation by replacing the traditional MyISAM-based system tables with the Transaction Data Dictionary (TDD), a more efficient and reliable approach. This upgrade has vastly improved the management and storage of... by Arunjith Aravindan | Aug 8, 2023 | Insight for DBAs, MySQL
The clone plugin was introduced in MySQL 8.0.17 and offers a convenient method for cloning data from either a local or remote MySQL server instance. This cloning process creates a physical snapshot of the data stored in InnoDB, including schemas, tables, tablespaces,... by Arunjith Aravindan | Aug 7, 2023 | Insight for DBAs, MySQL
In InnoDB, the undo log and the redo log are two indispensable components that play a vital role in maintaining data integrity and ensuring transactional consistency. Both logs are crucial in the ACID (Atomicity, Consistency, Isolation, Durability) properties of... by Arunjith Aravindan | Jul 13, 2023 | Insight for DBAs, MySQL
In the world of modern web applications, it is increasingly important to support a diverse range of languages and character sets. With the rise of globalization, the need to store and process multilingual data has become essential. MySQL, one of the most popular... by Arunjith Aravindan | Dec 12, 2022 | Insight for DBAs, MySQL, Percona Software
Table modifications are a common task for database administrators. In this blog, I’ll explain how to alter tables online in a controlled manner that does not disrupt application users or cause application downtime.One of the tools in Percona Toolkit is... by Arunjith Aravindan | Sep 15, 2022 | Cloud, MySQL, Percona Software
This article outlines the basic configurations for setting up and deploying Percona XtraDB Cluster 8.0 (PXC) on Amazon EC2, as well as what is new in the setup compared to Percona XtraDB Cluster 5.7. What is Percona XtraDB Cluster an ideal fit for? Percona XtraDB... by Arunjith Aravindan | Aug 29, 2022 | Insight for DBAs, MySQL, Percona Software
by Arunjith Aravindan | Feb 9, 2022 | Insight for DBAs, MySQL, Percona Software
It is essential to upgrade MySQL to the most recent version. Do you believe it’s tough to test and upgrade to a newer version?For a variety of reasons, including new features, performance advantages, bug corrections, and so on, databases with obsolete versions... by Arunjith Aravindan | Oct 27, 2020 | Insight for DBAs, Insight for Developers, MySQL
This blog discusses new features about the persisted system variables and how we can use it to make variable changes persistent. The MySQL server maintains system variables that control its operations. The dynamic variables used prior to the MySQL 8 release are not... by Arunjith Aravindan | Dec 27, 2019 | MySQL, Percona Software
This blog discusses a few concepts about Docker and how we can use it to run a MySQL async replication environment. Docker is a tool designed to make it easier for developers and sysadmins to create/develop, configure, and run applications with containers. The... by Arunjith Aravindan | Jun 29, 2018 | MySQL
In MySQL 8.0 there are two new features designed to support lock handling: NOWAIT and SKIP LOCKED. In this post, we’ll look at how MySQL 8.0 handles hot rows. Up until now, how have you handled locks that are part of an active transaction or are hot rows?... by Arunjith Aravindan | Mar 9, 2015 | MySQL, Percona Software
MySQL Replication is very simple to set up. In this post I’ll discuss its importance and five handy tools for monitoring and managing MySQL replication.What is MySQL Replication? It’s the process of copying the (real-time events) data from one master... by Arunjith Aravindan | Jan 2, 2015 | MySQL, Percona Software
The MySQL query cache is one of the prominent features in MySQL and a vital part of query optimization. It is important to know how the MySQL query cache works, as it has the potential to cause significant performance improvements – or a slowdown... by Arunjith Aravindan | Nov 19, 2014 | Insight for DBAs, MySQL, Percona Software
You might have encountered situations where you had to kill some specific select queries that were running for long periods and choking the database. This post will go into more detail with an example of report query offloading.Report query (select) offloading to... by Arunjith Aravindan | Oct 13, 2014 | MySQL, Percona Software
Percona Toolkit’s pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master – and the tool pt-table-sync...