Sat, 17 Feb 2024 01:11:22 +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/is-thread-pool-plugin-the-right-choice-for-your-workload/ https://www.percona.com/blog/is-thread-pool-plugin-the-right-choice-for-your-workload/#respond Tue, 02 Jan 2024 17:01:39 +0000 https://www.percona.com/blog/?p=92984 TL&DR: Depending on the workload, the thread pool plugin can cause serious performance drops.This post was motivated by two recent cases I’ve worked with. Two setups running in cluster mode: one in MariaDB+Galera and one with Percona XtraDB Cluster (Percona Server+Galera). In both cases, the clusters had the thread pool plugin enabled and were serving […]]]> https://www.percona.com/blog/is-thread-pool-plugin-the-right-choice-for-your-workload/feed/ 0 92984 https://www.percona.com/blog/save-money-in-aws-rds-dont-trust-the-defaults/ https://www.percona.com/blog/save-money-in-aws-rds-dont-trust-the-defaults/#comments Mon, 01 May 2023 13:14:38 +0000 https://www.percona.com/blog/?p=87381 Default settings can help you get started quickly – but they can also cost you performance and a higher cloud bill at the end of the month. Want to save money on your AWS RDS bill? I’ll show you some MySQL settings to tune to get better performance, and cost savings, with AWS RDS.Recently I […]]]> https://www.percona.com/blog/save-money-in-aws-rds-dont-trust-the-defaults/feed/ 2 87381 https://www.percona.com/blog/a-dive-into-mysql-multi-threaded-replication/ https://www.percona.com/blog/a-dive-into-mysql-multi-threaded-replication/#comments Thu, 24 Mar 2022 11:51:23 +0000 https://www.percona.com/blog/?p=80357 For a very long part of its history, MySQL replication has been limited in terms of performance. Because there was no way of knowing if transactions or updates were independent, the updates had to be executed on a replica following the exact same sequence of operations as on the primary server. The only way to […]]]> https://www.percona.com/blog/a-dive-into-mysql-multi-threaded-replication/feed/ 5 80357 https://www.percona.com/blog/comparing-amd-epyc-performance-with-intel-xeon-in-gcp/ https://www.percona.com/blog/comparing-amd-epyc-performance-with-intel-xeon-in-gcp/#comments Wed, 05 Jan 2022 13:11:03 +0000 https://www.percona.com/blog/?p=79448 Recently we were asked to check the performance of the new family of AMD EPYC processors when using MySQL in Google Cloud Virtual Machines. This was motivated by a user running MySQL in the N1 machines family and willing to upgrade to N2D generation considering the potential cost savings using the new AMD family. The idea […]]]> https://www.percona.com/blog/comparing-amd-epyc-performance-with-intel-xeon-in-gcp/feed/ 5 79448 https://www.percona.com/blog/making-aurora-write-latency-15x-higher-or-more-by-choosing-a-bad-primary-key/ https://www.percona.com/blog/making-aurora-write-latency-15x-higher-or-more-by-choosing-a-bad-primary-key/#comments Tue, 21 Sep 2021 15:00:25 +0000 https://www.percona.com/blog/?p=78190 Primary Key design is an important thing for InnoDB performance, and choosing a poor PK definition will have an impact on performance and also write propagation in databases. When this comes to Aurora, this impact is even worse than you may notice.In short, we consider a poor definition of a Primary Key in InnoDB as […]]]> https://www.percona.com/blog/making-aurora-write-latency-15x-higher-or-more-by-choosing-a-bad-primary-key/feed/ 2 78190 https://www.percona.com/blog/mysql-101-10-great-mysql-dba-interview-questions-and-answers/ Tue, 27 Apr 2021 15:22:27 +0000 https://www.percona.com/blog/?p=75758 DBAs are important cogs in the availability, performance, and security of your data. Getting a great DBA is one of the most important things any company can do to ensure their database operations continue working without a problem.  So how do you find great DBAs?In this post I’m going to show you some of the […]]]> 75758 https://www.percona.com/blog/mysql-101-tuning-mysql-after-upgrading-memory/ https://www.percona.com/blog/mysql-101-tuning-mysql-after-upgrading-memory/#comments Wed, 30 Sep 2020 15:04:44 +0000 https://www.percona.com/blog/?p=70341 In this post, we will discuss what to do when you add more memory to your instance. Adding memory to a server where MySQL is running is common practice when scaling resources.First, Some ContextScaling resources is just adding more resources to your environment, and this can be split in two main ways: vertical scaling and […]]]> https://www.percona.com/blog/mysql-101-tuning-mysql-after-upgrading-memory/feed/ 1 70341 https://www.percona.com/blog/tuning-mysql-innodb-flushing-for-a-write-intensive-workload/ https://www.percona.com/blog/tuning-mysql-innodb-flushing-for-a-write-intensive-workload/#comments Thu, 14 May 2020 18:57:01 +0000 https://www.percona.com/blog/?p=67999 In this post, the third in a series explaining the internals of InnoDB flushing, we’ll focus on tuning. (Others in the series can be seen at InnoDB Flushing in Action for Percona Server for MySQL and Give Love to Your SSDs – Reduce innodb_io_capacity_max!)Understanding the tuning process is very important since we don’t want to make […]]]> https://www.percona.com/blog/tuning-mysql-innodb-flushing-for-a-write-intensive-workload/feed/ 5 67999 https://www.percona.com/blog/innodb-flushing-in-action-for-percona-server-for-mysql/ https://www.percona.com/blog/innodb-flushing-in-action-for-percona-server-for-mysql/#comments Wed, 22 Jan 2020 15:39:11 +0000 https://www.percona.com/blog/?p=64904 As the second part of the earlier post Give Love to Your SSDs – Reduce innodb_io_capacity_max! we wanted to put together some concepts on how InnoDB flushing works in recent Percona Server for MySQL versions (8.0.x prior to 8.0.19, or 5.7.x). It is important to understand this aspect of InnoDB in order to tune it […]]]> https://www.percona.com/blog/innodb-flushing-in-action-for-percona-server-for-mysql/feed/ 4 64904 https://www.percona.com/blog/give-love-to-your-ssds-reduce-innodb_io_capacity_max/ https://www.percona.com/blog/give-love-to-your-ssds-reduce-innodb_io_capacity_max/#comments Wed, 18 Dec 2019 18:17:20 +0000 https://www.percona.com/blog/?p=63830 The innodb_io_capacity and innodb_io_capacity_max are often misunderstood InnoDB parameters. As consultants, we see, at least every month, people setting this variable based on the top IO write specifications of their storage. Is this a correct choice? Is it an optimal value for performance? What about the SSD/Flash wear leveling?Innodb_io_capacity 101Let’s begin with what the manual […]]]> https://www.percona.com/blog/give-love-to-your-ssds-reduce-innodb_io_capacity_max/feed/ 7 63830 https://www.percona.com/blog/debugging-mariadb-galera-cluster-sst-problems-a-tale-of-a-funny-experience/ https://www.percona.com/blog/debugging-mariadb-galera-cluster-sst-problems-a-tale-of-a-funny-experience/#comments Tue, 12 Feb 2019 13:25:41 +0000 https://www.percona.com/blog/?p=55071 Recently, I had to work on an emergency for a customer who was having a problem restarting a MariaDB Galera Cluster. After a failure in the cluster they decided to restart the cluster entirely following the right path: bootstrapping the first node, and then adding the rest of the members, one by one. Everything went […]]]> https://www.percona.com/blog/debugging-mariadb-galera-cluster-sst-problems-a-tale-of-a-funny-experience/feed/ 15 55071 https://www.percona.com/blog/understanding-mysql-x-all-flavors/ https://www.percona.com/blog/understanding-mysql-x-all-flavors/#comments Mon, 07 Jan 2019 16:07:37 +0000 https://www.percona.com/blog/?p=54433 Since 5.7.12 MySQL includes what is called the X plugin, but also it includes X protocol and X DevApi. But what is all this and how does it work? Let me share a personal short story on how I found myself investigating this feature. In a previous post I wrote about the MySQL Router tool, and […]]]> https://www.percona.com/blog/understanding-mysql-x-all-flavors/feed/ 5 54433 https://www.percona.com/blog/innodb-cluster-in-a-nutshell-part-3-mysql-shell/ https://www.percona.com/blog/innodb-cluster-in-a-nutshell-part-3-mysql-shell/#comments Fri, 20 Jul 2018 12:58:10 +0000 https://www.percona.com/blog/?p=50643 Welcome to the third part of this series. I’m glad you’re still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and now we will discuss the last component, MySQL Shell.MySQL ShellThis is the last component in […]]]> https://www.percona.com/blog/innodb-cluster-in-a-nutshell-part-3-mysql-shell/feed/ 4 50643 https://www.percona.com/blog/innodb-cluster-in-a-nutshell-part-2-mysql-router/ https://www.percona.com/blog/innodb-cluster-in-a-nutshell-part-2-mysql-router/#comments Mon, 16 Jul 2018 13:07:54 +0000 https://www.percona.com/blog/?p=50523 MySQL InnoDB Cluster is an Oracle High Availability solution that can be easily installed over MySQL to provide high availability with multi-master capabilities and automatic failover. In the previous post we presented the first component of InnoDB Cluster, group replication. Now we will go through the second component, MySQL Router.  We will address MySQL Shell in a final […]]]> https://www.percona.com/blog/innodb-cluster-in-a-nutshell-part-2-mysql-router/feed/ 4 50523 https://www.percona.com/blog/innodb-cluster-in-a-nutshell-part-1/ https://www.percona.com/blog/innodb-cluster-in-a-nutshell-part-1/#comments Mon, 09 Jul 2018 13:47:40 +0000 https://www.percona.com/blog/?p=50512 Since MySQL 5.7 we have a new player in the field, MySQL InnoDB Cluster. This is an Oracle High Availability solution that can be easily installed over MySQL to get High Availability with multi-master capabilities and automatic failover.This solution consists in 3 components: InnoDB Group Replication, MySQL Router and MySQL Shell, you can see how […]]]> https://www.percona.com/blog/innodb-cluster-in-a-nutshell-part-1/feed/ 3 50512 https://www.percona.com/blog/migrating-database-charsets-to-utf8mb4/ https://www.percona.com/blog/migrating-database-charsets-to-utf8mb4/#comments Tue, 10 Apr 2018 19:12:24 +0000 https://www.percona.com/blog/?p=48399 In this blog post, we’ll look at options for migrating database charsets to utf8mb4.Migrating charsets, in my opinion, is one of the most tedious tasks in a DBA’s life. There are so many things involved that can screw up our data, making it work is always hard. Sometimes what seems like a trivial task can […]]]> https://www.percona.com/blog/migrating-database-charsets-to-utf8mb4/feed/ 4 48399 https://www.percona.com/blog/is-your-query-cache-really-disabled/ https://www.percona.com/blog/is-your-query-cache-really-disabled/#comments Fri, 11 Nov 2016 18:46:16 +0000 https://www.percona.com/blog/?p=37973 This blog post was motivated by an internal discussion about how to fully disable query cache in MySQL.According to the manual, we should be able to disable “Query Cache” on the fly by changing [crayon-664ca2d7583e1141166502-i/] to 0, but as we will show this is not fully true. This blog will show you how to properly disable “query cache,” […]]]> https://www.percona.com/blog/is-your-query-cache-really-disabled/feed/ 9 37973 https://www.percona.com/blog/mysql-5-7-first-impressions-group-replication/ https://www.percona.com/blog/mysql-5-7-first-impressions-group-replication/#comments Thu, 29 Oct 2015 13:55:32 +0000 https://www.percona.com/blog/?p=32316 During the last few weeks I’ve been testing and playing a bit with the new group-replication plugin available for MySQL 5.7. Before continuing I’d like to clarify some aspects: the plugin is only available in labs and is not yet ready for production. The current version is 0.6. I used 5.7.9 GA running in a Vagrant 3 […]]]> https://www.percona.com/blog/mysql-5-7-first-impressions-group-replication/feed/ 3 32316 https://www.percona.com/blog/multi-source-replication-in-mysql-5-7-vs-tungsten-replicator/ https://www.percona.com/blog/multi-source-replication-in-mysql-5-7-vs-tungsten-replicator/#comments Wed, 29 Jul 2015 07:00:44 +0000 https://www.percona.com/blog/?p=30594 https://www.percona.com/blog/multi-source-replication-in-mysql-5-7-vs-tungsten-replicator/feed/ 8 30594 https://www.percona.com/blog/keep-your-mysql-data-in-sync-when-using-tungsten-replicator/ https://www.percona.com/blog/keep-your-mysql-data-in-sync-when-using-tungsten-replicator/#comments Mon, 04 May 2015 10:00:32 +0000 https://www.percona.com/blog/?p=29716 https://www.percona.com/blog/keep-your-mysql-data-in-sync-when-using-tungsten-replicator/feed/ 6 29716