Author - George O. Lorch III

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