It Actually is Easy Being Green

Posted on by Michael Bender

Fractal Tree™ indexes are green. They have the potential to be greener still. Here’s why:
Remarkably, data centers consume 1-3 percent of all the US electricity. A majority of this power is used to drive servers and storage systems.…

1 Comment

Cage Match: OldSQL, NoSQL and NewSQL

Posted on by Lawrence Schwartz

 
When I interviewed at Tokutek, I met a team of distinguished academics and engineers who could calmly and thoughtfully wax eloquent about the finer points of B-tree and Fractal Tree™ indexing,  drive I/Os, and database engines. Soon…

Leave a comment

This Weekend in Japan

Posted on by Lawrence Schwartz

We were happy to see a lot of folks from Japan on Twitter this weekend having a discussion about MySQL and Tokutek. While we always endeavor to explain ourselves as simply as possible, hearing what users and peers have to…

Leave a comment

Dude, Where’s my Fractal Tree?

Posted on by Lawrence Schwartz

Unless you are Ashton Kutcher (@aplusk), or one of his Hollywood buddies, you don’t need to read any further. Allow me to explain…
Over the weekend, we launched our new website. This type of announcement used to be…

2 Comments

Indexing: The Director’s Cut

Posted on by zardosht

Thanks again to Erin O’Neill and Mike Tougeron for having me at the SF MySQL Meetup last month for the talk on “Understanding Indexing.” The crowd was very interactive, and I appreciated that over 100 people signed up for…

1 Comment

Don’t Thrash: How to Cache your Hash on Flash

Posted on by Michael Bender

Last week I gave a talk entitled “Don’t Thrash: How to Cache your Hash.” The talk took place at the Workshop on Algorithms and Data Structures (ADS) in a medieval castle turned conference center in Bertinoro, Italy.…

2 Comments

Query Planner Gotchas

Posted on by Martin Farach-Colton

Indexes can reduce the amount of data your query touches by orders of magnitude. This results in a proportional query speedup. So what happens when you define a nice set of indexes and you don’t get the performance pop you…

Leave a comment

Understanding Indexing – SF MySQL Meetup

Posted on by zardosht

At this week’s SF MySQL Meetup, I will give a talk: “Understanding Indexing: Three rules on making indexes around queries to provide good performance.” The meetup is 7 pm tomorrow (Wednesday, 6/22), and will be held at CBS Interactive…

1 Comment

Speeding Up TPCC Table Loads by 8x with TokuDB...

Posted on by Rich Prohaska

Percona’s TPCC for MySQL toolset allows one to measure the query performance for an OLTP workload on various MySQL storage engines. The toolset includes a program to load the database tables, and a program to run queries and measure…

Leave a comment

We’ll Bring the Pie

Posted on by Lawrence Schwartz

Yesterday, Tokutek was invited (thanks to David Hughson, Vice-Consul of the British Consulate) to the Massachusetts State House for a forum on international business, hosted by Governor Deval Patrick. I felt pretty good about our Commonwealth – apparently we are…

Leave a comment