Tue, 13 Feb 2024 17:12:31 +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/custom-percona-monitoring-and-management-dashboards/ https://www.percona.com/blog/custom-percona-monitoring-and-management-dashboards/#respond Fri, 04 Aug 2023 14:06:38 +0000 https://www.percona.com/blog/?p=89887 Percona has bundled together some great open source pieces of software to create Percona Monitoring and Management (PMM), a very flexible and powerful monitoring solution. The goal of this post is not to introduce you to the existing PMM dashboards but to show you how to create your own application-centric custom PMM dashboards.If you have […]]]> https://www.percona.com/blog/custom-percona-monitoring-and-management-dashboards/feed/ 0 89887 https://www.percona.com/blog/how-bloom-filters-work-in-myrocks/ https://www.percona.com/blog/how-bloom-filters-work-in-myrocks/#respond Wed, 15 Feb 2023 13:07:50 +0000 https://www.percona.com/blog/?p=85216 Bloom filters are an essential component of an LSM-based database engine like MyRocks. This post will illustrate through a simple example how bloom filters work in MyRocks.Why?With MyRocks/RocksDB, data is stored in a set of large SST files.  When MyRocks needs to find the value associated with a given key, it uses a bloom filter […]]]> https://www.percona.com/blog/how-bloom-filters-work-in-myrocks/feed/ 0 85216 https://www.percona.com/blog/myrocks-use-case/ https://www.percona.com/blog/myrocks-use-case/#respond Fri, 23 Dec 2022 12:03:50 +0000 https://www.percona.com/blog/?p=84266 I wrote this post on MyRocks because I believe it is the most interesting new MySQL storage engine to have appeared over the last few years. Although MyRocks is very efficient for writes, I chose a more generic workload that will provide a different MyRocks use case.The use case is the TPC-C benchmark but executed […]]]> https://www.percona.com/blog/myrocks-use-case/feed/ 0 84266 https://www.percona.com/blog/efficient-data-archiving-in-mysql/ https://www.percona.com/blog/efficient-data-archiving-in-mysql/#respond Tue, 30 Aug 2022 11:50:57 +0000 https://www.percona.com/blog/?p=82354 Recently I have been working with a few customers with multiple terabytes of transactional data on their MySQL clusters. These very large datasets are not really needed for their daily operations but they are very convenient because they allow them to query historical data easily. However the convenience comes at a high price, you pay […]]]> https://www.percona.com/blog/efficient-data-archiving-in-mysql/feed/ 0 82354 https://www.percona.com/blog/tags-and-fulltext-indexes-in-mysql/ https://www.percona.com/blog/tags-and-fulltext-indexes-in-mysql/#respond Wed, 13 Jul 2022 11:05:36 +0000 https://www.percona.com/blog/?p=81648 As a principal architect at Percona, one of my duties is to tune MySQL database servers for our customers. The tuning effort looks at every aspect of the database service like the operating system, the MySQL configuration, the schema, the queries, etc. We have well-defined processes to tune the operating system and the MySQL configuration. […]]]> https://www.percona.com/blog/tags-and-fulltext-indexes-in-mysql/feed/ 0 81648 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/taking-a-look-at-btrfs-for-mysql/ https://www.percona.com/blog/taking-a-look-at-btrfs-for-mysql/#comments Tue, 04 Jan 2022 12:06:09 +0000 https://www.percona.com/blog/?p=79491 Following my post MySQL/ZFS Performance Update, a few people have suggested I should take a look at BTRFS (“butter-FS”, “b-tree FS”) with MySQL. BTRFS is a filesystem with an architecture and a set of features that are similar to ZFS and with a GPL license. It is a copy-on-write (CoW) filesystem supporting snapshots, RAID, and […]]]> https://www.percona.com/blog/taking-a-look-at-btrfs-for-mysql/feed/ 15 79491 https://www.percona.com/blog/mysql-zfs-in-the-cloud-leveraging-ephemeral-storage/ https://www.percona.com/blog/mysql-zfs-in-the-cloud-leveraging-ephemeral-storage/#respond Mon, 13 Sep 2021 13:51:05 +0000 https://www.percona.com/blog/?p=78039 Here’s a second post focusing on the performance of MySQL on ZFS in cloud environments. In the first post, MySQL/ZFS Performance Update, we compared the performances of ZFS and ext4. This time we’ll look at the benefits of using ephemeral storage devices. These devices, called ephemeral in AWS, local in Google cloud, and temporary in […]]]> https://www.percona.com/blog/mysql-zfs-in-the-cloud-leveraging-ephemeral-storage/feed/ 0 78039 https://www.percona.com/blog/mysql-zfs-performance-update/ https://www.percona.com/blog/mysql-zfs-performance-update/#comments Fri, 09 Jul 2021 12:14:38 +0000 https://www.percona.com/blog/?p=77189 As some of you likely know, I have a favorable view of ZFS and especially of MySQL on ZFS. As I published a few years ago, the argument for ZFS was less about performance than its useful features like data compression and snapshots. At the time, ZFS was significantly slower than xfs and ext4 except […]]]> https://www.percona.com/blog/mysql-zfs-performance-update/feed/ 28 77189 https://www.percona.com/blog/how-innodb-handles-text-blob-columns/ https://www.percona.com/blog/how-innodb-handles-text-blob-columns/#comments Thu, 27 May 2021 16:04:36 +0000 https://www.percona.com/blog/?p=76221 Recently we had a debate in the consulting team about how InnoDB handles TEXT/BLOB columns. More specifically, the argument was around the Barracuda file format with dynamic rows.In the InnoDB official documentation, you can find this extract:When a table is created with ROW_FORMAT=DYNAMIC, InnoDB can store long variable-length column values (for VARCHAR, VARBINARY, and BLOB […]]]> https://www.percona.com/blog/how-innodb-handles-text-blob-columns/feed/ 2 76221 https://www.percona.com/blog/innodb-file-growth-weirdness/ Tue, 04 May 2021 13:59:51 +0000 https://www.percona.com/blog/?p=75720 There is a common pattern in life, you often discover or understand things by accident. Many scientific discoveries fit such a description. In our database world, I was looking to see how BLOB/TEXT columns are allocated using overlay pages and I stumbled upon something interesting and unexpected. Let me present to you my findings, along […]]]> 75720 https://www.percona.com/blog/a-first-glance-at-amazon-aurora-serverless-rds/ Tue, 27 Oct 2020 13:54:00 +0000 https://www.percona.com/blog/?p=71612 If you often deploy services in the cloud, you certainly, at least once, forgot to stop a test instance. I am like you and I forgot my share of these. Another mistake I do once in a while is to provision a bigger instance than needed, just in case, and forget to downsize it. While […]]]> 71612 https://www.percona.com/blog/the-road-story-of-a-myrocks-mariadb-migration/ https://www.percona.com/blog/the-road-story-of-a-myrocks-mariadb-migration/#comments Tue, 04 Aug 2020 14:07:49 +0000 https://www.percona.com/blog/?p=70199 This post has been written in collaboration with Nicolas Modalvsky of e-planning. Nicolas and I recently worked together on a tuning engagement involving MyRocks on MariaDB. While it is easy to find online articles and posts about InnoDB performance, finding information about MyRocks tuning is more difficult. Both storage engines are well documented but what […]]]> https://www.percona.com/blog/the-road-story-of-a-myrocks-mariadb-migration/feed/ 5 70199 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/uuids-are-popular-but-bad-for-performance-lets-discuss/ https://www.percona.com/blog/uuids-are-popular-but-bad-for-performance-lets-discuss/#comments Fri, 22 Nov 2019 18:52:57 +0000 https://www.percona.com/blog/?p=63097 If you do a quick web search about UUIDs and MySQL, you’ll get a fair number of results. Here are just a few examples: Storing UUID and Generated Columns Storing UUID Values in MySQL Illustrating Primary Key models in InnoDB and their impact on disk usage MySQL UUID Smackdown: UUID vs. INT for Primary Key […]]]> https://www.percona.com/blog/uuids-are-popular-but-bad-for-performance-lets-discuss/feed/ 13 63097 https://www.percona.com/blog/update-on-fsync-performance/ https://www.percona.com/blog/update-on-fsync-performance/#comments Thu, 19 Sep 2019 19:00:11 +0000 https://www.percona.com/blog/?p=62293 Last year, I wrote a post focused on the performance of the fsync call on various storage devices. The fsync call is extremely important for a database when durability, the “D” of the ACID acronym is a hard requirement. The call ensures the data is permanently stored on disk. The durability requirement forces every transaction […]]]> https://www.percona.com/blog/update-on-fsync-performance/feed/ 4 62293 https://www.percona.com/blog/how-to-upgrade-amazon-aurora-mysql-from-5-6-to-5-7/ https://www.percona.com/blog/how-to-upgrade-amazon-aurora-mysql-from-5-6-to-5-7/#comments Tue, 05 Mar 2019 17:31:46 +0000 https://www.percona.com/blog/?p=55543 Over time, software evolves and it is important to stay up to date if you want to benefit from new features and performance improvements.  Database engines follow the exact same logic and providers are always careful to provide an easy upgrade path. With MySQL, the mysql_upgrade tool serves that purpose.A database upgrade process becomes more […]]]> https://www.percona.com/blog/how-to-upgrade-amazon-aurora-mysql-from-5-6-to-5-7/feed/ 11 55543