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

ClickHouse Meetup in Salt Lake City

 | May 1, 2018 |  Posted In: MyRocks, MySQL, Yandex ClickHouse

ClickHouse Cloud Native Utah

Join Percona CTO Vadim Tkachenko at the Cloud Native Utah meetup in Salt Lake City on Tuesday, May 8, 2018, for an Intro to ClickHouse. Next week, I’ll be switching from MyRocks performance testing and present an introduction to ClickHouse to the Cloud Native Utah meetup. Interestingly enough, even though it is totally different from OLTP engines, […]

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

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

Analyze MySQL Audit Logs with ClickHouse and ClickTail

 | March 29, 2018 |  Posted In: Database Monitoring, MySQL, Yandex ClickHouse

ClickHouse and ClickTail

In this blog post, I’ll look at how you can analyze MySQL audit logs (Percona Server for MySQL) with ClickHouse and ClickTail. Audit logs are available with a free plugin for Percona Server for MySQL (https://www.percona.com/doc/percona-server/LATEST/management/audit_log_plugin.html). Besides providing insights about activity on your server, you might need the logs for compliance purposes. However, on an active […]

Read More

Percona XtraDB Cluster on Amazon GP2 Volumes

and  | March 28, 2018 |  Posted In: AWS, High-availability, Insight for DBAs, Percona XtraDB Cluster

In this blog post, we look at the performance of Percona XtraDB Cluster on Amazon GP2 volumes. In our overview blog post on Best Practices for Percona XtraDB Cluster on AWS, GP2 volumes did not show good results. However, we allocated only the size needed to fit the database (200GB volumes). Percona XtraDB Cluster did not show […]

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

MyRocks Engine: Things to Know Before You Start

 | February 1, 2018 |  Posted In: MySQL

MyRocks

Percona recently released Percona Server with MyRocks as GA. You can see how Facebook explains wins they see in production with MyRocks. Now if you use Percona repositories, you can simply install MyRocks plugin and enable it with ps-admin –enable-rocksdb. There are some major and minor differences when comparing it to typical InnoDB deployments, and […]

Read More

20-30% Performance Hit from the Spectre Bug Fix on Ubuntu

 | January 23, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Security

Spectre Bug Fix on Ubuntu

In this blog post, we’ll look at the performance hit from the Spectre bug fix on Ubuntu. Recently we measured the performance penalty from the Meltdown fix on Ubuntu servers. It turned out to be negligible. Today, Ubuntu made a Spectre bug fix on Ubuntu available, shipped in kernel 4.4.0-112. As with the Meltdown fix, […]

Read More