Author - George O. Lorch III

MyRocks Experimental Now Available with Percona Server for MySQL 5.7.19-17

MyRocks with Percona Server for MySQL

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

Read more

TokuDB Troubleshooting: Q & A

TokuDB

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

Read more

New TokuDB and PerconaFT database file management feature in Percona Server 5.6.33-79.0 and Percona Server 5.7.15-9

MariaDB ColumnStore

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

Read more

TokuDB and PerconaFT Data Files: Database File Management Part 2 of 2

TokuDB

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

Read more

TokuDB and PerconaFT database file management part 1 of 2

TokuDB

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

Read more

TokuDB/PerconaFT fragmented data file performance improvements

fragmented data file performance

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

Read more

Getting started guide for OpenStack contributors

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

Read more

Worrying about the ‘InnoDB: detected cycle in LRU for buffer pool (…)’ message?

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 LRU for buffer pool 5, skipping to next buffer pool.
InnoDB: detected cycle […]

Read more

OpenStack Trove Day 2014 Recap: MySQL and DBaaS

OpenStack Trove Day
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 […]

Read more

Introduction to Percona XtraBackup 2.1 (MySQL webinar & more)

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

Read more