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 Vadim Tkachenko | Feb 7, 2020 | Cloud, MySQL, Percona Software
As our Percona Kubernetes Operator for Percona XtraDB Cluster gains in popularity, I am getting questions about its performance and how to measure it properly. Sysbench is the most popular tool for database performance evaluation, so let’s review how we can use... 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 Avinash Vallarapu | Jun 15, 2018 | Benchmarks, PostgreSQL
Percona has a long tradition of performance investigation and benchmarking. Peter Zaitsev, CEO and Vadim Tkachenko, CTO, led their crew into a series of experiments with MySQL in this space. The discussion that always follows on the results achieved is well known and... by Vadim Tkachenko | Apr 19, 2018 | Benchmarks, Insight for DBAs, Monitoring, MySQL
This time, we really mean it when we say sysbench-tpcc supports PostgreSQL.When I initially announced sysbench-tpcc, I mentioned it potentially could run against PostgreSQL, but it was more like wishful thinking than reality. The reality was that even though both... by Vadim Tkachenko | Mar 5, 2018 | Benchmarks, Insight for DBAs, MySQL
In this post I’ll look at some of our recent work for benchmark enthusiasts: a TPCC-like workload for Sysbench (version 1.0 or later).Despite being 25 years old, the TPC-C benchmark can still provide an interesting intensive workload for a database in... by Dave Avery | Sep 21, 2017 | Benchmarks, MySQL, Percona Live
Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the... by Peter Zaitsev | Sep 20, 2017 | Insight for DBAs, Monitoring, MySQL
In this blog post, I will demonstrate how to run and use sysbench histograms.One of the features of sysbench that I often I see overlooked (and rarely used) is its ability to produce detailed query response time histograms in addition to computing percentile numbers.... 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 Vadim Tkachenko | Apr 7, 2016 | MySQL
This blog will look at MySQL 5.7 sysbench OLTP read-only results to determine if they are faster than previous versions.As promised in my previous post, I have checked MySQL 5.7 performance against previous versions in a different workload. This time, I will use... by Vadim Tkachenko | Dec 3, 2015 | Cloud, MySQL, Percona Software
In my previous post Amazon Aurora – Looking Deeper, I promised benchmark results on Amazon Aurora.Amazon used quite a small dataset in their benchmark: 250 tables, with 25000 rows each, which in my calculation corresponds to 4.5GB worth of data. For this... 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 Michael Coburn | Sep 2, 2014 | Benchmarks, Insight for DBAs, MySQL, Percona Services
Given the recent excitement & interest around OpenStack I wanted to make sure I was ready to conduct appropriate evaluations of system performance. I generally turn to sysbench since it comes with a variety of different tests (accessed via –test=... by Peter Boros | Aug 12, 2014 | Benchmarks, Insight for DBAs, MySQL
Diablo Technologies engaged Percona to benchmark IBM eXFlash™ DIMMs in various aspects. An eXFlash™ DIMM itself is quite an interesting piece of technology. In a nutshell, it’s flash storage, which you can put in the memory DIMM slots. Enabled... 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 Peter Boros | Mar 31, 2014 | Benchmarks, Insight for DBAs, MySQL, Percona Live, Percona Services
ScaleArc recently hired Percona to perform various tests on its database traffic management product. This post is the outcome of the benchmarks carried out by Uday Sawant (ScaleArc) and myself. You can also download the report directly as a PDF here.The goal of these... 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... by Tim.Callaghan | May 28, 2013 | MySQL
Two months ago I posted a performance comparison running Sysbench on MongoDB versus MongoDB with Fractal Tree Indexes v0.0.2. The benchmark showed a 133% improvement in throughput. Nice, but our engineering team had an effort on our road-map for lock refinement that... by Tim.Callaghan | Mar 14, 2013 | MySQL
As we continue to test our Fractal Tree Indexing with MongoDB, I’ve been updating my benchmark infrastructure so I can compare performance, correctness, and resource utilization. Sysbench has long been a standard for testing MySQL performance, so I created... by Roel Van de Paar | Oct 23, 2012 | Benchmarks, Insight for DBAs, Percona Events, Percona Software
Continuous integration of new features and bug fixes is great – but what if a small change in seemingly insignificant code causes a major performance regression in overall server performance?We need to ensure this does not happen.That said, performance...