by Tokutek | Jul 29, 2011 | MySQL
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 after, I discovered that...
by Tokutek | Jul 25, 2011 | MySQL
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 say and ask in their native language is very...
by Zardosht.Kasheff | Jul 15, 2011 | MySQL
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...
by Michael.Bender | Jul 7, 2011 | MySQL
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. An earlier version of this work (with the same...
by Martin.FarachColton | May 27, 2011 | MySQL
Yesterday, Percona held Percona Live NYC, which they describe as an “intensive one-day MySQL summit.” They meant it. It was like drinking from a firehose. There was too much for me to give a complete report, so I’d like to highlight two sessions that...
by Martin.FarachColton | May 24, 2011 | MySQL
OldSQL DBs based on B-trees have some well-known problems and workarounds. TokuDB is a NewSQL storage engines based on Fractal Tree indexing, so the natural question is how InnoDB practice translates into TokuDB. This post gives a quick overview. Enjoy! FAQ Q: How do...
by Martin.FarachColton | May 12, 2011 | MySQL
I’ve recently been blogging about how partitioning is a poor man’s answer to covering indexes. I got the following comment from Jaimie Sirovich: “There are many environments where you could end up creating N! indices to cover queries for queries...
by Martin.FarachColton | May 6, 2011 | MySQL
On April 1st, the Department of Computer Science at Rutgers University, where I am a professor, held an open house. I gave a talk called “Elephants on a Trapeze: Keeping Big Data Agile”. The talk is an introduction to performance issues related to big data...
by Zardosht.Kasheff | Apr 26, 2011 | MySQL
Kudos to Ronald Bradford for creating a new MySQL meetup group in New York city and giving MySQL related talks. The next one is tonight, titled “MySQL Idiosyncrasies That Bite”. Information on it can be found at...
by Tokutek | Apr 19, 2011 | MySQL
What a busy week – between O’Reilly and Collaborate we gave a number of talks, sponsored a booth, and took some long flights in between the shows. But what an interesting week. The MySQL conference is a great time to catch up with customers and, as always,...
by Tokutek | Apr 11, 2011 | MySQL
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...
by kuszmaul | Apr 9, 2011 | MySQL
We’ve been busy at The MySQL Council. Giuseppe’s summary does a good job explaining what we’ve been up to. You can communicate with the MySQL council in several ways including: Respond to the MySQL Council Survey. Talk to one of the council members....
by Martin.FarachColton | Apr 8, 2011 | MySQL
Why do B-trees need “Tricks” to work? Marko Mäkelä recently posted a couple of “tips and tricks” you can use to improve InnoDB performance. Tips and tricks. A general purpose relational database like MySQL shouldn’t need “tips and...
by Martin.FarachColton | Apr 7, 2011 | MySQL
Hot Column Addition and Deletion (HCAD) In the previous HCAD post, I described HCAD and showed that it can reduce the downtime of column addition (or deletion) from 18 hours to 3 seconds. In fact, the downtime of InnoDB is proportional to the size of the database,...
by Aurimas Mikalauskas | Apr 7, 2011 | Insight for DBAs, MySQL
I don’t use many tools in my consulting practice but for the ones I do, I try to know them as best as I can. I’ve been using mk-query-digest for almost as long as it exists but it continues to surprise me in ways I couldn’t imagine it would. This...
by Tokutek | Apr 6, 2011 | MySQL
Tokutek, the leading innovator in high-performance and agile schema storage engines, announced today that its team members will be speaking at both the IOUG Collaborate 11 in Orlando, FL, on April 11, 2011 and the O’Reilly MySQL Conference in Santa Clara, CA, on April...
by Martin.FarachColton | Apr 5, 2011 | MySQL
From 31 minutes to 2 seconds Hot Indexing Overview TokuDB v5.0 introduces several features that are new to the MySQL world. Recently, we posted on HCAD: Hot Column addition and Deletion. In this post, we talk about Hot Indexing. What happens when you try to add a new...
by Tokutek | Apr 4, 2011 | MySQL
Keeping from Getting Buried in Big Data Boy, what a way to go into spring. We are expecting up to 1/2″ of rain (or perhaps sleet) today. This follows the 3″ of snow we had on Friday (Shaq — watch out we long ago got Nate – you are next). Here...
by Martin.FarachColton | Mar 30, 2011 | MySQL
From 18 hours to 3 seconds! Hot Column Addition and Deletion (HCAD) Overview TokuDB v5.0 introduces several features that are new to the MySQL world. In this series of posts, we’re going to present some information on these features: what’s the feature,...
by Tokutek | Mar 29, 2011 | MySQL
Running with Big Data It’s spring here in Boston, though one could hardly tell (still barely hitting 40°F). So, for those stuck indoors working out on the treadmill, or those lucky enough to do a workout outdoors, we’ve got a great podcast. Our Chief...
