MySQL Partitioning: A Flow Chart

Posted on by Martin Farach-Colton

In Part 1, and Part 2 of this series, I presented some thoughts on partitioning. I heard some great feedback on why people use partitioning. Here, I present a flow chart that summarizes what I’ve learned. In summary:…

7 Comments

Hip To Be Square

Posted on by Lawrence Schwartz

As Huey Lewis once noted, sometimes it’s “Hip To Be Square.” Apparently, occasionally, someone even pays attention to you when you are. Xconomy just featured “10 Boring Boston-Area Tech Companies That Are Actually Interesting” and we made…

Comments Off

Tokutek CEO talks to Wikibon about Big Data and...

Posted on by Lawrence Schwartz

John Partridge, President and CEO of Tokutek, sits down to talk about MySQL performance and scalability with the Wikibon Project’s Dave Vellante at last week’s MassTLC Big Data Summit.
http://siliconangle.tv/video/tokutek-ceo-discusses-big-data-and-scaling-mysql

Leave a comment

The Data is Coming! The Data is Coming!

Posted on by Lawrence Schwartz

This was an interesting week for data discussions in the Boston area. There were two back-to-back events this week — Big Data on Wednesday night hosted by TiE Boston and Channeling the Big Data Tsunami by

1 Comment

My-Shhhh!-QL

Posted on by Michael Bender

I gave a talk entitled “How to Index Massive Data Sets Quickly” at the Morrelly Homeland Security Center. The event was hosted at the Long Island Forum for Technology (LIFT) and was jointly supported by NYSTAR

Leave a comment

Tokutek Founder Named to IOUG MySQL Council

Posted on by Lawrence Schwartz

I am delighted to announce that Dr. Bradley Kuszmaul, Co-Founder and Chief Architect at Tokutek, has been appointed to the IOUG’s first MySQL Council. In the announcement on the IUOG website, president Andy Flower spoke highly of the MySQL…

Leave a comment

Partitioning, Free Lunches, & Indexing, Part...

Posted on by Martin Farach-Colton

Review
In part one, I presented a very brief and particular view of partitioning. I covered what partitioning is, with hardly a mention of why one would use partitioning. In this post, I’ll talk about a few use cases…

8 Comments

Partitioning, Free Lunches, and Indexing

Posted on by Martin Farach-Colton

Why partition?
Partitioning is a commonly touted method for achieving performance in MySQL and other databases. (See here, here, here and many other examples.) I started wondering where the performance from partitions comes from, and I’ve summarized…

5 Comments

Announcing TokuDB for MariaDB

Posted on by John Partridge

Tokutek is pleased to announce support for MariaDB for the first time with TokuDB v4.1.1 for MariaDB v5.1.47.
Our customers are choosing MariaDB more and more frequently for their most demanding database applications. We are delighted to help raise…

Leave a comment

Avoiding Fragmentation with Fractal Trees

Posted on by Martin Farach-Colton

Summary
B-trees suffer from fragmentation. Fragmentation causes headaches — in query performance and space used. Solutions, like dump and reload or OPTIMIZE TABLE are a pain and not always effective. Fractal trees don’t fragment. So if fragmentation is a problem,…

9 Comments