Percona's MySQL & InnoDB performance and scalability blog
91k followers 9 artículos/semana
MySQL 101: How to Find and Tune a Slow MySQL Query

This blog was originally published in June 2020 and was updated in April 2024.One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket.  While this can be caused by a multitude of factors, it is more often than not caused by a bad or slow MySQL […]

Wed Apr 17, 2024 21:28
Switch PostgreSQL Environments Across AWS, GCP, and k3d Using Kubernetes Contexts

This article explains how to install the Percona Distribution for PostgreSQL on Kubernetes using “context”. We will show you how to set up this distribution on Kubernetes clusters in AWS, Google Cloud, and locally with k3d. You’ll also learn how to switch between these setups to test them effectively.In Kubernetes, a context is a profile […]

Wed Apr 17, 2024 16:28
Percona Stands Firmly on the Side of Open Source

Percona is proud to formally state our support for the Valkey project and its community.  We will soon offer commercial support for the open source Redis alternative, Valkey.The world of open source is no stranger to controversy. From its earliest beginnings, the open source movement stirred many a debate and rustled more than its fair […]

Tue Apr 16, 2024 19:16
A Guide to Better Understanding MySQL Charset Levels

We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4. If you understand how the charset works on MySQL but have some questions regarding this change, please check out Migrating to utf8mb4: Things to Consider by Sveta Smirnova.Some of the questions […]

Tue Apr 16, 2024 16:49
Why SELECT COUNT(*) FROM TABLE Is Sometimes Very Slow in MySQL or MariaDB

If you have enough experience with MySQL, it is very possible that you stumbled upon an unusually slow SELECT COUNT(*) FROM TABLE; query execution, at least occasionally.Recently, I had a chance to investigate some of these cases closer, and it stunned me what huge differences there can be depending on the circumstance given the very […]

Mon Apr 15, 2024 16:14
Partially Rolling Back a Transaction in MySQL or PostgreSQL

This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to write an article on rolling back transactions to a particular point. I selected this topic because I found many people are not aware of this feature in databases.DescriptionEvery ACID-compliant RDBMS follows the “All or None”...

Fri Apr 12, 2024 16:36

Crea tu propio feed de noticias

¿Listo para probarlo?
Comienza una prueba de 14 días, no es necesaria tarjeta de crédito.

Crear cuenta