by Pablo Svampa | Apr 30, 2025 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Indexing is one of PostgreSQL’s most effective tools for improving query performance, but like any powerful tool, it can cause real problems when overused. A while ago, my colleague Jobin wrote a blog post exploring the negative side effects of over-indexing in...
by Vinodh Krishnaswamy | Sep 9, 2024 | Benchmarks, Database Trends, Insight for DBAs, MongoDB, Open Source
by Marco Tusa | Feb 6, 2024 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
To be honest, the comparison between the two MySQL distributions is not something that excited me a lot. Mainly because from my MySQL memories, I knew that there is not a real difference between the two distributions when talking about the code base. To my knowledge...
by Sveta Smirnova | Jul 29, 2022 | Benchmarks, Insight for DBAs, MySQL, Percona Software
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/sysbench BMK-kit –...
by Marco Tusa | May 26, 2016 | MySQL
Some time ago, I published the article on AWS Aurora Benchmarking (AWS Aurora Benchmarking – Blast or Splash?), in which I analyzed the behavior of different solutions using synchronous replication in AWS environment. This blog follows up with some of the...
by Fernando Ipar | May 13, 2016 | Benchmarks, MongoDB
In this blog post, we’ll discuss how to benchmark MongoDB with sysbench. In an earlier post, I mentioned our use of sysbench-mongodb (via this fork) to run benchmarks of MongoDB servers. I now want to share our work extending sysbench to make it work with...
by Brock Wilson | Feb 24, 2015 | Benchmarks, MySQL, Percona Services, Percona Software
MySQL’s innodb_file_per_table is a wonderful thing – most of the time. Having every table use its own .ibd file allows you to easily reclaim space when dropping or truncating tables. But in some use cases, it may cause significant performance issues. Many...
by Aurimas Mikalauskas | Jan 15, 2015 | Benchmarks, Insight for DBAs, MySQL
The other day a customer asked me to do capacity planning for their web server farm. I was looking at the CPU graph for one of the web servers that had Hyper-threading switched ON and thought to myself: “This must be quite a misleading graph – it shows 30%...
by Tim.Callaghan | Jan 12, 2015 | MySQL
UPDATE: Since the publication of this blog post, the first release candidate of TokuMXse was made available for testing. Learn more about v1.0.0.RC.0. In addition, MongoDB has decided to call the release formerly known as v2.8, v3.0. We’ve been working on...
by Joel.Epstein | Dec 23, 2014 | MySQL
The MySQL 5.6 Release has introduced some changes to how two phase commit works and is managed. In particular, the commit phase of transactions to the binary log is now serialized and this behavior is something we identified fairly immediately. We implement a group...
by Rich.Prohaska | Dec 17, 2014 | MySQL
TokuDB offers high throughput for write intensive applications, and the throughput scales with the number of concurrent clients. However, when the binary log is turned on, TokuDB 7.5.2 throughput suffers. The throughput scaling problem is caused by a poor...
by Tim.Callaghan | Oct 16, 2014 | MySQL
In a few weeks I’m presenting “Performance Benchmarking: Tips, Tricks, and Lessons Learned” at Percona Live London 2014 (November 3-4). I continue to learn lessons and improve my benchmarking capabilities, so the content is a full upgrade from my...
by Tim.Callaghan | Sep 29, 2014 | MySQL
Coming in TokuMX v2.0 is a feature we’re calling “Fast Updates”. Fast updates permit certain update operations to bypass the read-modify-write behavior that most databases require (including MongoDB and the current release of TokuMX). In this blog I’ll cover how Fast...
by Tim.Callaghan | Sep 23, 2014 | MySQL
New to TokuDB® v7.5 is a feature we’re calling “Read Free Replication” (RFR). RFR allows TokuDB replication slaves to process insert, update, and delete statements with almost no read IO. As a result, the slave can easily keep up with the master (no...
by Kenny Gryp | Jun 24, 2014 | Benchmarks, Insight for DBAs, MySQL
Tesora, previously called Parelastic, asked Percona to do a sysbench benchmark evaluation of its Database Virtualization Engine on specific architectures on Amazon EC2. The focus of Tesora is to provide a scalable Database As A Service platform for OpenStack. The...
by Dave Rosenlund | Apr 29, 2014 | MySQL
If you did not read my first blog post about Mark Callaghan’s (@markcallaghan) benchmarks as documented in his blog, Small Datum, you may want to skim through it now for a little context. ——————- On March 11th, Mark, a former Google and now Facebook database guru,...
by Dave Rosenlund | Apr 18, 2014 | MySQL
A little background… When I ventured into sales and marketing (I’m an engineer by education) I learned I would often have to interpret and simply summarize the business value that is sometimes hidden in benchmarks. Simply put, the people who approve the purchase...
by Leif.Walsh | Feb 25, 2014 | MySQL
We just released version 1.4.0 of TokuMX, our high-performance distribution of MongoDB. There are a lot of improvements in this version (release notes), the most of any release yet. In this series of blog posts, we describe the most interesting changes and how they’ll...
by Tim.Callaghan | Feb 16, 2014 | MySQL
I have always believed that TokuMX’s Fractal Tree indexes are an ideal fit for MongoDB’s sharding model, especially when it comes time for balancing to occur. At a very high level, balancing is needed when one shard contains more chunks than another. The...
by Tim.Callaghan | Sep 10, 2013 | MySQL
In talking to existing MongoDB users and TokuMX evaluators, I’ve often heard that the performance of MongoDB is very good as long as your working data set fits in RAM. The story continues that if your working data set grows to be larger than the RAM on your...
