EmergencyEMERGENCY? Get 24/7 Help Now!

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

Avoid Shared Locks from Subqueries When Possible

 | September 25, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL

Shared Locks

In this blog post, we’ll look at how to avoid shared locks from subqueries. I’m pretty sure most of you have seen an UPDATE statement matching rows returned from a SELECT query:

This query, when executed with autocommit=1, is normally harmless. However, this can have bad effects when combined with other statements in the […]

Read More

Percona Live Europe: Tutorials Day

 | September 25, 2017 |  Posted In: Group Replication, High-availability, InnoDB, Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Live

Percona Live Tutorials

Welcome to the first day of the Percona Live Open Source Database Conference Europe 2017: Tutorials day! 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 open source database […]

Read More

This Week in Data with Colin Charles #7: Percona Live Europe and Open Source Summit North America

 | September 22, 2017 |  Posted In: Business Continuity, Events and Announcements, Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Live

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Europe Dublin Are you affected by the Ryanair flight cancellations? Have you made alternative arrangements? Have you registered for the community dinner? Even speakers have to register, so this is a separate ticket cost! […]

Read More

sysbench Histograms: A Helpful Feature Often Overlooked

 | September 20, 2017 |  Posted In: Database Monitoring, Insight for DBAs, MySQL

Sysbench Histograms

In this blog post, I will demonstrate how to run and use sysbench histograms. One of the features of sysbench that I often I see overlooked (and rarely used) is its ability to produce detailed query response time histograms in addition to computing percentile numbers. Looking at histograms together with throughput or latency over time […]

Read More

Percona Live Europe Featured Talks: Automatic Database Management System Tuning Through Large-Scale Machine Learning with Dana Van Aken

 | September 19, 2017 |  Posted In: Database Monitoring, Insight for DBAs, MongoDB, 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 Dana Van Aken, […]

Read More

Percona Live Europe Featured Talks: Debugging with Logs (and Other Events) Featuring Charity Majors

 | September 18, 2017 |  Posted In: Database Monitoring, Insight for DBAs, MongoDB, 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 Charity Majors, CEO/Cofounder […]

Read More

This Week in Data with Colin Charles #6: Open Source Summit and Percona Live Europe

 | September 15, 2017 |  Posted In: Events and Announcements, Insight for DBAs, Insight for Developers, Percona Live, Percona Server for MongoDB, Percona Server for MySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. What a long, packed week! Spent most of it at Open Source Summit North America, while still enjoying the myriad phone calls and meetings you have as a Perconian. In addition to two talks, I […]

Read More

Massive Parallel Log Processing with ClickHouse

 | September 13, 2017 |  Posted In: Database Monitoring, Insight for DBAs, MySQL, Yandex ClickHouse

ClickHouse

In this blog, I’ll look at how to use ClickHouse for parallel log processing. Percona is seen primarily for our expertise in MySQL and MongoDB (at this time), but neither is quite suitable to perform heavy analytical workloads. There is a need to analyze data sets, and a very popular task is crunching log files. Below […]

Read More