Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

Bash One-Liners and Other Tools to Simplify MySQL Ops at Scale

Bash One-Liners and Other Tools to Simplify MySQL Ops at Scale

 25 April - 2:20 PM - 3:10 PM @ Ballroom E
Experience level: 
50 minutes conference
Tools and Techniques


Overview: There are a number of built-in MySQL commands and third party tools out there for generating data to help tune and diagnose your servers. All that information is great, but not always easy to parse through; especially if you are in the middle of an emergency. What do you do when you need to see only the non-sleeping processlist threads, pick out the top 5 longest currently running queries, or show the oldest open transactions from show engine innodb status? Sometimes you just need to be able to sort, split, or generally reorganize a lot of information quickly. In this session we will give you some helpful bash one-liners with common MySQL commands and output files to make parsing all that information easier to read. Format: Slide presentation and demos Target Audience: Beginner to intermediate DBAs looking to expand their Bash skills Agenda: The session will be a mix of presentation slides and demonstrations of commands.


Brian Cain's picture

Brian Cain

Database Engineer - MySQL SRE, Dropbox


Brian is a Database Engineer MySQL SRE for Dropbox. He has worked with MySQL for the past 5 years supporting multiple client environments as a consultant or FTE. He spends most of his time as an operational DBA automating routine tasks such as instance cloning and master promotions along with enhancing monitoring and alerts to proactively detect upcoming issues. He has a background as a developer, manager, and systems administrator over the past 20+ years. Brian is based out of Seattle, WA.

Share this talk