In my previous blog post, I explained the internals of the sorted index build process. The blog ended with saying “there is one disadvantage.”
Beginning in MySQL 5.6, many DDLs including ALTER TABLE ADD INDEX became “ONLINE”. Meaning, when the ALTER is in progress, there can be concurrent SELECTS and DMLs. See the MySQL documentation […]
Please join Percona’s Principal Support Engineer Marcos Albe as he presents “Beyond Relational Databases: A Look Into MongoDB, Redis, and ClickHouse” on Thursday, June 27th, 2019 at 12:00 PM PDT (UTC-7).
Register Now
We all use and love relational databases… until we use them for purposes for which they are not a good fit: queues, caches, […]
Percona is glad to announce the release of Percona XtraDB Cluster 5.7.26-31.37 on June 26, 2019. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.7.26-31.37 is now the current release, based on the following:
Percona Server for MySQL 5.7.26-29
Codership WSREP API release 5.7.25
Codership Galera library 3.26
All Percona software is open-source and […]
Read more
In this blog post, I am going to show why we have to be careful with stored functions in select list, as a single query can cause thousands of queries in the background if we aren’t cautious.
For this example, I am only going to use the SLEEP function to demonstrate the issue, but you […]
The Call for Papers for Percona Live Europe 2019 is now open! This year’s conference will be held September 30 – October 2, 2019 in Amsterdam, the Netherlands.
Percona Live is the one conference for the entire open source database community, especially for MySQL, PostgreSQL, MongoDB, and MariaDB. The theme of the 2019 conference is […]
Please join Percona’s Senior Support Engineer Adamo Tonete as he presents “MongoDB Data Security – Custom Rules and Views” on Wednesday, June 26th, 2019 at 11:00 AM PDT (UTC-7).
Register Now
In this presentation, we will discuss how to create custom rules when the default rules are not enough for the application. Have you ever needed […]
Recently I had a case where queries against Aurora Reader were 2-3 times slower than on the Writer node. In this blog post, we are going to discuss why.
I am not going to go into the details of how Aurora works, as there are
In my previous blog post “Percona’s View on MongoDB’s 4.2 Release – The Good, the Bad, and the Ugly…” I discussed the release of transaction support in sharded clusters, field-level encryption, search-engine integration, and the new update command syntaxes.
Those are all very important, but to me making MongoDB easier to use and removing technical […]
I receive many questions about errors being reported about pt-kill… and often those errors are not real. The main problem I have found is that pt-kill is hard to understand and the documentation doesn’t have many examples (I’ll add them), so, I decided to write a post about the most common usage of pt-kill: […]
Read more
Introduction
Those DBAs who are experts in one database system look for other database systems to have “similar features”. It is a human tendency to look at any new technology and compare it with a world they are familiar with. Most of the time, I keep addressing Oracle DBAs who are looking for similar features […]
