Speaking the same language as Developers and DBAs

1 . Speaking the same language as Developers and DBAs Michael Coburn Percona 1 © 2019 Percona 

2 .Michael Coburn ▪ Product Manager for PMM (as well as for Percona Toolkit) ▪ At Percona for 6 years across multiple MySQL roles • Principal Architect, Managing Consultant, Technical Account Manager 2 © 2019 Percona 

3 .Looking Inwards Who are you, who are they? 3 © 2019 Percona 

4 .Business Leaders ▪ Think about yourself and those around you: • Extroverted, passionate about your business? • You are driven by measurable results! • In the technical weeds? ▪ What are some metrics you use? 4 © 2019 Percona 

5 .Developers and DBAs ▪ See themselves as: • Problem solvers - code is the solution • Time not spent developing is time wasted ▪ Arguably trend introvert vs extrovert ▪ Driven by metrics, just like you! ▪ What are some examples? 5 © 2019 Percona 

6 .What can you do to bridge the gap ▪ Learn to code! • Do you have the time, what else do you give up (opportunity cost) • Is this realistic? Would the investment pay dividends? ▪ Be where your Developers and DBAs are • If they use Slack, then you should too ▪ Understand their view of Metrics! • Actionable and achievable - starting from today! 6 © 2019 Percona 

7 .Looking Outwards as a Developer or DBA Where are they going 7 © 2019 Percona 

8 .What are they using? ▪ Timeseries database • Graphite, Timescale, Prometheus ▪ Visualisation system • Cacti, Nagios, Grafana ▪ Build vs Deploy • Which way does your Development team trend? 8 © 2019 Percona 

9 .Percona Monitoring and Management ▪ Free, Open Source database troubleshooting and performance optimization platform for MySQL, MongoDB, and PostgreSQL ▪ Runs in your secure environment (this is not a SaaS product!) and on your equipment ▪ Be up and running in minutes! 9 © 2019 Percona 

10 .Database Metrics What’s important 10 © 2019 Percona 

11 .What are they looking for? ▪ Deviations from a baseline • Show me the last hour, overlayed with yesterday and last week ▪ Absolute value vs rate of change 11 © 2019 Percona 

12 .Now vs yesterday vs last week 12 © 2019 Percona 

13 .Absolute vs rate of change 13 © 2019 Percona 

14 .Available Dashboards ▪ PMM has 43 dashboards, of which 15 are MySQL focused ▪ 7 MongoDB ▪ … PostgreSQL, ProxySQL, and more! 14 © 2019 Percona 

15 .Query Analytics The single most important concept to take away from this session 15 © 2019 Percona 

16 .Slowest Queries ▪ The single most determinant factor in database performance is query & schema design ▪ Optimizing a query has the greatest impact on database performance ▪ Therefore identification of slow queries is CRITICAL ▪ Let's look at a slow query from Percona Production 16 © 2019 Percona 

17 .MySQL Query Analytics Top 10 17 © 2019 Percona 

18 .How do I find my slowest queries ▪ Queries are grouped by "time consumed by the database serving this query pattern" ▪ Our worst offender causes 55% of the load, and returns on average in 232ms (good but not great) 18 © 2019 Percona 

19 .Query Detail 19 © 2019 Percona 

20 .Drilling down on a slow query ▪ Query runs 1-3 times a second, no big deal... ▪ Query doesn't seem to be slow due to locks… ▪ Query returns one or two rows, ok… ▪ Query has to examine (look at, sort, etc) some 500,000 rows.. wait, what?! ▪ Query does a full table scan 1-2 times a second.. that's probably not good.. ▪ Just paste the URL in Slack and now you are speaking the same language as your Developers and DBAs! 20 © 2019 Percona 

21 .Beyond the Database Getting custom with PMM 21 © 2019 Percona 

22 .What else can I do with PMM? ▪ Plot your Application metrics alongside your Database metrics ▪ Less tools & systems to support means more time focused on your core competencies 22 © 2019 Percona 

23 .Versions over Time 23 © 2019 Percona 

24 .Country of Origin 24 © 2019 Percona 

25 .Wrapping up ▪ Your laser focus on metrics also applies to your Developers and DBAs - they just care about different metrics ▪ Using one tool vs many can reduce your maintenance overhead ▪ Familiarity with operational metrics builds trust! 25 © 2019 Percona