Buy Percona ServicesBuy Now!

Webinar Tues, 5/29: MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together

 | May 25, 2018 |  Posted In: Containers, High-availability, Insight for DBAs, Insight for Developers, MySQL, Percona Server for MySQL, Percona Software, Percona XtraDB Cluster, ProxySQL, Technical Webinars, XtraDB Cluster

Please join Percona’s Principal Architect Alex Rubin as he presents MySQL, Percona XtraDB Cluster, ProxySQL, Kubernetes: How they work together to give you a highly available cluster database environment on Tuesday, May 29th at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   In this webinar, Alex will discuss how to deploy […]

Read More

One Million Tables in MySQL 8.0

 | October 1, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 8.0

MySQL 8.0

In my previous blog post, I talked about new general tablespaces in MySQL 8.0. Recently MySQL 8.0.3-rc was released, which includes a new data dictionary. My goal is to create one million tables in MySQL and test the performance. Background questions Q: Why million tables in MySQL? Is it even realistic? How does this happen? Usually, millions […]

Read More

Non-Deterministic Order for SELECT with LIMIT

 | April 7, 2017 |  Posted In: Insight for DBAs, MySQL

Non-Deterministic Order

In this blog, we’ll look at how queries in systems with parallel processing can return rows in a non-deterministic order (and how to fix it). Short story: Do not rely on the order of your rows if your query does not use ORDER BY. Even with ORDER BY, rows with the same values can be sorted differently. To fix this […]

Read More

Column Store Database Benchmarks: MariaDB ColumnStore vs. Clickhouse vs. Apache Spark

 | March 17, 2017 |  Posted In: Apache Spark, Big Data, Column Store Database, MySQL

Column Store Database

This blog shares some column store database benchmark results, and compares the query performance of MariaDB ColumnStore v. 1.0.7 (based on InfiniDB), Clickhouse and Apache Spark. I’ve already written about ClickHouse (Column Store database). The purpose of the benchmark is to see how these three solutions work on a single big server, with many CPU cores and large amounts of […]

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