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/sysbenchBMK-kit –... by Vadim Tkachenko | Sep 16, 2020 | Benchmarks, Insight for DBAs, MongoDB
There is a special collection of database bugs when the system starts to perform worse when given more resources. Examples of such bugs for MySQL I have:Bug #15815 – This is where InnoDB on an 8-CPU system performed worse than on a 4-CPU system with increased... by Vadim Tkachenko | Sep 15, 2020 | Benchmarks, Insight for DBAs, MongoDB
Following my previous blogs on py-tpcc benchmark for MongoDB, Evaluating the Python TPCC MongoDB Benchmark and Evaluating MongoDB Under Python TPCC 1000W Workload, and the recent release of Percona Server for MongoDB 4.4, I wanted to evaluate 4.2 vs 4.4... by Vadim Tkachenko | Aug 14, 2020 | Benchmarks, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source,production-ready, and enterprise-grade MySQL alternative. Learn More Recently, I published a series of posts on MySQL and MariaDB, where MariaDB 10.5.4 does not... by Vadim Tkachenko | Aug 14, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
Part one of this series can be found here: How Many innodb_buffer_pool_instances Do You Need in MySQL 8?Following up on my recent benchmark posts on MySQL and MariaDB, MySQL and MariaDB on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, I... by Vadim Tkachenko | Aug 13, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
Following up on my recent benchmark posts on MySQL and MariaDB, MySQL and MariaDB on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, I wanted to dig a little deeper and understand how different MySQL parameters affect performance.One of the... by Tibor Korocz | Aug 6, 2020 | Benchmarks, MySQL, Percona Software
Recently I had the opportunity to test a storage device from ScaleFlux called CSD 2000. In this blog post, I will share the results of using it to run MySQL in comparison with an Intel device that had a similar capacity. First of all, why do we need another storage... by Vadim Tkachenko | Jul 31, 2020 | Benchmarks, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source, production-ready, and enterprise-grade MySQL alternative. Learn More Continuing with the same topic and evaluating new versions of MariaDB and MySQL on Enterprise SSD... by Vadim Tkachenko | Jul 30, 2020 | Benchmarks, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source,production-ready, and enterprise-grade MySQL alternative. Learn More MySQL and MariaDB on NVMe Storage – The Great Equalizer Continuing with the... by Vadim Tkachenko | Jul 29, 2020 | Benchmarks, MariaDB, MySQL
Continuing with the checkpointing topic I restarted a month ago with MongoDB and followed with PostgreSQL, I wanted to check how MySQL and MariaDB perform.It was actually some time when I last looked into MySQL in this regard, so I am curious how new MySQL versions... by Vadim Tkachenko | Jul 28, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, PostgreSQL
Continuing with the checkpointing topic I started a month ago with my blog post MongoDB Checkpointing Woes, this time I want to review how PostgreSQL performs in this area. After this, I will be taking a look at MySQL and MariaDB. If anything, it will be fair not only... by Sri Sakthivel | Jul 27, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MySQL
I would say that innodb_rollback_on_timeout is a very important parameter. In this blog, I am going to explain “innodb_rollback_on_timeout” and how it affects the transaction behavior at the MySQL level. I describe two scenarios with practical tests, as it... by Vadim Tkachenko | Jul 27, 2020 | Benchmarks, Insight for DBAs, Insight for Developers, MariaDB, MySQL
There were two new releases in the OpenSource Analytical Databases space, which made me want to evaluate how they perform in the Star Schema Benchmark.I covered Star Schema Benchmarks a few times before: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB... by Sri Sakthivel | Jul 17, 2020 | Benchmarks, Insight for DBAs, MariaDB, Storage Engine
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source, production-ready, and enterprise-grade MySQL alternative. Learn More MariaDB 10.5 has an excellent engine plugin called “S3”. The S3 storage engine is based... by Vadim Tkachenko | Jun 25, 2020 | Benchmarks, Insight for DBAs, MongoDB, Percona Software
In my recent post Evaluating MongoDB Under Python TPCC 1000W Workload with MongoDB benchmarks, I showed an average throughput for a prolonged period of time (900sec or 1800sec), and the average throughput tended to smooth and hide problems.But if we zoom in to 1-sec... by Vadim Tkachenko | Jun 24, 2020 | Benchmarks, Insight for DBAs, MongoDB, Percona Software
Following my blog post Evaluating the Python TPCC MongoDB Benchmark, I wanted to evaluate how MongoDB performs under workload with a bigger dataset. This time I will load a 1000 Warehouses dataset, which in raw format should equal to 100GB of data.For the comparison,... by Vadim Tkachenko | Jun 15, 2020 | Benchmarks, MongoDB, Percona Software
I was looking for a tool that could evaluate MongoDB performance under a complex workload, besides simple key-value operations that benchmarks like YCSB provides.That’s why the paper “Adapting TPC-C Benchmark to Measure Performance of Multi-Document... by Peter Zaitsev | Apr 14, 2020 | Benchmarks, MySQL, ProxySQL
When I run a benchmark and want to measure the CPU efficiency of something, I find it’s often a good choice to run a benchmark program, as well as the database, on the same server. This is in order to eliminate network impact and to look at single-thread... by Peter Zaitsev | Apr 13, 2020 | Benchmarks, MySQL, Percona Software
When connecting to a local MySQL instance, you have two commonly used methods: use TCP/IP protocol to connect to local address – “localhost” or 127.0.0.1 – or use Unix Domain Socket.If you have a choice (if your application supports... by Vadim Tkachenko | Apr 10, 2020 | Benchmarks, MySQL
In this post, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections. While this setup is identical to that in my post “Evaluating Group Replication Scaling Capabilities in...