by George O. Lorch III | 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 George O. Lorch III | May 20, 2021 | MySQL, Percona Software
Percona Server for MySQL 8.0.23-14 was released last week and I wanted to take a minute to call out some of the interesting new features that we have introduced in this release. These are included in addition to the features and improvements in MySQL 8.0.23 that were... by George O. Lorch III | 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 George O. Lorch III | Jul 21, 2020 | MySQL, Percona Software
On Monday, July 13, 2020, Oracle released MySQL 8.0.21. This release contained a few new changes that cause issues with Percona XtraBackup.First, this release introduced the ability to temporarily disable InnoDB redo logging (see the work log and... by George O. Lorch III | Apr 28, 2020 | MySQL, Percona Software
Update: Percona XtraBackup 8.0.12 now supports backup and restore processing for versions of MySQL 8.x; previous versions of Percona XtraBackup will not work with MySQL 8.0.20 and higher. More informationOn Monday, April 27, 2020, Oracle released the highly... by George O. Lorch III | Sep 6, 2017 | MySQL, Percona Events, Storage Engine
Percona, in collaboration with Facebook, is proud to announce the first experimental release of MyRocks in Percona Server for MySQL 5.7, with packages.Back in October of 2016, Peter Zaitsev announced that we were going to port MyRocks from Facebook MySQL to Percona... by George O. Lorch III | Apr 13, 2017 | MySQL, Webinars
In this blog, we will provide answers to the Q & A for the TokuDB Troubleshooting webinar.First, we want to thank everybody for attending the March 22, 2017 webinar. The recording and slides for the webinar are available here. Below is the list of your questions... by George O. Lorch III | Oct 28, 2016 | MySQL
This blog post discusses a new TokuDB and PerconaFT database file management feature in two Percona Server releases.By now you have hopefully read through Peter’s post and my two prior posts on the TokuDB/PerconaFT file set. If you have not, it is probably... by George O. Lorch III | Oct 24, 2016 | MySQL
This is the second installment of the blog series on TokuDB and PerconaFT data files. You can find my previous post here. In this post we will discuss some common file maintenance operations and how to safely execute these operations.Moving TokuDB data... by George O. Lorch III | Sep 27, 2016 | MySQL
In this blog post, we’ll look at TokuDB and PerconaFT database file management.The TokuDB/PerconaFT file set consists of many different files that all serve various purposes. These blog posts lists the different types of TokuDB and PerconaFT files,... by George O. Lorch III | Aug 17, 2016 | MySQL
In this blog post, we’ll discuss how we’ve improved TokuDB and PerconaFT fragmented data file performance.Through our internal benchmarking and some user reports, we have found that with long term heavy write use TokuDB/PerconaFT performance can degrade... by George O. Lorch III | Mar 18, 2015 | Insight for DBAs, MySQL, Percona Live
So you want to contribute to OpenStack? I can help!For the last year or so I have been involved with OpenStack and more specifically the Trove (DBaaS) project as sort of an ambassador for Percona, contributing bits of knowledge, help and debugging wherever I could and... by George O. Lorch III | Feb 26, 2015 | Insight for DBAs, MySQL
If you use Percona Server 5.5 and you have configured it to use multiple buffer pool instances than sooner or later you’ll see the following lines on the server’s error log and chances are you’ll be worried about them: Shell InnoDB: detected cycle in... by George O. Lorch III | Aug 28, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
I just returned from a week in Cambridge, Massachusetts where I was attending the OpenStack Trove Day and the Trove mid-cycle meetup, both sponsored by the great folks at Tesora.I am relatively new to the OpenStack and Trove arenas so this was a fantastic opportunity... by George O. Lorch III | Sep 6, 2013 | Percona Software, Webinars
Percona XtraBackup 2.1 has been in GA now for a little over four months and has some impressive new features to improve backup performance, security, and storage requirements. When used with Percona Server, additional features are enabled that can provide even more...