申请试用
HOT
登录
注册
 
Speaking the same language as Developers and DBAs
苏寒
/
发布于
/
1533
人观看

在本文中,我们将介绍PMM为您(CEO)提供的一些高级监控概念,以便与您的技术团队使用相同的语言。我们将涵盖:
-首席执行官应遵循哪些门槛
-主机特定资源-CPU、内存、磁盘、网络
-数据库特定资源-连接、每秒查询数、查询速度慢、复制延迟
-使用PMM构建自定义关键绩效指标
-可视化应用程序逻辑
-在一个视图下组合应用程序和数据库

展开查看详情

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

0 点赞
0 收藏
0下载
相关文档
确认
3秒后跳转登录页面
去登陆