Announcing TokuDB v6.5: Optimized for Flash
Semantic confusion follows me around. Like the harpies that tormented Phineus. Well, maybe not quite that bad. 😉
But I see in the news feed that TukoDB v6.5 has been optimized for Flash.
First thought: Why? Who would want a database optimized for Flash?
But they did not mean Flash, or one of the other seventy-five (75) meanings of Flash, but Flash.
I’m glad we had this conversation and cleared that up!
The “Flash” in this case refers to “flash memory.” And so this is an exciting announcement:
We are excited to announce TokuDB® v6.5, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB.
This version offers optimization for Flash as well as more hot schema change operations for improved agility.
We’ll be posting more details about the new features and performance, so here’s an overview of what’s in store.
- Flash
- TokuDB v6.5 continues the great Toku-tradition of fast insertions. On flash drives, we show an order-of-magnitude (9x) faster insertion rate than InnoDB. TokuDB’s standard compression works just as well on flash and helps you get the most out of your storage system. And TokuDB reduces wear on solid-state drives by more than an order of magnitude. The full technical details will be subject of a future blog post. In summary though, when TokuDB writes to disk, it updates many rows, whereas InnoDB may write a leaf to disk with a single modified row, in some circumstances. More changes per write means fewer writes, which makes the flash drive wear out much more slowly.
- More Hot Schema Changes
- TokuDB already has hot column addition, deletion and renaming. In this release we add hot column expansion, so you can change the size of the integers in a column or the number of characters in a field. These operations incurs no down time and the changes are immediately available on the table. In this release, we have also extended hot schema changes to partitioned tables.
Every disambiguation page at www.wikipedia.org, in every language, is testimony to a small part of the need for semantic disambiguation.
Did you know that as of today, there are 218,765 disambiguation pages in Wikipedia? Disambiguation Pages.
How many disambiguations could you use for an index at work, that don’t appear in Wikipedia?
You can stop at ten (10). Point made.