Buy Percona ServicesBuy Now!

How Binary Logs (and Filesystems) Affect MySQL Performance

 | May 4, 2018 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MySQL, MySQL 8.0

I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in throughput for the InnoDB storage engine, even though we spent a […]

Read More

A Look at MyRocks Performance

 | April 30, 2018 |  Posted In: Benchmarks, Insight for DBAs, MyRocks, MySQL

MyRocks Performance

In this blog post, I’ll look at MyRocks performance through some benchmark testing. As the MyRocks storage engine (based on the RocksDB key-value store http://rocksdb.org ) is now available as part of Percona Server for MySQL 5.7, I wanted to take a look at how it performs on a relatively high-end server and SSD storage. […]

Read More

Percona Live 2018 Keynotes, Day One

 | April 24, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Benchmarks, MariaDB, MongoDB, MySQL, Percona Live

Percona Live 2018 Keynotes Sugu

Welcome to Percona Live 2018 keynotes, day one! Percona Live 2018 is up and running! We call this day one, but in reality, yesterday was filled with tutorials that provided excellent and practical information on how to get your MySQL, MongoDB, MariaDB and PostgreSQL environments up, running and optimized. Today we started with keynote presentations […]

Read More

Sysbench-tpcc Supports PostgreSQL (No, Really This Time)

 | April 19, 2018 |  Posted In: Benchmarks, Database Monitoring, Insight for DBAs, MySQL

Sysbench-tpcc Supports PostgreSQL

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 databases speak SQL, the difference in dialects was too big and the queries written […]

Read More

Sneak Peek at Proxytop Utility

 | March 9, 2018 |  Posted In: Benchmarks, MySQL, ProxySQL

Proxytop

In this blog post, I’ll be looking at a new tool Proxytop for managing MySQL topologies using ProxySQL. Proxytop is a self-contained, real-time monitoring tool for ProxySQL. As some of you already know ProxySQL is a popular open source, high performance and protocol-aware proxy server for MySQL and its forks (Percona and MariaDB). My lab […]

Read More

TPCC-Like Workload for Sysbench 1.0

 | March 5, 2018 |  Posted In: Benchmarks, Insight for DBAs, MySQL

Sysbench-tpcc Supports PostgreSQL

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 my opinion. It runs multi-statement transactions and is write-heavy. We also decided to use Sysbench 1.0, […]

Read More