Insight for DBAs

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

Analyzing MySQL with strace

Analyzing MySQL with strace

In this blog post, we will briefly explore the OS tool strace. It is not widely used due to its performance impacts, and we don’t recommend using it in production. Still, it is amazing at helping you understand some things that happen in MySQL, where the OS is involved, and as a last case […]

Read more

MySQL 101: Parameters to Tune for MySQL Performance

Parameters to Tune for MySQL Performance

While there is no magic bullet for MySQL tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I wanted to break down some of the more critical settings that […]

Read more

Percona Server for MySQL Highlights – Extended Slow Query Logging

mysql extended slow query logging

Last year, I made the first post in a small series, which aimed to highlight unique features of Percona Server for MySQL, by discussing binlog_space_limit option.
Today, I am going to discuss another important type of log available in MySQL that is enhanced in Percona Server for MySQL – the slow query log. The reason […]

Read more

Are You The Next Great Percona TAM?

Percona TAM

In 2006, a small company formed, specializing in MySQL database consulting at a time when very few companies had fully embraced open source. This small company quickly grew, riding the wave of open source adoption within the greater enterprise market and became the Percona we know and love today.
My first awareness of Percona came […]

Read more