Emergency

Search Results for: mysql clustered indexes

Find and remove duplicate indexes

Having duplicate keys in our schemas can hurt the performance of our database: They make the optimizer phase slower because MySQL needs to examine more query plans. The storage engine needs to maintain, calculate and …

Read More
 

MySQL 5.1 Grammar Changes to Support Clustering Indexes

This post is for storage engine developers that may be interested in implementing multiple clustering keys. After blogging about TokuDB’s multiple clustering indexes feature, Baron Schwartz suggested we contribute the patch to allow other storage …

Read More
 

Introducing Multiple Clustering Indexes

In this posting I’ll describe TokuDB’s multiple clustering index feature. In general (not just for TokuDB) a clustered index or a clustering index is an index that stores the all of the data for the …

Read More
 

Why MySQL could be slow with large tables ?

If you’ve been reading enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle more than 1.000.000 (or select any other number) rows by some of the …

Read More
 

Why Percona Acquired Tokutek: by Peter Zaitsev

It is my pleasure to announce that Percona has acquired Tokutek and will take over development and support for TokuDB® and TokuMX™ as well as the revolutionary Fractal Tree® indexing technology that enables those products …

Read More
 

InnoDB’s multi-versioning handling can be Achilles’ heel

I believe InnoDB storage engine architecture is great for a lot of online workloads, however, there are no silver bullets in technology and all design choices have their trade offs. In this blog post I’m …

Read More
 

Yes, Virginia, There is Going to be a TokuMX Storage Engine for MongoDB 2.8

UPDATE: Since the publication of this blog post, Tokutek subsequently published preliminary benchmark results for this new TokuMX sibling, now called TokuMXse. In addition, there have been a number of release candidates.  Finally, MongoDB ultimately decided to …

Read More
 

What’s new in TokuMX 1.4, Part 1: Primary keys

We just released version 1.4.0 of TokuMX, our high-performance distribution of MongoDB. There are a lot of improvements in this version (release notes), the most of any release yet. In this series of blog posts, …

Read More
 

How TokuMX was Born

With TokuMX 1.4 coming out soon, with (teaser) wonderful improvements made to sharding and updates (and plenty of other goodies), I’ve recently reminisced about how we got TokuMX to this point. We (actually, really John) …

Read More
 

Move over Marcia: Top Ten for 2012

by:

Well, it’s that time of the year again for top ten lists. There have been many versions showing up on the web the last few days, including Time Magazine’s “Top 10 Everything of 2012” list, …

Read More