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 all DML operations on the server. This new redo log format […]
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 introduced by the Oracle MySQL team (and to […]
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 on it, we found out this version introduced a new compression […]
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 documentation). If you love your data, this feature should ONLY be used to speed up an […]
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 information On Monday, April 27, 2020, Oracle released the highly anticipated 8.0.20 version of the MySQL database server. This release contains changes to the InnoDB redo […]
Sep 06, 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 Server for MySQL. Then in April 2017, Vadim Tkachenko announced the availability […]
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 that we were unable to answer during the […]
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 a good idea to run through them now before we get into […]
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 (table/index) files to another location outside of the default MySQL datadir TokuDB uses […]
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, explains their purpose, shows their location and how to move them around. Peter Zaitsev blogged on the same topic […]
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 significantly on large data files. Using smaller node sizes makes the problem worse (which is one of […]
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 thought I would share some of my experience […]
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:
|
InnoDB: detected cycle in LRU for buffer pool 5, skipping to next buffer pool. InnoDB: detected cycle in LRU for buffer pool 3, skipping to next buffer pool. InnoDB: detected cycle in LRU for buffer pool 7, skipping to next buffer pool. |
Worry not as this is mostly harmless. It’s becoming a February tradition for me (Fernando) […]
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 for me to learn more about the communities, the […]
Sep 06, 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 dramatic performance improvements. Percona XtraBackup is open source, free MySQL hot backup software […]