Tag - fragmentation

Indexing: The Director’s Cut

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 the event and left some very positive comments and reviews.
Thanks to Mike, a video of […]

Read more

TokuDB Tames Huge Logfile Processing Workload for Jawa

Jawa
Issue addressed:

Process over 10 million log entries per day without partitions or other workarounds.

MySQL + TokuDB Tames Huge Logfile Processing Workload
The Company: Founded in 2005, Jawa develops software and media solutions enabling people to stay connected to information, entertainment and communities while on the go. Jawa is a privately held company headquartered in […]

Read more

MySQL Partitioning: A Flow Chart

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: with TokuDB in the picture there’s almost no reason to use partitioning. […]

Read more

TokuDB FAQ

Links to the FAQ Sections can be found here:

General Information
Open Source
Technical Details
Best Practices and Tools

General Information
ANY CHARACTER HERE
1.    What is TokuDB?

TokuDB is an ACID compliant storage engine for MySQL that is specifically designed for high performance on write-intensive workloads. It achieves this via Fractal Tree® indexing. This approach to building memory-efficient systems was originally jointly […]

Read more

Partitioning, Free Lunches, and Indexing

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 some of my thoughts here.
But first, what is partitioning? (I’ve taken the examples […]

Read more

Avoiding Fragmentation with Fractal Trees

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, check out Tokutek
What is fragmentation?
What do I mean when I say […]

Read more