MySQL Performance Blog

Percona's MySQL & InnoDB performance and scalability blog

Latest articles

Diagnosing and Fixing “MySQL Server Has Gone Away” Messages

We all like when error messages are descriptive and give a clear idea about what is happening; however, there are some cases when a few possible reasons lay behind one error message. “MySQL server has gone away” is one of them. Most of the cases when the error occurs are described in MySQL documentation, but it can get tricky. And here, I’d like to...

Webinar October 14: Percona, AWS, & ScienceLogic – Converting DBaaS to a Fully Managed Solution

Database-as-a-service (DBaaS) can be thought of as a platform that can be used to manage an organization’s database environment(s). One of the most well known DBaaS platforms is Aurora powered by AWS. In this webinar, Ananias Tsalouchidis, Senior MySQL DBA at Percona,  will discuss how Percona can convert your DBaaS to a fully-managed solution ensuring...

5 Cool Features in Percona Monitoring and Management You Should Try!

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL databases, along with Load Balancing tools like ProxySQL. It is also ‘cloud ready’, meaning it has support for monitoring DBaaS (Amazon RDS, Aurora, and more). You can run PMM in your own environment for maximum security...

Webinar October 7: eBPFTrace – DTrace Replacement on Linux

Join Peter Zaitsev, Percona CEO, as he discusses eBPFTrace and DTrace on Linux. While eBPF was included in Linux kernel for quite a few years, it lacked a good “front end” to complete Dtrace functionality in the Linux ecosystem. In this presentation, Peter will look into eBPFTrace as a capable Dtrace replacement. He will also demonstrate how you can...

New MongoDB Exporter Released with Percona Monitoring and Management 2.10.0

With Percona Monitoring and Management (PMM) 2.10.0, Percona is releasing a new MongoDB exporter for Prometheus. It is a complete rewrite from scratch with a totally new approach to collect and expose metrics from MongoDB diagnostic commands. The MongoDB exporter in the 0.11.x branch exposes only a static list of handpicked metrics with custom names...

Using Security Definer to Monitor PostgreSQL 9.6 or Earlier Using Percona Monitoring and Management

I have previously written a blog post on the detailed steps involved in enabling PostgreSQL monitoring using PMM. In that post, you could see me talking about the role: pg_monitor that can be granted to monitoring users. The pg_monitor role restricts a monitoring user from accessing user data but only grants access to statistic views needed for monitoring....

MongoDB 101: 5 Configuration Options That Impact Security (And How to Set Them)

As with any database platform, MongoDB security is of paramount importance to keeping your data safe.  MongoDB and other data platforms like Redis and Elasticsearch are often in the news for data breaches because of misconfigured settings in the database.  So how do you keep you and your company’s data from being compromised and from becoming another...

MongoDB Backup Best Practices

Why Take Backups? Regular database backups are a crucial part of guarding against unintended data loss events. They are even more important for the restoration and continuation of business operations. In this blog, we will be discussing different backup strategies and their use cases along with Pros and Cons and a few other tips. Generally, there...

Grafana 7 Arrives with Percona Monitoring and Management 2.10.0

As you may know, Percona Monitoring and Management (PMM) is based on Grafana, and all our frontend applications are either Grafana plugins or dashboards. We’ve just released PMM version 2.10 and it includes a lot of improvements and new functionality. In this article, I would like to highlight some. They are quite important for users and developers...

Percona Customer Portal and Your New, Free User Account

Google, Microsoft, and Apple have it. So do open source organizations like MongoDB, Red Hat, and SUSE. What do all these companies provide? A customer portal that enables anyone to create an identity with the company. To date, Percona hasn’t had a customer portal with a free user account –  but that’s about to change. Starting with the 2.10.0 release...

Discover, share and read the best on the web

Subscribe to RSS Feeds, Blogs, Podcasts, Twitter searches, Facebook pages, even Email Newsletters! Get unfiltered news feeds or filter them to your liking.

Get Inoreader
Inoreader - Subscribe to RSS Feeds, Blogs, Podcasts, Twitter searches, Facebook pages, even Email Newsletters!