Jan 22, 2019 |
Insight for DBAs, MySQL, Percona Software
A common challenge with continuously deployed applications is that new and modified SQL queries are constantly being introduced to the application. Many companies choose to use a database monitoring system (such as PMM) to identify those slow queries. But identifying slow queries is only the start – what about actually optimizing them? In this post […]
Nov 20, 2018 |
Percona Software, Security
Grafana Labs has released an important security update, and as you’re aware PMM uses Grafana internally. You’re probably curious whether this issue affects you. CVE-2018-19039 “File Exfiltration vulnerability Security fix” covers a recently discovered security flaw that allows any Grafana user with Editor or Admin permissions to have read access to the filesystem, performed with the same […]
Aug 01, 2018 |
Cloud, MongoDB, Monitoring, MySQL, Percona Events, Percona Software
PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently as possible. The most significant feature in this release is Prometheus 2, however we also packed a […]
Jul 06, 2018 |
MariaDB, MongoDB, MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.11 on July 6, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona […]
Jun 27, 2018 |
Cloud, MongoDB, Monitoring, MySQL, Percona Events, Percona Software
PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently as possible. In release 1.12, we invested our efforts in the following areas: Visual Explain in […]
May 23, 2018 |
Cloud, MongoDB, Monitoring, MySQL, Percona Events, Percona Software
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible. In PMM Release 1.11.0, we deliver the following changes: Configurable MySQL Slow Log Rotation […]
May 22, 2018 |
MariaDB, MongoDB, MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.10 on May 22, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona […]
Feb 06, 2018 |
Monitoring, MySQL, Open Source, Percona Software
In this blog post, we’ll introduce how you can look at some experimental Percona Monitoring and Management (PMM) features using Percona Labs builds on GitHub. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools created by Percona staff. While not covered by Percona support or services agreements, these handy utilities […]
Jan 16, 2018 |
Insight for DBAs, Monitoring, MySQL, Percona Software, Webinars
Join Percona’s Product Manager Michael Coburn as he presents MySQL Troubleshooting and Performance Optimization with Percona Monitoring and Management (PMM) Part 2 on Thursday, January 18, 2018, at 11:00 am PST / 2:00 pm EST (UTC-8). Register Now Tags: Percona Monitoring and Management, PMM, Monitoring, MySQL, Performance, Optimization, DBA, SysAdmin, DevOps Experience Level: Expert Optimizing […]
Dec 28, 2017 |
Cloud, MySQL, Percona Software
In this blog, we’ll look at how to monitor Amazon Aurora using Percona Monitoring and Management (PMM). One impact of the growth of web services such as AWS on DBAs is the need to understand and report on database and application resource usage. DBAs have always had to monitor for performance-related usability issues, which may […]
Dec 01, 2017 |
MongoDB, Monitoring, MySQL, Percona Software
In this post, we’ll examine how we’ve improved the GUI layout for Percona Monitoring and Management 1.5 by moving the Query Analytics (QAN) functions into the Grafana interface. For Percona Monitoring and Management users, you might notice that QAN appears a little differently in our 1.5 release. We’ve taken steps to unify the PMM interface […]
Jun 15, 2017 |
MongoDB, MySQL, Percona Software
In this blog post, we’ll look at three different methods for installing Percona Monitoring and Management (PMM). Percona offers multiple methods of installing Percona Monitoring and Management, depending on your environment and scale. I’ll also share comments on which installation methods we’ve decided to forego for now. Let’s begin by reviewing the three supported methods: […]
May 04, 2017 |
MongoDB, Monitoring, MySQL, Percona Software
I heard a frequent question at last week’s Percona Live conference regarding Percona Monitoring and Management (PMM): How much disk space should I allocate for PMM Server? First, let’s review the three components of Percona Monitoring and Management that consume non-negligible disk space: Prometheus data source for the time series metrics Query Analytics (QAN) which […]
Apr 03, 2017 |
Insight for DBAs, Insight for Developers, MariaDB, MySQL, Percona Events, Percona Software
In honor of the upcoming MariaDB M17 conference in New York City on April 11-12, we have enhanced Percona Monitoring and Management (PMM) Metrics Monitor with a new MariaDB Dashboard and multiple new graphs! The Percona Monitoring and Management MariaDB Dashboard builds on the efforts of the MariaDB development team to instrument the Aria Storage Engine Status Variables related […]
Jun 19, 2015 |
Cloud, MySQL, Percona Software, Webinars
Last week I hosted a webinar on using MySQL in the cloud for High Availability (HA) alongside 451 Research analyst Jason Stamper. You can watch the recording and also download the slides (free) here. Just click the “Register” button at the end of that page. We had several excellent questions and we didn’t have time […]
Jun 04, 2015 |
Insight for DBAs, MySQL
Next Wednesday (June 10) I’ll be co-presenting a webinar on using MySQL in the cloud for High Availability (HA). Joining me will be 451 Research analyst Jason Stamper and together we’ll talk about the realities of HA using MySQL in the cloud and how vendors are responding to changing application requirements with new developments that […]
Apr 03, 2015 |
MySQL
On a recent engagement I worked with a customer who makes extensive use of UUID() values for their Primary Key and stores it as char(36), and their row count on this example table has grown to over 1 billion rows. The table is INSERT-only (no UPDATEs or DELETEs), and the bulk of their retrieval are PK […]
Jan 23, 2015 |
MySQL, Percona Software
For months when speaking with customers I have been positioning Percona Cloud Tools (PCT) as a valuable tool for the DBA/Developer/SysAdmin but only recently have I truly been able to harness the data and make a technical recommendation to a customer that I feel would have been very difficult to accomplish otherwise. Let me provide […]
Sep 02, 2014 |
Benchmarks, Insight for DBAs, MySQL, Percona Services
Given the recent excitement & interest around OpenStack I wanted to make sure I was ready to conduct appropriate evaluations of system performance. I generally turn to sysbench since it comes with a variety of different tests (accessed via –test= option interface), including: fileio – File I/O test cpu – CPU performance test memory – […]
Jul 28, 2014 |
Cloud, Insight for DBAs, MySQL, Percona Services
Hi, I recently had the experience of assisting with a migration of a customer MySQL installation to Amazon RDS (Relational Database Service). Amazon RDS is a great platform for hosting your MySQL installation and offers the following list of pros and cons: You can scale your CPU, IOPS, and storage space separately by using Amazon […]