Percona curbs MySQL memory hunger

Percona's enhanced MySQL MEMORY storage engine can accept any data type, paving the way for use of more efficient data types

Percona has updated its version of MySQL so that the software's storage engine consumes less working memory, potentially increasing its suitability for tasks requiring an in-memory database, the company announced Friday.

The in-memory storage engine of Percona Server 5.5.15 now can hold all MySQL data types, including the previously unsupported BLOB and TEXT data types, which could also broaden its appeal to large-scale Web services companies.

If a deployment "has very small memory tables, [this version] may save a few megabytes of memory. It's no big deal. But if you are using tens or hundreds of gigabytes of data in memory, that is where you will find that our changes have an advantage," said Percona founder and CEO Peter Zaitsev.

Founded in 2006, Percona bills itself as the largest and oldest independent MySQL services vendor outside of Oracle. Internet-facing companies such as GroupOn, RightNow, Answer.Com, 37Signals and the British Broadcasting Corporation have availed themselves of Percona's services. Percona Server is an open source version of MySQL with a number of enhancements for production use. Percona sells support for the server.

For this release, the company modified the MySQL MEMORY storage engine, which was designed to store database tables in a server's working memory, eliminating the need to write each change to a disk, which can slow transaction speeds. For jobs such as hosting a website, MySQL Memory can significantly speed response times.

A number of limitations have hobbled the basic version of MySQL MEMORY, Zaitsev said. Most notably, MEMORY (formerly known as HEAP) can work only with a subset of data types allowable in MySQL, notably only those with fixed lengths.

With fixed-length data types, each entry to the database will be stored in an identically sized storage block. Because most entries won't use all the space in their storage blocks, this approach is inherently inefficient, due to all empty space it creates. "For many problems, you have to store strings of different lengths," Zaitsev said.

On disk drives, where space is relatively cheap, this waste is not a huge deal. On the more expensive RAM, however, such waste is costly.

Percona Server 5.5.15, which is based on MySQL 5.5.15, comes with an enhanced version of MySQL MEMORY that can work with any MySQL data type, including variable-length data types such as BLOB and TEXT.

EBay principal developer Igor Chernyshev first developed this technology in 2008, in order to improve memory usage for that company's services. His version allowed entries encoded in the VARCHAR data type to be stored at their natural lengths, rather than at a larger fixed length. Percona then added support for the TEXT and BLOB data types, both of which can be used to store large strings of text.

How much memory this version will save will vary greatly from one implementation to another, Zaitsev said. It could cut as much memory requirements by as much half or even more, on the data types formerly used. It also opens the use of in-memory databases to organizations that only use variable-length data types before, and were not willing to convert the data to a fixed-length data type.

In-memory databases are growing increasingly popular as more organizations set up Web-facing or real-time systems, which need to be as responsive as possible. Oracle's TimesTen, SAP's HANA database and VoltDB all serve this market as well.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is Joab_Jackson@idg.com

Join the Good Gear Guide newsletter!

Error: Please check your email address.

Tags open sourceapplicationsdatabasesPerconasoftwareOracle

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Joab Jackson

IDG News Service

Most Popular Reviews

Follow Us

Best Deals on GoodGearGuide

Shopping.com

Latest News Articles

Resources

GGG Evaluation Team

Kathy Cassidy

STYLISTIC Q702

First impression on unpacking the Q702 test unit was the solid feel and clean, minimalist styling.

Anthony Grifoni

STYLISTIC Q572

For work use, Microsoft Word and Excel programs pre-installed on the device are adequate for preparing short documents.

Steph Mundell

LIFEBOOK UH574

The Fujitsu LifeBook UH574 allowed for great mobility without being obnoxiously heavy or clunky. Its twelve hours of battery life did not disappoint.

Andrew Mitsi

STYLISTIC Q702

The screen was particularly good. It is bright and visible from most angles, however heat is an issue, particularly around the Windows button on the front, and on the back where the battery housing is located.

Simon Harriott

STYLISTIC Q702

My first impression after unboxing the Q702 is that it is a nice looking unit. Styling is somewhat minimalist but very effective. The tablet part, once detached, has a nice weight, and no buttons or switches are located in awkward or intrusive positions.

Latest Jobs

Shopping.com

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?