Over a million developers have joined DZone.

A Performance Comparison of LevelDB and MySQL

· Database Zone

Build fast, scale big with MongoDB Atlas, a hosted service for the leading NoSQL database. Try it now! Brought to you in partnership with MongoDB.

In January, Google released LevelDB, "a fast and lightweight key/value database library."  In a recent post on the "High Availability MySQL" blog has generated a discussion around the possibility of LevelDB being a storage engine for MySQL due to its performance benefits.  The discussion generated some insight LevelDB's comparative performance to MySQL.  

The LevelDB site provides some insight into these performance benefits.  When creating a brand new database, various methods shows a range of speeds from .4 MB/s to 62.7 MB/s in Write performance.  In Read performance, LevelDB ranged from 152 MB/s to 232 MB/s.  You can see a more detailed explanation of these benchmarks by checking out the LewisDB site here.  

The "High Availability MySQL" blog also suggests that LevelDB may be a "great fit" for MongoDB because it does not require multi-statement transactions.  Commenters pointed out a few more details about LevelDB that may limit its performance:

Unfortunately, there is a trade off between number of SST files and query latency variation: the larger single storage file is - the more time will require to compact it -- Vladmir Rodionov

A recent GitHub post also compared MySQL and LevelDB.  For sequential insert performance, LevelDB was found to get higher throughput/lower latency overall, although MySQL was more stable.

For both average latency and update performance, MySQL and LevelDB performed essentially the same.

Have you had a chance to use LevelDB? How does it compare to other libraries?  Please post your comments below.  

Now it's easier than ever to get started with MongoDB, the database that allows startups and enterprises alike to rapidly build planet-scale apps. Introducing MongoDB Atlas, the official hosted service for the database on AWS. Try it now! Brought to you in partnership with MongoDB.


Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}