EmergencyEMERGENCY? Get 24/7 Help Now!

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

Webinar Tuesday, September 19, 2017: A Percona Support Engineer Walkthrough for pt-stalk

 | September 18, 2017 |  Posted In: Database Monitoring, Percona Toolkit, Technical Webinars

Join Percona’s, Principal Support Engineer, Markus Albe as he presents A Percona Support Engineer Walkthrough for pt-stalk on Tuesday, September 19, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Register Now As a support engineer, I get dozens of pt-stalk captures from our customers containing samples of iostat, vmstat, top, ps, SHOW ENGINE […]

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

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

Upcoming Webinar September 14, 2017: Supercharge Your Analytics with ClickHouse

 | September 12, 2017 |  Posted In: Database Monitoring, Insight for DBAs, Insight for Developers, MySQL, Technical Webinars, Yandex ClickHouse

ClickHouse

Join Percona’s CTO Vadim Tkachenko @VadimTk and Altinity’s Co-Founder, Alexander Zaitsev as they present Supercharge Your Analytics with ClickHouse on Thursday, September 14, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot   ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has […]

Read More

Updating InnoDB Table Statistics Manually

 | September 11, 2017 |  Posted In: Database Monitoring, InnoDB, Insight for DBAs, Insight for Developers, MySQL

InnoDB Tables

In this post, we will discuss how to fix cardinality for InnoDB tables manually. As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by default. Instead it looks at random pages, as determined […]

Read More

Upcoming Webinar Thursday, September 7: Using PMM to Troubleshoot MySQL Performance Issues

 | September 6, 2017 |  Posted In: Database Monitoring, Insight for DBAs, Insight for Developers, MySQL, Percona Monitoring and Management, Technical Webinars

Troubleshooting MySQL Performance

Join Percona’s Product Manager, Michael Coburn as he presents Using Percona Monitoring and Management to Troubleshoot MySQL Performance Issues on Thursday, September 7, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot   Successful applications often become limited by MySQL performance. Michael will show you how to get great MySQL performance […]

Read More