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: 
Intermediate
Duration: 
50 minutes conference
Tracks:
Operations
Topics:
MySQL
Devops
Tools and Techniques

Description

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.

Speakers

Brian Cain's picture

Brian Cain

Database Engineer - MySQL SRE, Dropbox

Biography:

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