by Tim.Callaghan | Jan 26, 2012 | MySQL
iiBench measures the rate at which a database can insert new rows while maintaining several secondary indexes. We ran this for 1 billion rows with TokuDB and InnoDB starting last week, right after we launched TokuDB v5.2. While TokuDB completed it in 15 hours, InnoDB...
by Martin.FarachColton | Jan 19, 2012 | MySQL
TokuDB® v5.2, the latest version of Tokutek’s flagship storage engine for MySQL and MariaDB, is now available. This version offers performance enhancements over previous releases, especially for multi-client scale up and point queries, and extends the cases...
by Tim.Callaghan | Jan 11, 2012 | MySQL
Thanks again to Sheeri Cabral for having me at the Boston MySQL Meetup on Monday for the talk on “Fractal Tree® Indexes – Theoretical Overview and Customer Use Cases.” The crowd was very interactive, and I appreciated that over 50 people signed up for the...
by Tokutek | Jan 3, 2012 | MySQL
FictionPress Issues addressed: Support complex and efficient indexes at 100+ million rows. Predicable and consistent performance regardless of data size growth. Fast recovery. Ensuring Predictable Performance at Scale The Company: FictionPress operates both...
by Stewart Smith | Dec 22, 2011 | MySQL
Once upon a time, it would have been considered madness to even attempt to create 30,000 tables in InnoDB. That time is now a memory. We have customers with a lot more tables than a mere 30,000. There have historically been no tests for anything near this many tables...
by Tokutek | Dec 20, 2011 | MySQL
It’s almost the end of the year – that means holiday cards, shopping, cooking, parties, and the inevitable year-end top lists (including gems like this one). In the spirit of end of year list making, we fed our 60+ blogs this year through Google...
by Tokutek | Dec 14, 2011 | MySQL
Limelight Networks Issue addressed: Managing metadata at exabyte scale Delivering Agile Storage in the Cloud with Billions of Assets The Company: Founded in 2001, Limelight Networks, Inc (NASDAQ: LLNW) is an Internet platform and services company that integrates the...
by Tim.Callaghan | Dec 5, 2011 | MySQL
At next month’s Boston MySQL Meetup, I will give a talk: “Fractal Tree Indexes – Theoretical Overview and Customer Use Cases.” The meetup is 7 pm Monday, January 9th, 2012, and will be held at MIT Building E51 Room 337e (corner of Ames & Amherst St,...
by Zardosht.Kasheff | Nov 21, 2011 | MySQL
As a storage engine developer, I am excited for MySQL 5.6. Looking at http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html, there has been plenty of work done to improve the performance of reads in MySQL for all storage engines (provided they take...
by Tokutek | Nov 19, 2011 | MySQL
With the release of TokuDB v5.0 last March, we delivered a powerful and agile storage engine that broke through traditional MySQL scalability and performance barriers. As deployments of TokuDB have grown more varied, one request we have repeatedly heard from...
by Tokutek | Nov 17, 2011 | MySQL
Thanks to everyone who signed up and attended the webinar I gave this week with Tim Callaghan on Scaling MySQL. For those who missed it and are interested, the video and slides are now posted here. A brief description of the webinar is also below. MySQL...
by Tim.Callaghan | Nov 11, 2011 | MySQL
This version includes support for “SELECT … FOR UPDATE” as well as displaying table “create time” and “last update time” via “SHOW TABLE STATUS”. The release also addresses a number of other bugs and fixes such as “point...
by kuszmaul | Nov 4, 2011 | MySQL
I’ll be talking about How Fractal Trees Work today at MIT in the Computational Research In Boston and Beyond (CRIBB) seminar (http://www-math.mit.edu/crib/2011/nov4.html). The talk is at 12:30 in the Stata Center room 32-141. Pizza available before. This talk...
by Tokutek | Nov 3, 2011 | MySQL
MySQL implementations are often kept relatively small, often just a few hundred GB or less. Anything beyond this quickly leads to painful operational problems such as poor insertion rates, slow queries, hours to days offline for schema changes, prolonged downtime for...
by Tokutek | Nov 1, 2011 | MySQL
I had the pleasure of being invited to blog at the MassTLC unConference on Friday. The event was a full day of diverse topics and discussions ranging from the latest in recipe sharing sites, to entrepreneurial CEO war stories, to hot trends in venture...
by David Hildebrandt | Oct 31, 2011 | MySQL, Percona Events
If you have been waiting for Percona’s highly rated MySQL courses to be taught near you, your wait is over. We will be holding our Developer, DBA, InnoDB, and Operations training in the following cities: Dublin, Ireland – December 5 – 8, 2011 San...
by kuszmaul | Oct 25, 2011 | 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 supporting...
by Tim.Callaghan | Oct 20, 2011 | MySQL
I’ve been benchmarking and testing TokuDB for a few months now. One goal of benchmarking is to understand what is limiting the performance of a particular configuration. I frequently use “show engine [innodb/tokudb] status;” from within the MySQL...
by Tokutek | Oct 14, 2011 | MySQL
Review of Thursday’s Cloud Events in Boston Everyone is well aware by now of the EC2 outage that Amazon had back in April and it would have surprised no one if that high profile had put a damper on cloud adoption. But judging what we heard yesterday at Boston’s two...
by Zardosht.Kasheff | Oct 7, 2011 | MySQL
At next week’s NY Effective MySQL Meetup, I will give a talk: “Understanding Indexing: Three rules on making indexes around queries to provide good performance.” The meetup is 7 pm Tuesday, October 11th, and will be held at Hive at 55 (55 Broad Street, New York, NY)....
