Buy Percona ServicesBuy Now!

TPCC-Like Workload for Sysbench 1.0

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

TPCC-Like Workload for Sysbench

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


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

Does the Meltdown Fix Affect Performance for MySQL on Bare Metal?

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

Meltdown Fix Affect Performance small

In this blog post, we’ll look at does the Meltdown fix affect performance for MySQL on bare metal servers. Since the news about the Meltdown bug, there were a lot of reports on the performance hit from proposed fixes. We have looked at how the fix affects MySQL (Percona Server for MySQL) under a sysbench workload. […]

Read More

MySQL 8.0 Window Functions: A Quick Taste

 | December 5, 2017 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0

Window Functions

In this post, we’ll briefly look at window functions in MySQL 8.0. One of the major features coming to MySQL 8.0 is the support of Window functions. The detailed documentation is already available here Window functions. I wanted to take a quick look at the cases where window functions help. Probably one the most frequent limitations in […]

Read More

Webinar Wednesday, December 6, 2017: Gain a MongoDB Advantage with the Percona Memory Engine

and  | December 5, 2017 |  Posted In: MongoDB, Percona Memory Engine, Technical Webinars

Percona Memory Engine

Join Percona’s, CTO, Vadim Tkachenko as he presents Gain a MongoDB Advantage with the Percona Memory Engine on Wednesday, December 6, 2017, at 11:00 am PST / 2:00 pm EST (UTC-8). Experience: Entry Level to Intermediate Tags: Developer, DBAs, Operations Looking for the performance of Redis or Memcache, the expressiveness of the MongoDB query language […]

Read More

Best Practices for Percona XtraDB Cluster on AWS

and  | November 28, 2017 |  Posted In: MySQL

Percona XtraDB Cluster on AWS 2 small

In this blog post I’ll look at the performance of Percona XtraDB Cluster on AWS using different service instances, and recommend some best practices for maximizing performance. You can use Percona XtraDB Cluster in AWS environments. We often get questions about how best to deploy it, and how to optimize both performance and spend when […]

Read More

ClickHouse MySQL Silicon Valley Meetup Wednesday, October 25 at Uber Engineering with Percona’s CTO Vadim Tkachenko

 | October 4, 2017 |  Posted In: MySQL, Yandex ClickHouse

ClickHouse MySQL

I will be presenting at the ClickHouse MySQL Silicon Valley Meetup on Wednesday, October 25, 2017, at 6:30 PM. ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has already proved itself ready for the serious workloads. We will talk about ClickHouse in general, some internals […]

Read More

Big Dataset: All Reddit Comments – Analyzing with ClickHouse

 | October 2, 2017 |  Posted In: Database Monitoring, MongoDB, MySQL, MySQL 8.0, PostgreSQL, Yandex ClickHouse


In this blog, I’ll use ClickHouse and Tabix to look at a new very large dataset for research. It is hard to come across interesting datasets, especially a big one (and by big I mean one billion rows or more). Before, I’ve used on-time airline performance available from BUREAU OF TRANSPORTATION STATISTICS. Another recent example is NYC […]

Read More