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)....
by Leif.Walsh | Oct 4, 2011 | MySQL
In my last post, we talked about the read/write tradeoff of indexing data structures, and some ways that people augment B-trees in order to get better write performance. We also talked about the significant drawbacks of each method, and I promised to show some more...
by kuszmaul | Oct 1, 2011 | MySQL
Challenges of Big Databases with 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;...
by Percona | Sep 29, 2011 | MySQL
. Baron Schwartz This guest post is from our friends at Percona. They’re hosting Percona Live London from October 24-25, 2011. Percona Live is a two day summit with 100% technical sessions led by some of the most established speakers in the MySQL field. In the London...
by Tokutek | Sep 26, 2011 | MySQL
Review of the O’Reilly Strata Making Data Work Conference (reprinted from my guest blog for the Cloud Council of 7) Monica Rogati of LinkedIn told a story of the early days at the firm, when the reporting system consisted of a single server under someone’s...
by Leif.Walsh | Sep 22, 2011 | MySQL
Some indexing structures are write optimized in that they are better than B-trees at ingesting data. Other indexing structures are read optimized in that they are better than B-trees at query time. Even within B-trees, there is a tradeoff between write performance and...
by Tim.Callaghan | Sep 15, 2011 | MySQL
I’m creating a library of benchmarks and test suites that will run as part of a Continuous Integration (CI) process here at Tokutek. My goal is to regularly measure several aspects of our storage engine over time: performance, correctness, memory/CPU/disk utilization,...
by Tokutek | Sep 8, 2011 | MySQL
Intent Media Issue addressed: Ad hoc analytics on clickstream data arriving too fast for InnoDB or NoSQL to handle. TokuDB powers an online advertising application The Company: Headquartered in New York, Intent Media is a fast-growing online advertising startup. The...
by Tokutek | Aug 31, 2011 | MySQL
One of President John Kennedy’s most memorable phrases is “ask not what your country can do for you – ask what can you do for your country”. I got to thinking about this over lunch with a fellow colleague in the big data space. After comparing named customers...
by Tokutek | Aug 26, 2011 | MySQL
According to a recent MIT Sloan Management Review study, top performing organizations use analytics 5 times more than lower performers. That’s pretty astounding. And while we all know about the ocean/lake/waves/(your favorite water analogy) of Big Data we struggle...
by Michael.Bender | Aug 11, 2011 | MySQL
Fractal Tree™ indexes are green. They have the potential to be greener still. Here’s why: Remarkably, data centers consume 1-3 percent of all the US electricity. A majority of this power is used to drive servers and storage systems. Significant energy savings...
