Here are the slides and video for my MySQL UC ignite talk on measuring the performance of SSDs.
You can find this talk and other mostly technical material at http://tokutek.com/technology/.
This research was funded in part by the National Science Foundation.
I recently discovered that there’s a youtube video of the talk I gave at OpenSQL Camp in Portland in 2009.
This is a whiteboard presentation and is less well developed than the talk I gave a the MySQL conference (I posted those slides two days ago. But since it includes audio it may be easier to understand.
This talk presents the data structure underlying the TokuDB storage engine for MySQL.
Here’s the talk I presented at the MySQL User Conference. This talk is a fairly technical talk on how fractal trees work.
You can find this talk and other mostly technical material at http://tokutek.com/technology/.
I (Bradley C. Kuszmaul) am presenting two talks at the MySQL User Conference.
The first talk is a 5-minute talk at tonight’s Ignite MySQL session organized by Brian Aker. I’ll present some performance measurements on the Intel X25E SSD. The bottom line is that although I can get the 3,300 random 4KB writes per second, as the spec sheet advertises, I cannot seem to get more than about 11,000 reads per second, although the spec sheet says I should get 35,000.
My second talk is tomorrow (Thursday) at 10:50am, where I’ll talk about Fractal Trees. I’ll explain how Fractal Trees work, and show why they can get one to two orders of magnitude speedup on insertions compared to B-tree indexes. The talk is about data structures and algorithms, but I think it should be easy for everyone to understand. If you want to know why Fractal …
[Read more]Fast insertion – what Tokutek excels at – isn’t only important for handling high data rates. It also enables a new way to extract value from an existing database called ad hoc indexing. KAYAK has a billion rows stored in TokuDB and adding an index for a traditional MySQL storage engine would take too long to be of any practical value. With TokuDB, however, an index can be created on the fly to accelerate any ad hoc query that would otherwise be causing a vastly slower full table scan.
Here are the details.
At this year’s O’Reilly MySQL Conference we will be showing the latest version of our MySQL storage engine, TokuDB v3.1.
Come visit us at Table T1 in the OEM section of the Exhibit Hall.
We will be talking about how TokuDB can dramatically improve performance for:
Customers pick TokuDB for:
The Tokutek/Sunfish entry into the next America’s Cup promises to bring the America’s cup back to the USA’s east coast. The sailboat, named '; Update Race set time=1 where Team='Tokutek (we’re trying to win using a SQL injection attack) features a single-hull pontoon-type hull carrying a lateen sail mounted to an un-stayed mast. The fiberglass hull carries a crew of one or two. The double-plus secret keel technology features a daggerboard keel, an overall length of 4.22m, a beam of 1.24m, and a hull weight of 59kg. The 6.0m2 mainsail provides a D-PN of 100.7, and an on-board computer comprising an Android in a zip-lock sandwich bag running MySQL with TokuDB.
April 1, 2010, Totutek, Inc., announced the acquisition of Oracle Corporation. “Tokutek has long been a supporter of open-source software” said John Partridge, CEO of Tokutek. “Oracle is an innovative small company the develops database front ends such as MySQL. Tokutek intends to continue developing the MySQL technology and expand our commitment to open-soure software.” Oracle CEO Larry Ellison’s role has not been determined. Other than a statement that the transaction is an all-stock transaction, terms of the transaction were not disclosed.
Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 3.1. It is designed for continuous querying and analysis of large volumes of rapidly arriving and changing data, while maintaining full ACID properties.
TokuDB v3.1’s new functionality includes:
This new release builds on TokuDB’s core benefits:
Matt Aslett over at The 451 Group has written a Market Development report entitled “Tokutek delivers ACID transaction support with TokuDB version 3.0.” Get the full report and you can try out The 451 Group’s services for free by visiting http://the451group.com/apply/apply.php.
Matt observes that, “While TokuDB is effectively an operational database technology, it does blur the lines between operations and analytics”. We agree with that perspective and that blurred line is particularly relevant to the community of advanced web application developers who built on MySQL.
Ian Eure over at Digg articulated the issue well: “The fundamental problem is endemic to the …
[Read more]