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

Join the newsletter!


Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Tags open sourcedatabasesOraclesoftwareapplicationsPercona

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

Joab Jackson

IDG News Service
Show Comments

Brand Post

Most Popular Reviews

Latest Articles


PCW Evaluation Team

Tom Pope

Dynabook Portégé X30L-G

Ultimately this laptop has achieved everything I would hope for in a laptop for work, while fitting that into a form factor and weight that is remarkable.

Tom Sellers


This smart laptop was enjoyable to use and great to work on – creating content was super simple.

Lolita Wang


It really doesn’t get more “gaming laptop” than this.

Jack Jeffries


As the Maserati or BMW of laptops, it would fit perfectly in the hands of a professional needing firepower under the hood, sophistication and class on the surface, and gaming prowess (sports mode if you will) in between.

Taylor Carr


The MSI PS63 is an amazing laptop and I would definitely consider buying one in the future.

Christopher Low

Brother RJ-4230B

This small mobile printer is exactly what I need for invoicing and other jobs such as sending fellow tradesman details or step-by-step instructions that I can easily print off from my phone or the Web.

Featured Content

Product Launch Showcase

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?