Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Use slow logs to collect unique queries and their performance continuously

Use slow logs to collect unique queries and their performance continuously

Experience level: 
Intermediate
Duration: 
Lightning Talk
Tracks:
Operations
Developer
Topics:
MySQL
Tools and Techniques
Metrics

Description

When you upgrade to a new environment, you may wish to test each of the unique queries that enter the database for a safe upgrade, but how can you collect a complete set of unique queries on a heavily loaded database? When you stay on the same environment, you may want to know the performance of each of the unique queries for tuning purpose, how do you collect the data. In this lightning talk, I would like to introduce the concept and a tool based on the concept to achieve the two aforementioned purposes. They key concept is to collect new data and merge which the data already collected. While the Percona tool pt-query-digest which provides a snapshot view of what happened, my tool pv-mysql-slow-log-analyzer extends the capability by giving you a complete and evolving view of what has happened and what is happening.

Speakers

Michael Wang's picture

Michael Wang

MySQL DBA, Salesforce

Biography:

Michael Wang is a MySQL DBA at Salesforce, he is fluent in Objected Oriented Programming in Perl.

Share this talk