by Vadim Tkachenko | Apr 9, 2020 | Benchmarks, MySQL
In this blog, I want to evaluate Group Replication Scaling capabilities to handle several writers, that is, when the read-write connection is established to multiple nodes, and in this case, two nodes. This setup is identical to my previous post, Evaluating Group... by Vadim Tkachenko | Apr 8, 2020 | Benchmarks, MySQL
In this blog, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections.For testing, I will deploy multi-node bare metal servers, where each node and client are dedicated to an individual... by Marco Tusa | Mar 26, 2020 | Benchmarks, MySQL, Open Source
What You May Not Know About Random Number Generation in Sysbench Sysbench is a well known and largely used tool to perform benchmarking. Originally written by Peter Zaitsev in early 2000, it has become a de facto standard when performing testing and benchmarking.... 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 Sveta Smirnova | Jun 5, 2018 | Benchmarks, MySQL
If you attended my latest Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar you learned how I exploit benchmarking tools to replicate locking issues and crashes. But I told you nothing about proper use of these tools: for reliable benchmarks. I... by Sveta Smirnova | Jun 4, 2018 | Benchmarks, MySQL
In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar.First, I want to thank everybody for attending my May 23, 2018, webinar on troubleshooting tools for MySQL. The recording and slides... by Alexander Rubin | Oct 1, 2017 | Insight for DBAs, MySQL
In my previous blog post, I talked about new general tablespaces in MySQL 8.0. Recently MySQL 8.0.3-rc was released, which includes a new data dictionary. My goal is to create one million tables in MySQL and test the performance. Background questions Q: Why... by Peter Zaitsev | Aug 28, 2017 | Benchmarks, Hardware and Storage, Insight for DBAs, MySQL
In this blog post, I will look at disk utilization and saturation.In my previous blog post, I wrote about CPU utilization and saturation, the practical difference between them and how different CPU utilization and saturation impact response times. Now we will... by Sveta Smirnova | Jan 26, 2017 | MySQL, Open Source
In this blog post, we’ll look at Performance Schema benchmarks for OLTP Read/Write workloads.I am in love with Performance Schema and talk a lot about it. Performance Schema is a revolutionary MySQL troubleshooting instrument, but earlier versions had... by Peter Zaitsev | Jan 13, 2017 | Insight for DBAs, MySQL
In this blog, I’ll look at the impact of swapping on MySQL performance. It’s common sense that when you’re running MySQL (or really any other DBMS) you don’t want to see any I/O in your swap space. Scaling the cache size (using... by Peter Zaitsev | Dec 2, 2016 | Benchmarks, MySQL
This blog post discusses how better MySQL 8.0 benchmarks can improve MySQL in general.Like many in MySQL community, I’m very excited about what MySQL 8.0 offers. There are a lot of great features and architecture improvements. Also like many in the MySQL... by Vadim Tkachenko | Jul 26, 2016 | Benchmarks, MySQL
This blog post will detail the results of Samsung storage in tpcc-mysql benchmark using Percona Server.I had an opportunity to test different Samsung storage devices under tpcc-mysql benchmark powered by Percona Server 5.7. You can find a summary with... by Fernando Ipar | Feb 26, 2016 | MongoDB
In this blog post, we’ll discuss how using Prometheus can help with monitoring MongoDB response time. I am currently comparing the performance of different storage engines on Percona Server for MongoDB, using a slightly customized version of Tim... by Fernando Ipar | Feb 1, 2016 | Benchmarks
In a recent post, Vadim compared the performance of Amazon Aurora and Percona Server on AWS. This time, I am comparing write throughput for InnoDB and TokuDB, using the same workload (sysbench oltp/update/update_non_index) and a... by Vadim Tkachenko | Jul 14, 2015 | Benchmarks, MongoDB
In this post I’ll share the results of a sysbench-mongodb benchmark I performed on my server. I compared MMAP, WiredTiger, RocksDB and TokuMXse (based on MongoDB 3.0) and TokuMX (based on MongoDB 2.4) in an IO-intensive workload.The full results are available... by Vadim Tkachenko | Jul 1, 2015 | MongoDB, MySQL
Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with different memory limits. I have physical... by Yves Trudeau | Jun 17, 2015 | Benchmarks, Hardware and Storage, MySQL
IMPORTANT: DON’T TRY THIS IN PRODUCTION. As demonstrated by Marko (see comments), it may corrupt your data.In a post, written a few months ago, I found that using EXT4 transactions with the “data=journal” mount option, improves the write performance... by Vadim Tkachenko | May 1, 2015 | Benchmarks, MySQL
An idea for a benchmark based on the “arrival request” rate that I wrote about in a post headlined “Introducing new type of benchmark” back in 2012 was implemented in Sysbench. However, Sysbench provides only a simple workload, so to be able to... by Justin Swanhart | Sep 10, 2014 | Benchmarks, Insight for DBAs, MySQL
There are a lot of tools that generate test data. Many of them have complex XML scripts or GUI interfaces that let you identify characteristics about the data. For testing query performance and many other applications, however, a simple quick and dirty data... by Vadim Tkachenko | May 14, 2014 | Benchmarks, MySQL, Percona Software
We just released, as an open source release, our new percona-agent the agent to work with Percona Cloud Tools. This agent is written in Go.There will be more posts about percona-agent, but in the meantime I want to dedicate this one to Go, Go with MySQL and some...