Yearly Archives - 2019

Connect to MySQL after hitting ERROR 1040: Too many connections

ERROR 1040

ERROR 1040…again
A pretty common topic in Support tickets is the rather infamous error: ERROR 1040: Too many connections. The issue is pretty self-explanatory: your application/users are trying to create more connections than the server allows, or in other words, the current number of connections exceeds the value of the max_connections variable.
This situation on its […]

Read more

PMM for MongoDB: Quick Start Guide

PMM for MongoDB

As a Solutions Engineer at Percona, one of my responsibilities is to support our customer-facing roles such as the sales and customer success teams, which affords me the opportunity to speak to many current and new customers who partner with Percona. I often find that many people are interested in Percona Monitoring and Management […]

Read more

Percona Monitoring and Management (PMM) 2 Beta 4 Is Now Available

Percona Monitoring and Management

We are pleased to announce our 4th Beta release of PMM 2! PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. With this release we’ve made the following improvements since our last public Beta at the end of May:

Query Analytics

PostgreSQL – Aggregate & […]

Read more

Upcoming Webinar 7/23: 10 Common Mistakes Java Developers Make when Writing SQL

Mistakes Java Developers Make when Writing SQL

Please join Percona’s Senior Support Engineer Charly Batista as he presents “10 Common Mistakes (Java) Developers Make when Writing SQL” on Tuesday, July 23rd, 2019 at 8:00 AM EDT (UTC-4).
Register Now
It’s easy for Java developers (and users of other OO languages) to mix object-oriented thinking and imperative thinking. But when it comes to writing […]

Read more

MySQL: Disk Space Exhaustion for Implicit Temporary Tables

Implicit Temporary Tables

I was recently faced with a real issue about completely exhausting the disk space on MySQL. This was a serious issue because of the continuous outages of the service, as the customer had to constantly restart the server and wait for the next outage.
What was happening? In this article, I’m going to explain it […]

Read more

Assessing MySQL Performance Amongst AWS Options – Part One

MySQL Performance on AWS

With such a wide range of options available for running MySQL based servers in Amazon cloud environments, how do you choose? There’s no doubt it’s a challenge. In this two-part series of blog posts, we’ll try to draw a fair and informative comparison based on well-established benchmark scenarios – at scale.
In part one we […]

Read more

Upcoming Webinar 7/18: Learn how to connect a MySQL database with Java

connect a MySQL database with Java

Please join Percona’s Service Delivery Manager Rodrigo Trindade as he presents “Troubleshooting Java Connections to MySQL” on Thursday, July 18th, 2019 at 10:00 AM PDT (UTC-7).
Register Now
This talk will explain the steps needed to make a connection from Java to MySQL work and highlight potential issues you might encounter. It will cover all components, […]

Read more