addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrosseditemptyheartfacebookfolderfullheartglobegmailgoogleimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

The Boston MySQL Meetup Group Monthly Meetup

  • Mar 14, 2011 · 7:00 PM
  • This location is shown only to members

This meetup's topic is Understanding Indexing, given by Zardosht Kasheff of TokuDB.

Indexes are used to improve query performance. As a result, good indexes are designed around queries that users find important in their application. This talk presents three simple and effective rules on how to construct indexes around queries that result in good performance.

The rules are explained using a simple model that does NOT rely on understanding B-Trees, Fractal trees, or any other data structure used to store the data on disk. They are derived from these simple properties:

  • point queries are slow
  • range queries are fast

 

-------------
Logistics
-------------

MIT's map with the building (E51) highlighted:
http://whereis.mit.ed...

MIT's map with the Kendall square T stop highlighted:
http://whereis.mit.ed...
(the stop is in red on that map, and you can see E51 in the bottom right)

MIT's maps with parking lot information:
http://whereis.mit.ed...
and
http://whereis.mit.ed...

Note that MIT lots are free to park in after 3 pm or so, even if it says "reserved for faculty"

Free pizza and soda will be served, so please RSVP accurately.

To RSVP anonymously, please login to the Meetup site with the e-mail address "admin at sheeri dot com" and the password "guest".

For more information, see: http://www.meetup.com...

Join or login to comment.

  • Lawrence S.

    I found this a very educational and interesting meeting. Zardosht did a great job with it.Good attendance this month as well, with a robust discussion.

    March 15, 2011

  • Ike W.

    Great presentation!

    March 15, 2011

  • Raymond P.

    Great overview of indexes, covering indexes, clustered indexes!

    March 15, 2011

  • Don N.

    I would have liked to see and hear more detail on how and why the engine worked better... but the discussion was more about how to effectively use the indexes in toku and in that way it was spot on.

    March 15, 2011

Our Sponsors

  • Technocation, Inc.

    Video camera, host video files, meetup fees. They are non-profit.

  • Oracle, Inc.

    Oracle develops the MySQL database core and offers support and training.

  • Akiban Technologies

    Has a new table grouping technology as a denormalization alternative.

  • Tokutek

    TokuDB is a drop-in replacement for InnoDB that scales MySQL®.

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy