DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Newsletter
Log In / Join
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Related

  • Database Bottlenecks Nobody Talks About: Optimizing SQL Queries Beyond Indexing
  • LangChain With SQL Databases: Natural Language to SQL Queries
  • Stop Writing Dialect-Specific SQL: A Unified Query Builder for Node.js
  • Custom Model Context Protocol (MCP) for NL2SQL: A Rigorous Evaluation Framework on Oracle Database

Trending

  • When RabbitMQ Accepts a Message but Does Not Route It to a Queue
  • To Switch, or Not to Switch the AI Model
  • Treat Salesforce Configuration Like Code: Release Discipline in a Copado Pipeline
  • Kill the Worker, Keep the Research: Build a Recoverable LangGraph Agent on Temporal

Draft This article hasn't been published, so readers can't see it.

In moderation This article is waiting for review, so readers can't see it yet.

Deleted This article has been deleted, so readers can't see it.

  1. DZone
  2. Data Engineering
  3. Databases
  4. A Performance Comparison of LevelDB and MySQL

A Performance Comparison of LevelDB and MySQL

By 
Eric Genesky
·
Feb. 14, 12 · Interview
Post on X (opens in a new tab) Share on LinkedIn (opens in a new tab)
15.7K Views

Join the DZone community Save articles, join the discussion, and download Refcards and Trend Reports with a free account.

Join for free Already a member? Log in

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.  

LevelDB MySQL Comparison (grammar)

Opinions expressed by DZone contributors are their own.

Related

  • Database Bottlenecks Nobody Talks About: Optimizing SQL Queries Beyond Indexing
  • LangChain With SQL Databases: Natural Language to SQL Queries
  • Stop Writing Dialect-Specific SQL: A Unified Query Builder for Node.js
  • Custom Model Context Protocol (MCP) for NL2SQL: A Rigorous Evaluation Framework on Oracle Database

Partner Resources

×

Comments

Loading comments

The comments didn't load

Please try again in a moment.

Likes

Loading

The next likes didn't load. Please try again.

The likes didn't load

Please try again in a moment.

See who liked this

Log in or join DZone for free to see who liked this article.

Log in Join for free
  • RSS
  • X
  • Facebook

ABOUT US

  • About DZone
  • Support and feedback
  • Community research

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 215
  • Nashville, TN 37211
  • [email protected]

Let's be friends:

  • RSS
  • X
  • Facebook