by Arunjith Aravindan | Jan 4, 2023 | Insight for DBAs, MySQL, Percona Software
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 is used to quickly locate data without having to search every row in a table....
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 | 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 are...
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 – of your...
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 a...
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 synchronizes...