Percona Lifts Decade-Old Limitation from MySQL with New Release of Percona Server

Share Article

Latest Release of Percona Server 5.5 Dramatically Improves MySQL In-Memory Data Storage

Percona Inc. Logo

Percona Inc.

Percona, Inc., the largest and oldest independent MySQL services vendor, today announced the release of Percona Server version 5.5.15. The new release enables users to save memory and allows them to simultaneously hold more types of data (such as large BLOB and TEXT types) in memory by removing the fixed-length limitation on the MySQL MEMORY storage engine. The new release is based on improvements designed for the world’s largest online auction company.

Highlights

  •     Use of the MySQL MEMORY storage engine is popular for data that does not need to be stored permanently. The MEMORY storage engine provides a higher-performance alternative to disk storage, because memory is much faster than disk. Example uses include website sessions and temporary tables for processing queries in several steps. However, the MEMORY storage engine included in all current and historical versions of MySQL is limited to fixed-length data types. This causes it to waste space and prevents some types of data (such as large BLOB and TEXT types) from being used at all.
  •     Percona Server 5.5.15, based on MySQL 5.5.15, includes an enhanced version of the MEMORY storage engine that the server uses to store and process data without writing it to disk. The new release removes the fixed-length limitation with improvements designed for the world's largest online auction company, eBay.
  •     Percona Server users can now store any data type in memory-based tables. This change removes the requirement of padding memory to its maximum potential length. Percona Server 5.5.15 also now permits BLOB and TEXT columns to be created in a MEMORY table.
  •     A fork of MySQL, Percona Server includes fixes for known limitations sooner than the MySQL release schedule allows, resulting in faster, more reliable performance for critical MySQL deployments.

Quotes

Baron Schwartz, Chief Performance Architect for Percona, Inc.
“Percona is focused on improving MySQL performance for users worldwide. The new release of Percona Server 5.5 meets the demand of MySQL users to optimize memory storage usage and expand the types of data that can be stored in memory such as large BLOB and TEXT types. These types of cutting edge improvements to the MySQL platform in Percona Server, which is used by many of the largest and most demanding MySQL users in the world, have resulted in more than 250,000 downloads since the initial release of Percona Server in 2008.”

About Percona, Inc.

Percona Inc. is the largest and oldest independent MySQL services vendor with over 1,000 customers worldwide since 2006. Percona provides enterprise-grade MySQL support, consulting, training, and engineering services to companies such as Cisco Systems, Alcatel-Lucent, Groupon, and the BBC. Percona's founders authored the definitive book High Performance MySQL from O'Reilly Press and the widely read MySQL Performance Blog. Percona also develops software for MySQL users, including Percona Server and Percona XtraBackup, the only open source, hot backup utility for the InnoDB storage engine. The popular Percona Live conferences draw attendees and acclaimed speakers from around the world. For more information, visit http://www.percona.com.

###

Percona(R) and XtraBackup(R) are registered trademarks of Percona, Inc. All other registered and unregistered trademarks in this document are the sole property of their respective owners.

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Terry Erisman
Visit website