Buy Percona ServicesBuy Now!

Tradeoff: Insertions versus Point Queries

 | March 11, 2008 |  Posted In: Tokutek, TokuView

I’ve been waving my hands about lower bounds. Well, sometimes I haven’t been waving my hands, because the lower bounds are tight. But in other cases (lenient insertions, range queries), the lower bounds are very far from what we’re used to. So now, for a bit of math: Brodal and Fagerberg showed in 2003 that […]

Read More

Tradeoffs: Updates versus Range Queries

 | March 4, 2008 |  Posted In: Tokutek, TokuView

Sorry for the delay, now on to range queries and lenient updates. Let’s call them queries and updates, for short. So far, I’ve shown that B-trees (and any of a number of other data structures) are very far from the “tight bound.” I’ll say a bound is a tight if it’s a lower bound and […]

Read More

How Fast Can Updates Run?

 | February 11, 2008 |  Posted In: Tokutek, TokuView

Last time, I introduced the notion of strict and lenient updates. Now it’s time to see what the performance characteristics are of each. Just to rehash, we are focusing on the storage engine (a la MySQL) level, and we are looking at a database on a single disk — the one we are using for […]

Read More

Updates & Discipline

 | February 5, 2008 |  Posted In: Tokutek, TokuView

So far, I’ve analyzed point and range queries. Now it’s time to talk about insertions and deletions. We’ll call the combination updates. Updates come in two flavors, and today we’ll cover both. Depending on the exact settings of your database, the updates give a varying amount of feedback. For example, when a key is deleted, […]

Read More

The Trouble with Point Queries

 | January 18, 2008 |  Posted In: Tokutek, TokuView

Insertion and Queries Databases are complicated beasts, but I’d like to focus on the storage engine, just the part that talks to the storage system, and doesn’t have to worry about SQL, etc.: just transactions, concurrency, compression, updates and queries. In the next couple of blog entry, I’d like to just focus on updates (insertions […]

Read More