MySQL Monitoring with Percona Monitoring and Management
In this talk, I will introduce Percona’s latest open source software tool: Percona Monitoring and Management (PMM). I will briefly discuss high-level aspects of monitoring we’ve found work well in practice at Percona, and then spend the rest of the time with an online demonstration of how to use this tool to identify common MySQL issues. This demonstration will examine: · Base hardware performance and resource utilization assessment: CPU, disk, memory and network – all common performance problem causes. · MySQL-level metrics: how to understand the true MySQL load using command counters and row operations, as well as getting into userstat details such as query response time measurements and Performance Schema. · Individual MySQL query performance: how to find and optimize the most run MySQL queries, new queries, and queries that have started using more resources.
Peter co-founded Percona in 2006, assuming the role of CEO. Percona helps companies of all sizes maximize their success with MySQL. Percona was named to the Inc. 5000 in 2013. Peter was an early employee at MySQL AB, eventually leading the company’s High Performance Group. A serial entrepreneur, Peter co-founded his first startup while attending Moscow State University where he majored in Computer Science. As CEO of Percona, Peter enjoys mixing business leadership with hands on technical expertise. Peter is co-author of High Performance MySQL published by O’Reilly, one of the most popular books on MySQL performance. Peter blogs regularly on Percona Database Performance Blog and speaks frequently at conferences. Peter lives in North Carolina with his wife and two children. In his spare time, Peter enjoys travel and spending time outdoors.