MySQL

MySQL 101: Linux Tuning for MySQL

Linux Tuning for MySQL

When trying to do some Linux tuning for MySQL, there are a few options that will greatly influence the speed of MySQL.  Below are some of the most important of these settings to help you get started.
Swappiness
The first thing to look at is what swappiness is set to.  This will determine the tendency of […]

Read more

ProxySQL Behavior in the Percona Kubernetes Operator for Percona XtraDB Cluster

ProxySQL Percona Kubernetes Operator

The Percona Kubernetes Operator for Percona XtraDB Cluster(PXC) comes with ProxySQL as part of the deal. And to be honest, the behavior of ProxySQL is pretty much the same as in a regular non-k8s deployment of it. So why bother to write a blog about it? Because what happens around ProxySQL in the context […]

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

Achieving Consistent Read and High Availability with Percona XtraDB Cluster 8.0

High Availability with Percona XtraDB Cluster 8.0

In real life, there are frequent cases where getting a running application to work correctly is strongly dependent on consistent write/read operations. This is no issue when using a single data node as a provider, but it becomes more concerning and challenging when adding additional nodes for high availability and/or read scaling. 
In the MySQL […]

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