Database Monitoring

Percona Consulting can help you determine the right database monitoring solution for your system and help with its deployment, while ensuring optimal performance. Percona Support includes monitoring and management tools which put Percona’s deep operational expertise in your hands to provide visibility into problems before they happen. And if you lack the resources to manage your deployment, Managed Services team can take over the full operation, administration, and monitoring of your database.

Percona Live 2018 Keynotes, Day Two

Percona Live 2018 Panel Keynote

Welcome to Percona Live 2018 keynotes, day two!
Day two of Percona Live 2018 looks to be as filled with great talks as day one. Today we started with keynote presentations from Percona, a panel on the evolution of databases and talks from VividCortex and Upwork. You can view the recording of today’s keynotes here.
Percona Welcome […]

Read more

The Final Countdown: Are You Ready for Percona Live 2018?

Are you ready for Percona Live

It’s hard to believe Percona Live 2018 starts on Monday! We’re looking forward to seeing everyone in Santa Clara next week! Here are some quick highlights to remember:

In addition to all the amazing sessions and keynotes we’ve announced, we’ll be hosting the MySQL Community Awards and the Lightning Talks on Monday during the Opening […]

Read more

Percona Monitoring and Management (PMM) 1.10.0 Is Now Available

Percona Monitoring and Management 1.17.0

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible.
We focused mainly on two features in 1.10.0, but there are also several notable […]

Read more

Sysbench-tpcc Supports PostgreSQL (No, Really This Time)

Sysbench-tpcc Supports PostgreSQL

This time, we really mean it when we say sysbench-tpcc supports PostgreSQL.
When I initially announced sysbench-tpcc, I mentioned it potentially could run against PostgreSQL, but it was more like wishful thinking than reality. The reality was that even though both databases speak SQL, the difference in dialects was too big and the queries written […]

Read more

Why Analyze Raw MySQL Query Logs?

Raw MySQL Query Logs

In this blog post, I’ll examine when looking at raw MySQL query logs can be more useful than working with tools that only have summary data.
In my previous blog post, I wrote about analyzing MySQL Slow Query Logs with ClickHouse and ClickTail. One of the follow-up questions I got is when do you […]

Read more

Calling All Polyglots: Percona Live 2018 Keynote Schedule Now Available!

Percona Live 2019 Call for Papers

We’ve posted the Percona Live 2018 keynote addresses for the seventh annual Percona Live Open Source Database Conference 2018, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, CA. 
This year’s keynotes explore topics ranging from how cloud and open source database adoption accelerates business growth, to leading-edge emerging technologies, […]

Read more

Percona Live 2018 Featured Talk: The Accidental DBA with Jenni Snyder

Jenni Snyder Yelp Percona Live 2018 (2)

Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter.
This blog post highlights Jenni Snyder, Engineering Manager – Operations at Yelp. Her tutorial talk […]

Read more

Percona Monitoring and Management 1.9.0 Is Now Available

Percona Monitoring and Management 1.17.0

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible.
There are a number of significant updates in Percona Monitoring and Management 1.9.0 that […]

Read more

Plot MySQL Data in Real Time Using Percona Monitoring and Management (PMM)

Plot MySQL Data in Real Time

In this blog post, we’ll show that you can plot MySQL data in real time using Percona Monitoring and Management (PMM).
In my previous blog post, I showed how we could load into any metrics, benchmarks into MySQL and visualize it with PMM. But that’s not all! We can even visualize most any kind of […]

Read more

Analyze MySQL Audit Logs with ClickHouse and ClickTail

ClickHouse and ClickTail

In this blog post, I’ll look at how you can analyze MySQL audit logs (Percona Server for MySQL) with ClickHouse and ClickTail.
Audit logs are available with a free plugin for Percona Server for MySQL (https://www.percona.com/doc/percona-server/LATEST/management/audit_log_plugin.html). Besides providing insights about activity on your server, you might need the logs for compliance purposes.
However, on an active server, […]

Read more