by Alexey Stroganov | Nov 12, 2019 | Benchmarks, MySQL
Recently, at Percona Live Europe 2019, Dimitri Kravchuk from Oracle mentioned that he observed some unclear drop in performance for MySQL on an ext4 filesystem with the latest Linux kernels. I decided to check this case out on my side and found out that indeed,... by Alexey Stroganov | Jul 19, 2019 | MySQL
See part one of this series here. This post is part two of my series “Assessing MySQL Performance Amongst AWS Options”, taking a look at how current Amazon RDS services – Amazon Aurora and Amazon RDS for MySQL – compare with Percona Server... by Alexey Stroganov | Jul 17, 2019 | Cloud, MySQL
With such a wide range of options available for running MySQL based servers in Amazon cloud environments, how do you choose? There’s no doubt it’s a challenge. In this two-part series of blog posts, we’ll try to draw a fair and informative comparison... by Alexey Stroganov | Mar 28, 2018 | Cloud, Insight for DBAs, Percona Software
In this blog post, we look at the performance of Percona XtraDB Cluster on Amazon GP2 volumes.In our overview blog post on Best Practices for Percona XtraDB Cluster on AWS, GP2 volumes did not show good results. However, we allocated only the size needed to... by Alexey Stroganov | Jan 18, 2018 | Insight for DBAs, Insight for Developers, MySQL, Security
In this blog post, we’ll look at does the Meltdown fix affect performance for MySQL on bare metal servers. Since the news about the Meltdown bug, there were a lot of reports on the performance hit from proposed fixes. We have looked at how the fix affects... by Alexey Stroganov | Nov 28, 2017 | MySQL
In this blog post I’ll look at the performance of Percona XtraDB Cluster on AWS using different service instances, and recommend some best practices for maximizing performance.You can use Percona XtraDB Cluster in AWS environments. We often get questions about... by Alexey Stroganov | Jul 21, 2017 | MySQL, Percona Software
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance. Introduction Starting in version 5.7.17-29.20 of Percona XtraDB Cluster significantly improved performance. Depending on the workload, the increase in throughput is... by Alexey Stroganov | Apr 19, 2017 | MySQL, Percona Software
In our latest release of Percona XtraDB Cluster, we’ve introduced major performance improvements to the MySQLwrite-set replication layer. In this post, we want to show what these improvements look like.For the test, we used the sysbench OLTP_RW, UPDATE_KEY and... by Alexey Stroganov | Apr 5, 2017 | Benchmarks, MySQL, Percona Software
In this blog post, we’ll look at some of the available PMP profiling tools.While debugging or analyzing issues with Percona Server for MySQL, we often need a quick understanding of what’s happening on the server. Percona experts frequently use... by Alexey Stroganov | Mar 30, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll look at the performance of SST data transfer using encryption.In my previous post, we reviewed SST data transfer in an unsecured environment. Now let’s take a closer look at a setup with encrypted network connections between the... by Alexey Stroganov | Mar 29, 2017 | Insight for DBAs, MySQL
In this blog, we’ll look at evaluating the performance of an SST data transfer without encryption.A State Snapshot Transfer (SST) operation is an important part of Percona XtraDB Cluster. It’s used to provision the joining node with all the necessary data.... by Alexey Stroganov | Aug 22, 2016 | Benchmarks, MySQL
In this post, we’ll look at a scalability fix for issues the query rewrite plugin had on performance.Several months ago, Vadim blogged about the impact of a query rewrite plugin on performance. We decided to re-evaluate the latest release of... by Alexey Stroganov | May 9, 2016 | MySQL
In this blog post, we’ll discuss the ins and outs of Percona Server 5.7 parallel doublewrite.After implementing parallel LRU flushing as described in the previous post, we went back to benchmarking. At first, we tested with the doublewrite buffer turned... by Alexey Stroganov | May 5, 2016 | MySQL
In this blog post, we’ll discuss how to use multi-threaded LRU flushing to prevent bottlenecks in MySQL.In the previous post, we saw that InnoDB 5.7 performs a lot of single-page LRU flushes, which in turn are serialized by the shared doublewrite buffer. Based... by Alexey Stroganov | May 3, 2016 | MySQL
In this post, we’ll examine why in an initial flushing analysis we find that Performance Schema data is incomplete.Having shown the performance impact of Percona Server 5.7 patches, we can now discuss their technical reasoning and details. Let’s... by Alexey Stroganov | Mar 17, 2016 | Benchmarks, MySQL, Percona Software
In this blog post, we’ll be discussing Percona Server 5.7 performance improvements.Starting from the Percona Server 5.6 release, we’ve introduced several significant changes that help address performance problems for highly-concurrent I/O-bound workloads.... by Alexey Stroganov | Oct 26, 2015 | Benchmarks, MySQL, Percona Software
This week Oracle will release MySQL 5.7 GA, so it’s a perfect time to do a quick review of the current state of Percona Server 5.6.26, MySQL 5.6.26 and MySQL-5.7.8 RC. We used two boxes from our benchmark lab for this: – Box 1: 16 Cores+HT (32 virt... by Alexey Stroganov | Jan 29, 2014 | Benchmarks, MySQL, Percona Software
In a previous thread pool post, I mentioned that in Percona Server we used an open source implementation of MariaDB’s thread pool, and enhanced/improved it further. Below I would like to describe some of these improvements for transactional workloads.When we... by Alexey Stroganov | Jan 23, 2014 | Benchmarks, MySQL, Percona Software
By default, for every client connection the MySQL server spawns a separate thread which will process all statements for this connection. This is the ‘one-thread-per-connection’ model. It’s simple and efficient until some number of connections N is... by Alexey Stroganov | Oct 30, 2013 | MySQL, Percona Software
In MySQL 5.6 InnoDB has a dedicated thread (page_cleaner) that’s responsible for performing flushing operations. Page_cleaner performs flushing of the dirty pages from the buffer pool based on two factors: – access pattern – the least...