Author Archives: Bradley C. Kuszmaul

Three Ways that Fractal Tree Indexes Improve SSD for MySQL

Posted On September 27, 2012 | By Bradley C. Kuszmaul | 4 comments

Since Fractal Tree indexes turn random writes into sequential writes, it’s easy to see why they offer a big advantage for maintaining indexes on rotating disks. It turns out that that Fractal Tree indexing also offers signficant advantages on SSD. Here are three ways that Fractal Trees improve your life if you use SSDs. Advantage […]

Tagged: , , , , ,

XLDB Tutorial on Data Structures and Algorithms

Posted On September 7, 2012 | By Bradley C. Kuszmaul | 0 comments

Next week Michael and I (Bradley) will be travelling to Silicon Valley to present a tutorial on Data Structures and Algorithms for Big Databases at the 6th XLDB Conference. The tutorial, which is 4 hours on Monday afternoon, aims to cover the following topics (but it’s looking like we’ll have to drop several items for […]

Tagged: , , , , , , ,

FROSCON and VLDB

Posted On August 14, 2012 | By Bradley C. Kuszmaul | 0 comments

Next week I (Bradley) will be traveling to FROSCON near Bonn, Germany, and then on to VLDB in Istanbul. At FROSCON I’ll be talking about fast data structures for maintaining indexes. The talk will share some content with my upcoming MySQL Connect talk. At VLDB, Dzejla Medjedovic will be presenting a talk on our paper […]

Tagged: , , , , , ,

My Talks at MySQL Connect and Percona Live NYC

Posted On July 9, 2012 | By Bradley C. Kuszmaul | 0 comments

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 columns online; adding indexes online; preventing slave lag; and compressing data effectively. This session […]

Tagged: , , , , , , , , ,

Challenges of Big Databases with MySQL – IOUG Presentation

Posted On May 24, 2012 | By Bradley C. Kuszmaul | 1 comments

    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 connections, replication, and backup. For some scaling problems (connections and replication), MySQL® is better […]

Tagged: , , , , , , ,

My Talk on Tuesday at IOUG COLLABORATE 12

Posted On April 20, 2012 | By Bradley C. Kuszmaul | 0 comments

    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; changing schemas without downtime; and supporting connections, replication, and backup. For some scaling problems […]

Tagged: , , , , , , , ,

Call for nominations to the MySQL Council

Posted On December 28, 2011 | By Bradley C. Kuszmaul | 0 comments

The MySQL council is looking for candidates for 2012.  Based on community feedback, this will be an open nomination process (and you can nominate yourself). The MySQL council advocates for the MySQL community, and needs community leaders to help address issues such as keeping the bug database open and keeping the user conference from fragmenting. […]

Tagged:

“How Fractal Trees Work” at MIT today

Posted On November 4, 2011 | By Bradley C. Kuszmaul | 4 comments

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 will be academically-oriented (not much marketing).  The abstract is as follows: Most storage systems employ B-trees to achieve […]

Tagged: , , ,

Challenges of Big Databases with MySQL – OOW11 Presentation

Posted On October 25, 2011 | By Bradley C. Kuszmaul | 0 comments

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 connections, replication, and backup. For some scaling problems (connections and replication), MySQL® is better than most […]

Tagged: , , ,

My Talk on Sunday at Oracle Open World

Posted On October 1, 2011 | By Bradley C. Kuszmaul | 1 comments

    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; changing schemas without downtime; and supporting connections, replication, and backup. For some scaling problems […]

Tagged: , ,