by Radoslaw Szulgo | Jul 31, 2025 | Insight for DBAs, MongoDB, Percona Software
On behalf of the entire Percona product team for MongoDB, I’m excited to announce a significant enhancement to Percona Server for MongoDB: File Copy-Based Initial Sync (FCBIS). It is designed to accelerate your large-scale database deployment with a more efficient...
by Ibrar Ahmed | Apr 1, 2025 | Insight for DBAs, Open Source, PostgreSQL
This blog was first authored by Ibrar Ahmed in 2018. We’ve updated it in 2025 for clarity and relevance, reflecting current practices while honoring their original perspective. If your PostgreSQL performance seems to be lagging, you’re not imagining things. It...
by David Quilty | Mar 19, 2025 | Insight for DBAs, MySQL
MySQL databases serve as the foundation of countless applications, powering everything from simple blogs to massive enterprise platforms. But as these applications evolve and user bases expand, MySQL performance issues tend to pop up and ensuring smooth database...
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 Emily Ikuta | Aug 5, 2019 | MySQL, Webinars
Please join Percona CEO Peter Zaitsev as he presents “Performance Analyses and Troubleshooting Technologies for Databases” on Wednesday, August 7th, 2019 at 11:00 AM PDT (UTC-7). View the Recording Have you heard about the USE Method (Utilization – Saturation...
by Matthew Boehm | Apr 25, 2019 | Benchmarks, Insight for DBAs, Insight for Developers, Monitoring, MySQL, Percona Services
Sysbench has long been established as the de facto standard when it comes to benchmarking MySQL performance. Percona relies on it daily, and even Oracle uses it when blogging about new features in MySQL 8. Sysbench comes with several pre-defined benchmarking tests....
by Vadim Tkachenko | Feb 21, 2019 | Benchmarks, MySQL
MySQL 8.0.15 performs worse in sysbench oltp_read_write than MySQL 5.7.25 Initially I was testing group replication performance and was puzzled why MySQL 8.0.15 performs consistently worse than MySQL 5.7.25. It appears that a single server instance is affected by a...
by Corrado Pandiani | Dec 19, 2018 | MongoDB, Open Source, Percona Software
by Yves Trudeau | Nov 23, 2018 | Insight for DBAs, MySQL
Over the last year, I have been pursuing a part time hobby project exploring ways to squeeze as much data as possible in MySQL. As you will see, there are quite a few different ways. Of course things like compression ratio matters a lot but, other items like...
by Ibrar Ahmed | Aug 29, 2018 | Insight for DBAs, PostgreSQL
For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are...
by Vadim Tkachenko | Aug 1, 2018 | Benchmarks, Insight for DBAs, MySQL, Open Source, Storage Engine
The main focus of a previous blog post was the performance of MyRocks when using fast SSD devices. However, I figured that MyRocks would be beneficial for use in cloud workloads, where storage is either slow or expensive. In that earlier post, we demonstrated the...
by Vadim Tkachenko | Jul 13, 2018 | Benchmarks, MySQL, Percona Software
Recently, Dimitri published the results of measuring MySQL 8.0 on Intel Optane storage device. In this blog post, I wanted to look at this in more detail and explore the performance of MySQL 8, MySQL 5.7 and Percona Server for MySQL using a similar set up. The Intel...
by Alexander Rubin | Jul 12, 2018 | Benchmarks, MySQL
MySQL stored procedures, functions and triggers, are tempting constructs for application developers. However, as I discovered, there can be an impact on database performance when using MySQL stored routines. Not being entirely sure of what I was seeing during a...
by Vadim Tkachenko | Jul 11, 2018 | Benchmarks, MySQL, Percona Software
Ever since AMD released their EPYC CPU for servers I wanted to test it, but I did not have the opportunity until recently, when Packet.net started offering bare metal servers for a reasonable price. So I started a couple of instances to test Percona Server for MySQL...
by Sveta Smirnova | Jun 26, 2018 | Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Software, Webinars
Please join Percona’s Principal Support Escalation Specialist Sveta Smirnova as she presents Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance on Wednesday, June 27th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register...
by Peter Zaitsev | Jun 12, 2018 | MySQL, Webinars
Please join Percona’s CEO, Peter Zaitsev as he presents Performance Analysis and Troubleshooting Methodologies for Databases on Wednesday, June 13th, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now Have you heard about the USE Method...
by Sveta Smirnova | May 21, 2018 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Please join Percona’s Principal Support Escalation Specialist, Sveta Smirnova, as she presents Troubleshooting MySQL Concurrency Issues with Load Testing Tools on Wednesday, May 23, 2018 at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now ...
by Alexander Rubin | Feb 19, 2018 | Hardware and Storage, Insight for DBAs, MySQL
In this blog post, I will talk about archiving MySQL tables in ClickHouse for storage and analytics. Why Archive? Hard drives are cheap nowadays, but storing lots of data in MySQL is not practical and can cause all sorts of performance bottlenecks. To name just a few...
by Dave Avery | Dec 29, 2017 | Benchmarks, MariaDB, MongoDB, MySQL
Let’s look at some of the most popular Percona Database Performance Blog posts in 2017. The closing of a year lends itself to looking back. And making lists. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open...
by Anastasia Raspopina | Jan 6, 2017 | Benchmarks, MySQL, Open Source, Percona Live, PostgreSQL
This blog compares how PostgreSQL and MySQL handle millions of queries per second. Anastasia: Can open source databases cope with millions of queries per second? Many open source advocates would answer “yes.” However, assertions aren’t enough for...
