by Sveta Smirnova | Jan 3, 2024 | Monitoring, Open Source, Percona Software
A couple of weeks ago, we announced the first GA release of the PMM Dump: a new support tool that dumps Percona Monitoring and Management (PMM) metrics and Query Analytics (QAN) data to transfer to the expert engineer for review and performance suggestions. That blog... by Sveta Smirnova | Dec 22, 2023 | Insight for DBAs, Insight for Developers, Percona Software
Percona Toolkit 3.5.6 was released on December 21, 2023. This blog post covers the main changes in this release. New tool: pt-galera-log-explainer We continue adding more instruments for the Support teams. pt-galera-log-explainer was written by my Percona Support... by Sveta Smirnova | Dec 6, 2023 | Insight for DBAs, Monitoring, Percona Software
In this post, I will present a new Percona tool: PMM Dump. The PMM Dump performs a logical backup of the performance metrics collected by the Percona Monitoring and Management (PMM) Server and imports them into a different PMM Server instance. PMM Dump allows you to... 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... 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 Sveta Smirnova | Sep 26, 2023 | Insight for DBAs, MySQL, Percona Software
This blog post discusses the limitations of the MySQL Clone plugin.The MySQL clone plugin significantly simplifies the process of replica provisioning. All you need to do is: Ensure that the source server has binary logs enabled Grant appropriate permissions Execute... by Sveta Smirnova | Sep 1, 2023 | Insight for DBAs, MySQL
This blog was originally published in November 2021 and was updated in September 2023.MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this... by Sveta Smirnova | Jul 29, 2022 | Benchmarks, Insight for DBAs, MySQL, Percona Software
In this blog, I will cover important aspects which you need to test when benchmarking replication setup. MySQL has great tools that could be used to test its performance. They include:sysbench – https://github.com/akopytov/sysbenchBMK-kit –... by Sveta Smirnova | Jul 21, 2022 | Insight for DBAs, MySQL
In this blog, I explain how to recover from a replication failure caused by a corrupted relay log file.MySQL replica stores data received from its source binary log in the relay log file. This file could be corrupted due to various reasons, mostly hardware failures.... by Sveta Smirnova | Jul 13, 2022 | Monitoring, MySQL, Percona Software
In this blog, I will demonstrate how to use Percona Monitoring and Management (PMM) to find out the reason why the MySQL server is stalling. I will use only one typical situation for the MySQL server stall in this example, but the same dashboards, graphs, and... by Sveta Smirnova | Apr 6, 2022 | Insight for DBAs, MySQL, Security
For my previous blog post on the topic, I received plenty of questions about why I did not cover the caching_sha2_password plugin. This plugin is the default since MySQL 8, and all user accounts which are created without the option IDENTIFIED WITH, will use this... by Sveta Smirnova | Mar 29, 2022 | Insight for DBAs, Insight for Developers, MySQL
The utf8mb4 character set is the new default as of MySQL 8.0, and this change neither affects existing data nor forces any upgrades.Migration to utf8mb4 has many advantages including: It can store more symbols, including emojis It has new collations for Asian... by Sveta Smirnova | Mar 22, 2022 | Insight for DBAs, MySQL
When MySQL client connects to the server it uses one of the authentication plugins. On the server-side, plugins are located in the directory, specified by the option plugin-dir that defaults to BASEDIR/lib/plugin where BASEDIR is the base directory of your... by Sveta Smirnova | Dec 31, 2021 | MySQL, Percona Announcements
In Percona Support we spend a few hours per week doing Labs: short collective projects, not directly related to the tickets.One of our last labs was about to get ready for the winter holiday season which means preparing the tree and decorating it. To do it we used our... by Sveta Smirnova | Dec 29, 2021 | Insight for Developers, MySQL, Webinars
First I want to thank everyone who attended my November 16, 2021 webinar “MySQL Performance for DevOps“. Recording and slides are available on the webinar page.Here are answers to the questions from participants which I was not able to provide during the... by Sveta Smirnova | Dec 2, 2021 | MySQL, Webinars
First, I want to thank everyone who attended my November 9, 2021 webinar “Introduction to MySQL Query Tuning for Dev[Op]s“. Recording and slides are available on our webinars page.Here are answers to the questions from participants which I was not able to... by Sveta Smirnova | Oct 4, 2021 | Insight for DBAs, MySQL, Percona Software
It is a common use case to synchronize data in two tables inside MySQL servers. This blog post describes one specific case: how to synchronize data between two different tables on the same MySQL server. This could be useful, for example, if you test DML query... by Sveta Smirnova | Jul 7, 2021 | Insight for DBAs, MySQL, Open Source
“It would be nice to have an option, that would allow to suppress the DEFINER statement in the CREATE VIEW statements generated by mysqldump. This would help when transferring data structures between databases with different security models.” TLDR;... by Sveta Smirnova | Apr 23, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Apologies for the silly title, but the issue is a real one, even though it is not a new thing. Schema upgrades are not an ordinary operation in Galera. For the subject at hand, the bottom line is: under the default Total Order Isolation (TOI) method, “the... by Sveta Smirnova | Apr 2, 2021 | Insight for DBAs, MySQL, Percona Software
Recovering to a particular time in the past is called Point-In-Time Recovery (PITR). With PITR you can rollback unwanted DELETE without WHERE clause or any other harmful command.PITR with Percona XtraBackup is pretty straightforward and perfectly described in the user...