A Percona Support Engineer Walkthrough on pt-stalk

Wednesday 3:20PM-4:10PM

@ Field Suite 2

MySQL / MariaDB

50 minutes conference

Beginner

Tracks:
Developer, Operations

As a support engineer, everyday we get dozens of pt-stalk captures from our customers containing samples of iostat, vmstat, top, ps, SHOW ENGINE INNODB STATUS, SHOW PROCESSLIST and a multitude of other diagnostics outputs.

These are the tools of the trade for performance and troubleshooting, and we must learn to digest these outputs in an effective and systematic way to allow us to provide high quality service to a large volume of customers, and that is the knowledge we want to share through this presentation.

We will learn to setup, capture data, write plugins to trigger collection and to capture custom data, look at our systematic approach and learn what data to read first and how to unwind the tangled threads of pt-stalk.

By the end of this presentation you will have expert knowledge on how to capture diagnostic metrics at the right time and will have a generic approach to digest the captured data, allowing you to work on a large number of problems common to MySQL setups.


Speakers

Marcelo Altmann

Marcelo Altmann (Percona)

Senior Support Engineer

Biography:

Marcelo Altmann has joined Percona as a member of Support Team late in 2016. Prior to joining Percona , he worked as a MySQL DBA at Ireland's CCTLD, and worked as a DBA/PHP developer in Brazil. He holds a degree in Systems for Internet.


Marcos Albe

Marcos Albe (Percona)

Principal Support Engineer

Biography:

After 12 years working as a PHP/JS developer for local and remote firms, Marcos decided to pursuit true love and become full time DBA, so he has been doing MySQL Support at Percona for the past 6 years providing lead web properties with advise on anything-MySQL and in-depth system performance diagnostic help.


Slides



  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA