Mon, 13 May 2024 13:19:30 +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/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/ https://www.percona.com/blog/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/#respond Mon, 13 May 2024 13:19:30 +0000 https://www.percona.com/blog/?p=96293 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 access for application users and preventing application downtime. We will focus here on utilizing the powerful “pt-online-schema-change” […]]]> https://www.percona.com/blog/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/feed/ 0 96293 https://www.percona.com/blog/duplicate-redundant-and-invisible-indexes/ https://www.percona.com/blog/duplicate-redundant-and-invisible-indexes/#respond Tue, 02 Apr 2024 13:55:28 +0000 https://www.percona.com/blog/?p=84444 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 is used to quickly locate data without having to […]]]> https://www.percona.com/blog/duplicate-redundant-and-invisible-indexes/feed/ 0 84444 https://www.percona.com/blog/mysql-general-tablespaces-a-powerful-storage-option-for-your-data/ https://www.percona.com/blog/mysql-general-tablespaces-a-powerful-storage-option-for-your-data/#comments Thu, 04 Jan 2024 14:48:51 +0000 https://www.percona.com/blog/?p=93213 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 illustrative examples.What are MySQL general tablespaces?In contrast to the single system tablespace that holds system tables by default, general tablespaces are […]]]> https://www.percona.com/blog/mysql-general-tablespaces-a-powerful-storage-option-for-your-data/feed/ 1 93213 https://www.percona.com/blog/auto-increment-counter-persistence-in-mysql-8-comparing-the-evolution-from-mysql-5-7/ https://www.percona.com/blog/auto-increment-counter-persistence-in-mysql-8-comparing-the-evolution-from-mysql-5-7/#respond Tue, 12 Sep 2023 12:15:37 +0000 https://www.percona.com/blog/?p=90592 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 enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and […]]]> https://www.percona.com/blog/auto-increment-counter-persistence-in-mysql-8-comparing-the-evolution-from-mysql-5-7/feed/ 0 90592 https://www.percona.com/blog/mysql-8-new-transaction-data-dictionary-storing-information-about-database-objects/ https://www.percona.com/blog/mysql-8-new-transaction-data-dictionary-storing-information-about-database-objects/#respond Wed, 09 Aug 2023 12:33:48 +0000 https://www.percona.com/blog/?p=89961 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 metadata, resulting in better reliability and scalability for various database objects. In this blog post, we will explore the […]]]> https://www.percona.com/blog/mysql-8-new-transaction-data-dictionary-storing-information-about-database-objects/feed/ 0 89961 https://www.percona.com/blog/provisioning-replication-with-clone-plugin/ https://www.percona.com/blog/provisioning-replication-with-clone-plugin/#comments Tue, 08 Aug 2023 13:58:14 +0000 https://www.percona.com/blog/?p=89723 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, and data dictionary metadata. The clone plugin allows for easy provisioning of MySQL […]]]> https://www.percona.com/blog/provisioning-replication-with-clone-plugin/feed/ 1 89723 https://www.percona.com/blog/understanding-the-differences-between-innodb-undo-log-and-redo-log/ https://www.percona.com/blog/understanding-the-differences-between-innodb-undo-log-and-redo-log/#respond Mon, 07 Aug 2023 12:05:57 +0000 https://www.percona.com/blog/?p=89503 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 database systems. Additionally, they are essential for the Multi-Version Concurrency Control (MVCC) mechanism. In this blog […]]]> https://www.percona.com/blog/understanding-the-differences-between-innodb-undo-log-and-redo-log/feed/ 0 89503 https://www.percona.com/blog/the-power-of-utf8mb4-in-mysql-8-0-unleashing-the-full-potential-of-multilingual-data/ https://www.percona.com/blog/the-power-of-utf8mb4-in-mysql-8-0-unleashing-the-full-potential-of-multilingual-data/#respond Thu, 13 Jul 2023 12:03:29 +0000 https://www.percona.com/blog/?p=89405 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 relational database management systems, recognizes this need and has introduced utf8mb4 in […]]]> https://www.percona.com/blog/the-power-of-utf8mb4-in-mysql-8-0-unleashing-the-full-potential-of-multilingual-data/feed/ 0 89405 https://www.percona.com/blog/using-percona-toolkit-to-alter-database-tables-online-a-controlled-approach/ https://www.percona.com/blog/using-percona-toolkit-to-alter-database-tables-online-a-controlled-approach/#respond Mon, 12 Dec 2022 14:22:20 +0000 https://www.percona.com/blog/?p=84139 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 pt-online-schema-change, a utility that alters the structure of a table without interfering with the reads […]]]> https://www.percona.com/blog/using-percona-toolkit-to-alter-database-tables-online-a-controlled-approach/feed/ 0 84139 https://www.percona.com/blog/percona-xtradb-cluster-on-amazon-ec2-and-two-interesting-changes-in-pxc-8-0/ https://www.percona.com/blog/percona-xtradb-cluster-on-amazon-ec2-and-two-interesting-changes-in-pxc-8-0/#comments Thu, 15 Sep 2022 12:02:13 +0000 https://www.percona.com/blog/?p=82672 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 Cluster is a cost-effective, high-performance clustering solution for mission-critical data. It […]]]> https://www.percona.com/blog/percona-xtradb-cluster-on-amazon-ec2-and-two-interesting-changes-in-pxc-8-0/feed/ 2 82672 https://www.percona.com/blog/two-extremely-useful-tools-pt-upgrade-and-checkforserverupgrade-for-mysql-upgrade-testing/ https://www.percona.com/blog/two-extremely-useful-tools-pt-upgrade-and-checkforserverupgrade-for-mysql-upgrade-testing/#respond Mon, 29 Aug 2022 11:53:10 +0000 https://www.percona.com/blog/?p=82334 My last blog, Percona Utilities That Make Major MySQL Version Upgrades Easier, detailed the tools available from the Percona toolkit that assists us with major MySQL version upgrades. The pt-upgrade tool aids in testing application queries and generates reports on how each question performs on servers running various versions of MySQL.MySQL Shell Upgrade Checker is […]]]> https://www.percona.com/blog/two-extremely-useful-tools-pt-upgrade-and-checkforserverupgrade-for-mysql-upgrade-testing/feed/ 0 82334 https://www.percona.com/blog/percona-utilities-that-make-major-mysql-version-upgrades-easier/ https://www.percona.com/blog/percona-utilities-that-make-major-mysql-version-upgrades-easier/#respond Wed, 09 Feb 2022 12:58:51 +0000 https://www.percona.com/blog/?p=80047 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 vulnerable. Major version upgrades, on the other hand, can be problematic if […]]]> https://www.percona.com/blog/percona-utilities-that-make-major-mysql-version-upgrades-easier/feed/ 0 80047 https://www.percona.com/blog/using-mysql-8-persisted-system-variables/ Tue, 27 Oct 2020 16:13:18 +0000 https://www.percona.com/blog/?p=72010 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 persistent and are reset upon restart. These variables can be changed at […]]]> 72010 https://www.percona.com/blog/mysql-docker-containers-quick-async-replication-test-setup/ https://www.percona.com/blog/mysql-docker-containers-quick-async-replication-test-setup/#comments Fri, 27 Dec 2019 15:34:37 +0000 https://www.percona.com/blog/?p=63852 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 container allows us to package all parts of the application it needs, […]]]> https://www.percona.com/blog/mysql-docker-containers-quick-async-replication-test-setup/feed/ 6 63852 https://www.percona.com/blog/mysql8-hot-rows-with-nowait-skip-locked/ Fri, 29 Jun 2018 13:44:52 +0000 https://www.percona.com/blog/?p=50758 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? It’s likely that you have the application attempt […]]]> 50758 https://www.percona.com/blog/5-free-handy-tools-for-monitoring-and-managing-mysql-replication/ https://www.percona.com/blog/5-free-handy-tools-for-monitoring-and-managing-mysql-replication/#comments Mon, 09 Mar 2015 15:50:24 +0000 https://www.percona.com/blog/?p=28870 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 instance to another slave instance and maintaining the redundant consistent data in a different machine. […]]]> https://www.percona.com/blog/5-free-handy-tools-for-monitoring-and-managing-mysql-replication/feed/ 9 28870 https://www.percona.com/blog/the-mysql-query-cache-how-it-works-and-workload-impacts-both-good-and-bad/ https://www.percona.com/blog/the-mysql-query-cache-how-it-works-and-workload-impacts-both-good-and-bad/#comments Fri, 02 Jan 2015 08:00:13 +0000 https://www.percona.com/blog/?p=27490 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 workload.The MySQL query cache is a global one shared among the […]]]> https://www.percona.com/blog/the-mysql-query-cache-how-it-works-and-workload-impacts-both-good-and-bad/feed/ 9 27490 https://www.percona.com/blog/how-a-set-of-queries-can-be-killed-in-mysql-using-pt-kill/ https://www.percona.com/blog/how-a-set-of-queries-can-be-killed-in-mysql-using-pt-kill/#comments Wed, 19 Nov 2014 15:18:49 +0000 https://www.percona.com/blog/?p=26735 https://www.percona.com/blog/how-a-set-of-queries-can-be-killed-in-mysql-using-pt-kill/feed/ 1 26735 https://www.percona.com/blog/how-to-avoid-hash-collisions-when-using-mysqls-crc32-function/ https://www.percona.com/blog/how-to-avoid-hash-collisions-when-using-mysqls-crc32-function/#comments Mon, 13 Oct 2014 14:43:42 +0000 https://www.percona.com/blog/?p=26131 https://www.percona.com/blog/how-to-avoid-hash-collisions-when-using-mysqls-crc32-function/feed/ 2 26131