by Satya Bodapati | Jul 25, 2023 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
In this blog post, we will describe the improvements to Percona XtraBackup 8.0.33-28 (PXB), which significantly reduces the time to prepare the backups before the restore operation. This improvement in Percona XtraBackup significantly reduces the time required for a... by Satya Bodapati | Jul 19, 2022 | Insight for DBAs, MySQL, Percona Software
Oracle’s MySQL 8.0.29 release extended the support for ALTER TABLE … ALGORITHM=INSTANT to 1) allow users to instantly add columns in any position of the table, and 2) instantly drop columns. As part of this work, the InnoDB redo log format has changed for... by Satya Bodapati | Oct 23, 2020 | Insight for DBAs, MySQL, Percona Software
Earlier this week, Oracle released their Q4 releases series. As on the previous releases, backward compatibility has been broken with previous versions of the server. This time on both MySQL 5.7 and 8.0: MySQL 5.7.32 While our QA team was performing an extensive test... by Satya Bodapati | Jun 27, 2019 | MySQL
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... by Satya Bodapati | May 8, 2019 | Insight for Developers, MySQL, Percona Software
It’s not essential to understand how MySQL® and Percona Server for MySQL build indexes. However, if you have an understanding of the processing, it could help when you want to reserve an appropriate amount of space for data inserts. From MySQL 5.7,...