InnoDB ALTER TABLE ADD INDEX and INSERT performance

InnoDB ALTER TABLE ADD INDEX

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 […]

Read more

Upcoming Webinar 6/27: Beyond Relational Databases – A Look Into MongoDB, Redis, and ClickHouse

relational databases

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, […]

Read more

Percona XtraDB Cluster 5.7.26-31.37 Is Now Available

Percona XtraDB Cluster 5.7

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

Percona Live Europe 2019 Call for Papers is Now Open!

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 […]

Read more

Upcoming Webinar 6/26: MongoDB Data Security – Custom Rules and Views

MongoDB Data Security

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 […]

Read more

Diving into the MongoDB 4.2 Release Small Print

MongoDB 4.2

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 […]

Read more

pt-kill: How it Works

pt-kill MySQL

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