Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

A Performance Comparison of LevelDB and MySQL

DZone's Guide to

A Performance Comparison of LevelDB and MySQL

· Database Zone ·
Free Resource

RavenDB vs MongoDB: Which is Better? This White Paper compares the two leading NoSQL Document Databases on 9 features to find out which is the best solution for your next project.  

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.  

Get comfortable using NoSQL in a free, self-directed learning course provided by RavenDB. Learn to create fully-functional real-world programs on NoSQL Databases. Register today.

Topics:

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}