Fri, 16 Feb 2024 23:52:36 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/20x-faster-backup-preparation-with-percona-xtrabackup-8-0-33-28/ https://www.percona.com/blog/20x-faster-backup-preparation-with-percona-xtrabackup-8-0-33-28/#comments Tue, 25 Jul 2023 14:05:07 +0000 https://www.percona.com/blog/?p=89529 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 new node to join the Percona XtraDB Cluster (PXC).Percona XtraDB Cluster uses Percona XtraBackup to do […]]]> https://www.percona.com/blog/20x-faster-backup-preparation-with-percona-xtrabackup-8-0-33-28/feed/ 4 89529 https://www.percona.com/blog/percona-xtrabackup-8-0-29-and-instant-add-drop-columns/ https://www.percona.com/blog/percona-xtrabackup-8-0-29-and-instant-add-drop-columns/#comments Tue, 19 Jul 2022 12:53:05 +0000 https://www.percona.com/blog/?p=81836 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 all DML operations on the server. This new redo log format […]]]> https://www.percona.com/blog/percona-xtrabackup-8-0-29-and-instant-add-drop-columns/feed/ 19 81836 https://www.percona.com/blog/mysql-new-releases-and-percona-xtrabackup-incompatibilities/ https://www.percona.com/blog/mysql-new-releases-and-percona-xtrabackup-incompatibilities/#comments Fri, 23 Oct 2020 15:43:24 +0000 https://www.percona.com/blog/?p=72177 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.32While our QA team was performing an extensive test on it,  we found out this version introduced a new compression format version. […]]]> https://www.percona.com/blog/mysql-new-releases-and-percona-xtrabackup-incompatibilities/feed/ 9 72177 https://www.percona.com/blog/innodb-alter-table-add-index-and-insert-performance/ Thu, 27 Jun 2019 13:20:32 +0000 https://www.percona.com/blog/?p=57347 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 for […]]]> 57347 https://www.percona.com/blog/mysql-innodb-sorted-index-builds/ https://www.percona.com/blog/mysql-innodb-sorted-index-builds/#comments Wed, 08 May 2019 12:21:46 +0000 https://www.percona.com/blog/?p=56485 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, developers changed the way they built secondary indexes for InnoDB, applying a bottom-up […]]]> https://www.percona.com/blog/mysql-innodb-sorted-index-builds/feed/ 2 56485