by Zardosht.Kasheff | Jun 22, 2010 | MySQL
The analysis that shows how to make deletions really fast by using clustering keys and TokuDB’s fractal tree based engine also applies to make updates really fast. (I left it out of the last post to keep the story simple). As a quick example, let’s look at...
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 18, 2010 | MySQL
OpenSQL Camp Boston 2010 will be held at the Stata Center in Cambridge, Massachusetts, October 15-17, 2010. The Stata Center was designed by Frank Gehry and was completed in 2005. The Stata Center houses CSAIL (The MIT Computer Science and Artifical Intelligence...
by Maciej Dobrzanski | May 17, 2010 | Insight for Developers, MySQL
The problem I am going to describe is likely to be around since the very beginning of MySQL, however unless you carefully analyse and profile your queries, it might easily go unnoticed. I used it as one of the examples in our talk given at phpDay.it conference last...
by kuszmaul | May 11, 2010 | MySQL
I just spotted the youtube video of my OpenSQL Camp (Portland 2009) talk on An Open Storage Engine API. I talked about some of technical issues for implementing storage engines across many SQL front ends, not just MySQL. You can find this talk and other mostly...
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 Maciej Dobrzanski | Apr 14, 2010 | MySQL, Percona Events
While the majority of Percona gang travelled to California for the MySQL event of the year, I headed in the opposite direction to Moscow for RIT++ 2010 conference where I presented a talk on Sphinx. You can get the PDF file here – Improving MySQL-based...
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 Morgan Tocker | Jan 22, 2010 | MySQL, Percona Events
February and March as busy months for Community events. There’s MySQL University, Fosdem, the Seattle MySQL Meetup & Confoo.ca. Here are the details: February 4th – I’ll be presenting a talk via MySQL University on Optimizing Queries with...
by Morgan Tocker | Jan 21, 2010 | Insight for Developers, MySQL
A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing data and just storing it inside TEXT/BLOB columns. It seems that since then, the technique has gotten more popular with Ruby gems now around to do...
by Morgan Tocker | Jan 9, 2010 | Insight for Developers, MySQL
There was a discussion on LinkedIn one month ago that caught my eye: Database search by “within x number of miles” radius? Anyone out there created a zipcode database and created a “search within x numer of miles” function ? Thankful for any...
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...
