Buy Percona ServicesBuy Now!

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

Percona Database Performance Blog Year in Review: Top Blog Posts

 | December 29, 2017 |  Posted In: Benchmarks, MariaDB, MongoDB, MySQL

Percona Database Performance Blog

Let’s look at some of the most popular Percona Database Performance Blog posts in 2017. The closing of a year lends itself to looking back. And making lists. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple […]

Read More

Webinar Wednesday, October 18, 2017: How to Scale with MongoDB

and  | October 17, 2017 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MongoDB

Scale with MongoDB

Join Percona’s Senior Technical Services Engineer Adamo Tonete as he presents How To Scale with MongoDB on Wednesday, October 18, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now In this webinar, we will talk about how to scale with MongoDB, up to thousands of writes and reads per second. What are […]

Read More

Percona Live Europe Featured Talks: Modern sysbench – Teaching an Old Dog New Tricks with Alexey Kopytov

 | September 21, 2017 |  Posted In: Benchmarks, MySQL, Percona Live

Percona Live Europe 2017

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 presenter. This blog post is with Alexey Kopytov, sofware […]

Read More

Looking at Disk Utilization and Saturation

 | August 28, 2017 |  Posted In: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

DIsk Utilization and Saturation small

In this blog post, I will look at disk utilization and saturation. In my previous blog post, I wrote about CPU utilization and saturation, the practical difference between them and how different CPU utilization and saturation impact response times. Now we will look at another critical component of database performance: the storage subsystem. In this post, I […]

Read More

Gh-ost benchmark against pt-online-schema-change performance

 | July 12, 2017 |  Posted In: Benchmarks, Insight for DBAs, MySQL

gh-ost-benchmark

In this blog post, I will run a gh-ost benchmark against the performance of pt-online-schema-change. When gh-ost came out, I was very excited. As MySQL ROW replication became commonplace, you could use it to track changes instead of triggers. This practice is cleaner and safer compared to Percona Toolkit’s pt-online-schema-change. Since gh-ost doesn’t need triggers, I assumed it would […]

Read More

ClickHouse in a General Analytical Workload (Based on a Star Schema Benchmark)

 | June 22, 2017 |  Posted In: Benchmarks, MySQL, Performance Schema

ClickHouse

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test. We have mentioned ClickHouse in some recent posts (ClickHouse: New Open Source Columnar Database, Column Store Database Benchmarks: MariaDB ColumnStore vs. Clickhouse vs. Apache Spark), where it showed excellent results. ClickHouse by itself seems […]

Read More