by Zardosht.Kasheff | Jun 18, 2010 | MySQL
Continuing in the theme from previous posts, I’d like to examine another case where we can eliminate all disk seeks from a MySQL operation and therefore get two orders-of-magnitude speedup. The general outline of these posts is: B-trees do insertion disk seeks....
by Zardosht.Kasheff | Jun 8, 2010 | MySQL
In my last post, I discussed how fractal tree data structures can be up to two orders of magnitude faster on deletions over B-trees. I focused on the deletions where the row entry is known (the storage engine API handler::delete_row), but I did not fully analyze how...
by Zardosht.Kasheff | Jun 2, 2010 | MySQL
As mentioned in parts 1 and 2, having many disk seeks are bad (they slow down performance). Fractal tree data structures minimize disk seeks on ad-hoc insertions, whereas B-trees practically guarantee that disk seeks are performed on ad-hoc insertions. As a result,...
by Zardosht.Kasheff | May 25, 2010 | MySQL
In part 1, I discussed why having many disk seeks are bad (they slow down performance), and how fractal tree data structures minimize disk seeks on ad-hoc insertions, whereas B-trees practically guarantee that disk seeks are performed on ad-hoc insertions. As a...
by kuszmaul | May 4, 2010 | MySQL
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 here. This research was funded in part by the National Science Foundation.
by kuszmaul | Apr 30, 2010 | MySQL
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...
by kuszmaul | Apr 28, 2010 | 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://www.tokutek.com/technology/.
by kuszmaul | Apr 14, 2010 | MySQL
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...
by John.Partridge | Apr 8, 2010 | MySQL
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...
by John.Partridge | Apr 7, 2010 | MySQL
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...
by John.Partridge | Mar 25, 2010 | MySQL
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...
by John.Partridge | Mar 5, 2010 | MySQL
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...
by John.Partridge | Mar 3, 2010 | MySQL
One of Profile Technology Ltd.’s most popular applications is their Advanced Search function for Facebook. Find out how TokuDB v3.0 dramatically increased their insertion speed performance in our new Case Study.
by Rich.Prohaska | Jan 5, 2010 | MySQL
We recently made transactions in TokuDB 3.0 durable. We write table changes into a log file so that in the event of a crash, the table changes up to the last checkpoint can be replayed. Durability requires the log file to be fsync’ed when a transaction is...
by Tokutek | Dec 16, 2009 | MySQL
Last week Tokutek released version 3.0.0 of TokuDB, adding ACID transactions to its list of features. This post discusses an experiment we ran to measure recovery time following a system crash. In summary, while actively inserting records into a MySQL database using...
by Zardosht.Kasheff | Nov 17, 2009 | MySQL
Last spring, we added a feature that allows the user to see the progress of writes in a statement. Vadim liked it. In 2.2.0, in “show processlist”, we add progress information on reads. Here is an example of what “show processlist” displays on...
by John.Partridge | Nov 16, 2009 | MySQL
KAYAK, the world’s leading travel search engine, is using TokuDB for MySQL to provide a more personalized user experience. Read all about it in today’s press release.
by kuszmaul | Nov 10, 2009 | MySQL
We just updated our web site and blogs. We hope the update didn’t cause any trouble for people trying to read the blogs or download TokuDB, our MySQL storage engine. In addition to a new look, we now provide pricing as well as easier downloads.
by John.Partridge | Oct 30, 2009 | MySQL
Tokutek is pleased to announce the general availability of TokuDB for MySQL, version 2.2.0. This version offers several improvements: Better multi-core load balancing for concurrent workloads. Faster bulk loading performance. Enhanced diagnostics for easier tuning and...
by Tokutek | Oct 16, 2009 | MySQL
At Tokutek, Rich Prohaska used Gearman to automate our nightly build and test process for TokuDB for MySQL. Rich is busy working on TokuDB, so I’m writing up an overview of the build and test architecture on his behalf. Build and Test Process Rich created a...
