Buy Percona ServicesBuy Now!

This Week in Data with Colin Charles 25: Meltdown/Spectre still dominate, FOSDEM approaches and Timescale gets funding

 | January 26, 2018 |  Posted In: Amazon Aurora, AWS, Events and Announcements, MongoDB, MySQL, MySQL 8.0, Percona Live, PostgreSQL, ProxySQL, XtraDB Cluster

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Still on Meltdown/Spectre, this time MariaDB Corporation has published Meltdown Vulnerability Impact On MariaDB Server – interesting the comparison between glibc/tcmalloc. Worthy Facebook thread about this too, with a bit of chat about MongoDB performance. […]

Read More

MySQL 8.0.4 RC: auth_socket Users Beware!

 | January 24, 2018 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0, Security

MySQL 8.0.4 RC

The news that the latest MySQL 8.0.4 RC (release candidate) is available is indeed exciting. Unfortunately for users of the auth_socket plugin, dangers lie in wait! Back in November 2015, I reported Failure of auth_socket authentication with sha256_password as default. This prevents users that identify with the auth_socket plugin from logging in after SHA256 authentication has been […]

Read More

Webinar Wednesday, January 10, 2018: Why We’re Excited About MySQL 8.0

and  | January 9, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, MySQL 8.0, Technical Webinars

MySQL 8.0 innodb_dedicated_server

Join Percona’s, CEO and Co-Founder, Peter Zaitsev as he presents Why We’re Excited About MySQL 8.0 on Wednesday, January 10, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Experience: Basic Tags: Developer, DBAs, Operations, Executive, MySQL There are many great new features in MySQL 8.0, but how exactly can they help your applications? […]

Read More

Thoughts on MySQL 8.0.3 RC – The First MySQL 8.0 Release Candidate

 | December 12, 2017 |  Posted In: MySQL, MySQL 8.0, Percona Server for MySQL, Quality Assurance

MySQL 8.0.3 Release Candidate

Percona’s Technical Director of Quality Assurance Roel Van de Paar shares his findings on the quality of MySQL 8.0.3 RC. On 21 September 2017, our upstream friends at Oracle released MySQL 8.0.3 RC as the first MySQL 8.0 Release Candidate. I tested the MySQL 8.0.3 Release Candidate branch with selected Percona bugfixes applied and built […]

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

Percona Live Europe Social

 | October 4, 2017 |  Posted In: MongoDB, MySQL, MySQL 8.0, Percona Live

Percona Live Europe Social

One for the road… The social events at Percona Live Europe provide the community with more time to catch up with old friends and make new contacts. The formal sessions provided lots of opportunities for exchanging notes, experiences and ideas. Lunches and coffee breaks proved to be busy too. Even so, what’s better than chilling […]

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

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