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...
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,...
