EmergencyEMERGENCY? Get 24/7 Help Now!

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

Percona Software and Roadmap Update with CEO Peter Zaitsev: Q2 2017

 | May 24, 2017 |  Posted In: Backups, Benchmarks, MariaDB, MongoDB, MySQL, Percona XtraBackup, Percona XtraDB Cluster, PMM, Technical Webinars

Percona Software and Services

This blog post is a summary of the Percona Software and Roadmap Update – Q2 2017 webinar given by Peter Zaitsev on May 4, 2017. This webinar reflects changes and updates since the last update (Q1 2017). A full recording of this webinar, along with the presentation slide deck, can be found here. Percona Software Below are the […]

Read More

Storing UUID and Generated Columns

 | May 3, 2017 |  Posted In: Benchmarks, Insight for DBAs, MySQL

Storing UUID

A lot of things have been said about UUID, and storing UUID in an optimized way. Now that we have generated columns, we can store the decomposed information inside the UUID and merge it again with generated columns. This blog post demonstrates this process. First, I used a simple table with one char field that I called […]

Read More

Percona Live 2017 Tutorials Day

 | April 25, 2017 |  Posted In: Benchmarks, Big Data, Cloud and MySQL, Cloud and NoSQL, InnoDB, JSON, MariaDB, MongoDB, MyRocks, MySQL, Percona Live

Percona Live Keynotes

Welcome to the first day of the Percona Live Open Source Database Conference: Percona Live 2017 tutorials day! While technically the first day of the conference, this day focused on provided hands-on tutorials for people interested in learning directly how to use open source tools and technologies. Today attendees went to training sessions taught by […]

Read More

ProxySQL Rules: Do I Have Too Many?

 | April 10, 2017 |  Posted In: Benchmarks, MySQL, ProxySQL

In this blog post we are going to take a closer look at ProxySQL rules. How do they work, and how big is the performance impact of having many rules? I would like to say thank you to Renè, who was willing to answer all my questions during my tests. Overview ProxySQL is heavily based […]

Read More

Evaluation of PMP Profiling Tools

 | April 5, 2017 |  Posted In: Benchmarks, MySQL, Percona Toolkit

PMP Profiling Tools

In this blog post, we’ll look at some of the available PMP profiling tools. While debugging or analyzing issues with Percona Server for MySQL, we often need a quick understanding of what’s happening on the server. Percona experts frequently use the pt-pmp tool from Percona Toolkit (inspired by http://poormansprofiler.org). The pt-pmp tool collects application stack traces GDB and then […]

Read More

ClickHouse: New Open Source Columnar Database

 | February 13, 2017 |  Posted In: Benchmarks

Clickhouse

For this blog post, I’ve decided to try ClickHouse: an open source column-oriented database management system developed by Yandex (it currently powers Yandex.Metrica, the world’s second-largest web analytics platform). In my previous set of posts, I tested Apache Spark for big data analysis and used Wikipedia page statistics as a data source. I’ve used the same data as […]

Read More