by Tokutek | Aug 22, 2012 | MySQL
Businesses increasingly operate in a 24×7 environment, where complex analytics must be performed on live, continuously incoming “Big Data.” To address this, TokuDB has developed Fractal Tree® technology, a revolutionary new indexing capability that enables...
by Michael.Bender | Aug 7, 2012 | MySQL
A few weeks ago Bradley Kuszmaul and I attended the Dagstuhl Seminar on Database Workload Management. The Dagstuhl computer science research center is (remotely) located in the countryside in Saarland, Germany. The actual building is an 18th Century Manor House, first...
by Tim.Callaghan | Aug 1, 2012 | MySQL
Benchmarking is a tricky thing, especially when it comes to compression. Some data compresses quite well while other data does not compress at all. Storing jpeg images in a BLOB column produces 0% compression, but storing the string “AAAAAAAAAAAAAAAAAAAA” in a...
by Tim.Callaghan | Jul 24, 2012 | MySQL
I’ll be presenting TokuDB at the Emerging Business Technology Meetup in Boston this Thursday night at 6pm at 290 Congress St (near South Station). The meeting topic is “NewSQL: SQL Technologies Keeping NoSQL Promises” and also includes presentations...
by Zardosht.Kasheff | Jul 23, 2012 | MySQL
Three rules on making indexes around queries to provide good performance Application performance often depends on how fast a query can respond and query performance almost always depends on good indexing. So one of the quickest and least expensive ways to increase...
by Tim.Callaghan | Jul 18, 2012 | MySQL
TokuDB v6.1 is now generally available and can be downloaded here. New features include: Added support for MariaDB 5.5 (5.5.25) The TokuDB storage engine is now available with all the additional functionality of MariaDB 5.5. Added HCAD support to our MySQL 5.5 version...
by Rich.Prohaska | Jul 16, 2012 | MySQL
We found a simple XA transaction that crashes MySQL 5.5 replication. This simple transaction inserts a row into an InnoDB table and a TokuDB table. The bug was caused by a flaw in the logging code exposed by the transaction’s use of two XA storage engines (TokuDB and...
by kuszmaul | Jul 9, 2012 | MySQL
Solving the Challenges of Big Databases with MySQL When you’re using MySQL for big data (more than ten times as large as main memory), these challenges often arise: loading data fast; maintaining indexes under insertions deletions, and updates; adding and removing...
by Tokutek | Jul 5, 2012 | MySQL
… Ya se que estás piantao, piantao, piantao… For my lastest blog, a review of the MySQL, NoSQL and Cloud Conference, I’ll continue to use the tango metaphor. Balada para un loco (ballad for a crazy one) is a Piazzola classic and explains what I think of Santiago...
by Zardosht.Kasheff | Jul 3, 2012 | MySQL
In my last post, I wrote that I observed many similarities between TokuDB and MySQL Cluster. Many features that benefit TokuDB also benefit MySQL Cluster, and vice versa, with Hot Column Addition and Deletion (HCAD) being an example. Over my next few posts, I expand...
by Rich.Prohaska | Jun 28, 2012 | MySQL
Table optimization is a necessary evil; tables sometimes need to be optimized to reclaim space or to improve query performance. Unfortunately, MySQL blocks writes to a table while it is being optimized. Because optimization time is proportional to the table size,...
by Tokutek | Jun 25, 2012 | MySQL
Volver, con la frente marchita, las nieves del tiempo platearon mi sien… Martin’s blog (Mi Buenos Aires Querido) was named after a tango, so I decided to follow his lead. The 4 lines of the refrain make reference to someone returning to Buenos Aires after...
by Zardosht.Kasheff | Jun 21, 2012 | MySQL
As a TokuDB storage engine developer, numerous times I’ve been struck by the similarities between MySQL Cluster and TokuDB. Namely, many times where I find myself thinking, “TokuDB would benefit from this feature”, I also end up thinking “MySQL...
by Martin.FarachColton | Jun 18, 2012 | MySQL
Next week, a couple of us at Tokutek will be heading to Buenos Aires for the MySQL / MariaDB Conference & Expo LA. Gerry Narvaja actually grew up in Buenos Aires. My own family is Argentinian. I spent several years there as a child, and my childhood home in South...
by Rich.Prohaska | Jun 14, 2012 | MySQL
As ones data model evolves changing the database schema becomes painful, especially for big databases where the table must be taken offline. Fortunately, Tokutek introduced online schema changes starting in TokuDB v5.0. A typical schema change involves adding or...
by Martin.FarachColton | Jun 6, 2012 | MySQL
Executive Summary Fast indexing requires the leaves of a Fractal Tree® Index to be big. But some queries require the leaves to be small in order to get any reasonable performance. Basements nodes are our way to achieve these conflicting goals, and here I’ll...
by Tim.Callaghan | Jun 5, 2012 | MySQL
I’ll be attending this year’s US based Open Database Camp from June 8-10 in Charlotte, NC. The conference is co-located with SouthEast LinuxFest 2012. It appears that OpenSQL Camp was renamed Open Database Camp since I see many database technologies listed...
by Martin.FarachColton | Jun 4, 2012 | MySQL
The signal-to-noise ratio in the NoSQL world has made it hard to figure out what’s going on, or even who has something new. For all the talk of performance in the NoSQL world, much of the most exciting part of what’s new is really not about performance at all. Take...
by Michael.Bender | Jun 1, 2012 | MySQL
Martin Farach-Colton and I ran a Tutorial on Algorithms for Memory Sensitive Computing on May 18th at the 44th ACM Symposium on Theory of Computing (STOC) at NYU. Here is the program for the tutorial. Erik Demaine (MIT) spoke on the History of I/O Models. Throughout...
by Tokutek | May 30, 2012 | MySQL
TokuDB® is a proven solution that scales MySQL® and MariaDB® from GBs to TBs with unmatched insert and query speed, compression, and online schema flexibility. Tokutek’s recently launched TokuDB v6 delivers all of these features and more, with the introduction of high...
