Tue, 13 Feb 2024 17:07:58 +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/pmm-dump-gui-in-percona-monitoring-and-management-2-41-0/ https://www.percona.com/blog/pmm-dump-gui-in-percona-monitoring-and-management-2-41-0/#respond Wed, 03 Jan 2024 16:57:29 +0000 https://www.percona.com/blog/?p=93082 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 introduced a command-line interface. A week later, PMM 2.0.41.0 was […]]]> https://www.percona.com/blog/pmm-dump-gui-in-percona-monitoring-and-management-2-41-0/feed/ 0 93082 https://www.percona.com/blog/whats-new-in-percona-toolkit-3-5-6/ https://www.percona.com/blog/whats-new-in-percona-toolkit-3-5-6/#respond Fri, 22 Dec 2023 15:34:54 +0000 https://www.percona.com/blog/?p=92912 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-explainerWe continue adding more instruments for the Support teams. [crayon-664c836b357ed743983330-i/] was written by my Percona Support colleague Yoann La Cancellera. [crayon-664c836b357f5224183595-i/] filters, aggregates, and summarizes multiple Galera library logs together. The purpose of this tool […]]]> https://www.percona.com/blog/whats-new-in-percona-toolkit-3-5-6/feed/ 0 92912 https://www.percona.com/blog/percona-monitoring-and-management-dump-a-new-tool-to-support-percona-customers/ https://www.percona.com/blog/percona-monitoring-and-management-dump-a-new-tool-to-support-percona-customers/#respond Wed, 06 Dec 2023 14:42:00 +0000 https://www.percona.com/blog/?p=92365 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 share monitoring data collected by your PMM server securely […]]]> https://www.percona.com/blog/percona-monitoring-and-management-dump-a-new-tool-to-support-percona-customers/feed/ 0 92365 https://www.percona.com/blog/using-clone-instance-with-data-directory-on-replicas-with-data/ https://www.percona.com/blog/using-clone-instance-with-data-directory-on-replicas-with-data/#respond Tue, 17 Oct 2023 12:03:02 +0000 https://www.percona.com/blog/?p=91066 This blog post discusses using the [crayon-664c836b366be058960555-i/]  command with the safety option [crayon-664c836b366c3155550701-i/]  when you do not have enough disk space to store two datasets.In my previous blog post on the [crayon-664c836b366c6152739133-i/]  command, The MySQL Clone Plugin Is Not Your Backup, I mentioned that using the option [crayon-664c836b366c7959618572-i/]  helps to avoid situations where you need to re-initialize […]]]> https://www.percona.com/blog/using-clone-instance-with-data-directory-on-replicas-with-data/feed/ 0 91066 https://www.percona.com/blog/whats-new-in-percona-toolkit-3-5-5/ https://www.percona.com/blog/whats-new-in-percona-toolkit-3-5-5/#comments Wed, 04 Oct 2023 11:36:03 +0000 https://www.percona.com/blog/?p=91475 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 improvementsAfter nibble hookThis was contributed by Marcelo HP Ferreira at https://github.com/percona/percona-toolkit/pull/645. The feature allows you to define a custom plugin that will be triggered after copying each nibble.Here are a few examples of what you can […]]]> https://www.percona.com/blog/whats-new-in-percona-toolkit-3-5-5/feed/ 3 91475 https://www.percona.com/blog/the-mysql-clone-plugin-is-not-your-backup/ https://www.percona.com/blog/the-mysql-clone-plugin-is-not-your-backup/#respond Tue, 26 Sep 2023 14:03:53 +0000 https://www.percona.com/blog/?p=91075 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 the [crayon-664c836b3897b958825226-i/]  command on the recipient This works extremely easily when you provision a new […]]]> https://www.percona.com/blog/the-mysql-clone-plugin-is-not-your-backup/feed/ 0 91075 https://www.percona.com/blog/how-triggers-may-significantly-affect-the-amount-of-memory-allocated-to-your-mysql-server/ https://www.percona.com/blog/how-triggers-may-significantly-affect-the-amount-of-memory-allocated-to-your-mysql-server/#comments Fri, 01 Sep 2023 08:39:09 +0000 https://www.percona.com/blog/?p=78927 https://www.percona.com/blog/how-triggers-may-significantly-affect-the-amount-of-memory-allocated-to-your-mysql-server/feed/ 6 78927 https://www.percona.com/blog/how-to-benchmark-replication-performance-in-mysql/ https://www.percona.com/blog/how-to-benchmark-replication-performance-in-mysql/#respond Fri, 29 Jul 2022 11:56:16 +0000 https://www.percona.com/blog/?p=81980 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 – http://dimitrik.free.fr/blog/posts/mysql-perf-bmk-kit.htmlmysqlslap – https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.htmlLinkBench – https://github.com/facebookarchive/linkbenchI will not describe how to use them here, as you can find instructions on the provided […]]]> https://www.percona.com/blog/how-to-benchmark-replication-performance-in-mysql/feed/ 0 81980 https://www.percona.com/blog/how-to-resolve-error-reading-relay-log-event-after-relay-log-corruption/ https://www.percona.com/blog/how-to-resolve-error-reading-relay-log-event-after-relay-log-corruption/#respond Thu, 21 Jul 2022 12:04:50 +0000 https://www.percona.com/blog/?p=81894 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. If this happens, replication will stop working, and the error […]]]> https://www.percona.com/blog/how-to-resolve-error-reading-relay-log-event-after-relay-log-corruption/feed/ 0 81894 https://www.percona.com/blog/how-percona-monitoring-and-management-helps-you-find-out-why-your-mysql-server-is-stalling/ https://www.percona.com/blog/how-percona-monitoring-and-management-helps-you-find-out-why-your-mysql-server-is-stalling/#respond Wed, 13 Jul 2022 13:45:26 +0000 https://www.percona.com/blog/?p=81760 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 principles will help you in all other cases.Nobody wants […]]]> https://www.percona.com/blog/how-percona-monitoring-and-management-helps-you-find-out-why-your-mysql-server-is-stalling/feed/ 0 81760 https://www.percona.com/blog/upgrade-your-libraries-authentication-plugin-caching_sha2_password-cannot-be-loaded/ https://www.percona.com/blog/upgrade-your-libraries-authentication-plugin-caching_sha2_password-cannot-be-loaded/#comments Wed, 06 Apr 2022 12:45:56 +0000 https://www.percona.com/blog/?p=80586 For my previous blog post on the topic, I received plenty of questions about why I did not cover the [crayon-664c836b3c7ac158571899-i/]  plugin. This plugin is the default since MySQL 8, and all user accounts which are created without the option [crayon-664c836b3c7b4201732600-i/], will use this plugin. Locally everything works fine because the plugin is built-in to […]]]> https://www.percona.com/blog/upgrade-your-libraries-authentication-plugin-caching_sha2_password-cannot-be-loaded/feed/ 1 80586 https://www.percona.com/blog/migrating-to-utf8mb4-things-to-consider/ https://www.percona.com/blog/migrating-to-utf8mb4-things-to-consider/#comments Tue, 29 Mar 2022 12:00:17 +0000 https://www.percona.com/blog/?p=80533 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 languages It is faster than utf8mb3 Still, you may wonder how migration affects […]]]> https://www.percona.com/blog/migrating-to-utf8mb4-things-to-consider/feed/ 8 80533 https://www.percona.com/blog/authentication-plugin-cannot-be-loaded-how-mysql-searches-client-side-plugins/ https://www.percona.com/blog/authentication-plugin-cannot-be-loaded-how-mysql-searches-client-side-plugins/#respond Tue, 22 Mar 2022 12:01:37 +0000 https://www.percona.com/blog/?p=80411 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 [crayon-664c836b3e3c2135363774-i/]  where [crayon-664c836b3e3c5910570650-i/]  is the base directory of your MySQL installation. This perfectly works whenever you install MySQL using package manager, or from the […]]]> https://www.percona.com/blog/authentication-plugin-cannot-be-loaded-how-mysql-searches-client-side-plugins/feed/ 0 80411 https://www.percona.com/blog/percona-support-team-new-year-greetings/ https://www.percona.com/blog/percona-support-team-new-year-greetings/#respond Fri, 31 Dec 2021 16:06:53 +0000 https://www.percona.com/blog/?p=79607 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 favorite tools: MySQL, and ASCII art […]]]> https://www.percona.com/blog/percona-support-team-new-year-greetings/feed/ 0 79607 https://www.percona.com/blog/q-a-on-webinar-mysql-performance-for-devops/ https://www.percona.com/blog/q-a-on-webinar-mysql-performance-for-devops/#respond Wed, 29 Dec 2021 12:30:44 +0000 https://www.percona.com/blog/?p=79556 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 webinar.Q: Hi! We have troubles with DELETE queries. We have to remove some […]]]> https://www.percona.com/blog/q-a-on-webinar-mysql-performance-for-devops/feed/ 0 79556 https://www.percona.com/blog/qa-on-the-webinar-introduction-to-mysql-query-tuning-for-devops/ https://www.percona.com/blog/qa-on-the-webinar-introduction-to-mysql-query-tuning-for-devops/#respond Thu, 02 Dec 2021 13:51:27 +0000 https://www.percona.com/blog/?p=79185 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 provide during the webinar due to a technical issue we experienced at the […]]]> https://www.percona.com/blog/qa-on-the-webinar-introduction-to-mysql-query-tuning-for-devops/feed/ 0 79185 https://www.percona.com/blog/synchronize-tables-on-the-same-server-with-pt-table-sync/ https://www.percona.com/blog/synchronize-tables-on-the-same-server-with-pt-table-sync/#respond Mon, 04 Oct 2021 14:48:10 +0000 https://www.percona.com/blog/?p=78318 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 performance and do not want to affect production data. […]]]> https://www.percona.com/blog/synchronize-tables-on-the-same-server-with-pt-table-sync/feed/ 0 78318 https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/ https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/#comments Wed, 07 Jul 2021 13:23:18 +0000 https://www.percona.com/blog/?p=77159 “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;Use mysqlpump with option[crayon-664c836b42aea330437171-i/] instead of [crayon-664c836b42af0453919527-i/].The StoryThis was requested as MySQL Bug #24680 on Nov 29, 2006. This […]]]> https://www.percona.com/blog/migrating-ownership-of-your-stored-routines-views-and-triggers-in-mysql/feed/ 6 77159 https://www.percona.com/blog/yearly-reminder-ddls-that-fail-to-propagate-may-cause-percona-xtradb-cluster-inconsistencies/ Fri, 23 Apr 2021 16:55:30 +0000 https://www.percona.com/blog/?p=75338 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 cluster replicates the schema change query as a […]]]> 75338 https://www.percona.com/blog/percona-xtrabackup-point-in-time-recovery-for-the-single-database/ https://www.percona.com/blog/percona-xtrabackup-point-in-time-recovery-for-the-single-database/#comments Fri, 02 Apr 2021 16:15:42 +0000 https://www.percona.com/blog/?p=74903 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 manual. You need to restore the data from the backup, then apply all binary logs […]]]> https://www.percona.com/blog/percona-xtrabackup-point-in-time-recovery-for-the-single-database/feed/ 1 74903