by Michael.Bender | Jul 12, 2012 | MySQL
I attended the NSF Workshop on Research Directions in the Principles of Parallel Computation in Pittsburgh on 6/27/12. The workshop brought together researchers from academia and industry to explore visions for the future of parallel computing. I was one of 17 invited...
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 Leif.Walsh | Jun 11, 2012 | MySQL
Modern file systems are well equipped to deal with large writes. One area that remains challenging however is to efficiently write out “microdata”, such as metadata and small portions of large files, while showing good I/O utilization when the data is read...
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...
by kuszmaul | May 24, 2012 | MySQL
Many database management tasks become difficult as you move from millions of rows and gigabytes of data to billions of rows and terabytes of data. Such tasks include ingesting data while maintaining indexes; changing schemas without downtime; and...
by Tokutek | May 16, 2012 | MySQL
Tackling machine data on the ground to ensure successful operations for NASA in space Issues addressed: Scaling MySQL to multi-terabytes Insertion rates as InnoDB hit a performance wall Schema flexibility to handle an evolving data model The Company: Southwest...
by Tokutek | May 14, 2012 | MySQL
We are excited to have Gerry Narvaja start today at Tokutek! Gerry has spent more than 25 years in the software industry, most of them working with databases for different kinds of applications, from embedded to large-scale web products. Gerry worked first at MySQL,...
by Leif.Walsh | May 10, 2012 | MySQL
In April, I got to give a talk at Percona Live, about why The Right Read Optimization is Actually Write Optimization. It was my first industry talk, so I was delighted when someone in the audience said “I feel like I just earned a college credit.” Box...
by Tokutek | May 2, 2012 | MySQL
MySQL storage engine provider joins forces with leading database consultants to deliver support for growing number of MySQL and MariaDB customers Lexington, MA – (May 2, 2012) – Tokutek, the leader in high-performance and agile database storage engines, today...
