EmergencyEMERGENCY? Get 24/7 Help Now!

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

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

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

ProxySQL Improves MySQL SSL Connections

 | September 19, 2017 |  Posted In: MySQL, ProxySQL, Security, SSL

In this blog post, we’ll look at how ProxySQL improves MySQL SSL connection performance. When deploying MySQL with SSL, the main concern is that the initial handshake causes significant overhead if you are not using connection pools (i.e., mysqlnd-mux with PHP, mysql.connector.pooling in Python, etc.). Closing and making new connections over and over can greatly impact […]

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, Percona Server for MongoDB

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

Percona Live Europe Featured Talks: Monitoring Open Source Databases with Icinga with Bernd Erk

 | September 14, 2017 |  Posted In: Database Monitoring, 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 Bernd Erk, CEO […]

Read More

Percona Live Europe Featured Talks: Visualize Your Data with Grafana Featuring Daniel Lee

 | September 13, 2017 |  Posted In: Database Monitoring, 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 Daniel Lee, a […]

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