Tag - Percona Monitoring and Management

MySQL Query Performance Troubleshooting: Resource-Based Approach

MySQL Query Performance Troubleshooting

When I speak about MySQL performance troubleshooting (or frankly any other database), I tend to speak about four primary resources which typically end up being a bottleneck and limiting system performance: CPU, Memory, Disk, and Network.
It would be great if when seeing what resource is a bottleneck, we could also easily see what queries […]

Read more

Enable Email Sending in Percona Monitoring and Management 2

email sending percona monitoring and management

Many years ago I was banned from touching anything of critical importance as far as production infrastructure goes…something about “the leadership curse”, so the multiple layers of monitoring and notifications I once wrestled with were now overkill for my needs. What that means is that even though Percona Monitoring and Management (PMM) now integrates […]

Read more

Adding eBPF-Based Metrics to Percona Monitoring and Management

ebpf percona monitoring and management

I wanted to start this post with the words “eBPF is the hot new thing”, but I think it’s already too late to write that. Running eBPF programs in production is becoming less of a peculiarity and more of a normal way to operate. Famously, Facebook runs about 40 BPF programs on each server. […]

Read more

Preventing MySQL Error 1040: Too Many Connections

mysql error 1040

One of the most common errors encountered in the MySQL world at large is the infamous Error 1040:

Shell

ERROR 1040 (00000): Too many connections

1

ERROR 1040 (00000): Too many connections

What this means in practical terms is that a MySQL instance has reached its maximum allowable limit for client connections.  Until connections are closed, no new connection […]

Read more

Webinar July 14: How Percona Monitoring and Management Improves Database Security

Percona Monitoring and Management Improves Database Security

Data breaches seem to be a daily occurrence, so much so that seeing an article about the latest company to fall victim draws little attention outside of those immediately impacted. That is of course unless that company is yours and data security is your responsibility!
While companies continue to invest heavily in fortifying networks with […]

Read more