Speaking the same language as Developers and DBAs Michael Coburn - - PowerPoint PPT Presentation

Speaking the same language as Developers and DBAs

Michael Coburn 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

Looking Inwards

Who are you, who are they?

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?

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?

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!

Looking Outwards as a Developer

• r DBA

Where are they going

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?

9

Percona Monitoring and Management

• Free, Open Source database troubleshooting and performance
• ptimization 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!

Database Metrics

What's important

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

12

Now vs yesterday vs last week

13

Absolute vs rate of change

14

Available Dashboards

• PMM has 43 dashboards, of

which 15 are MySQL focused

• 7 MongoDB
• … PostgreSQL, ProxySQL, and

more!

Query Analytics

The single most important concept to take away from this session

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

17

MySQL Query Analytics Top 10

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)

19

Query Detail

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!

Beyond the Database

Getting custom with PMM

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

23

Versions over Time

24

Country of Origin

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!

26

Rate My Session

27